SELECT forums.forum_id AS fid, forums.forum_name, forums.forum_description, posts, topics, guests_see, forum_status, forum_order, topics.topic_id, topics.topic_name, users.user_id, users.username, posts.post_id, posts.date, posts.poster_id, groups.group_style FROM forums LEFT JOIN topics ON forums.forum_id = topics.forum_id LEFT JOIN posts ON topics.topic_id = posts.parent_topic AND posts.post_id = post_id LEFT JOIN users ON posts.poster_id = users.user_id LEFT JOIN groups ON groups.group_id = users.user_group GROUP BY forums.forum_id
Wreszcie dziala w miare jak nalezy, tylko ze pobiera mi najnizsze dane o najnizszym post_id a ja chce pobierac jeden najwiekszy wzgledem tego ze `date` ma najwieksza wartosc