sirvival
Erfahrenes Mitglied
hallo allerseits,
kann mir jemand sagen wieso dieses statement in mysql 5.0 funktioninert aber in 4.0 nicht?
kann mir jemand sagen wieso dieses statement in mysql 5.0 funktioninert aber in 4.0 nicht?
Code:
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;