Index: /trunk/ippTools/share/Makefile.am
===================================================================
--- /trunk/ippTools/share/Makefile.am	(revision 15061)
+++ /trunk/ippTools/share/Makefile.am	(revision 15062)
@@ -39,4 +39,5 @@
 	difftool_revertdiffskyfile.sql \
 	pztool_find_completed_exp.sql \
+	pztool_pendingimfile.sql \
 	regtool_pendingexp.sql \
 	regtool_pendingimfile.sql \
Index: /trunk/ippTools/share/pztool_pendingimfile.sql
===================================================================
--- /trunk/ippTools/share/pztool_pendingimfile.sql	(revision 15062)
+++ /trunk/ippTools/share/pztool_pendingimfile.sql	(revision 15062)
@@ -0,0 +1,8 @@
+SELECT
+    summitImfile.*,
+    summitExp.dateobs
+FROM pzPendingImfile
+JOIN summitImfile
+    USING(exp_name, camera, telescope, class, class_id)
+JOIN summitExp
+    USING(exp_name, camera, telescope)
Index: /trunk/ippTools/src/pztool.c
===================================================================
--- /trunk/ippTools/src/pztool.c	(revision 15061)
+++ /trunk/ippTools/src/pztool.c	(revision 15062)
@@ -28,4 +28,5 @@
 
 #include "pxtools.h"
+#include "pxdata.h"
 #include "pztool.h"
 
@@ -217,11 +218,9 @@
     }
 
-    psString query = psStringCopy(
-            "SELECT"
-            "   summitImfile.*"
-            " FROM pzPendingImfile"
-            " JOIN summitImfile"
-            "   USING(exp_name, camera, telescope, class, class_id)"
-        );
+    psString query = pxDataGet("pztool_pendingimfile.sql");
+    if (!query) {
+        psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");
+        return false;
+    }
 
     if (config->where) {