Форум пользователей MySQL

SELECT
    max(msgs.id),
    msgs.send_time,
    msgs.user_to,
    msgs.from,
    msgs.from_side,
    msgs.dialog_id,
    msgs.msg_text,
    msgs.readed,
    users.id AS one_id,
    users.photo AS one_photo,
    users.name AS one_name,
    users.second_name AS one_second_name,
    other_side.id AS two_id,
    other_side.photo AS two_photo,
    other_side.name AS two_name,
    other_side.second_name AS two_second_name
FROM msgs
LEFT JOIN users ON msgs.from = users.id
LEFT JOIN users AS other_side ON msgs.user_to = other_side.id
WHERE msgs.user_to = 40 OR msgs.from = 40
GROUP BY msgs.dialog_id
ORDER BY max(msgs.id) DESC
LIMIT 10