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.