Changeset 28471 for branches/pap/ippTools/share/bgtool_advancechip.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_advancechip.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(*)