Unlinked author page transcluding linked reference template

SQL

SELECT templatepage.page_title
FROM page templatepage
JOIN categorylinks templatecat ON templatecat.cl_from = templatepage.page_id
WHERE templatepage.page_namespace = 10
AND templatepage.page_title IN (
  SELECT linktarget.lt_title
  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_id IN (
    SELECT authorcat.cl_from
    FROM categorylinks authorcat
    WHERE authorcat.cl_to = "Taxon_authorities"
    AND authorcat.cl_from NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")
  )
  AND authorpage.page_namespace = 0
  AND authorpage.page_is_redirect = 0
  AND linktarget.lt_namespace = 10
)
AND templatecat.cl_to = "Reference_templates"

SQL

Checking query status...