Index: trunk/ippTools/share/chiptool_completely_processed_exp.sql
===================================================================
--- trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 20477)
+++ trunk/ippTools/share/chiptool_completely_processed_exp.sql	(revision 20608)
@@ -13,5 +13,5 @@
     end_stage
 FROM
-    (SELECT 
+    (SELECT
         chipRun.*,
         rawImfile.class_id as rawimfile_class_id,
@@ -19,5 +19,6 @@
     FROM chipRun
     JOIN rawImfile
-        USING(exp_id)
+        ON chipRun.exp_id = rawImfile.exp_id
+        AND rawImfile.ignored = 0
     LEFT JOIN chipProcessedImfile
         ON chipRun.chip_id = chipProcessedImfile.chip_id
Index: trunk/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 20477)
+++ trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 20608)
@@ -12,5 +12,6 @@
     USING(exp_id)
 JOIN rawImfile
-    USING(exp_id)
+    ON rawExp.exp_id = rawImfile.exp_id
+    AND rawImfile.ignored = 0
 LEFT JOIN chipProcessedImfile
     ON chipRun.chip_id = chipProcessedImfile.chip_id
Index: trunk/ippTools/share/faketool_completely_processed_exp.sql
===================================================================
--- trunk/ippTools/share/faketool_completely_processed_exp.sql	(revision 20477)
+++ trunk/ippTools/share/faketool_completely_processed_exp.sql	(revision 20608)
@@ -13,5 +13,5 @@
     epoch
 FROM
-    (SELECT 
+    (SELECT
         fakeRun.*,
         rawImfile.class_id as rawimfile_class_id,
@@ -25,5 +25,6 @@
         USING(exp_id)
     JOIN rawImfile
-        USING(exp_id)
+        ON rawImfile.exp_id = rawExp.exp_id
+        AND rawImfile.ignored = 0
     LEFT JOIN fakeProcessedImfile
         ON fakeRun.fake_id = fakeProcessedImfile.fake_id
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 20477)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 20608)
@@ -234,4 +234,5 @@
     moon_alt FLOAT,
     moon_phase FLOAT,
+    ignored TINYINT DEFAULT 0,
     hostname VARCHAR(64),
     fault SMALLINT NOT NULL,
@@ -1081,7 +1082,7 @@
         det_type VARCHAR(64),
         dvodb VARCHAR(64),
-    	camera VARCHAR(64),
-    	telescope VARCHAR(64),
-	epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+        camera VARCHAR(64),
+        telescope VARCHAR(64),
+        epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         filter VARCHAR(64),
         state VARCHAR(64),
@@ -1100,5 +1101,5 @@
         corr_id BIGINT,
         chip_id BIGINT,
-	include TINYINT,
+        include TINYINT,
         PRIMARY KEY(corr_id, chip_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
@@ -1110,5 +1111,5 @@
         chip_id BIGINT,
         cam_id BIGINT,
-	include TINYINT,
+        include TINYINT,
         PRIMARY KEY(corr_id, cam_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
Index: trunk/ippTools/share/regtool_pendingexp.sql
===================================================================
--- trunk/ippTools/share/regtool_pendingexp.sql	(revision 20477)
+++ trunk/ippTools/share/regtool_pendingexp.sql	(revision 20608)
@@ -39,4 +39,5 @@
         newExp.state = 'run'
         AND rawExp.exp_id IS NULL
+        AND rawImfile.ignored = 0
 -- where hook %s
     GROUP BY
Index: trunk/ippTools/share/regtool_processedimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_processedimfile.sql	(revision 20477)
+++ trunk/ippTools/share/regtool_processedimfile.sql	(revision 20608)
@@ -7,4 +7,3 @@
 JOIN newExp
     USING(exp_id)
--- bogus conditional so there is a where clause to append to
-WHERE rawImfile.exp_id is NOT NULL
+WHERE rawImfile.ignored = 0
Index: trunk/ippTools/share/warptool_imfile.sql
===================================================================
--- trunk/ippTools/share/warptool_imfile.sql	(revision 20477)
+++ trunk/ippTools/share/warptool_imfile.sql	(revision 20608)
@@ -19,5 +19,6 @@
 JOIN rawImfile -- is there any reason not to refer back to rawimfiles?
     ON chipProcessedImfile.exp_id = rawImfile.exp_id
-    AND chipProcessedImfile.class_id = rawImfile.class_id 
+    AND chipProcessedImfile.class_id = rawImfile.class_id
+    AND rawImfile.ignored = 0
 WHERE
     warpRun.state = 'new'