wiki for school

SQL

select p1.page_title
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

AخA
 
select p1.page_titlefrom categorylinks cljoin page p1    on cl.cl_to = "Статті_про_географію,_створені_під_час_конкурсу_Вікіпедія_для_школи_(2021_—_2022)"    and cl.cl_from = p1.page_idleft join page p0    on p1.page_title = p0.page_title and p0.page_namespace = 0left 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 < 202202220000order by p1.page_title

SQL

Checking query status...