SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 FROM #__content AS a
 LEFT JOIN #__categories AS cc ON cc.id = a.catid
 LEFT JOIN #__sections AS s ON s.id = cc.section AND s.scope='content'
 LEFT JOIN #__users AS u ON u.id = a.created_by
 LEFT JOIN #__content_rating AS v ON a.id = v.content_id
 LEFT JOIN #__groups AS g ON a.access = g.id
 WHERE a.id='196' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-06-19 08:26:00')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-06-19 08:26:00')
 AND a.access <= 0