get_trending_players.sqlā¢531 B
-- Most viewed players analysis
-- get_trending_players: Get most viewed players in recent time
SELECT
username,
COUNT(*) as view_count,
MAX(follower_count) as latest_followers,
MIN(follower_count) as earliest_followers,
MAX(follower_count) - MIN(follower_count) as follower_growth,
COUNT(DISTINCT DATE(viewed_at)) as days_tracked
FROM player_profile_views
WHERE viewed_at >= CURRENT_DATE - INTERVAL ($days || ' days')
GROUP BY username
HAVING COUNT(*) >= $min_views
ORDER BY view_count DESC
LIMIT $limit;