Linked misspellings

SQL

        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_misspellings'
        AND NOT ( r1.rd_namespace = r2.rd_namespace AND r1.rd_title = r2.rd_title )
        GROUP BY 1
        LIMIT 1000;
SQL

Checking query status...
