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

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

@@ -1 +1 @@
 SELECT DISTINCT
-    fullForceSummary.*,
-    fullForceRun.state,
-    fullForceRun.label,
-    fullForceRun.data_group,
-    fullForceRun.xccal_id,
-    fullForceRun.workdir,
-    fullForceRun.sources_path_base,
+    xcForceSummary.*,
+    xcForceRun.state,
+    xcForceRun.label,
+    xcForceRun.data_group,
+    xcForceRun.xccal_id,
+    xcForceRun.workdir,
+    xcForceRun.sources_path_base,
+    xcForceRun.tess_id,
+    xcForceRun.skycell_id,
     'summary' AS dist_component,
-    stackRun.stack_id,
-    stackRun.tess_id,
-    stackRun.skycell_id,
-    stackRun.filter,
-    rawExp.camera
-FROM fullForceRun
-    JOIN fullForceSummary USING(ff_id)
-    JOIN fullForceInput USING(ff_id)
-    JOIN xccalRun using(xccal_id)
-    JOIN stackRun using(stack_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)
+FROM xcForceRun
+    JOIN xcForceSummary USING(xcff_id)
+    JOIN xcForceInput USING(xcff_id)
+    JOIN skycell USING (tess_id, skycell_id)