Watch Time — Last 7 Days

Custom SQL query returning 2 rows (hide)

SELECT p.pseudo,
       COUNT(*) AS titles_touched,
       ROUND(SUM(pr.position_seconds) / 3600.0, 2) AS hours
FROM progress pr JOIN profiles p ON p.id = pr.profile_id WHERE pr.updated_at > strftime('%s', 'now') - 604800 GROUP BY p.id, p.pseudo ORDER BY hours DESC

Edit SQL