Fork of
templates with bad names
by Achim55
This query is marked as a draft
This query has been published
by Geraki.
SQL
x
SELECT CONCAT('# [[Πρότυπο:', REPLACE (page_title,'_',' '), ']]')
FROM page
WHERE page_namespace = 10
AND (page_title LIKE 'User:%'
OR page_title LIKE 'Χρήστης:%'
OR page_title LIKE 'Βοήθεια:%'
OR page_title LIKE 'Βικιπαίδεια:%'
OR page_title LIKE 'Utilisateur:%'
OR page_title LIKE 'Κατηγορία:%'
OR page_title LIKE 'Wikipedia:%'
OR page_title LIKE 'WP:%'
)
ORDER BY page_title
LIMIT 200;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.