Changeset 19258 for trunk/ippTools/share/stacktool_find_complete_warps.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_find_complete_warps.sql (modified) (2 diffs)

trunk/ippTools/share/stacktool_find_complete_warps.sql

@@ -7 +7 @@
 FROM warpRun
 JOIN warpSkyfile 
-    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)
 LEFT JOIN stackInputSkyfile
     ON warpSkyfile.warp_id = stackInputSkyfile.warp_id
 LEFT JOIN stackRun
-    ON stackRun.tess_id = warpSkyfile.tess_id
-    AND stackRun.skycell_id = warpSkyfile.skycell_id
+    ON stackRun.skycell_id = warpSkyfile.skycell_id
     AND stackRun.stack_id = stackInputSkyfile.stack_id
 WHERE
@@ -26 +25 @@
     AND warpSkyfile.ignored = 0
 GROUP BY
-    warpSkyfile.skycell_id, warpSkyfile.tess_id, stackRun.stack_id
+    warpSkyfile.skycell_id, stackRun.stack_id
 HAVING
     num_avail > num_extant