Index: trunk/ippTools/share/addtool_find_diff_id_dvo.sql
===================================================================
--- trunk/ippTools/share/addtool_find_diff_id_dvo.sql	(revision 38296)
+++ trunk/ippTools/share/addtool_find_diff_id_dvo.sql	(revision 38359)
@@ -3,6 +3,12 @@
      diffInputSkyfile 
 JOIN diffSkyfile using (diff_id, skycell_id) 
-JOIN diffRun using (diff_id)
-
+JOIN diffRun using (diff_id,tess_id)
+JOIN skycell using (skycell_id, tess_id) 
+     	     	   JOIN warpRun on (warp1 = warp_id 
+                   AND diffInputSkyfile.skycell_id = skycell_id) 
+                   JOIN fakeRun using (fake_id) 
+                   JOIN camRun using (cam_id) 
+                   JOIN chipRun using (chip_id)  
+                   JOIN rawExp using (exp_id) 
 WHERE diffRun.state = 'full' and diffSkyfile.quality = 0
     AND diffRun.diff_id NOT IN (SELECT diffRun.diff_id