Index: trunk/ippTools/share/difftool_definebyquery.sql
===================================================================
--- trunk/ippTools/share/difftool_definebyquery.sql	(revision 18673)
+++ trunk/ippTools/share/difftool_definebyquery.sql	(revision 19258)
@@ -24,14 +24,13 @@
         diffTemplates.stack_id AS current_stack_id
     FROM warpSkyfile
-    JOIN warpRun 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 warpRun USING(warp_id)
+    JOIN fakeRun USING(fake_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    JOIN rawExp USING(exp_id)
     -- Check if it has an associated diff
     LEFT JOIN diffInputSkyfile AS diffInputs
         ON diffInputs.warp_id = warpSkyfile.warp_id
         AND diffInputs.skycell_id = warpSkyfile.skycell_id
-        AND diffInputs.tess_id = warpSkyfile.tess_id
         AND diffInputs.template = 0 -- only join input files
     -- Get the stack_id currently used as a template, if any
@@ -56,5 +55,4 @@
     GROUP BY
         skycell_id,
-        tess_id,
         filter
-    ) AS stacksForDiff USING(skycell_id, tess_id, filter)
+    ) AS stacksForDiff USING(skycell_id, filter)