SELECT authorpage.page_title, templatepage.page_title

FROM page authorpage

JOIN categorylinks authorcat ON authorcat.cl_from = authorpage.page_id

JOIN templatelinks ON templatelinks.tl_from = authorpage.page_id

JOIN linktarget ON linktarget.lt_id = templatelinks.tl_target_id

JOIN page templatepage ON templatepage.page_title = linktarget.lt_title

JOIN categorylinks templatecat ON templatecat.cl_from = templatepage.page_id

WHERE authorpage.page_namespace = 0

AND authorcat.cl_to = "Taxon_authorities"

AND authorpage.page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname = "wikibase_item")

AND authorpage.page_is_redirect = 0

AND linktarget.lt_namespace = 10

AND 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")