Index: trunk/ippTools/share/pztool_pendingimfile.sql
===================================================================
--- trunk/ippTools/share/pztool_pendingimfile.sql	(revision 33525)
+++ trunk/ippTools/share/pztool_pendingimfile.sql	(revision 33533)
@@ -1,5 +1,6 @@
 SELECT *
 FROM (
-    SELECT
+    SELECT * FROM 
+    (SELECT
         summitImfile.*,
         summitExp.dateobs
@@ -20,6 +21,8 @@
         AND pzDownloadImfile.class_id IS NULL
 	AND summitImfile.exp_name NOT LIKE '%a'
+    ORDER BY dateobs) AS partA
 UNION
-    SELECT
+    SELECT * FROM 
+    (SELECT
         summitImfile.*,
         summitExp.dateobs
@@ -40,3 +43,4 @@
         AND pzDownloadImfile.class_id IS NULL
 	AND summitImfile.exp_name LIKE '%a'
+    ORDER BY dateobs) AS partB
 ) as Foo
Index: trunk/ippTools/src/pztool.c
===================================================================
--- trunk/ippTools/src/pztool.c	(revision 33525)
+++ trunk/ippTools/src/pztool.c	(revision 33533)
@@ -338,8 +338,8 @@
         }
 
-        psStringAppend(&query, " ORDER BY dateobs");
-        if (desc) {
-            psStringAppend(&query, " DESC");
-        }
+/*         psStringAppend(&query, " ORDER BY dateobs"); */
+/*         if (desc) { */
+/*             psStringAppend(&query, " DESC"); */
+/*         } */
 
         // request the full "limit" from each known camera and throw away any