Untitled query #65456

This query is marked as a draft This query has been published by Nmine13.

SQL

with user_cat_page as (
	select cl_from, cl_to, page.page_id, page.page_namespace
  	from categorylinks
	join page on page.page_title = categorylinks.cl_to
    where page.page_namespace = 14
	and cl_to = "Wikipedians_by_education"
)
select 
cl_from as child_cat_page_id, 
cl_to as cat_title,
user_cat_page.page_id as cat_page_id,
page.page_title as child_cat_title
from user_cat_page 
left outer join page on page.page_id = cl_from
where page.page_namespace = 14

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...