mysql versionsproblem

[sirvival]

hallo allerseits,

kann mir jemand sagen wieso dieses statement in mysql 5.0 funktioninert aber in 4.0 nicht?

SELECT thread.guid, thread.Title, CONCAT(LastMessageUsers.FirstName, ' ', LastMessageUsers.LastName), LastMessages.TimeDate, SUM(messages.Duration), threadstatus.`Value`
FROM thread
INNER JOIN messages AS LastMessages ON thread.GUID = LastMessages.ThreadID
INNER JOIN
		  (
			SELECT messages.ThreadID, MAX(ID) AS MaxID
			FROM messages
			INNER JOIN
					  (
						SELECT messages.ThreadID, MAX(TimeDate) AS MaxMessageTime
						FROM messages
						GROUP BY messages.ThreadID
					  ) AS ThreadMaxMessageTimes
			ON ThreadMaxMessageTimes.ThreadID = messages.ThreadID 
			AND ThreadMaxMessageTimes.MaxMessageTime = messages.TimeDate
			GROUP BY ThreadID
		  ) AS ThreadLastMessageIDs ON ThreadLastMessageIDs.MaxID = LastMessages.ID
INNER JOIN messages AS firstMessages ON Thread.GUID = firstMessages.ThreadID          
INNER JOIN
		  (
			SELECT messages.ThreadID, MIN(ID) AS MinID
			FROM messages
			INNER JOIN
					  (
						SELECT messages.ThreadID, Min(TimeDate) AS MinMessageTime
						FROM messages
						GROUP BY messages.ThreadID
					  ) AS ThreadMinMessageTimes
			ON ThreadMinMessageTimes.ThreadID = messages.ThreadID 
			AND ThreadMinMessageTimes.MinMessageTime = messages.TimeDate
			GROUP BY ThreadID
		  ) AS ThreadfirstMessageIDs ON ThreadfirstMessageIDs.MinID = firstMessages.ID
INNER JOIN users AS LastMessageUsers ON LastMessageUsers.GUID = LastMessages.UserGUID
INNER JOIN users AS firstMessageUsers ON firstMessageUsers.GUID = firstMessages.UserGUID
INNER JOIN threadstatus ON  thread.ThreadStatusID = threadstatus.ID
INNER JOIN messages ON messages.ThreadID = thread.GUID
WHERE thread.SupportGUID = '5136cfeca483be40e2250662764bd47b'
AND FirstMessages.UserGUID =  'f4c51ce16ee838158cf185ddf4ddda77' 
GROUP BY thread.Title, CONCAT(LastMessageUsers.FirstName, ' ' , LastMessageUsers.LastName), LastMessages.TimeDate
ORDER BY LastMessages.TimeDate DESC;

 

[ripkens]

Ne Fehlermeldung wäre nicht schlecht.

Bei mir läuft die query auf 4.1.16 und 5.0.23

Gruß