SQL
AخA
select p.page_title, p.page_len
from page p
where p.page_namespace=0 and p.page_title in (select pla.page_title
from categorylinks cla
join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
where pla.page_namespace=1 and cla.cl_type="page" and
cla.cl_to="All_Wikipedia_vital_articles") and p.page_title in (select pla.page_title
from categorylinks cla
join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
where pla.page_namespace=1 and cla.cl_type="page" and
cla.cl_to like "Stub-Class%") and p.page_title in (select pla.page_title
from categorylinks cla
join page pla on cla.cl_from=pla.page_id# and cla.tl_from_
where pla.page_namespace=1 and cla.cl_type="page" and
(cla.cl_to like "Top-importance%" or cla.cl_to like "High-importance%"))
limit 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.