Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Jura1
.
Toggle Highlighting
SQL
# test use wikidatawiki_p; SELECT CONCAT('Q', term_entity_id) AS item, term_text, GROUP_CONCAT( term_language ) As langs, CONCAT('#{{Q|', term_entity_id, '}}') AS simplelist from wb_terms WHERE term_entity_type = 'item' # 'item' not 'property' and term_type = 'description' # 'label', 'description', 'alias' and term_language in ('en') and term_entity_id IN ( 18978288, 19006980, 5795850, 18707653, 19689390, 15130287, 18038709, 3660491, 18177247, 19688330, 18524102, 18449855, 5088587, 2963143, 14946485, 18195741, 7601360, 18562424, 18342070, 18156204, 17518420, 5209168, 4354045, 1067002, 18227986, 18620267, 16188355, 18699277, 5802106, 16275369, 18450086, 16549390, 16275526, 18220772, 18450130, 17766912, 18699279, 19689401, 16275583, 17018131, 10479874, 12765136, 18145462, 18145467, 3719512, 5346977, 19688400, 18116812, 18324312, 2684485, 5829589, 19688408, 19731088, 10482032, 18218731, 15849752, 10482249, 5831468, 18587703, 18131047, 3056634, 1857802, 16323502, 3482156, 10492741, 16275742, 16275767, 16275784, 15809351, 9258196, 6596953, 18030007, 19688418, 5458054, 15208017, 16275878, 12017837, 19689420, 18195535, 3094170, 3759041, 5528781, 9267344, 3761181, 18218247, 16276004, 5584405, 17864520, 16276257, 13584814, 16276289, 18611851, 14945139, 18641773, 18111066, 16427546, 18410867, 18038848, 16276743, 18176395, 18188038, 18220017, 19411671, 19689445, 18043410, 6978561, 19688618, 16277100, 10535639, 11977320, 18177335, 3801794, 3802190, 19278672, 18198822, 19376017, 18171079, 1822320, 16429346, 4295485, 4178117, 18147464, 18218143, 11725845, 16277391, 5932709, 18220098, 18218344, 14436605, 3766002, 18194764, 10541107, 14629919, 16563832, 17374392, 2408413, 18697129, 17854918, 16430008, 18978361, 6377170, 15823286, 10544842, 3195138, 19689457, 19688881, 18584936, 11743623, 17518406, 6434189, 18039564, 19595388, 19597653, 18608330, 3229170, 2755787, 4256413, 19379451, 16420838, 19380171, 18181772, 19347737, 18699291, 18526591, 16278614, 19689479, 18176973) GROUP BY term_text
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...