Reply to thread

Message: <blockquote data-quote="JimCatMP" data-source="post: 966607" data-attributes="member: 103549">Not sure how to put this SQL statement (can manage select & delete, have problems much beyond that), but... 1) Create SeriesID list from local_episode (ie select distinct SeriesID from local_series). 2) Walk the list and delete from local_episode where SeriesID = listitem and local_series.ID(listitem) == NULL (ie no such series). On my Atom based system, with 140 odd series and 4500 or so episode, a simple delete from table command, removing a single episode takes several seconds - something I would not want to run on plugin start up for any complex request, but certainly something I would run from config. Cheers - JCMP PS - wrote this and was ready to post BEFORE I saw input from ltfearme - and yep, I don't think it's trivial to do, and certainly not to do well.</blockquote>