Test - Quarry

SQL

USE frwiki_p;
SELECT
  CONCAT("{{u'|", page_title, "}}") AS sortie
FROM page
LEFT JOIN `user`
ON REPLACE(page.page_title, '_', ' ') = user.user_name
WHERE page_namespace IN (2,3)
AND page_is_redirect = 0
AND page_title NOT LIKE "%/%"
AND page_title NOT RLIKE "(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)"
AND page_title NOT RLIKE "(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})"
AND user_name IS NULL
SQL

Checking query status...
