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
use wikidatawiki_p; SELECT CONCAT('Q', term_entity_id), term_text from wb_terms WHERE term_entity_type = 'item' AND term_language = 'nb' and term_type = 'label' and term_entity_id IN ( 10512682, 10536776, 10697867, 11049480, 11166412, 11192273, 11194528, 11679994, 11873219, 11957582, 11957632, 11957786, 11958043, 11958077, 11958119, 11958147, 11958336, 11960827, 11963344, 11964063, 11965966, 11966444, 11966763, 11967041, 11967092, 11967313, 11967618, 11968575, 11970107, 11970213, 11973376, 11973848, 11977093, 11977320, 11977502, 11977655, 11979264, 11979504, 11979547, 11979724, 11980204, 11980459, 11980529, 11980670, 11980788, 11980957, 11980973, 11983640, 11986894, 11987935, 11987983, 11988450, 11989393, 11989456, 11990382, 11990500, 11990894, 11993398, 11993504, 11993741, 11997750, 11998892, 11999999, 12000304, 12001815, 12004094, 12004578, 12004736, 12005110, 12005362, 12006451, 12006781, 12007055, 12008425, 12008474, 12008876, 12009080, 12009806, 12010014, 12010878, 12011655, 12011663, 12011709, 12713565, 12717384, 12718513, 12719389, 13410754, 14667660, 14786737, 14828331, 15135420, 16161555, 16161598, 16164164, 16164220, 16164391, 16164425, 16164740, 16169773, 16169921, 16172837, 16177243, 16180115, 16180200, 16182330, 16184495, 17748593, 17750078, 17769434, 17770348, 17779617, 18338328, 18369670, 18369928, 18369961, 18638241, 18638498, 18689507, 241290, 2456724, 2778125, 3178641, 3393713, 3417064, 3431095, 3433340, 3841003, 3857549, 4347255, 4563473, 4569738, 4569813, 4569937, 4571101, 4574502, 4575472, 4583654, 4586587, 4587148, 4587552, 4981331, 5395705, 6949699, 6978561, 6978835, 6979664, 6981730, 838315 )
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...