Pages utilisateur non liées à un utilisateur et utilisant flow sur WP:FR

SQL

SELECT
  CONCAT("{{u'|", REPLACE(page_title, '_', ' '), "}}") AS Sortie
FROM page
LEFT JOIN `user`
ON REPLACE(SUBSTRING_INDEX(page.page_title, '/', 1), '_', ' ') = user.user_name /* Get page name, extract substring till char '/' and replace '_' by ' '. This is user name, use it to LEFT JOIN with 'user' table. */
WHERE page_namespace IN (2,3)
AND page_content_model = "flow-board"
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
GROUP BY page_title /* éliminer les doublons */
ORDER BY page_title /* trier par ordre alphabétique */

SQL

Checking query status...