(

  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

)