[вздыхает]

G_Z 29.10.2011 21:30

SELECT
	tags.tagid,
	tags.tag,
	COUNT(posts_tags.postid) AS posts_count
FROM
	tags,
	posts_tags
WHERE
	tags.tagid = posts_tags.tagid
GROUP BY tags.tagid
ORDER BY posts_count DESC
LIMIT 40