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 (
#	disambiguation items
	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,
#	other
	125846, 1054634
)
#AND CONCAT('Q', term_entity_id) = term_text
;
SQL

Checking query status...
