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 page AS page_sub
                    WHERE page_sub.page_namespace = 3
                    AND page_sub.page_title != '127.0.0.1'
                    AND NOT EXISTS (
                        SELECT 1
                        FROM user
                        WHERE user_name = REPLACE(SUBSTRING_INDEX(page_sub.page_title, '/', 1), '_', ' ')
                    )
                    AND NOT EXISTS (
                        SELECT 1
                        FROM 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 categorylinks
                    WHERE cl_from = id AND cl_to = '快速删除候选'
                )
                ORDER BY namespace ASC, title ASC /* SLOW_OK */;
SQL

Checking query status...
