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

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

@@ -1 +1 @@
 SELECT
-    fullForceResult.*,
-    fullForceRun.state,
-    fullForceRun.label,
-    fullForceRun.data_group,
-    fullForceRun.xccal_id,
-    fullForceRun.workdir,
-    fullForceRun.sources_path_base,
+    xcForceResult.*,
+    xcForceRun.state,
+    xcForceRun.label,
+    xcForceRun.data_group,
+    xcForceRun.xccal_id,
+    xcForceRun.workdir,
+    xcForceRun.sources_path_base,
     CONCAT_WS('.', warp_id, skycell_id) AS dist_component,
-    stackRun.tess_id,
-    stackRun.skycell_id,
-    stackRun.filter,
+    xcForceRun.tess_id,
+    xcForceRun.skycell_id,
     warpImfile.warp_skyfile_id,
     rawExp.exp_id,
     rawExp.exp_name,
     rawExp.camera
-FROM fullForceRun
-    JOIN fullForceResult USING(ff_id)
-    JOIN xccalRun using(xccal_id)
-    JOIN stackRun using(stack_id)
+FROM xcForceRun
+    JOIN xcForceResult USING(xcff_id)
     JOIN warpRun using(warp_id, tess_id)
     JOIN warpSkyfile USING(warp_id, tess_id, skycell_id)