Untitled query #6014

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

USE enwiki_p;
SELECT page_id,page_title,
GROUP_CONCAT(DISTINCT cl1.cl_to,', ') `cats1`,
GROUP_CONCAT(DISTINCT cl2.cl_to,', ') `cats2`,
GROUP_CONCAT(DISTINCT cl3.cl_to,', ') `cats3`
FROM categorylinks cl1,categorylinks cl2,page
LEFT OUTER JOIN categorylinks cl3 ON cl3.cl_from=page_id AND
cl3.cl_to IN ('Women_architects','Women_architects_by_nationality','Albanian_women_architects','American_women_architects','Angolan_women_architects','Argentine_women_architects','Australian_women_architects','Austrian_women_architects','Bangladeshi_women_architects','Belarusian_women_architects','Belgian_women_architects','Belizean_women_architects','Bosnia_and_Herzegovina_women_architects','British_women_architects','Bulgarian_women_architects','Canadian_women_architects','Chilean_women_architects','Chinese_women_architects','Croatian_women_architects','Cuban_women_architects','Czech_women_architects','Danish_women_architects','Dominican_Republic_women_architects','Dutch_women_architects','Egyptian_women_architects','Estonian_women_architects','Finnish_women_architects','French_women_architects','German_women_architects','Greek_women_architects','Icelandic_women_architects','Indian_women_architects','Iranian_women_architects','Iraqi_women_architects','Irish_women_architects','Israeli_women_architects','Italian_women_architects','Jamaican_women_architects','Japanese_women_architects','Kenyan_women_architects','Libyan_women_architects','Luxembourgian_women_architects','Mexican_women_architects','Moldovan_women_architects','Montenegrin_women_architects','Nepalese_women_architects','New_Zealand_women_architects','Nigerian_women_architects','Norwegian_women_architects','Pakistani_women_architects','Palestinian_women_architects','Polish_women_architects','Portuguese_women_architects','Puerto_Rican_women_architects','Romanian_women_architects','Russian_women_architects','Saudi_Arabian_women_architects','Serbian_women_architects','Singaporean_women_architects','Slovenian_women_architects','South_African_women_architects','Spanish_women_architects','Sri_Lankan_women_architects','Swedish_women_architects','Swiss_women_architects','Taiwanese_women_architects','Thai_women_architects','Turkish_women_architects','Venezuelan_women_architects','Women_landscape_architects')
WHERE cl1.cl_to IN
-- python -c $'import sys\nprint ",".join(repr(i.strip().replace(" ","_")) for i in sys.stdin.readlines())' < cats.txt > cats.escaped.txt
('Architects','Architects_by_century','11th-century_architects','12th-century_architects','12th-century_Italian_architects','13th-century_architects','13th-century_English_architects','13th-century_French_architects','13th-century_Italian_architects','14th-century_architects','14th-century_English_architects','14th-century_French_architects','14th-century_Italian_architects','15th-century_architects','15th-century_English_architects','15th-century_French_architects','15th-century_Italian_architects','16th-century_architects','16th-century_English_architects','16th-century_French_architects','16th-century_German_architects','16th-century_Italian_architects','17th-century_architects','Dutch_Golden_Age_architects','17th-century_English_architects','17th-century_French_architects','17th-century_German_architects','17th-century_Italian_architects','18th-century_architects','18th-century_British_architects','18th-century_English_architects','18th-century_Scottish_architects','18th-century_French_architects','18th-century_German_architects','18th-century_Italian_architects','19th-century_architects','19th-century_American_architects','19th-century_Australian_architects','19th-century_Belgian_architects','19th-century_British_architects','19th-century_English_architects','19th-century_Scottish_architects','19th-century_French_architects','19th-century_German_architects','19th-century_Italian_architects','Thomas_Penson','20th-century_architects','20th-century_American_architects','20th-century_Australian_architects','20th-century_Belgian_architects','20th-century_British_architects','20th-century_English_architects','20th-century_Scottish_architects','20th-century_Bulgarian_architects','20th-century_Canadian_architects','20th-century_Croatian_architects','20th-century_Danish_architects','20th-century_Dutch_architects','20th-century_Estonian_architects','20th-century_Filipino_architects','20th-century_Finnish_architects','20th-century_French_architects','20th-century_German_architects','Architects_who_died_in_the_Holocaust','Architects_who_died_in_Nazi_concentration_camps','20th-century_Hungarian_architects','20th-century_Israeli_architects','20th-century_Italian_architects','20th-century_Mexican_architects','20th-century_Swedish_architects','20th-century_Turkish_architects','20th-century_Uruguayan_architects','21st-century_architects','21st-century_American_architects','21st-century_Belgian_architects','21st-century_British_architects','21st-century_Croatian_architects','21st-century_Danish_architects','21st-century_Dutch_architects','21st-century_Finnish_architects','21st-century_French_architects','21st-century_German_architects','21st-century_Italian_architects','21st-century_Spanish_architects','British_architects_by_century','18th-century_British_architects','18th-century_English_architects','18th-century_Scottish_architects','19th-century_British_architects','19th-century_English_architects','19th-century_Scottish_architects','20th-century_British_architects','20th-century_English_architects','20th-century_Scottish_architects','21st-century_British_architects','English_architects_by_century','13th-century_English_architects','14th-century_English_architects','15th-century_English_architects','16th-century_English_architects','17th-century_English_architects','18th-century_English_architects','19th-century_English_architects','20th-century_English_architects','French_architects_by_century','13th-century_French_architects','14th-century_French_architects','15th-century_French_architects','16th-century_French_architects','17th-century_French_architects','18th-century_French_architects','19th-century_French_architects','20th-century_French_architects','21st-century_French_architects','German_architects_by_century','16th-century_German_architects','17th-century_German_architects','18th-century_German_architects','19th-century_German_architects','20th-century_German_architects','21st-century_German_architects','Italian_architects_by_century','12th-century_Italian_architects','13th-century_Italian_architects','14th-century_Italian_architects','15th-century_Italian_architects','16th-century_Italian_architects','17th-century_Italian_architects','18th-century_Italian_architects','19th-century_Italian_architects','20th-century_Italian_architects','21st-century_Italian_architects','Architects_by_nationality','Architects_by_style','Architects_by_city','Architects_by_ethnicity','Architects_by_activity','Lists_of_architects','Lists_of_architects_by_nationality','Ancient_architects','Ancient_Greek_architects','Ancient_Roman_architects','Architects_of_Alexander_the_Great','Buildings_and_structures_by_architect','Fictional_architects','Architecture_groups','Architects_who_died_in_the_Holocaust','Architects_who_died_in_Nazi_concentration_camps','LGBT_architects','Medieval_architects','11th-century_architects','12th-century_architects','12th-century_Italian_architects','13th-century_architects','13th-century_English_architects','13th-century_French_architects','13th-century_Italian_architects','14th-century_architects','14th-century_English_architects','14th-century_French_architects','14th-century_Italian_architects','15th-century_architects','15th-century_English_architects','15th-century_French_architects','15th-century_Italian_architects','Byzantine_architects','Gothic_architects','Manueline_architects','Nazi_architects','Architects_who_committed_suicide','Architectural_theoreticians','Architect_stubs','American_architect_stubs','Asian_architect_stubs','Canadian_architect_stubs','European_architect_stubs','South_American_architect_stubs','Wikipedia_categories_named_after_architects','Le_Corbusier','Le_Corbusier_buildings','Le_Corbusier_buildings_in_France','Le_Corbusier_buildings_in_India','Norman_Foster_(architect)','Norman_Foster_buildings','Metro_Bilbao','Metro_Bilbao_stations','Metro_Bilbao_templates','Buckminster_Fuller','Books_by_Buckminster_Fuller','Geodesic_domes','Poul_Henningsen','Arne_Jacobsen','Arne_Jacobsen_buildings','Richard_Rogers','Richard_Rogers_buildings','Vladimir_Shukhov','Vladimir_Shukhov_structures','Lattice_shell_structures_by_Vladimir_Shukhov','Roof_structures_by_Vladimir_Shukhov','Thomas_Telford','Works_of_Thomas_Telford','John_Vanbrugh','John_Vanbrugh_buildings','Plays_by_John_Vanbrugh','Frank_Lloyd_Wright')
AND cl1.cl_from=page_id AND cl2.cl_from=page_id AND page_namespace=0 GROUP BY page_id ORDER BY page_id ASC
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...
