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

Timestamp:

Nov 4, 2010, 12:39:06 PM (16 years ago)

Author:

watersc1

Message:

forgot the sql files.

File:

• trunk/ippTools/share/difftool_definestackstack_part1.sql (modified) (3 diffs)

trunk/ippTools/share/difftool_definestackstack_part1.sql

@@ -23 +23 @@
            stackRun.state = 'full' AND
            stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-           -- template where hook %s
+           @STACK2_QUERY@ -- template constraint
      GROUP BY
            skycell_id,
@@ -39 +39 @@
           JOIN stackSumSkyfile USING(stack_id)
           WHERE 1
-          -- input where hook %s
+          @STACK1_QUERY@ -- input constraint
 ) AS diffExp ON diffExp.stack1 = stackRun.stack_id AND diffExp.stack2 = template.max_stack_id
 WHERE
         stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-        -- diff where hook %s
-        -- input where hook again %s
+        @STACK1_QUERY@ -- input constraint
 group by stackRun.stack_id,
        stackRun.data_group,
@@ -54 +53 @@
        template.max_stack_id,
        template.template_label
+       @DIFF1_QUERY@  -- diff constraint
 ORDER BY stackRun.data_group,stackRun.filter,stackRun.skycell_id