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
Alexander.vingardt
.
Toggle Highlighting
SQL
USE wikidatawiki_p; DESCRIBE wb_terms; SELECT * FROM wb_terms WHERE term_type = 'label' AND term_language = "en" AND term_full_entity_id in ('Q82955','Q937857','Q33999','Q36180','Q1930187','Q1028181','Q1622272','Q177220','Q36834','Q40348','Q10800557','Q49757','Q47064','Q43845','Q10798782','Q201788','Q10871364','Q639669','Q3665646','Q28389','Q19204627','Q12299841','Q2526255','Q250867','Q11513337','Q11774891','Q39631','Q2309784','Q189290','Q42973','Q193391','Q16533','Q81096','Q628099','Q2066131','Q2259451','Q482980','Q333634','Q37226','Q1281618','Q901','Q188094','Q33231','Q14089670','Q4610556','Q185351','Q1749879','Q6625963','Q3282637','Q753110','Q13414980','Q483501','Q486748','Q169470','Q947873','Q11338576','Q1234713','Q170790','Q158852','Q15117302','Q131524','Q13382576','Q593644','Q42603','Q4964182','Q10843402','Q488205','Q855091','Q13365117','Q183945','Q14467526','Q10833314','Q2405480','Q1231865','Q19595175','Q214917','Q2865819','Q2374149','Q644687','Q121594','Q15981151','Q10873124','Q16145150','Q3621491','Q15627169','Q131512','Q4263842','Q3055126','Q1792450','Q13141064','Q212238','Q2722764','Q4853732','Q15296811','Q806798','Q14373094','Q5137571','Q10349745','Q212980','Q3400985','Q14915627','Q2095549','Q2306091','Q2516866','Q182436','Q1371925','Q3387717','Q13381572','Q4009406','Q13219587','Q6665249','Q1607826','Q3062119','Q245068','Q13381863','Q622807','Q774306','Q864503','Q715301','Q41583','Q4773904','Q520549','Q3455803','Q822146','Q205375','Q15980158','Q11303721','Q350979','Q488111','Q5716684','Q1402561','Q4991371','Q222344','Q11063','Q1238570','Q4144610','Q2705098','Q19841381','Q378622','Q82594','Q13382566','Q10843263','Q219477','Q13474373','Q2252262','Q13418253','Q18844224','Q11900058','Q215536','Q2490358','Q1259917','Q901402','Q16267607','Q2961975','Q13382608','Q211346','Q859528','Q16287483','Q3014296','Q1650915','Q16029547','Q13381376','Q599151','Q130857','Q11774202','Q386854','Q635734','Q5322166','Q765778','Q10511368','Q13590141','Q17486376','Q864380','Q7042855','Q13582652','Q1079215','Q1397808','Q17524364','Q18581305','Q2478141','Q11607585','Q860918','Q152002','Q191633','Q12800682','Q10866633','Q627325','Q970153','Q384593','Q578109','Q2462658','Q805221','Q13382603','Q15253558','Q1925963','Q876864','Q372436','Q18814623','Q105186','Q23833535','Q1781198','Q1114448','Q1415090','Q974144','Q2919046','Q329439','Q17167049','Q3357567','Q10732476','Q266569','Q11569986','Q3501317','Q1662561','Q13570226','Q1225716','Q846750','Q476246','Q2059704','Q13382519','Q13382533','Q4439155','Q703534','Q6606110','Q24037210','Q3246315','Q202883','Q9149093','Q19953086','Q186360','Q3391743','Q17516936','Q18805','Q16947657','Q16947675','Q17361147','Q2727289','Q12330954','Q1476215','Q4594605','Q955464','Q3242115','Q708492','Q1643514','Q13382460','Q1076502','Q133485','Q10669499','Q2468727','Q2732142','Q1423891','Q674426','Q13235160','Q2640827','Q6430706','Q2504617','Q27349','Q1906857','Q17361156','Q11296761','Q212948','Q2986228','Q2251335','Q13382355','Q11481802','Q487596','Q13381753','Q713200','Q1350157','Q8246794','Q13383011','Q63755375','Q1086863','Q2707485','Q15895020','Q9017214','Q783906','Q16004431','Q63755400','Q270389','Q6168364','Q18515558','Q7541856','Q806349','Q3332711','Q15306067','Q3126128','Q2055046','Q4220892','Q12377274','Q3658608','Q17125263','Q34074720','Q2310145','Q831474','Q16278103','Q128124','Q13219637','Q12362622','Q733786','Q17505902','Q18617021','Q13382605','Q191808','Q15709642','Q3130384','Q12144794','Q3368718','Q2664701','Q484876','Q10862983','Q8178443','Q18702210','Q7019111','Q18199024','Q4164507','Q1734662','Q15117395','Q1595570','Q1371378','Q1323191','Q1731155','Q14972848','Q1569495','Q17489339','Q63755423','Q3499072','Q1326886','Q512314','Q3492027','Q4351403','Q5352191','Q222982','Q943995','Q9352089','Q4504549','Q322170','Q27532437','Q3075052','Q26481809','Q10842936','Q10872101','Q1743122','Q4379701','Q584301','Q2004963','Q15839134','Q17351648','Q21141408','Q1294787','Q2143894','Q462390','Q2599593','Q998550','Q662729','Q1208175','Q2259532','Q18574233','Q16742096','Q10694573','Q808967','Q12013238','Q11620676','Q15924224','Q4002666','Q112040','Q17351861','Q18576582','Q6337803','Q957729','Q189010','Q18510502','Q2500638','Q1209498','Q11631','Q15855449','Q1919436','Q226008','Q752129','Q2487799','Q13416354','Q15972912','Q2114605','Q2135538','Q17488316','Q465501','Q202648','Q484188','Q3409375','Q13219447','Q10841764','Q18200514','Q16004471','Q83307','Q2962070','Q15295720','Q175151','Q3427922','Q118865','Q25339110','Q13382981','Q131062','Q156839','Q8359428','Q18437198','Q2159907','Q388513','Q1414443','Q2627699','Q3779582','Q15214752','Q3186699','Q2643890','Q1075651','Q16323111','Q18524075','Q466640','Q2730732','Q1162163','Q1897112','Q17165321','Q1979607','Q326653','Q1937431','Q18939491','Q3286043','Q45199','Q329455','Q57199189','Q1278335','Q3410028','Q13424456','Q23892384','Q17488465','Q13365201','Q173950','Q1900167','Q5482740','Q2815948','Q48282','Q12347522','Q12713481','Q7501153','Q589298','Q19350898','Q432386','Q3578589','Q11122954','Q13581129','Q11598549','Q13391392','Q18545066','Q17682262','Q168559','Q1493121','Q212071','Q15983985','Q8963721','Q11499147','Q1350189','Q17307272','Q20870256','Q15077007','Q22132694','Q2145981','Q730242','Q3264451','Q30185','Q15949613','Q2629392','Q13724897','Q16012028','Q10297252','Q12406482','Q1056391','Q1198887','Q1955150','Q38142','Q4205432','Q13638192','Q600751','Q728711','Q11165895','Q23868946','Q725440','Q1340643','Q500251','Q15634285','Q551835','Q11538947','Q63755505','Q15472169','Q11598573','Q18667447','Q1776724','Q13464497','Q13561328','Q17337766','Q11699606','Q9648008','Q618694') LIMIT 10;
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...