home / watch

Most Active Users (all time)

Custom SQL query returning 2 rows (hide)

SELECT p.pseudo,
       COUNT(*) AS titles_started,
       SUM(pr.completed) AS completed,
       ROUND(SUM(pr.position_seconds) / 3600.0, 1) AS total_hours
FROM progress pr JOIN profiles p ON p.id = pr.profile_id GROUP BY p.id, p.pseudo ORDER BY total_hours DESC

Edit SQL

This data as json, CSV

pseudotitles_startedcompletedtotal_hours
Bochelly 3 1 1.3
Le 52 2 0 0.3
Powered by Datasette · Queries took 7.695ms