Index: trunk/ippTools/share/regtool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_pendingimfile.sql	(revision 17572)
+++ trunk/ippTools/share/regtool_pendingimfile.sql	(revision 17573)
@@ -1,18 +1,17 @@
-SELECT DISTINCT * FROM
-    (SELECT
-        newExp.exp_id,
-        newExp.tmp_exp_name,
-        newExp.tmp_camera,
-        newExp.tmp_telescope,
-        newExp.workdir,
-        newImfile.tmp_class_id,
-        newImfile.uri
-    FROM newImfile
-    JOIN newExp
-        USING(exp_id)
-    LEFT JOIN rawImfile
-        ON newExp.exp_id = rawImfile.exp_id
-        AND newImfile.tmp_class_id = rawImfile.tmp_class_id
-    WHERE
-        newExp.state = 'run'
-        AND rawImfile.tmp_class_id IS NULL) as Foo
+SELECT DISTINCT
+    newExp.exp_id,
+    newExp.tmp_exp_name,
+    newExp.tmp_camera,
+    newExp.tmp_telescope,
+    newExp.workdir,
+    newImfile.tmp_class_id,
+    newImfile.uri
+FROM newImfile
+JOIN newExp
+    USING(exp_id)
+LEFT JOIN rawImfile
+    ON newExp.exp_id = rawImfile.exp_id
+    AND newImfile.tmp_class_id = rawImfile.tmp_class_id
+WHERE
+    newExp.state = 'run'
+    AND rawImfile.tmp_class_id IS NULL