Zkus neco takoveho:SELECT user.*, session.activity AS last_activity, session.logout_time AS logout_time FROM `test_users` AS user JOIN ( SELECT user_id, MAX(id) as id FROM `chatv2_sessions` GROUP BY user_id ) AS pom ON pom.user_id = user.user_id JOIN `chatv2_sessions` as session on pom.id = session.id ORDER BY session.activity
Co můžeš udělat dnes, odlož na včerejšek.