Index: trunk/ippTools/share/disttool_pending_camera.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_camera.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_camera.sql	(revision 25838)
@@ -17,5 +17,5 @@
     chipRun.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN camRun ON camRun.cam_id = distRun.stage_id
 JOIN camProcessedExp USING(cam_id)
Index: trunk/ippTools/share/disttool_pending_chip.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_chip.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_chip.sql	(revision 25838)
@@ -6,5 +6,5 @@
     stage_id,
     chipProcessedImfile.class_id AS component,
-    clean,
+    distRun.clean,
     rawExp.camera,
     CONCAT_WS('.', outroot, CONVERT(distRun.dist_id, CHAR)) as outdir,
@@ -17,5 +17,5 @@
     chipProcessedImfile.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN chipRun ON chipRun.chip_id = distRun.stage_id
 JOIN rawExp using(exp_id)
Index: trunk/ippTools/share/disttool_pending_diff.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_diff.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_diff.sql	(revision 25838)
@@ -19,5 +19,5 @@
     diffSkyfile.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN diffRun ON stage_id = diff_id
 JOIN diffSkyfile using(diff_id)
Index: trunk/ippTools/share/disttool_pending_fake.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_fake.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_fake.sql	(revision 25838)
@@ -17,5 +17,5 @@
     0
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN fakeRun ON fakeRun.fake_id = distRun.stage_id
 JOIN fakeProcessedImfile USING(fake_id)
Index: trunk/ippTools/share/disttool_pending_raw.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_raw.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_raw.sql	(revision 25838)
@@ -17,5 +17,5 @@
     rawImfile.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN rawExp ON rawExp.exp_id = stage_id
 JOIN rawImfile USING(exp_id)
@@ -52,5 +52,5 @@
     rawExp.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN rawExp ON exp_id = stage_id
 LEFT JOIN distComponent 
Index: trunk/ippTools/share/disttool_pending_stack.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_stack.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_stack.sql	(revision 25838)
@@ -19,5 +19,5 @@
     0 AS magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN stackRun
     ON stage_id = stack_id
Index: trunk/ippTools/share/disttool_pending_warp.sql
===================================================================
--- trunk/ippTools/share/disttool_pending_warp.sql	(revision 25837)
+++ trunk/ippTools/share/disttool_pending_warp.sql	(revision 25838)
@@ -17,5 +17,5 @@
     warpSkyfile.magicked
 FROM distRun
-JOIN distTarget USING(target_id, stage)
+JOIN distTarget USING(target_id, stage, clean)
 JOIN warpRun ON stage_id = warp_id
 JOIN warpSkyfile using(warp_id)