Index: /trunk/ippTools/share/pstamptool_completedreq.sql
===================================================================
--- /trunk/ippTools/share/pstamptool_completedreq.sql	(revision 25281)
+++ /trunk/ippTools/share/pstamptool_completedreq.sql	(revision 25281)
@@ -0,0 +1,8 @@
+SELECT * 
+FROM pstampRequest 
+WHERE state = 'run'
+    AND (
+    	SELECT count(*) FROM pstampJob 
+	WHERE pstampJob.req_id = pstampRequest.req_id
+		AND pstampJob.state != 'stop'
+	) = 0
Index: /trunk/ippTools/src/pstamptool.c
===================================================================
--- /trunk/ippTools/src/pstamptool.c	(revision 25280)
+++ /trunk/ippTools/src/pstamptool.c	(revision 25281)
@@ -383,8 +383,5 @@
     PXOPT_LOOKUP_BOOL(simple, config->args, "-simple", false);
 
-    psString query = 
-        "SELECT * FROM pstampRequest WHERE state = 'run' AND "
-            "(SELECT count(*) FROM pstampJob WHERE pstampJob.req_id = pstampRequest.req_id "
-            " AND pstampJob.state != 'stop') = 0" ;
+    psString query = pxDataGet("pstamptool_completedreq.sql");
 
     // treat limit == 0 as "no limit"