SELECT

          CONVERT(p1.page_title USING utf8),

          COUNT(*)

        FROM page AS p1

        JOIN redirect AS r1 ON p1.page_id=r1.rd_from

        JOIN categorylinks

        ON p1.page_id = cl_from

        JOIN linktarget

        ON p1.page_title = lt_title AND lt_namespace = 0

        JOIN pagelinks ON lt_id = pl_target_id

        JOIN page AS p2

        ON pl_from = p2.page_id AND p2.page_namespace = 0

        LEFT JOIN redirect AS r2 ON p2.page_id=r2.rd_from

        WHERE p1.page_namespace = 0

        AND p1.page_is_redirect = 1

        AND cl_to = 'Redirects_from_incorrect_hyphenation'

        AND NOT ( r1.rd_namespace <=> r2.rd_namespace AND r1.rd_title <=> r2.rd_title )

        GROUP BY 1

        LIMIT 1000;