Index: trunk/ippTools/share/disttool_definebyquery_SSdiff.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_SSdiff.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_SSdiff.sql	(revision 36668)
@@ -22,5 +22,3 @@
       AND distTarget.state = 'enabled'
       AND rcInterest.state = 'enabled'
-      AND distRun.dist_id IS NULL
-
       AND ((diffRun.state = 'full') OR (distTarget.clean AND diffRun.state = 'cleaned'))
Index: trunk/ippTools/share/disttool_definebyquery_camera.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_camera.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_camera.sql	(revision 36668)
@@ -21,4 +21,3 @@
 WHERE distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL      -- no existing distRun 
     AND ((camRun.state = 'full') OR (distTarget.clean AND camRun.state = 'cleaned'))
Index: trunk/ippTools/share/disttool_definebyquery_chip_bg.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_chip_bg.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_chip_bg.sql	(revision 36668)
@@ -23,4 +23,3 @@
 WHERE distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL      -- no existing distRun
     AND ((chipBackgroundRun.state = 'full') OR (distTarget.clean AND chipBackgroundRun.state = 'cleaned'))
Index: trunk/ippTools/share/disttool_definebyquery_diff.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_diff.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_diff.sql	(revision 36668)
@@ -25,5 +25,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((diffRun.state = 'full') OR (distTarget.clean AND diffRun.state = 'cleaned'))
 
Index: trunk/ippTools/share/disttool_definebyquery_fake.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_fake.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_fake.sql	(revision 36668)
@@ -20,4 +20,3 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((fakeRun.state = 'full') OR (distTarget.clean AND fakeRun.state = 'cleaned'))
Index: trunk/ippTools/share/disttool_definebyquery_ff.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_ff.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_ff.sql	(revision 36668)
@@ -21,5 +21,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND fullForceRun.state = 'full'
     AND stackRun.filter = distTarget.filter
Index: trunk/ippTools/share/disttool_definebyquery_raw.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_raw.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_raw.sql	(revision 36668)
@@ -16,6 +16,5 @@
 JOIN rcInterest USING(target_id)
 LEFT JOIN distRun ON distRun.stage_id = exp_id AND distRun.target_id = distTarget.target_id
-WHERE distRun.dist_id IS NULL           -- no existing distRun for this exposure
-    AND distTarget.state = 'enabled'    -- target and intrest are enabled
+WHERE distTarget.state = 'enabled'    -- target and intrest are enabled
     AND rcInterest.state = 'enabled'
     AND magicDSRun.state = 'full'       -- destreaked files are available
Index: trunk/ippTools/share/disttool_definebyquery_sky.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_sky.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_sky.sql	(revision 36668)
@@ -23,5 +23,4 @@
     AND rcInterest.state = 'enabled'
     AND distTarget.filter = 'multi'
-    AND distRun.dist_id IS NULL
     AND ((staticskyRun.state = 'full') OR (distTarget.clean AND staticskyRun.state = 'cleaned'))
     -- we shouldn't need to check fault. If faulted it shouldn't be full
Index: trunk/ippTools/share/disttool_definebyquery_sky_singlefilter.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_sky_singlefilter.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_sky_singlefilter.sql	(revision 36668)
@@ -22,5 +22,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((staticskyRun.state = 'full') OR (distTarget.clean AND staticskyRun.state = 'cleaned'))
     AND stackRun.filter = distTarget.filter
Index: trunk/ippTools/share/disttool_definebyquery_skycal.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_skycal.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_skycal.sql	(revision 36668)
@@ -1,3 +1,3 @@
-SELECT
+SELECT DISTINCT
     'skycal' as stage,
     skycalRun.skycal_id AS stage_id,
@@ -21,5 +21,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((skycalRun.state = 'full') OR (distTarget.clean AND skycalRun.state = 'cleaned'))
     AND stackRun.filter = distTarget.filter
Index: trunk/ippTools/share/disttool_definebyquery_stack.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_stack.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_stack.sql	(revision 36668)
@@ -21,5 +21,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((stackRun.state = 'full') OR (distTarget.clean AND stackRun.state = 'cleaned'))
     -- we shouldn't need to check fault. If faulted it shouldn't be full
Index: trunk/ippTools/share/disttool_definebyquery_warp.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_warp.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_warp.sql	(revision 36668)
@@ -22,5 +22,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((warpRun.state = 'full') OR (distTarget.clean AND warpRun.state = 'cleaned'))
 
Index: trunk/ippTools/share/disttool_definebyquery_warp_bg.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_warp_bg.sql	(revision 36665)
+++ trunk/ippTools/share/disttool_definebyquery_warp_bg.sql	(revision 36668)
@@ -24,5 +24,4 @@
 WHERE  distTarget.state = 'enabled'
     AND rcInterest.state = 'enabled'
-    AND distRun.dist_id IS NULL
     AND ((warpBackgroundRun.state = 'full') OR (distTarget.clean AND warpBackgroundRun.state = 'cleaned'))
 
