Wikidata items with prefixed labels

SQL

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;
SQL

Checking query status...
