Changeset 42596 for branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_definebyquery_select_warps.sql

Timestamp:

Jan 19, 2024, 8:12:15 AM (2 years ago)

Author:

eugene

Message:

working on xcfftool

File:

• branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_definebyquery_select_warps.sql (modified) (1 diff)

branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_definebyquery_select_warps.sql

@@ -1 +1 @@
 SELECT warp_id
-FROM warpRun join warpSkyfile using(warp_id, tess_id)
-    JOIN fakeRun using(fake_id)
-    JOIN camRun USING(cam_id)
-    JOIN chipRun USING(chip_id)
-    JOIN rawExp USING(exp_id)
-    JOIN skycell ON skycell.tess_id = warpSkyfile.tess_id AND skycell.skycell_id = warpSkyfile.skycell_id
-WHERE warpRun.tess_id = '%s' AND warpSkyfile.skycell_id = '%s' AND rawExp.filter = '%s'
-    AND warpRun.state = 'full' AND warpSkyfile.quality = 0 and warpSkyfile.fault = 0
+FROM stackInputSkyfile
+JOIN warpRun using (warp_id)
+JOIN warpSkyfile using(warp_id, tess_id)
+WHERE (stack_id = %lld)
+AND   warpRun.state = 'full'
+AND   warpSkyfile.quality = 0
+AND   warpSkyfile.fault = 0