Changeset 20691 for trunk/ippTools/share/magictool_diffskyfile.sql

Timestamp:

Nov 11, 2008, 2:51:22 PM (17 years ago)

Author:

Paul Price

Message:

Fixing and verifying queries.

File:

• trunk/ippTools/share/magictool_diffskyfile.sql (modified) (2 diffs)

trunk/ippTools/share/magictool_diffskyfile.sql

@@ -1 +1 @@
 SELECT
-    diff_id,
+    diffSkyfile.diff_id,
+    diffRun.skycell_id,
     diffSkyfile.uri,
     diffSkyfile.path_base
@@ -7 +8 @@
 JOIN diffRun USING(diff_id)
 JOIN diffSkyfile USING(diff_id)
+JOIN diffInputSkyfile
+    ON diffInputSkyfile.diff_id = diffRun.diff_id
+    AND diffInputSkyfile.skycell_id = diffRun.skycell_id
+    -- Want input warps only
+    AND diffInputSkyfile.warp_id IS NOT NULL
+    AND diffInputSkyfile.template = 0
+JOIN warpSkyCellMap
+    ON warpSkyCellMap.warp_id = diffInputSkyfile.warp_id
+    AND warpSkyCellMap.skycell_id = diffInputSkyfile.skycell_id
+JOIN warpSkyfile
+    ON warpSkyfile.warp_id = warpSkyCellMap.warp_id
+    AND warpSkyfile.skycell_id = warpSkyCellMap.skycell_id
+    AND warpSkyfile.ignored = 0
 WHERE
     diffRun.state = 'full'