Untitled

SELECT t1.game, t1.text, t1.timestamp, t1.user, t2.firstname, 
			AVG(t3.rating_gr) AS average_gr, AVG(t3.rating_so) AS average_so, 
			AVG(t3.rating_gp) AS average_gp, t4.platform, t4.iconurl, t4.platform
			FROM `goozex_reviews` AS t1
			LEFT JOIN `goozex_userlookup` AS t2 ON t1.user = t2.fbid
			LEFT JOIN `goozex_ratings` AS t3 ON t1.game = t3.game
			LEFT JOIN `goozex_gameinfocache` AS t4 ON t1.game = t4.gid
			WHERE t1.game = $gid
			GROUP BY t3.game ORDER BY t1.timestamp DESC