Untitled query #65252

SQL

USE enwiki_p;

select distinct rc_title
from recentchanges 
#where page_touched > 20220510112717
where rc_timestamp BETWEEN 20220608112717 and 20220609112717
and rc_type in (0,1,6)
and rc_title <= 'B'
order by rc_title ASC
limit 10000
/*
with distinct_page_titles as (

), 
pages as (
  select page_title, page_id 
  from distinct_page_titles
  join page on rc_title = page_title
)
select 
select 
	page_title, 
	page_id, 
    categorylinks.cl_to as category_title
from page 

left join categorylinks on categorylinks.cl_from = page.page_id
limit 1

*/
SQL

Checking query status...
