Wikidata labels which look like Q-IDs

SQL

USE wikidatawiki_p;

SELECT term_entity_id AS 'qid', term_text, term_language
FROM wb_terms
WHERE term_entity_type = 'item'
AND term_type = 'label'
AND term_text LIKE 'Q%'
AND term_text REGEXP '^Q[0-9]+$'
AND term_entity_id not in (
	3412283, 165472, 404776, 416042, 395446, 395685, 1209173, 404615, 3412287, 1209166, 448368, 7265344, 22008601, 22676624
	7265345, 7265346,
	7265350, 7265349, 7265349, 7265352, 7265355, 23673400, 16460748, 3412288, 7265360, 7265362, 3412289,
	3412285, 7265333, 7265337, 7265338, 7265339, 7265340, 7265341, 21072824
)
;

SQL

Checking query status...