Polluted Cats - Quarry

SQL

        SELECT DISTINCT
          CONVERT(ns_name USING utf8),
          CONVERT(pg1.page_title USING utf8)
        FROM page AS pg1
        JOIN toolserver.namespace
        ON dbname = CONCAT(?, '_p')
        AND pg1.page_namespace = ns_id
        JOIN revision
        ON rev_page = pg1.page_id
        LEFT JOIN categorylinks
        ON cl_from = pg1.page_id
        LEFT JOIN pagelinks
        ON pl_from = pg1.page_id
        WHERE pg1.page_namespace = 4
        AND pg1.page_is_redirect = 0
        AND cl_from IS NULL
        AND (SELECT
               COUNT(DISTINCT rev_user_text)
             FROM revision
             WHERE rev_page = pg1.page_id) = 1
        AND (SELECT
               COUNT(*)
             FROM page AS pg2
             LEFT JOIN pagelinks AS pltmp
             ON pg2.page_id = pltmp.pl_from
             WHERE pltmp.pl_title = pg1.page_title
             AND pltmp.pl_namespace = pg1.page_namespace
             AND pg2.page_namespace = 4) = 0
        AND NOT EXISTS (SELECT
                          1
                        FROM templatelinks
                        JOIN page AS pg3
                        ON tl_from = pg3.page_id
                        WHERE tl_namespace = 4
                        AND tl_title = pg1.page_title
                        AND pg3.page_namespace = 4)
        LIMIT 1000;
SQL

Checking query status...
