Index: trunk/ippTools/share/difftool_definestackstack_part1.sql
===================================================================
--- trunk/ippTools/share/difftool_definestackstack_part1.sql	(revision 29528)
+++ trunk/ippTools/share/difftool_definestackstack_part1.sql	(revision 29553)
@@ -1,3 +1,3 @@
-SELECT 
+SELECT distinct
        stackRun.stack_id,
        stackRun.data_group,
@@ -9,5 +9,5 @@
        template.max_stack_id,
        template.template_label,
-       diffExp.diff_id
+       count(diffExp.diff_id) as n_diff
 FROM stackRun JOIN stackSumSkyfile USING(stack_id) 
 JOIN (
@@ -45,3 +45,12 @@
 	-- diff where hook %s
 	-- input where hook again %s
+group by stackRun.stack_id,
+       stackRun.data_group,
+       stackRun.filter,
+       stackRun.label,
+       stackRun.tess_id,
+       stackRun.skycell_id,
+       stackSumSkyfile.good_frac,
+       template.max_stack_id,
+       template.template_label
 ORDER BY stackRun.data_group,stackRun.filter,stackRun.skycell_id