Changeset 33525 for trunk/ippTools/share/addtool_find_sky_id_multi_dvo.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_dvo.sql (modified) (1 diff)

trunk/ippTools/share/addtool_find_sky_id_multi_dvo.sql

@@ -5 +5 @@
 
 WHERE staticskyRun.state = 'full' and staticskyResult.quality = 0
-    AND sky_id NOT IN (SELECT sky_id
+    AND stack_id NOT IN (SELECT stack_id
        FROM addRun
        JOIN staticskyResult on staticskyResult.sky_id = addRun.stage_id
        JOIN staticskyRun USING(sky_id)
-       WHERE addRun.stage = 'staticsky_multi' AND %s
+       JOIN staticskyInput USING(sky_id)
+       WHERE addRun.stage = 'staticsky' AND %s
       )