Index: /tags/ipp-20100823/ippTools/share/chiptool_listrun.sql
===================================================================
--- /tags/ipp-20100823/ippTools/share/chiptool_listrun.sql	(revision 29209)
+++ /tags/ipp-20100823/ippTools/share/chiptool_listrun.sql	(revision 29210)
@@ -29,3 +29,3 @@
 LEFT JOIN camProcessedExp USING(cam_id)
 LEFT JOIN magicDSRun
-    ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place
+    ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place AND magicDSRun.state != 'drop'
Index: /tags/ipp-20100823/ippTools/share/chiptool_processedimfile.sql
===================================================================
--- /tags/ipp-20100823/ippTools/share/chiptool_processedimfile.sql	(revision 29209)
+++ /tags/ipp-20100823/ippTools/share/chiptool_processedimfile.sql	(revision 29210)
@@ -42,3 +42,3 @@
     AND chipProcessedImfile.class_id = rawImfile.class_id
 LEFT JOIN magicDSRun
-    ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place
+    ON stage_id = chip_id AND stage = 'chip' AND magicDSRun.re_place AND magicDSRun.state != 'drop'