Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 14241)
+++ trunk/ippTools/share/Makefile.am	(revision 14242)
@@ -14,9 +14,11 @@
 	detselect_select.sql \
 	dettool_find_completed_runs.sql \
+	dettool_normalizedstat.sql
 	dettool_raw.sql \
-	dettool_start_new_iteration.sql \
+	dettool_revertnormalizedstat.sql \
 	dettool_revertprocessedexp.sql \
 	dettool_revertprocessedimfile.sql \
 	dettool_revertstacked.sql \
+	dettool_start_new_iteration.sql \
 	dettool_todetrunsummary.sql \
 	dettool_tonormalizedexp.sql \
Index: trunk/ippTools/share/dettool_normalizedstat.sql
===================================================================
--- trunk/ippTools/share/dettool_normalizedstat.sql	(revision 14242)
+++ trunk/ippTools/share/dettool_normalizedstat.sql	(revision 14242)
@@ -0,0 +1,12 @@
+SELECT
+    *
+FROM
+    (SELECT
+        detNormalizedStatImfile.*
+    FROM detNormalizedStatImfile
+    JOIN detRun
+    USING(det_id, iteration)
+    WHERE
+        detRun.state = 'run'
+        AND detRun.mode = 'master'
+    ) as Foo
Index: trunk/ippTools/share/dettool_revertnormalizedstat.sql
===================================================================
--- trunk/ippTools/share/dettool_revertnormalizedstat.sql	(revision 14242)
+++ trunk/ippTools/share/dettool_revertnormalizedstat.sql	(revision 14242)
@@ -0,0 +1,3 @@
+DELETE FROM detNormalizedStatImfile
+WHERE
+    fault != 0