Changeset 24735

Timestamp:

Jul 9, 2009, 10:54:41 AM (17 years ago)

Author:

bills

Message:

remove unneeded join. Join to warpRun before warpSkyfile

File:

• trunk/ippTools/share/magicdstool_todestreak.sql (modified) (1 diff)

trunk/ippTools/share/magicdstool_todestreak.sql

@@ -129 +129 @@
 JOIN magicMask USING (magic_id)
 JOIN magicRun USING (magic_id)
-JOIN magicInputSkyfile USING(magic_id)
-JOIN warpSkyfile ON warp_id = stage_id
-JOIN warpRun USING(warp_id)
+JOIN warpRun ON warp_id = stage_id
+JOIN warpSkyfile USING(warp_id)
 JOIN rawExp ON magicRun.exp_id = rawExp.exp_id
 LEFT JOIN magicDSFile