Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 25779)
+++ trunk/ippTools/share/Makefile.am	(revision 25789)
@@ -4,5 +4,10 @@
 
 dist_pkgdata_DATA = \
+     addtool_donecleanup.sql \
+     addtool_find_cam_id.sql \
      addtool_find_pendingexp.sql \
+     addtool_find_processedexp.sql \
+     addtool_pendingcleanupexp.sql \
+     addtool_pendingcleanuprun.sql \
      addtool_queue_cam_id.sql \
      addtool_reset_faulted_runs.sql \
Index: trunk/ippTools/share/addtool_donecleanup.sql
===================================================================
--- trunk/ippTools/share/addtool_donecleanup.sql	(revision 25789)
+++ trunk/ippTools/share/addtool_donecleanup.sql	(revision 25789)
@@ -0,0 +1,5 @@
+SELECT
+    addRun.*
+FROM addRun
+WHERE
+    addRun.state = 'cleaned'
Index: trunk/ippTools/share/addtool_find_cam_id.sql
===================================================================
--- trunk/ippTools/share/addtool_find_cam_id.sql	(revision 25789)
+++ trunk/ippTools/share/addtool_find_cam_id.sql	(revision 25789)
@@ -0,0 +1,9 @@
+SELECT
+    camRun.*
+FROM camRun
+JOIN chipRun
+    USING(chip_id)
+JOIN rawExp
+    USING(exp_id)
+WHERE
+    camRun.state = 'full'
Index: trunk/ippTools/share/addtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/addtool_find_pendingexp.sql	(revision 25779)
+++ trunk/ippTools/share/addtool_find_pendingexp.sql	(revision 25789)
@@ -12,8 +12,6 @@
 JOIN chipRun
     USING(chip_id)
-JOIN chipProcessedImfile
-    USING(chip_id)
 JOIN rawExp
-    ON chipRun.exp_id = rawExp.exp_id
+    USING(exp_id)
 LEFT JOIN addProcessedExp
     USING(add_id)
Index: trunk/ippTools/share/addtool_find_processedexp.sql
===================================================================
--- trunk/ippTools/share/addtool_find_processedexp.sql	(revision 25789)
+++ trunk/ippTools/share/addtool_find_processedexp.sql	(revision 25789)
@@ -0,0 +1,10 @@
+SELECT
+    addProcessedExp.*,
+    addRun.workdir
+FROM addRun
+JOIN camProcessedExp
+    USING(cam_id)
+JOIN chipRun
+    USING(chip_id)
+JOIN rawExp
+    ON chipRun.exp_id = rawExp.exp_id
Index: trunk/ippTools/share/addtool_pendingcleanupexp.sql
===================================================================
--- trunk/ippTools/share/addtool_pendingcleanupexp.sql	(revision 25789)
+++ trunk/ippTools/share/addtool_pendingcleanupexp.sql	(revision 25789)
@@ -0,0 +1,12 @@
+SELECT
+    addProcessedExp.*,
+    addRun.state,
+    addRun.workdir,
+    addRun.label,
+    addRun.dvodb,
+FROM addRun
+JOIN addProcessedExp
+    USING(add_id)
+WHERE
+    (addRun.state = 'goto_cleaned' OR addRun.state = 'goto_purged' OR addRun.state = 'goto_scrubbed')
+
Index: trunk/ippTools/share/addtool_pendingcleanuprun.sql
===================================================================
--- trunk/ippTools/share/addtool_pendingcleanuprun.sql	(revision 25789)
+++ trunk/ippTools/share/addtool_pendingcleanuprun.sql	(revision 25789)
@@ -0,0 +1,13 @@
+SELECT
+    addRun.add_id,
+    rawExp.camera,
+    addRun.state
+FROM addRun
+JOIN camRun
+USING (cam_id)
+JOIN chipRun
+USING (chip_id)
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    (addRun.state = 'goto_cleaned' OR addRun.state = 'goto_purged' OR addRun.state = 'goto_scrubbed')