Index: trunk/ippTools/share/magicdstool_todestreak_camera.sql
===================================================================
--- trunk/ippTools/share/magicdstool_todestreak_camera.sql	(revision 27300)
+++ trunk/ippTools/share/magicdstool_todestreak_camera.sql	(revision 27301)
@@ -5,13 +5,14 @@
     magicDSRun.label,
     camera,
-    magicMask.uri as streaks_uri,
+    magicMask.uri AS streaks_uri,
     CAST(NULL AS CHAR(255)) AS inv_streaks_uri,
     stage,
     stage_id,
-    'exposure' as component,
+    'exposure' AS component,
     CAST(NULL AS CHAR(255)) AS uri,
     camProcessedExp.path_base,
     magicRun.inverse,
-    camProcessedExp.path_base as cam_path_base,
+    camProcessedExp.path_base AS cam_path_base,
+    camRun.reduction AS cam_reduction,
     outroot,
     recoveryroot,
Index: trunk/ippTools/share/magicdstool_todestreak_chip.sql
===================================================================
--- trunk/ippTools/share/magicdstool_todestreak_chip.sql	(revision 27300)
+++ trunk/ippTools/share/magicdstool_todestreak_chip.sql	(revision 27301)
@@ -5,13 +5,14 @@
     magicDSRun.label,
     camera,
-    magicMask.uri as streaks_uri,
+    magicMask.uri AS streaks_uri,
     CAST(NULL AS CHAR(255)) AS inv_streaks_uri,
     stage,
     stage_id,
-    class_id as component,
+    class_id AS component,
     chipProcessedImfile.uri,
     chipProcessedImfile.path_base,
     magicRun.inverse,
-    camProcessedExp.path_base as cam_path_base,
+    camProcessedExp.path_base AS cam_path_base,
+    camRun.reduction AS cam_reduction,
     outroot,
     recoveryroot,
@@ -21,4 +22,5 @@
 JOIN magicMask USING (magic_id)
 JOIN magicRun USING(magic_id)
+JOIN camRun USING(cam_id)
 JOIN camProcessedExp USING(cam_id)
 JOIN chipRun ON chip_id = stage_id
Index: trunk/ippTools/share/magicdstool_todestreak_diff.sql
===================================================================
--- trunk/ippTools/share/magicdstool_todestreak_diff.sql	(revision 27300)
+++ trunk/ippTools/share/magicdstool_todestreak_diff.sql	(revision 27301)
@@ -6,13 +6,14 @@
     magicDSRun.label,
     rawExp.camera,
-    magicMask.uri as streaks_uri,
+    magicMask.uri AS streaks_uri,
     CAST(NULL AS CHAR(255)) AS inv_streaks_uri,
     stage,
-    magicRun.diff_id as stage_id,
-    diffSkyfile.skycell_id as component,
+    magicRun.diff_id AS stage_id,
+    diffSkyfile.skycell_id AS component,
     CAST(NULL AS CHAR(255)) AS uri,
     diffSkyfile.path_base,
     magicRun.inverse,
-    CAST(NULL AS CHAR(255)) as cam_path_base,
+    CAST(NULL AS CHAR(255)) AS cam_path_base,
+    CAST(NULL AS CHAR(255)) AS cam_reduction,
     outroot,
     recoveryroot,
Index: trunk/ippTools/share/magicdstool_todestreak_raw.sql
===================================================================
--- trunk/ippTools/share/magicdstool_todestreak_raw.sql	(revision 27300)
+++ trunk/ippTools/share/magicdstool_todestreak_raw.sql	(revision 27301)
@@ -14,4 +14,5 @@
     magicRun.inverse,
     camProcessedExp.path_base as cam_path_base,
+    camRun.reduction AS cam_reduction,
     outroot,
     recoveryroot,
@@ -21,4 +22,5 @@
 JOIN magicMask USING (magic_id)
 JOIN magicRun USING (magic_id)
+JOIN camRun USING(cam_id)
 JOIN camProcessedExp USING(cam_id)
 JOIN rawImfile ON magicRun.exp_id = rawImfile.exp_id
Index: trunk/ippTools/share/magicdstool_todestreak_warp.sql
===================================================================
--- trunk/ippTools/share/magicdstool_todestreak_warp.sql	(revision 27300)
+++ trunk/ippTools/share/magicdstool_todestreak_warp.sql	(revision 27301)
@@ -14,4 +14,5 @@
     magicRun.inverse,
     CAST(NULL AS CHAR(255)) as cam_path_base,
+    CAST(NULL AS CHAR(255)) as cam_reduction,
     outroot,
     recoveryroot,