zapytanie, znowu Opcje

[deniol13]

[SQL] pobierz, plaintext 
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
[SQL] pobierz, plaintext 

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

[cojack]

A kolega o klauzurze ORDER BY słyszał?