This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

AخA
 
USE commonswiki_p;
SELECT pp_value, term_text
FROM page_props
JOIN page AS categories ON categories.page_id = pp_page
JOIN wikidatawiki_p.page AS items ON items.page_namespace = 0 AND items.page_title = pp_value
LEFT JOIN wikidatawiki_p.pagelinks ON pl_from = items.page_id AND pl_title IN (
  'Q4167836', 'Q13331174', 'Q15407973', 'Q15647814', 'Q20010800', 'Q20113609', 'Q20769287', 'Q23894233', 'Q23894246', 'Q24046192',
  'Q24514938', 'Q24571879', 'Q24574745', 'Q30330522', 'Q30432511', 'Q38084761') AND pl_namespace = 0
JOIN wikidatawiki_p.wb_terms ON term_full_entity_id = pp_value
WHERE categories.page_namespace = 14
AND pp_propname = 'wikibase_item'
AND term_type = 'label'
AND term_language = 'en'
AND term_text LIKE 'Category:%'
AND pl_title IS NULL;
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.

Checking query status...