Changeset 24133

Timestamp:

May 11, 2009, 12:57:34 PM (17 years ago)

Author:

Paul Price

Message:

Query needed reworking following removal of diffRun.exp_id

File:

• branches/pap_magic/ippTools/share/difftool_definewarpstack_part1.sql (modified) (1 diff)

branches/pap_magic/ippTools/share/difftool_definewarpstack_part1.sql

@@ -12 +12 @@
 JOIN chipRun USING(chip_id)
 JOIN rawExp USING(exp_id)
-LEFT JOIN diffRun USING(exp_id)
+LEFT JOIN (
+    SELECT DISTINCT
+        diffRun.*,
+        exp_id
+    FROM diffRun
+    JOIN diffInputSkyfile USING(diff_id)
+    JOIN warpRun
+        ON warpRun.warp_id = diffInputSkyfile.warp1
+    JOIN fakeRun USING(fake_id)
+    JOIN camRun USING(cam_id)
+    JOIN chipRun USING(chip_id)
+    WHERE warp1 IS NOT NULL
+) AS diffExp USING(exp_id)
 WHERE
     warpSkyfile.fault = 0