====== Jellyfin ======

===== Restore watch history after path fuckup =====

Delete new entries if needed
<code>
DELETE FROM UserData
WHERE ItemId IN (SELECT Id FROM BaseItems WHERE Path Like '/newpath/%');
</code>

Overwrite ItemIds
<code>
UPDATE UserData
SET ItemId = new.Id
FROM BaseItems AS old
JOIN BaseItems AS new ON old.SortName = new.SortName
WHERE UserData.ItemId = old.Id;
</code>