Pages utilisateur d'IP en redirection sur WP:FR

SQL

SELECT
  CONCAT("{{a-redir-simple|Utilisateur:", page_title, "}}") AS pu,
  CONCAT("{{a-redir-simple|Discussion utilisateur:", page_title, "}}") AS pdd
FROM page
LEFT JOIN `user`
/* Get page name, extract substring till char '/' and replace '_' by ' '. This is user name, use it to LEFT JOIN with 'user' table. */
ON REPLACE(SUBSTRING_INDEX(page.page_title, '/', 1), '_', ' ') = user.user_name
WHERE page_namespace IN (2,3)
AND ( SUBSTRING_INDEX(page_title, '/', 1) 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]?)" /* IPv4 */
OR SUBSTRING_INDEX(page_title, '/', 1)  RLIKE "(^([0-9]{1,3}[.]){3}[0-9]{1,3}$|^([[:alnum:]]{1,4}[:]){7})" ) /* IPv6 */
AND page_is_redirect = 1
AND user_name IS NULL
GROUP BY page_title /* éliminer les doublons */
ORDER BY page_title /* trier par ordre alhabetique */
SQL

Checking query status...
