Index: trunk/ippTools/share/pztool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/pztool_pendingimfile.sql	(revision 15306)
+++ trunk/ippTools/share/pztool_pendingimfile.sql	(revision 15821)
@@ -1,10 +1,13 @@
-SELECT
-    summitImfile.*,
-    summitExp.dateobs
-FROM pzPendingImfile
-JOIN summitImfile
-    USING(exp_name, camera, telescope, class, class_id)
-JOIN summitExp
-    USING(exp_name, camera, telescope)
-ORDER BY
-    summitExp.dateobs
+SELECT *
+FROM (
+    SELECT
+        summitImfile.*,
+        summitExp.dateobs
+    FROM pzPendingImfile
+    JOIN summitImfile
+        USING(exp_name, camera, telescope, class, class_id)
+    JOIN summitExp
+        USING(exp_name, camera, telescope)
+    ORDER BY
+        summitExp.dateobs
+) as Foo