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)')
*/

/*
select page_title from page
where page_namespace = 0 and page_is_redirect = 0
and page_title rlike '^[\\d\\p{Han}]*[\\p{Han}][\\d\\p{Han}]*(_\\(disambiguation\\))?$' collate utf8_general_ci
and page_id in (
  select cl_from from categorylinks
  where cl_to in ("All_disambiguation_pages") and cl_type = 'page'
)
and page_id not in (
  select cl_from from categorylinks
  where cl_to in ("Disambiguation_pages_with_Chinese_character_titles") and cl_type = 'page'
)
*/

/*
select p1.page_title, p2.page_title from redirect
join page p1 on p1.page_id = rd_from and p1.page_namespace = 0
join page p2 on p2.page_title = rd_title and p2.page_namespace = 0
where rd_namespace = 0 and p1.page_is_redirect = 1
and p1.page_title rlike '^[\\d\\p{Han}]*[\\p{Han}][\\d\\p{Han}]*(_\\(disambiguation\\))?$' collate utf8_general_ci
and p2.page_title not rlike '^[\\d\\p{Han}]*[\\p{Han}][\\d\\p{Han}]*(_\\(disambiguation\\))?$' collate utf8_general_ci
and p2.page_id in (
  select cl_from from categorylinks
  where cl_to in ("All_disambiguation_pages") and cl_type = 'page'
)
*/

/*
select page_title from page
where page_namespace = 0 and page_is_redirect = 0
and page_title not rlike '^[\\p{Han}]+(_\\(disambiguation\\))?$' collate utf8_general_ci
and page_title rlike '^[\\d\\p{Han}]*[\\p{Han}][\\d\\p{Han}]*(_\\(disambiguation\\))?$' collate utf8_general_ci
*/

/*
select count(*) from page where page_namespace = 0 and page_is_redirect = 0 and page_title like '%\_(film)';
select count(*) from page where page_namespace = 0 and page_is_redirect = 0 and page_title like '%\_(movie)';
select count(*) from page where page_namespace = 0 and page_is_redirect = 0 and page_title like '%\_(TV\_series)';
select count(*) from page where page_namespace = 0 and page_is_redirect = 0 and page_title like '%\_(television\_series)';
*/

select page_title from page where page_namespace = 0 and page_is_redirect = 0 and page_title like '%\_(movie)' collate utf8_general_ci;
select page_title from page where page_namespace = 0 and page_is_redirect = 0 and page_title like '%\_(television\_series)' collate utf8_general_ci;

-- show variables like 'char%'
-- show variables like 'collation%'
-- show create database enwiki_p
-- show create table page
-- set @@character_set_connection=utf8mb4
SQL

Checking query status...
