Changeset 28471

Timestamp:

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

Author:

Paul Price

Message:

Fix advance queries.

Location:

branches/pap/ippTools/share

Files:

• bgtool_advancechip.sql (modified) (1 diff)
• bgtool_advancewarp.sql (modified) (1 diff)

branches/pap/ippTools/share/bgtool_advancechip.sql

@@ -8 +8 @@
     AND chipProcessedImfile.quality = 0
     AND chipProcessedImfile.fault = 0
-    AND chipBackgroundImfile.fault = 0
 -- WHERE hook %s
 GROUP BY chip_bg_id
-HAVING COUNT(chipBackgroundImfile.chip_bg_id) = COUNT(chipProcessedImfile.chip_id)
+HAVING
+    COUNT(chipBackgroundImfile.class_id) = COUNT(chipProcessedImfile.class_id)
+    AND SUM(IF(chipBackgroundImfile.fault > 0, 1, 0)) = 0
+    AND SUM(IF(chipBackgroundImfile.quality > 0, 1, 0)) != COUNT(*)

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(*)