Index: trunk/ippTools/share/camtool_find_chip_id.sql
===================================================================
--- trunk/ippTools/share/camtool_find_chip_id.sql	(revision 23613)
+++ trunk/ippTools/share/camtool_find_chip_id.sql	(revision 23617)
@@ -1,31 +1,28 @@
 SELECT
-    *
-FROM
-    (SELECT DISTINCT
-        chipRun.*,
-        rawExp.camera,
-        rawExp.telescope,
-        rawExp.dateobs,
-        rawExp.exp_tag,
-        rawExp.exp_type,
-        rawExp.filelevel,
-        rawExp.filter,
-        rawExp.airmass,
-        rawExp.ra,
-        rawExp.decl,
-        rawExp.exp_time,
-        rawExp.sat_pixel_frac,
-        rawExp.bg,
-        rawExp.bg_stdev,
-        rawExp.bg_mean_stdev,
-        rawExp.alt,
-        rawExp.az,
-        rawExp.ccd_temp,
-        rawExp.posang,
-        rawExp.object,
-        rawExp.sun_angle
-    FROM chipRun
-    JOIN rawExp
-        using(exp_id)
-    WHERE
-        chipRun.state = 'full') as Foo
+    chipRun.*,
+    rawExp.camera,
+    rawExp.telescope,
+    rawExp.dateobs,
+    rawExp.exp_tag,
+    rawExp.exp_type,
+    rawExp.filelevel,
+    rawExp.filter,
+    rawExp.airmass,
+    rawExp.ra,
+    rawExp.decl,
+    rawExp.exp_time,
+    rawExp.sat_pixel_frac,
+    rawExp.bg,
+    rawExp.bg_stdev,
+    rawExp.bg_mean_stdev,
+    rawExp.alt,
+    rawExp.az,
+    rawExp.ccd_temp,
+    rawExp.posang,
+    rawExp.object,
+    rawExp.sun_angle
+FROM chipRun
+JOIN rawExp
+    using(exp_id)
+WHERE
+    chipRun.state = 'full'
Index: trunk/ippTools/share/camtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 23613)
+++ trunk/ippTools/share/camtool_find_pendingexp.sql	(revision 23617)
@@ -2,29 +2,23 @@
 -- does a little more work then is necessary for -addprocessed but it seems
 -- "cleaner" to use the same query for both cases 
-SELECT * FROM
-    (SELECT
-        camRun.*,
-        rawExp.exp_tag,
-        rawExp.exp_id,
-        rawExp.exp_name,
-        rawExp.camera,
-        rawExp.telescope,
-        rawExp.filelevel
-    FROM camRun
-    JOIN chipRun
-        USING(chip_id)
---  JOIN chipProcessedImfile
---      USING(chip_id)
-    JOIN rawExp
-        USING(exp_id)
---      ON chipProcessedImfile.exp_id = rawExp.exp_id
-    LEFT JOIN camProcessedExp
-        USING(cam_id)
-    LEFT JOIN camMask
-        ON camRun.label = camMask.label
-    WHERE
-        chipRun.state = 'full'
-        AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL)
-            OR camRun.state = 'update')
-        AND camMask.label IS NULL
-    ) as Foo
+SELECT
+    camRun.*,
+    rawExp.exp_tag,
+    rawExp.exp_id,
+    rawExp.exp_name,
+    rawExp.camera,
+    rawExp.telescope,
+    rawExp.filelevel
+FROM camRun
+JOIN chipRun
+    USING(chip_id)
+JOIN rawExp
+    USING(exp_id)
+LEFT JOIN camProcessedExp
+    USING(cam_id)
+LEFT JOIN camMask
+    ON camRun.label = camMask.label
+WHERE
+    chipRun.state = 'full'
+    AND ((camRun.state = 'new' AND camProcessedExp.cam_id IS NULL) OR camRun.state = 'update')
+    AND camMask.label IS NULL
Index: trunk/ippTools/share/camtool_find_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 23613)
+++ trunk/ippTools/share/camtool_find_pendingimfile.sql	(revision 23617)
@@ -1,25 +1,20 @@
-SELECT DISTINCT * FROM
-     -- the subselect is so where criteria can be specified without knowing
-     -- which table the field came from
-    (SELECT
-        camRun.cam_id,
-        chipProcessedImfile.*,
-        rawExp.exp_name,
-        rawExp.camera,
-        rawExp.telescope,
-        rawExp.filelevel
-    FROM camRun
-    JOIN chipRun
---      ON camRun.chip_id = chipRun.chip_id
-        USING (chip_id)
-    JOIN chipProcessedImfile
---      ON camRun.chip_id = chipProcessedImfile.chip_id
-        USING (chip_id)
-    JOIN rawExp
-      ON chipProcessedImfile.exp_id = rawExp.exp_id
-    LEFT JOIN camProcessedExp
-        USING(cam_id)
-    LEFT JOIN camMask
-        ON camRun.label = camMask.label
-    WHERE
-        camMask.label IS NULL) as foo
+SELECT
+    camRun.cam_id,
+    chipProcessedImfile.*,
+    rawExp.exp_name,
+    rawExp.camera,
+    rawExp.telescope,
+    rawExp.filelevel
+FROM camRun
+JOIN chipRun
+    USING (chip_id)
+JOIN chipProcessedImfile
+    USING (chip_id)
+JOIN rawExp
+  ON chipProcessedImfile.exp_id = rawExp.exp_id
+LEFT JOIN camProcessedExp
+    USING(cam_id)
+LEFT JOIN camMask
+    ON camRun.label = camMask.label
+WHERE
+    camMask.label IS NULL
Index: trunk/ippTools/share/camtool_find_processedexp.sql
===================================================================
--- trunk/ippTools/share/camtool_find_processedexp.sql	(revision 23613)
+++ trunk/ippTools/share/camtool_find_processedexp.sql	(revision 23617)
@@ -1,3 +1,3 @@
-SELECT DISTINCT
+SELECT
     camProcessedExp.*,
     chipRun.chip_id,