Changeset 33525 for trunk/ippTools/share/addtool_find_sky_id_multi.sql

Timestamp:

Mar 14, 2012, 3:05:17 PM (14 years ago)

Author:

heather

Message:

dvodb changes: staticsky and staticsky_multi are now just staticsky

File:

• trunk/ippTools/share/addtool_find_sky_id_multi.sql (modified) (2 diffs)

trunk/ippTools/share/addtool_find_sky_id_multi.sql

@@ -4 +4 @@
     staticskyResult.num_inputs
 FROM 
-     staticskyResult
-join staticskyRun using (sky_id)
+     staticskyRun
+join staticskyResult using (sky_id)
 join staticskyInput using(sky_id)
 JOIN stackRun USING(stack_id)
 
-LEFT JOIN (SELECT sky_id       AS added_sky_id,
+LEFT JOIN (SELECT stack_id       AS added_stack_id,
                   addRun.dvodb AS previous_dvodb
            FROM addRun
 JOIN staticskyRun on sky_id = stage_id
           ) as foo
-     ON sky_id = added_sky_id 
-     AND stage = 'staticsky_multi'
+     ON stack_id = added_stack_id 
+     AND stage = 'staticsky'
      -- hook for qualifying the join on the previous_dvodb
      AND %s
@@ -21 +21 @@
     staticskyRun.state = 'full'
     AND staticskyResult.quality = 0
-    AND added_exp_id IS NULL
+    AND added_stack_id IS NULL
     -- addtool adds checks on exposure being added to the dvodb previously