Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 32960)
+++ trunk/ippTools/share/Makefile.am	(revision 32962)
@@ -387,4 +387,6 @@
 	staticskytool_defineskycalrun.sql \
 	staticskytool_pendingskycalrun.sql \
+	staticskytool_revertskycal.sql \
+	staticskytool_skycalresult.sql \
 	staticskytool_export_run.sql \
 	staticskytool_export_input.sql \
Index: trunk/ippTools/share/disttool_definebyquery_raw_no_magic.sql
===================================================================
--- trunk/ippTools/share/disttool_definebyquery_raw_no_magic.sql	(revision 32960)
+++ trunk/ippTools/share/disttool_definebyquery_raw_no_magic.sql	(revision 32962)
@@ -14,5 +14,4 @@
 JOIN rcInterest USING(target_id)
 LEFT JOIN distRun ON distRun.stage_id = exp_id AND distRun.target_id = distTarget.target_id
-WHERE distRun.dist_id IS NULL           -- no existing distRun for this exposure
-    AND distTarget.state = 'enabled'    -- target and intrest are enabled
+WHERE distTarget.state = 'enabled'    -- target and intrest are enabled
     AND rcInterest.state = 'enabled'
Index: trunk/ippTools/share/staticskytool_revertskycal.sql
===================================================================
--- trunk/ippTools/share/staticskytool_revertskycal.sql	(revision 32962)
+++ trunk/ippTools/share/staticskytool_revertskycal.sql	(revision 32962)
@@ -0,0 +1,6 @@
+DELETE FROM skycalResult
+USING skycalResult, skycalRun, stackRun
+WHERE skycalRun.skycal_id = skycalResult.skycal_id
+    AND stackRun.stack_id = skycalRun.stack_id
+    AND skycalRun.state = 'new'
+    AND skycalResult.fault != 0
Index: trunk/ippTools/share/staticskytool_skycalresult.sql
===================================================================
--- trunk/ippTools/share/staticskytool_skycalresult.sql	(revision 32962)
+++ trunk/ippTools/share/staticskytool_skycalresult.sql	(revision 32962)
@@ -0,0 +1,14 @@
+SELECT 
+    skycalResult.*,
+    skycalRun.stack_id,
+    stackRun.tess_id,
+    stackRun.skycell_id,
+    stackRun.filter,
+    skycalRun.state,
+    skycalRun.label,
+    skycalRun.data_group,
+    skycalRun.sky_id
+FROM skycalRun
+JOIN skycalResult USING(skycal_id)
+JOIN stackRun USING(stack_id)
+