Click to add title...

SQL

                 SELECT id, namespace, title FROM (
                    SELECT
                    page_sub.page_id AS id,
                    page_sub.page_title AS title,
                    page_sub.page_namespace AS namespace
                    FROM zhwiki_p.page AS page_sub
                    WHERE page_sub.page_namespace = 3
                    AND page_sub.page_title != '127.0.0.1'
                    AND NOT (
                    	page_title RLIKE '^[0-9]+[.][0-9]+[.][0-9]+[.][0-9]+$'
                        OR page_title RLIKE '^([0-9A-Z]{1,4}:){7}[0-9A-Z]{1,4}$'
        			)
                    AND NOT EXISTS (
                        SELECT 1
                        FROM zhwiki_p.user
                        WHERE user_name = REPLACE(SUBSTRING_INDEX(page_sub.page_title, '/', 1), '_', ' ')
                    )
                    AND NOT EXISTS (
                        SELECT 1
                        FROM zhwiki_p.logging
                        WHERE log_type = 'renameuser'
                        AND log_title = SUBSTRING_INDEX(page_sub.page_title, '/', 1)
                    )
                    AND NOT EXISTS (
                        SELECT 1
                        FROM metawiki_p.logging
                        WHERE log_type = 'gblrename'
                        AND log_params RLIKE CONCAT('.+olduser";s:\\d+:"', REPLACE(SUBSTRING_INDEX(page_sub.page_title, '/', 1), '_', ' '), '".+')
                    )
                ) AS csdcand
                WHERE NOT EXISTS (
                    SELECT * FROM zhwiki_p.categorylinks
                    WHERE cl_from = id AND cl_to = '快速删除候选'
                )
                ORDER BY namespace ASC, title ASC /* SLOW_OK */;
SQL

Checking query status...
