Changeset 29553 for trunk/ippTools/share/difftool_definestackstack_part1.sql

Timestamp:

Oct 25, 2010, 3:27:09 PM (16 years ago)

Author:

eugene

Message:

merge changes from eam_branches/ipp-20100823

Location:

trunk/ippTools

Files:

• . (modified) (1 prop)
• share/difftool_definestackstack_part1.sql (modified) (3 diffs)

trunk/ippTools/share/difftool_definestackstack_part1.sql

@@ -1 @@
-SELECT 
+SELECT distinct
        stackRun.stack_id,
        stackRun.data_group,
@@ -9 +9 @@
        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 +45 @@
         -- 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