|
Could not obtain game list information
DEBUG MODE
SQL Error : 2006 MySQL server has gone away
SELECT g.game_name, g.game_id, g.author_name, g.user_id,
COUNT(r.review_index) * 2 + COUNT(ur.user_id) AS num_opinions,
IFNULL( ROUND( ( SUM(r.overall_score) / 14 * 2 +
IF( COUNT(ur.user_id) >= 2 || COUNT(r.review_index) > 0, SUM(ur.rating) / 5, 0 ) ) /
( COUNT(r.review_index) * 2 + COUNT(ur.user_id) ) * 14 ), -1 ) AS weighted_score
FROM gamelist g
LEFT OUTER JOIN game_ratings ur ON ur.id = g.game_id
LEFT OUTER JOIN review_list r ON r.game_index = g.game_id
GROUP BY g.game_id
ORDER BY weighted_score DESC, num_opinions DESC, g.num_reviews DESC, g.game_name ASC
LIMIT 5 Line : 192 File : functions_stats.php |
|
|