IT
Size: a a a
IT
IT
Р
IT
IT
Р
DZ
КБ
AM
DZ
КБ
БГ
SELECT
CASE WHEN m.to_id = ?
THEN
sender.id
ELSE
receiver.id
END interlocutor,
CASE WHEN m.to_id = ?
THEN
sender.name
ELSE
receiver.name
END username,
sender.id msg_sender_id,
m.text msg_text
FROM messages m
JOIN users sender ON
sender.id = m.from_id
JOIN users receiver ON
receiver.id = m.to_id
WHERE m.to_id = ? OR m.from_id = ?
GROUP BY interlocutor
HAVING m.id = max(m.id)
ORDER BY m.id DESC
БГ
БГ
JOIN table t ON ...
БГ
B
k
А