АР
Size: a a a
АР
A
БГ
АР
БГ
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.name msg_sender,
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
БГ
АР
БГ
АР
БГ
W
👑️
БГ
count(*)
БГ
👑️
👑️
👑️
АЩ
ᅠ