SELECT

          CONVERT(p1.page_title USING utf8),

          COUNT(*)

        FROM page AS p1

        JOIN categorylinks

        ON p1.page_id = cl_from

        JOIN pagelinks

        ON p1.page_title = pl_title AND pl_namespace = 0

        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'

        GROUP BY 1

        LIMIT 1000;