Index: trunk/ippTools/share/diffphottool_advance.sql
===================================================================
--- trunk/ippTools/share/diffphottool_advance.sql	(revision 28343)
+++ trunk/ippTools/share/diffphottool_advance.sql	(revision 28364)
@@ -1,15 +1,11 @@
-UPDATE diffPhotRun
-SET state = 'full'
-WHERE diff_phot_id IN (
-    SELECT
-        diff_phot_id
-    FROM diffPhotRun
-    JOIN diffSkyfile USING(diff_id)
-    JOIN diffPhotSkyfile USING(diff_phot_id)
-    WHERE diffPhotRun.state = 'new'
-        AND diffPhotSkyfile.fault = 0
-        AND diffSkyfile.fault = 0
-        AND diffSkyfile.quality = 0
-        -- WHERE hook %s
-    HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)
-) AS diffPhotRunsDone
+SELECT
+    diff_phot_id
+FROM diffPhotRun
+JOIN diffSkyfile USING(diff_id)
+JOIN diffPhotSkyfile USING(diff_phot_id)
+WHERE diffPhotRun.state = 'new'
+    AND diffPhotSkyfile.fault = 0
+    AND diffSkyfile.fault = 0
+    AND diffSkyfile.quality = 0
+-- WHERE hook %s
+HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)