Changeset 29363 for trunk/ippTools/share/magictool_definebyquery_select.sql

Timestamp:

Oct 8, 2010, 12:13:27 PM (16 years ago)

Author:

bills

Message:

make sure that at least one diffSkyfile has non-zero quality

File:

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

trunk/ippTools/share/magictool_definebyquery_select.sql

@@ -15 +15 @@
     FROM diffRun
     JOIN diffInputSkyfile USING(diff_id)
+    JOIN diffSkyfile USING(diff_id, skycell_id)
     WHERE diffInputSkyfile.warp1 IS NOT NULL
         AND diffRun.exposure = 1
         AND diffRun.magicked = 0
+        AND diffSkyfile.quality = 0
     -- diff WHERE hook %s
     UNION
@@ -28 +30 @@
     FROM diffRun
     JOIN diffInputSkyfile USING(diff_id)
+    JOIN diffSkyfile USING(diff_id, skycell_id)
     WHERE diffInputSkyfile.warp2 IS NOT NULL
         AND diffRun.exposure = 1
         AND diffRun.bothways = 1
         AND diffRun.magicked = 0
+        AND diffSkyfile.quality = 0
     -- diff WHERE hook %s
     ) AS diffWarps