Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 24683)
+++ trunk/ippTools/share/Makefile.am	(revision 24689)
@@ -161,4 +161,5 @@
      magicdstool_torevert_raw.sql \
      magicdstool_torevert_chip.sql \
+     magicdstool_torevert_camera.sql \
      magicdstool_torevert_warp.sql \
      magicdstool_torevert_diff.sql \
Index: trunk/ippTools/share/magicdstool_torevert_camera.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_camera.sql	(revision 24689)
+++ trunk/ippTools/share/magicdstool_torevert_camera.sql	(revision 24689)
@@ -0,0 +1,22 @@
+SELECT
+    magic_ds_id,
+    exp_id,
+    re_place,
+    camera,
+    stage,
+    stage_id,
+    component,
+    outroot,
+    camProcessedExp.path_base,
+    camProcessedExp.path_base AS cam_path_base,
+    0 AS bytes,
+    0 AS md5sum
+FROM magicDSRun
+    JOIN magicDSFile using(magic_ds_id)
+    JOIN camProcessedExp ON stage_id = camProcessedExp.cam_id
+    JOIN camRun ON camRun.cam_id = camProcessedExp.cam_id
+    JOIN chipRun USING(chip_id)
+    JOIN rawExp using(exp_id)
+WHERE magicDSRun.stage = 'camera'
+    AND magicDSRun.state = 'new'
+    AND magicDSFile.fault > 0
Index: trunk/ippTools/share/magicdstool_torevert_chip.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 24683)
+++ trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 24689)
@@ -1,4 +1,5 @@
 SELECT
     magic_ds_id,
+    exp_id,
     re_place,
     camera,
Index: trunk/ippTools/share/magicdstool_torevert_diff.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_diff.sql	(revision 24683)
+++ trunk/ippTools/share/magicdstool_torevert_diff.sql	(revision 24689)
@@ -1,4 +1,5 @@
 SELECT
     magic_ds_id,
+    exp_id,
     re_place,
     camera,
Index: trunk/ippTools/share/magicdstool_torevert_raw.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_raw.sql	(revision 24683)
+++ trunk/ippTools/share/magicdstool_torevert_raw.sql	(revision 24689)
@@ -1,4 +1,5 @@
 SELECT
     magic_ds_id,
+    exp_id,
     re_place,
     rawImfile.camera,
Index: trunk/ippTools/share/magicdstool_torevert_warp.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_warp.sql	(revision 24683)
+++ trunk/ippTools/share/magicdstool_torevert_warp.sql	(revision 24689)
@@ -1,4 +1,5 @@
 SELECT
     magic_ds_id,
+    exp_id,
     re_place,
     camera,