Index: /branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanupexp.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanupexp.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanupexp.sql	(revision 18645)
@@ -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: /branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanuprun.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanuprun.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/camtool_pendingcleanuprun.sql	(revision 18645)
@@ -0,0 +1,9 @@
+SELECT
+    camRun.cam_id,
+    rawExp.camera,
+    camRun.state
+FROM camRun
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    camRun.state = 'goto_cleaned'
Index: /branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanuprun.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanuprun.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanuprun.sql	(revision 18645)
@@ -0,0 +1,9 @@
+SELECT
+    diffRun.diff_id,
+    rawExp.camera,
+    diffRun.state
+FROM diffRun
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    diffRun.state = 'goto_cleaned'
Index: /branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanupskyfile.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanupskyfile.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/difftool_pendingcleanupskyfile.sql	(revision 18645)
@@ -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: /branches/eam_branch_20080719/ippTools/share/faketool_pendingcleanupimfile.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/faketool_pendingcleanupimfile.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/faketool_pendingcleanupimfile.sql	(revision 18645)
@@ -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: /branches/eam_branch_20080719/ippTools/share/faketool_pendingcleanuprun.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/faketool_pendingcleanuprun.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/faketool_pendingcleanuprun.sql	(revision 18645)
@@ -0,0 +1,9 @@
+SELECT
+    fakeRun.fake_id,
+    rawExp.camera,
+    fakeRun.state
+FROM fakeRun
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    fakeRun.state = 'goto_cleaned'
Index: /branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanuprun.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanuprun.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanuprun.sql	(revision 18645)
@@ -0,0 +1,9 @@
+SELECT
+    stackRun.stack_id,
+    rawExp.camera,
+    stackRun.state
+FROM stackRun
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    stackRun.state = 'goto_cleaned'
Index: /branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanupskyfile.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanupskyfile.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/stacktool_pendingcleanupskyfile.sql	(revision 18645)
@@ -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: /branches/eam_branch_20080719/ippTools/share/warptool_pendingcleanuprun.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/warptool_pendingcleanuprun.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/warptool_pendingcleanuprun.sql	(revision 18645)
@@ -0,0 +1,9 @@
+SELECT
+    warpRun.warp_id,
+    rawExp.camera,
+    warpRun.state
+FROM warpRun
+JOIN rawExp 
+USING (exp_id)
+WHERE
+    warpRun.state = 'goto_cleaned'
Index: /branches/eam_branch_20080719/ippTools/share/warptool_pendingcleanupwarp.sql
===================================================================
--- /branches/eam_branch_20080719/ippTools/share/warptool_pendingcleanupwarp.sql	(revision 18645)
+++ /branches/eam_branch_20080719/ippTools/share/warptool_pendingcleanupwarp.sql	(revision 18645)
@@ -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'