Wikidata items with prefixed labels

SQL

USE commonswiki_p;
SELECT * 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 pagelinks ON pl_from = items.page_id AND pl_title = 'Q4167836' 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:%'
LIMIT 100;

SQL

Checking query status...