ПЛ
Size: a a a
ПЛ
ПЛ
ПЛ
DX
S
e
E
e
E
DX
БГ
SELECT
users.id,
users.name,
messages.from_id,
messages.text
FROM (
SELECT
CASE WHEN messages.from_id = 1 THEN messages.to_id ELSE messages.from_id END AS interlocutor,
max(messages.id) AS last_message
FROM messages
WHERE messages.to_id = 1 OR messages.from_id = 1
GROUP BY interlocutor
) conversations
JOIN users ON users.id = conversations.interlocutor
JOIN messages ON messages.id = conversations.last_message
ORDER BY messages.id DESC
AT
SELECT
users.id,
users.name,
messages.from_id,
messages.text
FROM (
SELECT
CASE WHEN messages.from_id = 1 THEN messages.to_id ELSE messages.from_id END AS interlocutor,
max(messages.id) AS last_message
FROM messages
WHERE messages.to_id = 1 OR messages.from_id = 1
GROUP BY interlocutor
) conversations
JOIN users ON users.id = conversations.interlocutor
JOIN messages ON messages.id = conversations.last_message
ORDER BY messages.id DESC
БГ
AT
БГ
SELECT
users.id,
users.name,
messages.from_id,
messages.text
FROM (
SELECT
CASE WHEN messages.from_id = 1 THEN messages.to_id ELSE messages.from_id END AS interlocutor,
max(messages.id) AS last_message
FROM messages
WHERE messages.to_id = 1 OR messages.from_id = 1
GROUP BY interlocutor
) conversations
JOIN users ON users.id = conversations.interlocutor
JOIN messages ON messages.id = conversations.last_message
ORDER BY messages.id DESC
AT
БГ
R3
БГ
R3