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, 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 ( 3282050, 12034998, 11766819, 6751262, 16576135, 6762645, 18193752, 1532960, 19688703, 18823055, 16279273, 2607462, 6836888, 19381519, 16422423, 2313170, 12796682, 18385152, 18699294, 10586124, 18082046, 3859710, 18978392, 1285335, 9301036, 10594119, 16422886, 1977784, 18642351, 16280131, 18452229, 18199687, 253589, 11795834, 18339805, 19688723, 18699301, 19360717, 4927713, 16420784, 18978403, 19688729, 16423546, 16280473, 8758158, 18060544, 17641352, 16280529, 17770018, 17764440, 11887738, 19594626, 18608522, 18978414, 12045349, 18978415, 19688743, 18986522, 19689528, 19687118, 18520545, 18503079, 7308423, 18385819, 16861467, 17561019, 16280912, 18420753, 18038759, 18551845, 2066845, 16281029, 18844258, 16281046, 7397944, 10660337, 18191037, 12050883, 18023649, 17591690, 18157157, 6124292, 18950544, 18608876, 14901750, 16425929, 12672893, 18067255, 3491121, 18609788, 18760994, 16281837, 7674709, 17326500, 18198086, 15111386, 8346272, 16428902, 18028626, 19688778, 3991600, 19688779, 19345740, 18699306, 12059666, 16618163, 16282229, 15829976, 16282244, 9366507, 15732145, 7900718, 13405605, 14438051, 9370421, 17142382, 18571949, 16282503, 18182056, 2689397, 18130793, 19688788, 18180431, 18012369, 18699308, 16430484, 16430488, 9383641, 19001706, 17327128, 3894860, 16275103, 5202338, 18670193, 17374327, 362403, 2529610, 1855388, 2672502, 5760091 ) 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...