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