Index: trunk/ippTools/share/stacktool_definebyquery_part1.sql
===================================================================
--- trunk/ippTools/share/stacktool_definebyquery_part1.sql	(revision 19092)
+++ trunk/ippTools/share/stacktool_definebyquery_part1.sql	(revision 19105)
@@ -13,13 +13,13 @@
     SELECT
         skycell_id,
-        tess_id,
-        filter,
+        warpSkyfile.tess_id,
+        rawExp.filter,
         COUNT(warpSkyfile.skycell_id) AS num_warp -- number of warps that can be stacked
     FROM warpRun
-        JOIN warpSkyfile USING(warp_id, tess_id)
-        JOIN fakeRun USING(fake_id, tess_id)
-        JOIN camRun USING(cam_id, tess_id)
-        JOIN chipRun USING(chip_id, tess_id)
-        JOIN rawExp USING(exp_id, tess_id)
+        JOIN warpSkyfile USING(warp_id)
+        JOIN fakeRun USING(fake_id)
+        JOIN camRun USING(cam_id)
+        JOIN chipRun USING(chip_id)
+        JOIN rawExp USING(exp_id)
     WHERE
         warpRun.state = 'full'