Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 35960)
+++ trunk/ippTools/share/Makefile.am	(revision 36009)
@@ -400,4 +400,5 @@
 	stacktool_tosummary.sql \
 	stacktool_addsummary.sql \
+	stacktool_summary.sql \
 	staticskytool_definebyquery_select.sql \
 	staticskytool_definebyquery_select_by_dg.sql \
@@ -484,4 +485,5 @@
 	releasetool_definerelgroup_select_exp_data_group.sql \
 	releasetool_definerelgroup_select_exp_lap.sql \
+	releasetool_stacksummary.sql \
 	releasetool_pendingrelgroup.sql
 
Index: trunk/ippTools/share/releasetool_stacksummary.sql
===================================================================
--- trunk/ippTools/share/releasetool_stacksummary.sql	(revision 36009)
+++ trunk/ippTools/share/releasetool_stacksummary.sql	(revision 36009)
@@ -0,0 +1,19 @@
+SELECT DISTINCT sass_id,
+       stackAssociation.tess_id,
+       stackAssociation.projection_cell,
+       stackAssociation.filter,
+       stackSummary.path_base,
+       stackAssociation.data_group,
+       survey.surveyName,
+       ippRelease.release_name,
+       ippRelease.rel_id
+
+FROM relStack 
+    JOIN ippRelease USING(rel_id)
+    JOIN survey USING(surveyID)
+    JOIN stackAssociationMap USING(stack_id) 
+    JOIN stackAssociation USING(sass_id, filter)
+    JOIN stackSummary using(sass_id, projection_cell)
+
+-- WHERE rel_id = 37 and skycell_id like 'skycell.0635.045' and filter = 'r.00000'\G
+-- WHERE rel_id = 37 and projection_cell = 'skycell.0635' and filter = 'r.00000'\G
Index: trunk/ippTools/share/stacktool_summary.sql
===================================================================
--- trunk/ippTools/share/stacktool_summary.sql	(revision 36009)
+++ trunk/ippTools/share/stacktool_summary.sql	(revision 36009)
@@ -0,0 +1,13 @@
+SELECT DISTINCT sass_id,
+       stackAssociation.tess_id,
+       stackAssociation.projection_cell,
+       stackAssociation.filter,
+       stackSummary.path_base,
+       stackAssociation.data_group
+FROM stackRun 
+    JOIN stackAssociationMap USING(stack_id) 
+    JOIN stackAssociation USING(sass_id, filter)
+    JOIN stackSummary using(sass_id, projection_cell)
+
+-- WHERE stackRun.label ='lap.threepi.20130717' and skycell_id like 'skycell.0635%' and filter = 'r.00000'\G
+-- WHERE stackRun.label ='lap.threepi.20130717' and projection_cell = 'skycell.0635' and filter = 'r.00000'\G