Index: trunk/ippTools/share/diffphottool_advance.sql
===================================================================
--- trunk/ippTools/share/diffphottool_advance.sql	(revision 28364)
+++ trunk/ippTools/share/diffphottool_advance.sql	(revision 28365)
@@ -9,3 +9,4 @@
     AND diffSkyfile.quality = 0
 -- WHERE hook %s
+GROUP BY diff_phot_id
 HAVING COUNT(diffPhotSkyfile.skycell_id) = COUNT(diffSkyfile.skycell_id)
Index: trunk/ippTools/src/diffphottool.c
===================================================================
--- trunk/ippTools/src/diffphottool.c	(revision 28364)
+++ trunk/ippTools/src/diffphottool.c	(revision 28365)
@@ -428,5 +428,5 @@
         psS64 diff_phot_id = psMetadataLookupS64(NULL, row, "diff_phot_id");
 
-        const char *query = "UPDATE diffRun SET state = 'full' WHERE diff_id = %" PRId64;
+        const char *query = "UPDATE diffPhotRun SET state = 'full' WHERE diff_phot_id = %" PRId64;
         if (!p_psDBRunQueryF(config->dbh, query, diff_phot_id)) {
             psError(psErrorCodeLast(), false,