Разница в версиях мускуля

[zenit]

Разница в версиях мускуля

Привет всем!

Подскажите пожалуйста
почему запрос

SELECT mc.ID,
IF (PlayerID=7, OpponentName, PlayerName) as OpponentName, DATE_FORMAT(d.RecordDate, '%W') as MatchDay,
DATE_FORMAT(d.RecordDate, '%e %b %Y') as MatchDate, ts.Name as SlotName,
o.Name as Event,
b.Name as BoxName,
r.Name as RoundName,
t.Name as TournamentName
FROM tbMatchCards as mc,
tbUserDairyData as dd, tbUserDairy as d,
tbUserTimeSlot as ts, tbRoundBoxes as b,
tbTournamentRounds as r,
tbTournaments as
t LEFT JOIN tbTournamentOptions as o ON o.ID=r.PlayersType WHERE mc.ID=2795
AND b.ID=mc.RoundBoxID
AND r.ID=b.TournamentRoundID
AND t.ID=r.TournamentID
AND mc.MatchStatus=5
AND dd.SlotState=-1*mc.ID
AND d.ID=dd.UserDairyID
AND d.UserID=7
AND ts.ID=dd.UserSlotID

нормально исполняется в 4.0.18, но вешает 3.56
БД одинаковые...

Зпранее спасибо.

 

[chira]

для начала попробуй сделать EXPLAIN для двух версий ...