Переформулирую

Дэн 21.12.2007 19:33

SELECT 
	posts.id as id,
	posts.user_id as user_id,
	posts.content as content,
	users.login as login,
	SUM(IF(posts_rates.post_id = posts.id, posts_rates.rate, 0)) as rate						   
FROM
	posts,
	users,
	posts_rates
WHERE
	posts.user_id = users.id
GROUP BY
	posts.id