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

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

@@ -22 +22 @@
 LEFT JOIN (
   SELECT DISTINCT xcsky_id,
-    xcstackRun.skycell_id,
-    xcstackRun.tess_id,
-    xcstackRun.data_group,
+    MIN(xcstackRun.skycell_id) as skycell_id,
+    MIN(xcstackRun.tess_id) as tess_id,
+    MIN(xcstackRun.data_group) as data_group,
     COUNT(xcstack_id) AS num_filter
   FROM xcskyRun