Index: /trunk/ippTools/share/magicdstool_todestreak_camera.sql
===================================================================
--- /trunk/ippTools/share/magicdstool_todestreak_camera.sql	(revision 32535)
+++ /trunk/ippTools/share/magicdstool_todestreak_camera.sql	(revision 32536)
@@ -14,4 +14,5 @@
     stage_id,
     'exposure' AS component,
+    0 AS mismatched_tess,
     CAST(NULL AS CHAR(255)) AS uri,
     camProcessedExp.path_base,
Index: /trunk/ippTools/share/magicdstool_todestreak_chip.sql
===================================================================
--- /trunk/ippTools/share/magicdstool_todestreak_chip.sql	(revision 32535)
+++ /trunk/ippTools/share/magicdstool_todestreak_chip.sql	(revision 32536)
@@ -14,4 +14,5 @@
     stage_id,
     class_id AS component,
+    0 AS mismatched_tess,
     chipProcessedImfile.uri,
     chipProcessedImfile.path_base,
Index: /trunk/ippTools/share/magicdstool_todestreak_diff.sql
===================================================================
--- /trunk/ippTools/share/magicdstool_todestreak_diff.sql	(revision 32535)
+++ /trunk/ippTools/share/magicdstool_todestreak_diff.sql	(revision 32536)
@@ -15,4 +15,5 @@
     diffRun.magicked,
     diffSkyfile.skycell_id AS component,
+    0 AS mismatched_tess,
     CAST(NULL AS CHAR(255)) AS uri,
     diffSkyfile.path_base,
@@ -63,4 +64,5 @@
     diffRun.magicked,
     diffSkyfile.skycell_id AS component,
+    0 AS mismatched_tess,
     CAST(NULL AS CHAR(255)) AS uri,
     diffSkyfile.path_base,
Index: /trunk/ippTools/share/magicdstool_todestreak_raw.sql
===================================================================
--- /trunk/ippTools/share/magicdstool_todestreak_raw.sql	(revision 32535)
+++ /trunk/ippTools/share/magicdstool_todestreak_raw.sql	(revision 32536)
@@ -14,4 +14,5 @@
     rawExp.magicked,
     class_id as component,
+    0 AS mismatched_tess,
     rawImfile.uri AS uri,
     -- XXX: replace this with rawImfile.path_base once it exists
Index: /trunk/ippTools/share/magicdstool_todestreak_warp.sql
===================================================================
--- /trunk/ippTools/share/magicdstool_todestreak_warp.sql	(revision 32535)
+++ /trunk/ippTools/share/magicdstool_todestreak_warp.sql	(revision 32536)
@@ -14,4 +14,6 @@
     warpRun.magicked,
     warpSkyfile.skycell_id as component,
+    diffRun.tess_id != warpRun.tess_id AS mismatched_tess,
+    diffRun.tess_id as diff_tess_id,
     warpSkyfile.uri,
     warpSkyfile.path_base,
@@ -27,4 +29,5 @@
 JOIN magicMask USING (magic_id)
 JOIN magicRun USING (magic_id)
+JOIN diffRun USING(diff_id)
 JOIN warpRun ON warp_id = stage_id
 JOIN warpSkyfile USING(warp_id)