query for scene passthrus using 'sxxexx' only (subquery excludes shows that have scene mappings that dont use 'sxxexx' which would result in getting absolute numbers) which if these series are in sonarr and set to anime.. would result in bad searches as absolute numbers dont exist...
- note that this does not cover the scenario where the scene season itself could dictate an absolute start.. thus these series could be fine
select e.id, e.main_name, o.name as Origin,d.name AS Destination, p.type from passthrus AS p
join elements AS e on e.id=p.element_id and e.parent = 0
join locations o on (o.id=p.origin_id)
join locations d on (d.id=p.destination_id)