Index: /branches/bills_081204/ippTools/share/difftool_definebyquery_part1.sql
===================================================================
--- /branches/bills_081204/ippTools/share/difftool_definebyquery_part1.sql	(revision 20955)
+++ /branches/bills_081204/ippTools/share/difftool_definebyquery_part1.sql	(revision 20955)
@@ -0,0 +1,22 @@
+    SELECT
+        exp_id,
+        warp_id,
+        rawExp.filter,
+        warpRun.label,
+        warpRun.tess_id,
+        count(skycell_id) as skycell_count
+    FROM warpRun
+    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)
+    LEFT JOIN diffRun USING(exp_id)
+
+    WHERE
+        warpSkyfile.ignored = 0
+        -- warp where hook %s
+        -- exp where hook %s
+        -- diff where hook %s
+
+    GROUP BY exp_id, warp_id DESC
Index: /branches/bills_081204/ippTools/share/difftool_definebyquery_part2.sql
===================================================================
--- /branches/bills_081204/ippTools/share/difftool_definebyquery_part2.sql	(revision 20955)
+++ /branches/bills_081204/ippTools/share/difftool_definebyquery_part2.sql	(revision 20955)
@@ -0,0 +1,33 @@
+-- insert skycells to diff 
+INSERT INTO skycellsToDiff
+    SELECT
+        0,              -- diff_id
+        warpSkyfile.skycell_id,
+        warp_id,        -- warp1
+        NULL,           -- stack1
+        NULL,           -- warp2
+        max_stack_id,   -- stack2
+        warpSkyfile.tess_id
+        FROM warpSkyfile
+        JOIN warpRun USING(warp_id)
+        LEFT JOIN (
+            SELECT
+                MAX(stack_id) AS max_stack_id, -- most recent stack, by virtue of auto-increment
+                stackRun.skycell_id,
+                stackRun.tess_id,
+                filter
+            FROM stackRun
+            JOIN stackSumSkyfile USING(stack_id)
+            GROUP BY 
+                skycell_id,
+                filter
+            ) as bestStacks
+        USING(skycell_id)
+        WHERE
+            warp_id = %lld
+            AND ignored = 0
+            AND filter IS NOT NULL
+            AND warpSkyfile.tess_id = bestStacks.tess_id
+        -- (good fraction test goes here for example also above)
+        -- warp where hook %s
+        -- stacks where hook %s
Index: /branches/bills_081204/ippTools/share/difftool_definebyquery_temp_create.sql
===================================================================
--- /branches/bills_081204/ippTools/share/difftool_definebyquery_temp_create.sql	(revision 20955)
+++ /branches/bills_081204/ippTools/share/difftool_definebyquery_temp_create.sql	(revision 20955)
@@ -0,0 +1,10 @@
+CREATE TEMPORARY TABLE skycellsToDiff (
+diff_id BIGINT,
+warp1 BIGINT,
+warp2 BIGINT,
+stack1 BIGINT,
+stack2 BIGINT,
+skycell_id VARCHAR(64),
+tess_id VARCHAR(64),
+PRIMARY KEY(diff_id, skycell_id)
+) ENGINE=MEMORY;