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