Currently Watching (last 15 min)

Custom SQL query (hide)

SELECT p.pseudo,
       pr.media_type,
       pr.tmdb_id,
       pr.season,
       pr.episode,
       ROUND(pr.position_seconds / 60.0, 1) AS position_min,
       datetime(pr.updated_at, 'unixepoch') AS last_seen
FROM progress pr JOIN profiles p ON p.id = pr.profile_id WHERE pr.updated_at > strftime('%s', 'now') - 900 ORDER BY pr.updated_at DESC

Edit SQL