Wikidata labels which look like Q-IDs

SQL

USE wikidatawiki_p;

SELECT CONCAT('Q', 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, # 0-13

	7265345, # 16
	7265346, # 22
	7265350, # 35
	7265349, # 38
	7265352, # 40
	7265355, # 45
	23673300, # 50
	23673404, # 60
	23673400, # 70
	16460748, # 87
	3412288, # 92

	7265360, 7265362, # 94-95

	3412289, 3412285, 7265333, 7265337, 7265338, 7265339, # 99-104

	7265340, 7265341, # 106-107

	21072824, # 300
#	others
	125846, # Q1 skyscraper
	1054634, # Q10 TV series
	129609, # Q10 temperature coefficient
	7265361, # Q96 radio station
	18166377 # Q150 anniversary of Queensland
)
#AND CONCAT('Q', term_entity_id) = term_text
;
SQL

Checking query status...
