Alternate Releases Table for Scenes

[metacarejeff]

Since Merging scenes is problematic, have a separate table for Alternate Releases
id, base_release_id, alternate_release_id -> Need a method to add scraped filenames to the base array or match on any releases filename array

You could one further this with a bigger change, would also handle re-releases nicely:
BaseScenes(current data minus studio/site specific data and dates)
SceneReleases(studio specifics/dates Filenames)

This is an imperfect SQL query that identifies multi-release scenes (add cast for a more accurate version)
SELECT scenes.scraper_id, ts.scraper_id, ts.scene_id,scenes.scene_id,ts.title from scenes join
(select * from scenes where scraper_id !='(Your Aggregate Site scraper here)' and title in
(SELECT title from scenes where scraper_id ='(Your Aggregate Sitel scraper here)')) ts on scenes.title = ts.title
order by title