Index: trunk/ippTools/share/addtool_checkminidvodbaddrun.sql
===================================================================
--- trunk/ippTools/share/addtool_checkminidvodbaddrun.sql	(revision 39519)
+++ trunk/ippTools/share/addtool_checkminidvodbaddrun.sql	(revision 39528)
@@ -15,5 +15,5 @@
         -- the second select grabs and counts all the addRuns with state
         -- of 'full'         
-   WHERE addRun.state = 'full' and minidvodb_group = minidbg
+   WHERE addRun.state = 'full' and minidvodb_group = '%s'
    GROUP BY minidvodb_name ) 
 AS foo2 
Index: trunk/ippTools/share/addtool_find_diff_id_dvo.sql
===================================================================
--- trunk/ippTools/share/addtool_find_diff_id_dvo.sql	(revision 39519)
+++ trunk/ippTools/share/addtool_find_diff_id_dvo.sql	(revision 39528)
@@ -12,7 +12,11 @@
                    JOIN rawExp using (exp_id) 
 WHERE diffRun.state = 'full' and diffSkyfile.quality = 0
-    AND diffRun.diff_id NOT IN (SELECT diffRun.diff_id
-       FROM addRun
-       JOIN diffRun on (diffRun.diff_id = addRun.stage_id and addRun.stage = 'diff') JOIN diffSkyfile on (diffRun.diff_id = diffSkyfile.diff_id)
+    AND diffInputSkyfile.diff_skyfile_id NOT IN (SELECT diffInputSkyfile.diff_skyfile_id
+    FROM 
+    	 diffInputSkyfile  
+    JOIN diffSkyfile     USING (diff_id, skycell_id) 
+    JOIN diffRun     using(diff_id, tess_id) 
+    JOIN skycell using (skycell_id, tess_id) 
+    left join addRun  ON (diff_id = stage_id and diff_skyfile_id = stage_extra1 and stage = "diff")
        WHERE addRun.stage = 'diff' AND %s
       )
Index: trunk/ippTools/src/addtool.c
===================================================================
--- trunk/ippTools/src/addtool.c	(revision 39519)
+++ trunk/ippTools/src/addtool.c	(revision 39528)
@@ -1921,5 +1921,5 @@
 
   psString query = NULL;
-  psStringAppend(&query, bare_query, minidvodb_group);
+  psStringAppend(&query, bare_query, minidvodb_group, minidvodb_group);
   psStringAppend(&query," %s ", where_string);