Index: branches/eam_branches/ipp-20230313/ippTools/share/Makefile.am
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/Makefile.am	(revision 42636)
+++ branches/eam_branches/ipp-20230313/ippTools/share/Makefile.am	(revision 42699)
@@ -556,4 +556,5 @@
 	fpcamtool_revertupdatedexp.sql \
 	xcstacktool_definebyquery_select.sql \
+	xcstacktool_definebyquery_select_XC.sql \
 	xcstacktool_addbyquery_select.sql \
 	xcstacktool_addcamera.sql \
Index: branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_addbyquery_select.sql
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_addbyquery_select.sql	(revision 42636)
+++ branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_addbyquery_select.sql	(revision 42699)
@@ -26,5 +26,5 @@
   ) AS TMP
     LEFT JOIN xcstackInputSkyfile
-    ON (TMP.stack_id = xcstackInputSkyfile.stack_id)
+    ON (TMP.xcstack_id = xcstackInputSkyfile.xcstack_id)
     AND (camera_id = %d)
     WHERE xcstackInputSkyfile.xcstack_id IS NULL
Index: branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select.sql
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select.sql	(revision 42636)
+++ branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select.sql	(revision 42699)
@@ -5,11 +5,9 @@
     xcstack_id,
     stackRun.stack_id,
-    tess_id,
-    skycell_id,
-    filter
+    stackRun.tess_id,
+    stackRun.skycell_id,
+    stackRun.filter
     FROM %s.stackRun
     JOIN %s.stackSumSkyfile USING (stack_id)
-    LEFT JOIN xcstackInputSkyfile
-    ON (stackRun.stack_id = xcstackInputSkyfile.stack_id)
-    AND (xcstackInputSkyfile.camera_id = %d)
-    WHERE xcstack_id IS NULL
+    LEFT JOIN
+    
Index: branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select_XC.sql
===================================================================
--- branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select_XC.sql	(revision 42699)
+++ branches/eam_branches/ipp-20230313/ippTools/share/xcstacktool_definebyquery_select_XC.sql	(revision 42699)
@@ -0,0 +1,6 @@
+SELECT
+ xcstack_id,
+ stack_id
+ FROM xcstackRun
+ JOIN xcstackInputSkyfile USING (xcstack_id)
+