wiki for school

SQL

select p1.page_title, p0.page_id, r.rev_timestamp 
from categorylinks cl
join page p1
	on cl.cl_to = "Статті_про_географію,_створені_під_час_конкурсу_Вікіпедія_для_школи_(2021_—_2022)"
	and cl.cl_from = p1.page_id
left join page p0
	on p1.page_title = p0.page_title and p0.page_namespace = 0
left join revision_userindex r
	on p0.page_id = r.rev_page
    and r.rev_parent_id = 0
    and r.rev_timestamp >= 20211231220000
--    and r.rev_timestamp < 202202220000
order by p1.page_title
SQL

Checking query status...
