Untitled query #70638

SQL

(
  SELECT
  	page_title,
  	0 as through_redirect,
  	(SELECT pp_value FROM page_props WHERE pp_page = page_id AND pp_propname = "wikibase_item") AS qid
  FROM page
  INNER JOIN categorylinks ON cl_from = page_id
  WHERE cl_to = "Taxon_authorities"
  AND page_namespace = 0
  AND page_is_redirect = 0
)
UNION
(
  SELECT
    src.page_title,
    1 as through_redirect,
    (SELECT pp_value FROM page_props WHERE pp_page = dst.page_id AND pp_propname = "wikibase_item") AS qid
  FROM categorylinks
  INNER JOIN page dst ON categorylinks.cl_from = dst.page_id
  INNER JOIN redirect ON redirect.rd_title = dst.page_title
  INNER JOIN page src ON src.page_id = redirect.rd_from
  WHERE categorylinks.cl_to = "Taxon_authorities"
  AND dst.page_namespace = 0
  AND redirect.rd_namespace = 0
)
SQL

Checking query status...
