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

Fork of Pages utilisateur non liées à un utilisateur sur WP:FR by Epok

This query is marked as a draft This query has been published by Epok.

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 IS "flow-board"
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...