Untitled query #65456

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"
  	or cl_to = "Wikipedians_by_ethnicity_and_nationality"
    or cl_to = "Wikipedians_by_gender"
  	or cl_to = "Wikipedians_by_interest"
  	or cl_to = "Wikipedians_by_hobby"
  	or cl_to = "LGBT%2B_Wikipedians"
  	or cl_to = "Wikipedians_by_location"
  	or cl_to = "Wikipedians_by_medical_condition" 
  	or cl_to = "Wikipedians_by_membership"
  	or cl_to = "Wikipedians_by_philosophy"
  	or cl_to = "Wikipedians_by_profession"
  	or cl_to = "Wikipedians_by_regional_identity"
  	or cl_to = "Wikipedians_by_religion"
   	or cl_to = "Wikipedians_by_skill"
  	or cl_to = "Wikipedians_by_MediaWiki_skin"
  	or cl_to = "Wikipedians_by_software"
  	or cl_to = "Wikipedians_by_sport"
  	or cl_to = "Wikipedians_by_Wikipedia_user_access_level"
  	or cl_to = "Wikipedians_by_website"
  	or cl_to = "Wikipedians—by_other_Wikimedia_projects"
  	or cl_to = "Wikipedians_by_Wikipedia_activity"
  	or cl_to = "Wikipedians_by_Wikipedia_user_page"
)
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
SQL

Checking query status...
