SELECT COUNT( id ) AS `cnt`, ROUND( SUM( vote ) / COUNT( id ) , 5 ) AS `vote`
                       FROM `test419_pmf_topic_rating`
                       WHERE`topic_id` =10
                       GROUP BY `topic_id`

phpMyForum (http://pmf-test.j-remmer.de/index.php)
-- Kategorie - Test (http://pmf-test.j-remmer.de/board.php?id=2)
---- Forum - Test (http://pmf-test.j-remmer.de/board.php?id=6)
Thema: Test 2 02.05.2012 (http://pmf-test.j-remmer.de/topic.php?id=10)