Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 41705)
+++ trunk/ippTools/share/Makefile.am	(revision 42097)
@@ -421,4 +421,5 @@
 	stacktool_sassskyfile.sql \
 	stacktool_tosum.sql \
+	stacktool_tosum_allstates.sql \
 	stacktool_tobkg.sql \
 	stacktool_tosummary.sql \
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 41705)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 42097)
@@ -1453,5 +1453,5 @@
         username VARCHAR(255),
         proj_id BIGINT,
-        registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+        registered datetime,
         timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         fault SMALLINT,
Index: trunk/ippTools/share/stacktool_tosum_allstates.sql
===================================================================
--- trunk/ippTools/share/stacktool_tosum_allstates.sql	(revision 42097)
+++ trunk/ippTools/share/stacktool_tosum_allstates.sql	(revision 42097)
@@ -0,0 +1,21 @@
+SELECT
+    stackRun.stack_id,
+    stackRun.tess_id,
+    stackRun.skycell_id,
+    stackRun.workdir,
+    stackRun.reduction,
+    stackRun.label,
+    stackRun.state,
+    stackSumSkyfile.path_base,
+    IFNULL(Label.priority, 10000) AS priority
+FROM stackRun
+JOIN stackInputSkyfile USING(stack_id)
+JOIN warpRun USING(warp_id)
+LEFT JOIN stackSumSkyfile USING(stack_id)
+LEFT JOIN Label ON Label.label = stackRun.label
+WHERE
+    ((stackRun.state = 'new' AND stackSumSkyfile.stack_id IS NULL)
+    OR (stackRun.state = 'update' AND stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0))
+    AND (Label.active OR Label.active IS NULL)
+    -- WHERE hook %s
+GROUP BY stack_id