Jellyfin

Restore watch history after path fuckup

Delete new entries if needed

DELETE FROM UserData
WHERE ItemId IN (SELECT Id FROM BaseItems WHERE Path Like '/newpath/%');

Overwrite ItemIds

UPDATE UserData
SET ItemId = new.Id
FROM BaseItems AS old
JOIN BaseItems AS new ON old.SortName = new.SortName
WHERE UserData.ItemId = old.Id;