Main pl.wiki query 2

SQL

#RESULTSET_13
SELECT CONCAT('# [[User:',page_title,']]') AS page_title
FROM page
LEFT JOIN user ON user_name = REPLACE(page_title, '_', ' ')
WHERE page_namespace = 2
AND page_is_redirect = 0
AND page_title NOT LIKE '%/%'
AND page_title NOT RLIKE '[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}'
AND page_title NOT RLIKE '^([0-9A-F]{1,4}:){7,7}[0-9A-F]{1,4}'
AND user_name IS NULL
ORDER BY page_len DESC;
#RESULTSET_14
SELECT CONCAT('# [[User talk:',page_title,']]') AS page_title
FROM page
LEFT JOIN user ON user_name = REPLACE(page_title, '_', ' ')
WHERE page_namespace = 3
AND page_is_redirect = 0
AND page_title NOT LIKE '%/%'
AND page_title NOT RLIKE '[0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}[.][0-9]{1,3}'
AND page_title NOT RLIKE '^([0-9A-F]{1,4}:){7,7}[0-9A-F]{1,4}'
AND user_name IS NULL
ORDER BY page_len DESC;
SQL

Checking query status...
