SELECT

  p1.page_title,

  COUNT(*)

FROM

  page AS p1

  JOIN categorylinks ON p1.page_id = cl_from

  JOIN linktarget on p1.page_title = lt_title

  AND lt_namespace = 0

  JOIN pagelinks ON pl_target_id = lt_id

  JOIN page AS p2 ON pl_from = p2.page_id

  AND p2.page_namespace = 0

WHERE

  p1.page_namespace = 0

  AND p1.page_is_redirect = 1

  AND cl_to = 'Redirects_from_miscapitalisations'

  AND NOT(p1.page_id = p2.page_id)

GROUP BY

  1

LIMIT

  1000;