Changeset 42596 for branches/eam_branches/ipp-20230313/ippTools/share/xcfftool_todo.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_todo.sql (modified) (1 diff)

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

@@ -1 +1 @@
 SELECT
-    fullForceRun.*,
-    fullForceInput.warp_id,
-    stackRun.tess_id,
-    stackRun.skycell_id,
-    stackRun.filter,
-    rawExp.camera,
+    xcForceRun.*,
+    xcForceInput.warp_id,
     warpSkyfile.path_base AS warp_path_base
-FROM fullForceRun
-    JOIN fullForceInput USING(ff_id)
-    JOIN xccalRun USING(xccal_id)
-    JOIN stackRun USING(stack_id)
+FROM xcForceRun
+    JOIN xcForceInput USING(xcff_id)
     JOIN warpRun USING(warp_id, tess_id)
     JOIN warpSkyfile USING(warp_id, tess_id, skycell_id)
-    JOIN fakeRun USING(fake_id)
-    JOIN camRun USING(cam_id)
-    JOIN chipRun USING(chip_id)
-    JOIN rawExp USING(exp_id)
-    LEFT JOIN fullForceResult USING(ff_id, warp_id)
-WHERE fullForceRun.state = 'new'
-    AND fullForceResult.ff_id IS NULL
+    LEFT JOIN xcForceResult USING(xcff_id, warp_id)
+WHERE xcForceRun.state = 'new'
+    AND xcForceResult.xcff_id IS NULL
     AND warpSkyfile.data_state = 'full'