Index: trunk/ippTools/share/diffphottool_advance.sql
===================================================================
--- trunk/ippTools/share/diffphottool_advance.sql	(revision 28365)
+++ trunk/ippTools/share/diffphottool_advance.sql	(revision 28414)
@@ -3,7 +3,6 @@
 FROM diffPhotRun
 JOIN diffSkyfile USING(diff_id)
-JOIN diffPhotSkyfile USING(diff_phot_id)
+LEFT JOIN diffPhotSkyfile USING(diff_phot_id, skycell_id)
 WHERE diffPhotRun.state = 'new'
-    AND diffPhotSkyfile.fault = 0
     AND diffSkyfile.fault = 0
     AND diffSkyfile.quality = 0
@@ -11,2 +10,3 @@
 GROUP BY diff_phot_id
 HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)
+    AND SUM(IF(diffPhotSkyfile.fault > 0, 1, 0)) = 0