Index: trunk/ippTools/share/magicdstool_torevert_chip.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 28768)
+++ trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 28853)
@@ -2,5 +2,5 @@
     magic_ds_id,
     magicDSRun.state,
-    exp_id,
+    rawExp.exp_id,
     re_place,
     camera,
@@ -19,7 +19,6 @@
     JOIN camProcessedExp using(cam_id)
     JOIN chipRun ON (stage_id = chipRun.chip_id)
-    -- JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
-    JOIN chipProcessedImfile USING(chip_id, exp_id)
-    JOIN rawExp using(exp_id)
+    JOIN chipProcessedImfile ON (stage_id = chipProcessedImfile.chip_id AND component = class_id)
+    JOIN rawExp ON chipRun.exp_id = rawExp.exp_id
 WHERE magicDSRun.stage = 'chip'
     AND ((magicDSRun.state = 'new' AND magicDSFile.fault > 0)