Index: /trunk/ippTools/share/Makefile.am
===================================================================
--- /trunk/ippTools/share/Makefile.am	(revision 14026)
+++ /trunk/ippTools/share/Makefile.am	(revision 14027)
@@ -16,5 +16,4 @@
 	difftool_skyfile.sql \
 	difftool_todiffskyfile.sql \
-	regtool_find_unprocessed_imfile.sql \
 	regtool_pendingexp.sql \
 	regtool_pendingimfile.sql \
Index: /trunk/ippTools/share/camtool_find_pendingexp.sql
===================================================================
--- /trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 14026)
+++ /trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 14027)
@@ -4,4 +4,5 @@
 SELECT
     camRun.*,
+    rawExp.exp_tag,
     rawExp.exp_id,
     rawExp.exp_name,
Index: /trunk/ippTools/share/camtool_find_pendingimfile.sql
===================================================================
--- /trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 14026)
+++ /trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 14027)
@@ -1,9 +1,8 @@
-SELECT * FROM 
+SELECT DISTINCT * FROM 
      -- the subselect is so where criteria can be specified without knowing
      -- which table the field came from
     (SELECT
-        camPendingExp.*,
-        chipProcessedExp.exp_id,
-        chipProcessedExp.guide_id,
+        camRun.*,
+        chipProcessedImfile.exp_id,
         chipProcessedImfile.class_id,
         chipProcessedImfile.uri,
@@ -16,15 +15,15 @@
         rawExp.telescope,
         rawExp.filelevel
-    FROM camPendingExp
-    JOIN chipProcessedExp
+    FROM camRun
+    JOIN chipRun
         USING(chip_id)
     JOIN chipProcessedImfile
         USING(chip_id)
     JOIN rawExp
-        ON chipProcessedExp.exp_id = rawExp.exp_id
+        ON chipProcessedImfile.exp_id = rawExp.exp_id
     LEFT JOIN camProcessedExp
-        ON camPendingExp.cam_id = camProcessedExp.cam_id
+        ON camRun.cam_id = camProcessedExp.cam_id
     LEFT JOIN camMask
-        ON camPendingExp.label = camMask.label
+        ON camRun.label = camMask.label
     WHERE
         camProcessedExp.cam_id IS NULL
Index: /trunk/ippTools/share/camtool_find_processedexp.sql
===================================================================
--- /trunk/ippTools/share/camtool_find_processedexp.sql	(revision 14026)
+++ /trunk/ippTools/share/camtool_find_processedexp.sql	(revision 14027)
@@ -1,4 +1,5 @@
 SELECT
     camProcessedExp.*,
+    rawExp.exp_tag,
     rawExp.exp_name,
     rawExp.camera,