SELECT g.game_name, g.game_id, g.author_name, g.user_id, COUNT(d1.user_ip) AS num_downloads
FROM gamelist g, game_downloads d1
WHERE d1.game_id = g.game_id AND d1.download_time >= 1712995301
GROUP BY g.game_id
ORDER BY num_downloads DESC
LIMIT 5 Line : 108 File : functions_stats.php