start with lower case (Cyrillic, Greek) in zhwikt template/module

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.

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)

SQL

Checking query status...