Episode redirects

SQL

SELECT *
FROM page authorpage
JOIN templatelinks ON templatelinks.tl_from = authorpage.page_id
JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id
WHERE authorpage.page_namespace = 0
AND authorpage.page_is_redirect = 0
AND linktarget.lt_namespace = 10
AND linktarget.lt_title IN (
  SELECT templatepage.page_title
  FROM page templatepage
  JOIN categorylinks templatecat ON templatecat.cl_from = templatepage.page_id
  WHERE templatepage.page_namespace = 10
  AND templatecat.cl_to = "Reference_templates"
  AND templatepage.page_id IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")
)
SQL

Checking query status...
