Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 28146)
+++ trunk/ippTools/share/Makefile.am	(revision 28154)
@@ -294,4 +294,5 @@
      staticskytool_todo.sql \
      staticskytool_result.sql \
+     staticskytool_revert.sql \
      warptool_change_skyfile_data_state.sql \
      warptool_change_run_state.sql \
Index: trunk/ippTools/share/staticskytool_revert.sql
===================================================================
--- trunk/ippTools/share/staticskytool_revert.sql	(revision 28154)
+++ trunk/ippTools/share/staticskytool_revert.sql	(revision 28154)
@@ -0,0 +1,5 @@
+DELETE FROM staticskyResult
+USING staticskyResult, staticskyRun
+WHERE staticskyRun.sky_id = staticskyResult.sky_id
+    AND staticskyRun.state = 'new'
+    AND staticskyResult.fault != 0
Index: trunk/ippTools/share/staticskytool_todo.sql
===================================================================
--- trunk/ippTools/share/staticskytool_todo.sql	(revision 28146)
+++ trunk/ippTools/share/staticskytool_todo.sql	(revision 28154)
@@ -4,5 +4,7 @@
     staticskyRun.reduction,
     staticskyRun.label,
-    staticskyRun.state
+    staticskyRun.state,
+    stackRun.tess_id,
+    stackRun.skycell_id
 FROM staticskyRun
 JOIN staticskyInput USING (sky_id)