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

SELECT m.*, u.username as create_username, u.user_id as create_user_id, u.user_colour as create_user_colour, f.album_link, f.video, b.blog_link, f.album_link, v.album_link AS count_video, me.meeting_geo1, me.meeting_geo2, me.meeting_geo3, mf.image_id AS count_image, gp.gpslink_id AS count_gpslink
FROM phpbb3_marshrut_data m
LEFT JOIN phpbb3_users AS u ON m.marshrut_by_user = u.user_id
LEFT JOIN phpbb3_meeting_falbum AS f ON m.meeting_id = f.meeting_id
LEFT JOIN phpbb3_marshrut_foto AS mf ON m.marshrut_id = mf.marshrut_id
LEFT JOIN phpbb3_marshrut_gpslink AS gp ON m.marshrut_id = gp.marshrut_id
LEFT JOIN phpbb3_meeting_fvideo AS v ON m.meeting_id = v.meeting_id
LEFT JOIN phpbb3_meeting_blog AS b ON b.meeting_id = m.meeting_id
LEFT JOIN phpbb3_meeting_data AS me ON m.marshrut_id = me.meeting_marshrut
WHERE m.marshrut_id <>0
GROUP BY m.marshrut_id
ORDER BY marshrut_time DESC LIMIT 10, 10