Changeset 28471 for branches/pap/ippTools/share/bgtool_advancewarp.sql

Timestamp:

Jun 24, 2010, 12:46:06 PM (16 years ago)

Author:

Paul Price

Message:

Fix advance queries.

File:

• branches/pap/ippTools/share/bgtool_advancewarp.sql (modified) (1 diff)

branches/pap/ippTools/share/bgtool_advancewarp.sql

@@ -8 +8 @@
     AND warpSkyfile.quality = 0
     AND warpSkyfile.fault = 0
-    AND warpBackgroundSkyfile.fault = 0
 -- WHERE hook %s
 GROUP BY warp_bg_id
-HAVING COUNT(warpBackgroundSkyfile.warp_bg_id) = COUNT(warpSkyfile.warp_id)
+HAVING
+    COUNT(warpBackgroundSkyfile.skycell_id) = COUNT(warpSkyfile.skycell_id)
+    AND SUM(IF(warpBackgroundSkyfile.fault > 0, 1, 0)) = 0
+    AND SUM(IF(warpBackgroundSkyfile.quality > 0, 1, 0)) != COUNT(*)