CJKV dabpages - Quarry

SQL

/*
select * from logging join actor on actor_id = log_actor
where log_namespace = 0 and log_title in ('社', 'She_(Chinese_character)')
*/

/*
-- ALTER TABLE page CONVERT TO CHARACTER SET utf8mb4, COLLATE utf8mb4_bin
select page_title, page_title = '慶応', REGEXP_SUBSTR(page_title, '\\p{Han}*'), REGEXP_SUBSTR('慶応', '\\p{Han}*')
from page where page_namespace = 0 and page_title = '慶応' -- rlike '^\\p{Han}+$' limit 100
*/

-- show variables like 'character_set%'
show create database enwiki_p
SQL

Checking query status...
