Jellyfin playbackPositionTicks info query

jellyfin-contine-watching.sql

SELECT
  key, COALESCE(ti.SortName, mi.sortname) SortName, COALESCE(ti.Path, mi.Path) Path
FROM UserDatas u
LEFT JOIN TypedBaseItems ti
ON
  u.key = ti.UserDataKey
  OR REPLACE(u.key, '-', '') = ti.PresentationUniqueKey
LEFT JOIN MediaItems mi
ON
  REPLACE(u.key, '-', '') = mi.PresentationUniqueKey
WHERE
  playbackPositionTicks > 0;

Joins what I think are the correct tables to find items that will appear on Continue Watching (so you can reset them)--ignores users (I only use a single user)