USE elwiki_p;

SELECT concat( "# [[Χρήστης:", page_title, "]]" )

FROM page

WHERE page_namespace =2

AND page_is_redirect =0

AND page_title LIKE '%/%'

AND page_id IN (

 SELECT cl_from FROM categorylinks

 WHERE cl_to NOT LIKE "Χρηστ%"

 AND cl_to NOT LIKE "Βικιπαίδ%"

 AND cl_to NOT LIKE "Σελίδ%"

 AND cl_to NOT LIKE "Λήμματα%"

 AND cl_to NOT LIKE "Βιβλία%"

 AND cl_to NOT LIKE "Pages%"

 AND cl_to NOT LIKE "Πρότυπα χρ%")

ORDER BY page_title;