Top 100, Voters >= 5, not Browser game
SELECT
ROW_NUMBER() OVER (ORDER BY g.total_play_time_median DESC) AS "Rank",
'<a href="game.php?game=' || g.id || '" style="display: block; width: 400px;">' || g.gamename || '</a>' AS "Game name",
g.total_play_time_median AS "Median playtime (hours)",
count(ur.total_play_time) AS "Voters",
CASE WHEN ag.has_attr IS NOT NULL THEN '+' ELSE '' END AS "Free"
FROM gamelist g
JOIN userreview ur ON g.id = ur.game
LEFT JOIN (
SELECT DISTINCT game, 1 AS has_attr
FROM attributegroupsboolean
WHERE attribute = 53
) ag ON ag.game = g.id
WHERE g.total_play_time_median IS NOT NULL
AND ur.total_play_time IS NOT NULL
AND g.id NOT IN (21888, 25936)
GROUP BY g.gamename, g.total_play_time_median, g.id, ag.has_attr
HAVING count(ur.total_play_time) >= 5
LIMIT 100;