Index: trunk/ippTools/share/stacktool_definebyquery_select.sql
===================================================================
--- trunk/ippTools/share/stacktool_definebyquery_select.sql	(revision 26147)
+++ trunk/ippTools/share/stacktool_definebyquery_select.sql	(revision 27680)
@@ -3,7 +3,7 @@
 
 SELECT
+    tess_id,
     skycell_id,
     filter,
-    tess_id,
     num_warp,
     MAX(num_stack) AS num_stack
@@ -11,6 +11,6 @@
     -- Number of stack-ready warps as a function of skycell and filter
     SELECT
+        warpSkyfile.tess_id as tess_id,
         skycell_id,
-        warpSkyfile.tess_id as tess_id,
         rawExp.filter,
         COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked
@@ -28,4 +28,5 @@
     -- WHERE hook %s
     GROUP BY
+        warpSkyfile.tess_id,
         skycell_id,
         filter
@@ -45,7 +46,8 @@
     ) AS stackSizes
 -- JOINing the warpsToStack and stackSizes tables
-    USING(skycell_id, filter)
+    USING(tess_id, skycell_id, filter)
     )
 GROUP BY
+    tess_id,
     skycell_id,
     filter