Changeset 29667 for trunk/ippTools/share/difftool_definestackstack_part0.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_part0.sql (modified) (2 diffs)

trunk/ippTools/share/difftool_definestackstack_part0.sql

@@ -22 +22 @@
            stackRun.state = 'full' AND
            stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0
-           -- template where hook %s
+           @STACK2_QUERY@ -- template condition
      GROUP BY
            skycell_id,
@@ -38 +38 @@
           JOIN stackSumSkyfile USING(stack_id)
           WHERE 1
-          -- input where hook %s
+          @STACK1_QUERY@ -- input condition
 ) 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
+        @DIFF0_QUERY@  -- diff constraint
+        @STACK1_QUERY@ -- input constraint
 ORDER BY stackRun.data_group,stackRun.filter