Changeset 19258 for trunk/ippTools/share/stacktool_definebyquery_insert_random_part1.sql

Timestamp:

Aug 27, 2008, 5:57:36 PM (18 years ago)

Author:

eugene

Message:

do not join against tess_id

File:

• trunk/ippTools/share/stacktool_definebyquery_insert_random_part1.sql (modified) (1 diff)

trunk/ippTools/share/stacktool_definebyquery_insert_random_part1.sql

@@ -14 +14 @@
     FROM warpSkyfile
     JOIN warpRun
-        USING(warp_id, tess_id)
+        USING(warp_id)
     JOIN fakeRun
-        USING(fake_id, tess_id)
+        USING(fake_id)
     JOIN camRun
-        USING(cam_id, tess_id)
+        USING(cam_id)
     JOIN chipRun
-        USING(chip_id, tess_id)
+        USING(chip_id)
     JOIN rawExp
-        USING(exp_id, tess_id)
+        USING(exp_id)
     WHERE
         skycell_id = '%s'
-        AND tess_id = '%s'
-        AND rawExp.filter = '%s'
+        AND warpRun.state = 'full'
+        AND rawExp.filter = '%s' -- the result of the query is grouped by filter and inserted for one at a time
         AND warpSkyfile.fault = 0
         AND warpSkyfile.ignored = 0