Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 18328)
+++ trunk/ippTools/share/Makefile.am	(revision 18366)
@@ -11,7 +11,9 @@
 	chiptool_find_rawexp.sql \
 	chiptool_find_unprocessed_imfile.pl \
-	chiptool_pendingcleanup.sql \
+	chiptool_pendingcleanuprun.sql \
+	chiptool_pendingcleanupimfile.sql \
 	chiptool_pendingimfile.sql \
 	chiptool_processedimfile.sql \
+	chiptool_run.sql \
 	chiptool_revertprocessedimfile.sql \
 	chiptool_unmasked.sql \
Index: trunk/ippTools/share/camtool_find_chip_id.sql
===================================================================
--- trunk/ippTools/share/camtool_find_chip_id.sql	(revision 18328)
+++ trunk/ippTools/share/camtool_find_chip_id.sql	(revision 18366)
@@ -29,3 +29,3 @@
         using(exp_id)
     WHERE
-        chipRun.state = 'stop') as Foo
+        chipRun.state = 'full') as Foo
Index: trunk/ippTools/share/camtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 18328)
+++ trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 18366)
@@ -24,5 +24,5 @@
         ON camRun.label = camMask.label
     WHERE
-        chipRun.state = 'stop'
+        chipRun.state = 'full'
         AND camRun.state = 'run'
         AND camMask.label IS NULL
Index: trunk/ippTools/share/camtool_queue_chip_id.sql
===================================================================
--- trunk/ippTools/share/camtool_queue_chip_id.sql	(revision 18328)
+++ trunk/ippTools/share/camtool_queue_chip_id.sql	(revision 18366)
@@ -16,4 +16,4 @@
     FROM chipRun
     WHERE
-        chipRun.state = 'stop'
+        chipRun.state = 'full'
         AND chipRun.chip_id = %lld
Index: trunk/ippTools/share/chiptool_pendingcleanup.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingcleanup.sql	(revision 18328)
+++ 	(revision )
@@ -1,5 +1,0 @@
-SELECT
-    chipRun.*
-FROM chipRun
-WHERE
-    chipRun.state = 'goto_clean'
Index: trunk/ippTools/share/chiptool_pendingcleanupimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingcleanupimfile.sql	(revision 18366)
+++ trunk/ippTools/share/chiptool_pendingcleanupimfile.sql	(revision 18366)
@@ -0,0 +1,15 @@
+SELECT
+    chipProcessedImfile.*,
+    chipRun.state,
+    chipRun.workdir,
+    chipRun.label,
+    chipRun.reduction,
+    chipRun.expgroup,
+    chipRun.dvodb,
+    chipRun.tess_id,
+    chipRun.end_stage
+FROM chipRun
+JOIN chipProcessedImfile
+    USING(chip_id)
+WHERE
+    chipRun.state = 'goto_cleaned'
Index: trunk/ippTools/share/chiptool_pendingcleanuprun.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingcleanuprun.sql	(revision 18366)
+++ trunk/ippTools/share/chiptool_pendingcleanuprun.sql	(revision 18366)
@@ -0,0 +1,9 @@
+SELECT
+    chipRun.chip_id,
+    rawExp.camera,
+    chipRun.state
+FROM chipRun
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    chipRun.state = 'goto_cleaned'
Index: trunk/ippTools/share/chiptool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 18328)
+++ trunk/ippTools/share/chiptool_pendingimfile.sql	(revision 18366)
@@ -20,5 +20,5 @@
     ON chipRun.label = chipMask.label
 WHERE
-    chipRun.state = 'run'
+    chipRun.state = 'new'
     AND chipProcessedImfile.chip_id IS NULL
     AND chipProcessedImfile.exp_id IS NULL
Index: trunk/ippTools/share/flatcorr_completely_processed_chiprun.sql
===================================================================
--- trunk/ippTools/share/flatcorr_completely_processed_chiprun.sql	(revision 18328)
+++ trunk/ippTools/share/flatcorr_completely_processed_chiprun.sql	(revision 18366)
@@ -26,5 +26,5 @@
             AND rawImfile.class_id = chipProcessedImfile.class_id
         WHERE
-            chipRun.state = 'stop'
+            chipRun.state = 'full'
         GROUP BY
             chipRun.chip_id,
Index: trunk/ippTools/share/flatcorr_find_processedimfiles.sql
===================================================================
--- trunk/ippTools/share/flatcorr_find_processedimfiles.sql	(revision 18328)
+++ trunk/ippTools/share/flatcorr_find_processedimfiles.sql	(revision 18366)
@@ -11,4 +11,4 @@
 WHERE
     flatcorrRun.state = 'run'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'new'
 
Index: trunk/ippTools/share/flatcorr_pending.sql
===================================================================
--- trunk/ippTools/share/flatcorr_pending.sql	(revision 18328)
+++ trunk/ippTools/share/flatcorr_pending.sql	(revision 18366)
@@ -15,5 +15,5 @@
 WHERE
     flatcorrRun.state = 'run'
-    AND chipRun.state = 'stop'
+    AND chipRun.state = 'full'
 GROUP BY
     chipRun.chip_id,