Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
zhwikt: start with lower case in template/module
by
Xiplus
This query is marked as a draft
This query has been published
by
Xiplus
.
Toggle Highlighting
SQL
USE zhwiktionary_p; SELECT page_namespace, page_title, CONCAT(case when page_namespace = 10 then "Template:" when page_namespace = 11 then "Template talk:" when page_namespace = 828 then "Module:" when page_namespace = 829 then "Module talk:" end, page_title) AS 'real title' FROM page WHERE page_title REGEXP '^(а|ӑ|ӓ|ә|ӛ|ӕ|б|в|г|ґ|ѓ|ғ|ӷ|ҕ|д|ђ|е|ѐ|ё|ӗ|ҽ|ҿ|є|ж|ӂ|җ|ӝ|з|з|́|ҙ|ӟ|ӡ|ѕ|и|ѝ|ӥ|ӣ|і|ї|ӏ|й|ҋ|ј|к|қ|ҟ|ҡ|ӄ|ҝ|л|ӆ|љ|м|ӎ|н|ӊ|ң|ӈ|ҥ|њ|о|ӧ|ө|ӫ|ҩ|п|ҧ|р|ҏ|с|с|́|ҫ|т|ҭ|ћ|ќ|у|ў|ӳ|ӱ|ӯ|ү|ұ|ф|х|ҳ|һ|ц|ҵ|ч|ӵ|ҷ|ӌ|ҹ|џ|ш|щ|ъ|ы|ӹ|ь|ҍ|э|ӭ|ю|я|α|β|γ|δ|ε|ζ|η|θ|ι|κ|λ|μ|ν|ξ|ο|π|ρ|σ|τ|υ|φ|χ|ψ|ω)' AND (page_namespace = 10 OR page_namespace = 11 OR page_namespace = 828 OR page_namespace = 829)
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...