home / watch

Recent Activity (last 50 events)

Custom SQL query returning 5 rows (hide)

SELECT p.pseudo,
       pr.media_type,
       pr.tmdb_id,
       pr.season,
       pr.episode,
       ROUND(pr.position_seconds / 60.0, 1) AS position_min,
       CASE WHEN pr.completed = 1 THEN 'yes' ELSE '' END AS done,
       datetime(pr.updated_at, 'unixepoch') AS updated_at
FROM progress pr JOIN profiles p ON p.id = pr.profile_id ORDER BY pr.updated_at DESC LIMIT 50

Edit SQL

This data as json, CSV

pseudomedia_typetmdb_idseasonepisodeposition_mindoneupdated_at
Le 52 tv 73586 5 1 15.1   2026-02-23 04:12:24
Bochelly tv 73586 3 4 26.6   2026-02-23 03:27:23
Bochelly tv 129552 1 10 44.4 yes 2026-02-22 21:56:59
Le 52 movie 1236153     0.7   2026-02-22 20:50:09
Bochelly tv 4604 3 1 8.8   2026-02-22 13:47:03
Powered by Datasette · Queries took 1.712ms