Slow Query time - unable to scan or play media

[sa2000]

@John-C-B
Did you run this query for me ? and establish which version of Plex Media Server was running on the 24th October ?

@sa2000

This query will identify the movie

select id, title, guid, refreshed_at from metadata_items Where id = '45323';

@John-C-B

still got one file with over 1m extras.

Before running the sql.txt sqlite3 transaction - did you actually run the step 2 action quoted in this linked post Slow library performance due to increasingly growing database - #28 by shayanzadeh

which would be
DELETE FROM metadata_relations WHERE metadata_item_id = '45323';