home / watch

Watch Time — Today

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', date('now')) GROUP BY p.id, p.pseudo ORDER BY hours DESC

Edit SQL

This data as json, CSV

pseudotitles_touchedhours
Bochelly 1 0.44
Le 52 1 0.25
Powered by Datasette · Queries took 3.012ms