User:Edgars2007/Latvia1

enwiki
USE enwiki_p; select REPLACE(pla.page_title, '_', ' ') from categorylinks cla join page pla on cla.cl_from=pla.page_id# and cla.tl_from_ where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="WikiProject_Latvia_articles"#(cla.cl_to="WikiProject_Latvia_articles" and cla.cl_to<>"Redirect-Class_Latvia_articles") #limit 10;

dewiki
use dewiki_p; select REPLACE(l.ll_title, '_', ' ') from langlinks l join page p on p.page_id=l.ll_from where p.page_namespace=0 and p.page_title in (select pla.page_title		from categorylinks cla		join page pla on cla.cl_from=pla.page_id# and cla.tl_from_		where pla.page_namespace=0 and cla.cl_type="page" and                                             cla.cl_to="Lette") and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="en") and l.ll_lang="en" group by l.ll_from
 * 1) join page p on p.page_id=l.ll_from
 * 2) where l.ll_from in (select tl.tl_from from templatelinks tl
 * 3) 						where tl.tl_title="Portail_Lettonie" and tl_namespace=10 and tl.tl_from_namespace=0)
 * 1) having count(l.ll_lang)>10
 * 2) order by count(l.ll_lang) desc

frwiki
use frwiki_p; select REPLACE(l.ll_title, '_', ' ') from langlinks l where l.ll_from in (select tl.tl_from from templatelinks tl						where tl.tl_title="Portail_Lettonie" and tl_namespace=10 and tl.tl_from_namespace=0) and l.ll_from in (select m.ll_from from langlinks m where m.ll_lang="en") and l.ll_lang="en" group by l.ll_from
 * 1) join page p on p.page_id=l.ll_from
 * 1) having count(l.ll_lang)>10
 * 2) order by count(l.ll_lang) desc

ruwiki
use ruwiki_p; select p.page_title, count(l.ll_lang) from langlinks l join page p on l.ll_from=p.page_id where l.ll_from in (select p.page_id from pagelinks pl						join page p on p.page_title=pl.pl_title and pl.pl_namespace=p.page_namespace						where pl.pl_from=5971091 and pl.pl_namespace=0) and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv") group by l.ll_from order by count(l.ll_lang) desc
 * 1) having count(l.ll_lang)>20

wd
Āņi Ābeļi Parish Ādaži Ādaži Airfield Ādaži Municipality Āgenskalns Āne Āraiši lake dwelling site Ārlava parish Čeriaukštė Červonka Čiekurkalns Čornaja parish Ēdole Castle Ēdole parish Ērģeme Ērģeme parish Ērberģe Manor Ērgļi Ērgļi Municipality Ērgļi parish Ēvele parish Ģibuļi parish Īle parish Īslīce parish Īvande Manor Īvande parish Īve parish Ķīpsala Ķīšezers, Riga Ķīšupe Station Ķūļciems parish Ķegums Ķegums Hydroelectric Power Station Ķegums Municipality Ķegums Station Ķeipene parish Ķekava Ķekava Municipality Ķekava parish Ķemeri Ķemeri National Park Ķemeri Station Ķengarags Ķepova parish Ķirpēni Ķoņi parish Ļaudona Ļaudona parish Ļukas Ņivņiki Ņukši parish Ūdrīši parish .lv 18 November Torchlight procession 2009 Latvian meteorite hoax A1 road (Latvia) A10 road (Latvia) A11 road (Latvia) A2 road (Latvia) A3 road (Latvia) A4 road (Latvia) A5 road (Latvia) A6 road (Latvia) A7 road (Latvia) A8 road (Latvia) A9 road (Latvia) ABLV Bank AFA Olaine ASK Riga ASK/Brocēni/LMT ASK/Ogre Abava Abava Valley Abava parish Adamova Manor Administrative divisions of Latvia Adolfa Alunāna Theatre Aerodium Latvia Aglona Aglona Municipality Aglona Parish Agriculture in Latvia Agudas Israel (Latvia) Ainaži Ainaži Lighthouse Ainaži parish Airīte Station AirBaltic Aiviekste Aiviekste Parish Aiviekste hydroelectric power station Aizkraukle Aizkraukle Castle Aizkraukle District Aizkraukle Municipality Aizkraukle Parish Aizkraukle Station Aizpute Aizpute Castle Aizpute Municipality Aizpute Parish Aizstrautnieki Aizupe Manor Akācijas Akmenrags Lighthouse Aknīste Aknīste Municipality Aknīste parish Alūksne Alūksne Castle Alūksne District Alūksne Municipality Alūksne Museum Alūksne New Castle Alūksne Upland Albert Street, Riga Alderi Alexander Leutner & Co. All Saints Church, Riga All for Latvia! Allaži Parish Almāle Aloja Municipality Aloja parish Aloja, Latvia Alotene Station Alpha Baltic-Unitymarathons.com Alsunga Alsunga Castle Alsunga Municipality Alsunga Parish Alsviķi Parish Amata (river) Amata Municipality Amata parish Ambeļi Ambeļi Parish Ance parish Ance, Latvia Andrejs Upīts' Memorial Museum Andrejsala Andrupene parish Andzeļi parish Anna Parish Annenieki Annenieki Parish Annual Latvian Music Recording Awards Annunciation of Our Most Holy Lady Church, Riga Ape Municipality Ape parish Ape, Latvia Apgulde, Naudīte Parish Apriķi Manor Apšupe Apšupe Station Arena Riga Arendole Manor Arona parish Arsenāls – Fine Arts Museum Art Academy of Latvia Asūne parish Asare Manor Asare parish Asari Station, Latvia Asari, Latvia Ascension Church, Riga Assumption of Our Lady Church, Bolderāja Atari, Ādaži Municipality Atašiene parish Atgāzene Atgāzene Station Auči Auce Auce Castle Auce Municipality Audriņi Audriņi parish Audrupi Augstkalne parish Auleja parish Aumeisteri Manor Auri Parish Auri, Latvia Ausātas Auseklis Limbazi Theatre Ave Line Avotu Iela Bārbele parish Bārta Bārta parish Bēne Manor Bēne parish Bērzaine parish Bērzaune parish Bērzbeķe Bērze Bērze Parish Bērze, Bērze Parish Bērzgale parish Bērziņi parish Bērzkalne parish Bērzkalni, Alsunga Municipality Bērzkrasti Bērzpils parish Bērzupe Station Bērzupe, Annenieki Parish Bīriņi Palace Būcmaņi BA School of Business and Finance BFC Daugavpils BK Barons BK Gulbenes Buki BK Jēkabpils BK Jūrmala BK Jelgava BK Liepājas Lauvas BK Saldus BK Skonto BK VEF Rīga BK Valmiera BK Ventspils Babīte Municipality Babīte Station Babīte parish Bakans Balande Baldonas Baldone Baldone Manor Baldone Municipality Baldone parish Balgale parish Baloži Baloži Station Baltā māja Baltezers, Ādaži Municipality Baltic Coal Terminal Baltic International Academy Baltic News Service Baltinava Baltinava Municipality Baltinava parish Balvi Balvi District Balvi Municipality Balvi parish Bank of Latvia Banka Baltija Barkava parish Basilica of the Assumption, Aglona Battle of Wallhof Bauska Bauska Castle Bauska District Bauska Municipality Bauskas alus Bauska’s Defenders' Monument Beļava Manor Beļava parish Beberbeķi Bebrene Manor Bebri Parish Belarus–Latvia border Berģi Beverīna Municipality Biķernieki Biķernieki Parish Bieriņi Bikernieki Memorial Biksēre Manor Biksti Biksti Manor Biksti Parish Biksti Station Bikstu Stacija Bilska parish Birzgale parish Birznieki, Ādaži Municipality Bitenieki Bišumuiža Blīdene Station Blīdene parish Blankenfelde Manor Blome parish Blonti parish Boja Manor Bolderāja Bolderāja Lutheran Church Bornsminde Manor Brīvzemnieki parish Brainstorm (Latvian band) Braki Brakšķi Station Bramberģe Manor Brankas Branti parish Brasa Station Brasa, Riga Braslava parish Brekši Brenguļi parish Briģi Briģi parish Briežuciems parish Brocēni Brocēni Municipality Brocēni Station Brothers' Cemetery Brukna Manor Brunava parish Buļļu sala Bukaiši parish Bukulti Bulduri Bulduri Station Bunka parish Burtnieki Burtnieki Castle Burtnieki Municipality Burtnieki parish Cēre Manor Cēsis Cēsis Castle Cēsis District Cēsis Municipality Cēsu Alus Cīrava Palace Cīrava parish Cape Kolka Carnikava Carnikava Municipality Carnikava Station Cat House (Riga) Category:Latvia templates Category:Russian traditions Catrigroup Cekule Celtnieks Rīga Celtnieks Stadium Cena (river) Cena Station Cena, Ozolnieki Municipality Central District, Riga Centrs, Riga Ceraukste parish Ceriņi Cesvaine Cesvaine Municipality Cesvaine Palace Cesvaine parish Christ the King Church, Riga Christ the Saviour Church, Riga Christian Democratic Union (Latvia) Christian National Union (Latvia) Church of Christ, Riga Church of Jesus, Riga Church of Luther, Riga Church of the Cross, Riga Church of the Resurrection, Riga Church of the Theotokos of Kazan, Riga Cibla Cibla Municipality Cibla parish Ciecere parish Cimdenieki Cinevilla Cirma parish Cirsti Manor Citadele Banka Civic Union (Latvia) Code parish Commercialization Reactor Communist Party of Latvia Constitutional Court of Latvia Convent Yard, Riga Corruption Prevention and Combating Bureau Courland Courland Peninsula Cross of Recognition Cukurfabrika Station Dārzciems Dārziņi Dārziņi Station Dāviņi parish Dūdas DHK Latgale Dabikinė Dagda Municipality Dagda parish Dagda, Latvia Dailes Theatre Daina (Latvia) Dalbe Dalbe Station Dartz Daudzese Parish Daugava (river) Daugava Stadium (Daugavpils) Daugava Stadium (Liepāja) Daugava Stadium (Riga) Daugavgrīva Daugavgrīva Abbey Daugavgrīva Lighthouse Daugavgrīva White Church Daugavgrīva castle Daugavpils Daugavpils City Party Daugavpils District Daugavpils Ice Arena Daugavpils International Airport Daugavpils Municipality Daugavpils Station Daugavpils University Daugavpils fortress Daugavpils hydroelectric power station Daugmale Station Daugmale parish Dauksti parish Degole parish Degumuiža Dekšāres parish Demene Demene Parish Democratic Center Party of Latvia Democratic Centre (Latvia) Democratic Party "Saimnieks" Democrats Union Demokrāti.lv Depo Station Diatom Enterprises Diena Dienvidrietumi (Liepāja) Dienvidstacija Dienvidsusēja Dievs, svētī Latviju! Dignāja parish Dikļi Manor Dikļi parish Dimzukalns Dinaburg FC Dinaburga Castle Dinamo Riga Dinamo Riga (original) Districts of Latvia Divezeri Dobele Dobele Castle Dobele District Dobele Municipality Dobele Parish Dobele Station Dobele crater Dole Manor Dole Station Doles sala Dominante Park Dorupe Station Double Coffee Drabeši Manor Drabeši parish Dreiliņi, Riga Dreiliņi, Stopiņi Municipality Dricāni parish Drive eO Drusti parish Druviena parish Dubna (Daugava) Dubna Parish Dubulti Dubulti Station Dunalka Manor Dunalka Old Manor Dunalka parish Dunava parish Dundaga Dundaga Castle Dundaga Municipality Dundaga parish Dunika parish Durbe Durbe Manor Durbe Municipality Durbe Station Durbe parish Dursupe Manor Dviete Dviete Parish Dynatek-Latvia Dzērbene Manor Dzērbene parish Dzērve Manor Dzelzāmurs Dzelzava Dzelzava Manor Dzelzava parish Dzidriņas Dziesma Dzimtmisa Dzimtmisa Manor Dzintari Dzintari Station Dzirciems Džūkste Station Džūkste parish Ecolines Eglaine Eglaine Parish Eimuri, Ādaži Municipality Eirobaltija Riga Eirodziesma Eleja Eleja manor house Eleja parish Elko Grupa Elkšķene Station Elkšņi parish Embūte Embūte Castle Embūte parish Emburga Engure Engure Municipality Engure parish Equal Rights (Latvia) European Parliament election, 2004 (Latvia) European Parliament election, 2009 (Latvia) European Parliament election, 2014 (Latvia) European route E22 European route E262 European route E264 European route E67 European route E77 Eversmuiža Manor Expobank EzerNet Ezere Manor Ezere parish Ezeriņi, Penkule Parish Ezerkrasts Ezernieki parish FB Gulbene FC Caramba/Dinamo FC Daugava FC Daugava Riga FC Jūrmala FC Skonto/Cerība-46.vsk. FC Tranzit FK 1625 Liepāja FK ASK FK Alberts FK Alfa FK Apgaismes tehnika FK Auda FK Autonets FK Daugava (2003) FK Dinamo-Rīnuži/LASD FK Gauja FK Hemat FK Iecava FK Jēkabpils/JSC FK Jūrnieks FK Jaunība Rīga FK Jelgava FK Latvijas finieris FK Liepāja FK Liepājas Metalurgs FK Multibanka Rīga FK Nikars FK Ogre FK Pļaviņas DM FK Rīga FK Rīgas Futbola skola FK Smiltene/BJSS FK Spartaks Jūrmala FK Staiceles Bebri FK Starts FK Tukums 2000 FK VEF Rīga FK Venta FK Ventspils FK Viesulis Rīga FK Vindava FK Zibens/Zemessardze FS METTA/Latvijas Universitāte Feimaņi parish Felicianova Manor Finland–Latvia relations Firck Palace First Straujuma cabinet For Fatherland and Freedom/LNNK For Latvia and Ventspils For Latvia from the Heart For the Native Language! Ford-Vairogs Forticom Free port of Ventspils Freedom Monument Freeport of Riga Gārsene Manor Gārsene parish G. Ērenpreis Bicycle Factory Gaiķi parish Gaigalava parish Gailīši parish Gaisma Station Gaiziņkalns Galēni parish Galgauska parish Gallery Park Hotel, Riga Garciems Station Gardene Garkalne Municipality Garkalne, Ādaži Municipality Garoza, Ozolnieki Municipality Garupe Station Gauja Gauja National Park Gauja River Railway Bridge Gauja Station Gauja Valley Gaujiena Gaujiena Castle Gaujiena Palace Gaujiena Parish Gavieze parish Geography of Latvia German-Baltic Reform Party Glūda Station Glūda parish Goliševa parish Grāveri Parish Grāveri, Alsunga Municipality Grīnvalti Grīziņkalns Gramzda parish Grand Liepaja Data Center Grand Palace Hotel, Riga Great Cemetery Grebenstchikov House of Prayer, Riga Grindeks Griškāni parish Grobiņa Grobiņa Castle Grobiņa Municipality Grobiņa parish Grundzāle parish Gudenieki parish Gulbene Gulbene District Gulbene Municipality Gulbenes Sporta Centrs Gulf of Riga Gutmanis Cave HK Lido Nafta Riga HK Liepāja HK Liepājas Metalurgs HK Nik's Brih Riga HK Ozolnieki/Monarhs HK Prizma Riga HK Rīga HK Riga (1997) HK Riga 2000 HK Zemgale Hansabank Harmony Centre Helsinki-86 Holy Archangel Mikhail Church, Riga Holy Trinity Cathedral, Liepāja Holy Trinity Cathedral, Riga Holy Trinity Lutheran Church, Riga Holy Trinity Orthodox Church, Riga House of the Blackheads House of the Livonian Noble Corporation Iļģuciems Iļķene Iecava Iecava (river) Iecava Municipality Igate Manor Ikšķile Ikšķile Municipality Ikšķile Station Ilūkste Ilūkste Municipality Ilūkstes NSS Ilūkstes pilsētas stadions Ilga Manor Ilmāja Station Ilzene Parish Ilzeskalns parish Imanta Imanta Station Inčukalns Inčukalns Municipality Inčupe Station Inbox.lv ledus halle Indra parish Ineši parish Interbaltija Inversija Ipiķi parish Irbe Strait Irlava parish Iron Bridge, Riga Irši Parish Island Bridge, Riga Isnauda parish Istra parish Izvalta parish Jāņavārti Station Jāņi Jāzeps Vītols Latvian Academy of Music Jēkabpils Jēkabpils Air Base Jēkabpils District Jēkabpils Municipality Jērcēni parish Jūrkalne Jūrkalne parish Jūrmala Jūrmala airport JFC Kauguri Jūrmala JFK Olimps JFK Saldus JZ Microphones Jasmuiža Manor Jaunā Māja Jaunķemeri Jauna Pasaule (Liepāja) Jaunalūksne Parish Jaunanna Parish Jaunauce Manor Jaunauce parish Jaunbērze Jaunbērze Parish Jaunciems Jaunciems Lutheran Church Jaunciems, Riga Jaundubulti Jaundubulti Station Jaungulbene Jaungulbene Manor Jaungulbene parish Jaunjelgava Jaunjelgava Municipality Jaunjelgava parish Jaunlaicene Parish Jaunlutriņi parish Jaunmokas Manor Jaunmuiža Manor Jaunogre Station Jaunolaine Station Jaunpēternieki Jaunpiebalga Jaunpiebalga Municipality Jaunpiebalga parish Jaunpils Jaunpils Castle Jaunpils Municipality Jaunpils parish Jaunsāti parish Jaunsvente Manor Jaunsvirlauka parish Jelgava Jelgava Air Base Jelgava District Jelgava Gymnasium Jelgava Municipality Jelgava Palace Jelgava Station Jeri parish Jersika Parish Jersika Station Jews in Latvia (museum) Josta Station Jugla, Riga Jumprava Station Jumprava parish Jumurda Manor Jumurda parish Juniors Riga Just5 Juzefinova Manor Kārķi parish Kārsava Kārsava Municipality Kūdra Station Kūkas parish Kaķenieki Kabile Manor Kabile parish Kadaga Kaibala Station Kaiserwald Riga Kaiserwald concentration camp Kaive Oak Kaive parish Kalēti parish Kalkūne Parish Kalkūni, Latvia Kalna Manor Kalna parish Kalncempji Parish Kalnciems Kalngale Station Kalnieši parish Kalnmuiža Manor Kalsnava parish Kalupe Kalupe Parish Kalvene Station Kalvene parish Kameņeca Manor Kandava Kandava Municipality Kandava Station Kandavas Kartodroms Kantinieki parish Kaplava parish Karosta Kastuļina parish Katlakalns Katvari Manor Katvari parish Kaucminde Manor Kauguri parish Kauguri, Latvia Kaunata parish Kazdanga Palace Kazdanga parish Kazupe Klapkalnciems Kleisti Klintaine Parish Kocēni Kocēni Municipality Kocēni parish Kokmuiža Manor Koknese Koknese Castle Koknese Municipality Koknese Parish Koknese Station Kolka parish Kolka, Latvia Kombuļi parish Konstantinova parish Košrags Krāslava Krāslava District Krāslava Municipality Krāslava New Palace Krāslava Old Palace Krūmiņsala Krape parish Kreis Hasenpoth Krimūna Parish Krimūnas Krimulda Castle Krimulda Municipality Krimulda parish Krišjāņi parish Krišjānis Barons Memorial Museum Krustpils Castle Krustpils Municipality Krustpils Station Krustpils parish Kubuli parish Kukhva River Kuldīga Kuldīga District Kuldīga Municipality Kundziņsala Kuprava parish Kurmāle parish Kurmene Parish Kursīši parish Kurzeme District, Riga Kurzeme Planning Region Kusa, Latvia Lēdmane parish Lēdurga parish Līči Station Līči, Stopiņi Municipality Lībagi parish Līdumi Līdumnieki parish Līgatne Līgatne Municipality Līgatne parish Līgciems Station Līgo parish Līksna Līksna Parish Līksna Station Līvāni Līvāni Municipality Līvāni Station Līvbērze Station Līvbērze parish Līvi, Biksti Parish Lūznava Lūznava Manor Lūznava parish Lūžņa LB/Prizma Riga LETA LMR Liepāja Laidi Palace Laidi parish Laidze parish Laima (confectioner) Lake Alūksne Lake Burtnieks Lake Drīdzis Lake Engure Lake Engure Nature Park Lake Kaņieris Lake Lubāns Lake Pape Lake Rychy Lamiņi Manor Lapmežciems Parish Large Guild, Riga Latgale Latgale Suburb, Riga Latgalian Christian Peasant and Catholic Party Latgalian Farmer-Labour Party Latgalian Farmers Party Latgyprogorstroy Lattelecom Latvenergo Latvia Latvia (European Parliament constituency) Latvia University of Agriculture Latvia's First Party Latvia's First Party/Latvian Way Latvian Academy of Sciences Latvian Air Force Latvian Association for Support of Disabled People Latvian Brown Latvian Development Latvian Environment, Geology and Meteorology Centre Latvian Ethnographic Open Air Museum Latvian Farmers' Union Latvian Green Party Latvian ISBN Agency Latvian Land Forces Latvian Military Police Latvian Mobile Telephone Latvian Museum of Architecture Latvian Museum of Decorative Arts and Design Latvian Museum of Foreign Art Latvian Museum of National History Latvian Museum of Natural History Latvian Museum of Pharmacy Latvian Museum of Photography Latvian National Armed Forces Latvian National Armed Forces Staff Battalion Latvian National Guard Latvian National Independence Movement Latvian National Museum of Art Latvian National Opera Latvian National Theatre Latvian Naval Forces Latvian Railway History Museum Latvian Railways Latvian Railways Cup Latvian Riga Cathedral referendum, 1931 Latvian Russian Union Latvian Shipping Company Latvian Social Democratic Party Latvian Social Democratic Workers' Party Latvian Song and Dance Festival Latvian Special Tasks Unit Latvian State Language Center Latvian Unity Party Latvian War Museum Latvian Way Latvian White pig Latvian lats Latvian mythology Latvian parliamentary election, 2010 Latvian parliamentary election, 2011 Latvian parliamentary election, 2014 Latvian rublis Latvia–Lithuania border Latvia–Russia border Latvia–Russia relations Latvijas Balzams Latvijas Basketbola līga Latvijas Gāze Latvijas Krājbanka Latvijas Neatkarīgā Televīzija Latvijas Pasts Latvijas Televīzija Latvijas Universitāte men's basketball Latvijas Universitates Stadions Laubere parish Laucesa Parish Lauciņi Lauciene parish Lauderi Lauderi Parish Launkalne parish Lazdona parish Lazdukalns parish Lazduleja parish Lašupe Station Laža parish Leimaņi parish Lejasciems Lejasciems parish Lejasstrazdi Lendži parish Lestene parish Lieģi Lielais Kristaps Lielauce Manor Lielauce parish Lielbērze Lielirbe Lielmēmele Manor Lielplatone parish Lielstraupe Castle Lielupe Lielupe Station Lielvārde Lielvārde Air Base Lielvārde Castle Lielvārde Municipality Lielvārde Station Lielvārde parish Lielzalve Manor Liepāja Liepāja District Liepāja International Airport Liepāja Lighthouse Liepāja Museum Liepāja Party Liepāja Station Liepāja Theatre Liepāja lake Liepājas tramvajs Liepa manor Liepa parish Liepas Air Base Liepna Parish Liepupe parish Liepziedi Liezēre parish Light of Latgale Lilaste Station Limbaži Limbaži District Limbaži Municipality Limbaži parish List of National Roads in Latvia List of national parks in the Baltics List of tourist attractions in Riga Litene Litene Manor Litene parish Livonian coast Lizums Manor Lizums parish Local history Lociki Lode parish Lubāna Lubāna Municipality Lube parish Lucavsala Ludza Ludza Castle Ludza District Ludza Municipality Ludza River Lugaži Lure Riga Lutriņi Station Lutriņi parish Lycée Français de Riga Mākoņkalns parish Mālpils Mālpils Manor Mālpils Municipality Mālupe Parish Māras Mārciena parish Mārkalne Parish Mārsnēni parish Mārtiņi Mārupe Mārupe Municipality Mērdzene parish Mērsrags Mērsrags Lighthouse Mērsrags Municipality Mērsrags Port Mētriena parish Mīlgrāvis Mūkupurvs Mūrmuiža Mūrmuiža Manor Mūša M-Sola Heliport Maļinova Maļinova Parish Madara Cosmetics Madliena parish Madona Madona District Madona Municipality Madona Radio Towers Majori Majori Station Maliena Parish Malnava Manor Malnava parish Malta (river) Malta parish Mangaļi Station Mangaļsala Maritime Administration of Latvia Mark Rothko Art Centre Marseille 13-KTM Martin Luther Cathedral, Daugavpils Maskavas Forštate Matīši parish Maxima Group Mazā Jugla Mazbiksti Mazirbe Mazozoli parish Mazsalaca Mazsalaca Manor Mazsalaca Municipality Mazsalaca parish Mazzalve Parish Meņģele parish Medņeva parish Medumi Medumi Parish Medze parish Melluži Melluži Station Melnsils Mencendarbe Manor Meteņi Mežāre parish Mežaparks Mežaparks Lutheran Church Mežciems Station Mežciems, Riga Mežinieki Mežmuiža Manor Mežotne Mežotne Palace Mežotne parish Mežvidi parish Miķeļbāka Miķeļi Miķeļtornis Microphone Records MikroTik Mikrofona aptauja Miltiņi Milzkalne Milzkalne Station Ministry of Foreign Affairs (Latvia) Mis Latvija Misa (river in Latvia) Miss Universe Latvia Monument to the sailors and fishermen perished in the sea Monuments and memorials in Riga Moricsala Nature Reserve Murmastiene parish Museum of the History of Riga and Navigation Museum of the Occupation of Latvia Nīca Nīca Municipality Nīca parish Nīcgale Nīcgale Parish Nīcgale Station Nīgrande parish Nīkrāce parish Nītaure Nītaure parish NUTS of Latvia Nagļi parish National Alliance (Latvia) National Harmony Party National Library of Latvia National Power Unity National Union (Latvia) Nativity Cathedral, Riga Naudīte Naudīte Parish Naujene Parish Naukšēni Naukšēni Manor Naukšēni Municipality Naukšēni parish Nautrēni parish Nemunėlis Nereta Nereta (river) Nereta Municipality Nereta Parish New Centre (Latvia) New Era Party New Farmers' Union New Farmers-Small Landowners Party New Party (Latvia) New Riga Theatre Nirza parish Nogale Manor Norby Telecom Nordea Nordeka LFKA Nordic Investment Bank North Vidzeme Biosphere Reserve Northern District, Riga Norvik Banka Novadnieki parish Nurmuiža Castle ODO Riga OMEGA (counterterrorism unit) Occupation of the Latvian Republic Day Odziena Manor Ogre (river) Ogre District Ogre Municipality Ogre Station Ogre, Latvia Olaine Olaine Municipality Olaine Station Olaine parish Olainfarm Old Believers (Latvia) Olimpia Liepaja Olimpija Rīga Olympic Sports Center of Zemgale Olympic Sports Centre, Riga Order of Lāčplēsis Order of Viesturs Order of the Three Stars Otaņķi parish Our Lady of Sorrows Church, Riga Ovisi Lighthouse Ozo Golf Club Ozolaine parish Ozolmuiža Manor Ozolmuiža parish Ozolnieki Ozolnieki Municipality Ozolnieki Station Ozolsala Station Ošupe parish Pāle parish Pārdaugava Pārgauja Municipality Pārogre Station Pāvilosta Pāvilosta Municipality Pāvilosta Port Pērkone Pērkonkrusts Pērse Pētersala-Andrejsala Pļaviņas Pļaviņas Hydroelectric Power Station Pļaviņas Municipality Pļaviņas Station Pļavnieki Pūre Station Pūre parish P30 (Latvia) Pabaži Station Padone Station Padure Manor Padure parish Palink Palladium Riga Palsmane Manor Palsmane parish Pampāļi parish Pape Lighthouse Pape Nature Reserve Parūķis Parex Bank Party of the Orthodox Pasažieru vilciens Pasiene Pasiene Manor Pasiene Parish Pastende Manor Patent Office of the Republic of Latvia Patkule Pauls Stradiņš Clinical University Hospital Pededze Pededze Parish Pedeli Pedvale Open Air Museum Peitav Synagogue Pelči Palace Pelči parish Pelēči Parish Penkule Penkule Parish People's Party (Latvia) Piņķi Piedruja parish Pilda parish Pilskalne Parish, Ilūkste Municipality Pilskalne Parish, Nereta Municipality Pilsrundāle Piltene Piltene Castle Piltene parish Pitelis Pitrags Plāņi parish Plāņi, Ozolnieki Municipality Planning regions of Latvia Platone parish Pleskodāle Pokrov Cemetery Policijas FK Polish-Catholic Latvian Union of Poles Political Union of Economists Pope Palace Pope parish Popular Front of Latvia Port of Liepāja Positivus Festival Powder Tower, Riga Prauliena parish Praviņi Station Preiļi Preiļi District Preiļi Municipality Preiļi Palace Preiļu BJSS Priedaine Station Priekuļi Priekuļi Municipality Priekuļi parish Priekule Municipality Priekule parish Priekule, Latvia Prime Minister of Latvia Principality of Jersika PrivatBank (Latvia) Proud to serve Riga Puikule Manor Pumpuri Pumpuri Station Pureņi parish Purvciems Pushkin Statue (Riga) Puze Station Puze parish Puša parish Pušmucova parish Rāzna National Park Rēzekne Rēzekne (river) Rēzekne Castle Rēzekne District Rēzekne Municipality Rēzeknes FA Rīgas FS Rīgas Satiksme Rīgas Vagonbūves Rūpnīca Rītabuļļi Rūjiena Rūjiena Municipality Rūpnieki, Auri Parish RAF-Avia RFK Riga RSK Dižvanagi Raņķi parish Radio SWH Rock Radisson Blu Daugava Hotel Railway Bridge, Riga Raiskums parish Ramata parish Ranka parish Rauna Rauna Castle Rauna Municipality Rauna parish Reģi Reģi Manor Reņģe Manor Reform Party (Latvia) Reiu (river) Remembrance day of the Latvian legionnaires Remte Manor Remte parish Rencēni parish Renda parish Renda, Latvia Revelation of Christ Church, Riga Reverta Revolutionary Socialist Party of Latvia Riebiņi Riebiņi Municipality Riebiņi parish Rietumu Banka Riga Riga Autobus Factory Riga Aviation Museum Riga Business School Riga Castle Riga Cathedral Riga Cathedral pipe organ Riga Central Market Riga Central Station Riga City Council Riga District Riga Dome Choir School Riga Film Museum Riga Film Studio Riga Football Cup Riga Graduate School of Law Riga Hydroelectric Power Plant Riga Hydroelectric Power Plant Crossing Pylon Riga International Airport Riga International Coach Terminal Riga International Film Festival 2ANNAS Riga International School of Economics and Business Administration Riga LVRTC Transmitter Riga Metro Riga Motor Museum Riga Passenger Terminal Riga Planning Region Riga Porcelain Museum Riga Radio and TV Tower Riga Secondary School No. 13 Riga State Gymnasium No.1 Riga Stradiņš University Riga Technical University Riga Vanderer Riga Zoo Rigas Sporta Pils Rigatta Rikava Manor Rikava parish Rimi Baltic Rite parish Robežnieki parish Roja Municipality Roja Port Roja parish Roman Catholicism in Latvia Ropaži Ropaži Municipality Rosme Ruba parish Rubene parish Rucava Rucava Municipality Rucava parish Rudbārži Palace Rudbārži Station Rudbārži parish Rudzāti Parish Rugāji Rugāji Municipality Rugāji parish Rumba parish Rumbula Air Base Rumbula Station Rumbula, Stopiņi Municipality Rundāle Municipality Rundāle Palace Rundāle parish Rundēni Rundēni parish Russian traditions and superstitions Rušona parish Sēļi parish Sēja Municipality Sēlpils Sēlpils parish Sēme parish Sērene Parish Sērmūkši Manor Sīļukalns parish Sīkrags Sīpele SAF Tehnika SEB Unibanka SFK United SK Blāzma SK Cēsis SK LSPA/Riga SK Latvijas Avīze Sabile Sabile Municipality Sabile Station Saeima Saka Municipality Saka parish Sakstagals parish Sala Municipality, Latvia Sala Parish, Babīte Municipality Sala Parish, Sala Municipality Sala, Sala Parish Salaca Salacgrīva Salacgrīva Municipality Salacgrīva Port Salacgrīva fortress Salacgrīva parish Salas, Riga Salaspils Salaspils FC Salaspils Municipality Salaspils Station Salaspils concentration camp Salaspils parish Saldus Saldus Art School Saldus District Saldus Municipality Saldus Station Saldus parish Salgale Parish Saliena Saliena Parish Salnava Manor Salnava parish Sarkaņi parish Sarkandaugava Sarkandaugava Station Sasmaka Manor Sauka parish Saulkrasti Saulkrasti Jazz Festival Saulkrasti Municipality Saulkrasti Station Saulkrasti parish Sauna Parish Saunags Saurieši Sausnēja parish Sece Parish Second Straujuma cabinet Seda, Latvia Selonia Semigallia Sereal Sesava parish Sestā grupa (Liepāja) Shelter of Our Most Holy Lady Church, Riga Sidrabene, Ozolnieki Municipality Sieksāte Station SigmaNet Sigulda Sigulda Castle Sigulda Medieval Castle Sigulda Municipality Sigulda bobsleigh, luge, and skeleton track Silajāņi parish Silmala parish Sinyaya River Skaņkalne parish Skaista parish Skaistkalne Skaistkalne Manor Skaistkalne parish Skanste Skonto FC Skonto Hall Skonto Stadium Skrīveri Skrīveri Municipality Skrīveri Parish Skrīveri Station Skrudaliena Skrudaliena Parish Skrunda Skrunda Municipality Skrunda Station Skrunda parish Skrunda-1 Skujaine Skujene parish Skulte Port Skulte Station Skulte parish Skulte, Skulte Parish Slītere Lighthouse Slītere National Park Slagūne Slampe Station Slampe parish Slocene Sloka Station Sloka, Latvia Slokas Stadium Smārde Smārde Station Smārde parish Small Guild, Riga SmartLynx Airlines Smiltene Smiltene Municipality Smiltene parish Snēpele Palace Snēpele parish Sniķera sala Social Democratic Party "Harmony" Social Democratic Party (Latvia) Socialist Party of Latvia Society for Political Change Sokolki parish Southern Bridge Spāre Station Spartaks Rīga Speaker of the Saeima Spilve Airport Spilve, Riga Sporta Aģentūras Stadions Ss. Boris and Gleb Cathedral, Daugavpils Stāmeriena Palace Stāmeriena parish St. Albert's Church, Riga St. Alexander Nevsky Church, Riga St. Catherine's Lutheran Church, Riga St. Catherine's Roman Catholic Church, Riga St. Francis Church, Riga St. George's Church, Riga St. Gertrude New Church, Riga St. Gertrude Old Church, Riga St. James's Cathedral, Riga St. John the Forerunner Church, Riga St. John's Church, Riga St. John's Church, Saldus St. Joseph's Church, Riga St. Martin's Church, Riga St. Mary Magdalene's Church, Riga St. Paul's Lutheran Church, Riga St. Peter and St. Paul Church, Riga St. Peter's Church, Riga St. Saviour's Church, Riga St. Sergius of Radonezh Church, Riga Stabulnieki parish Staburadze Staburags Parish Stadions Arkādija Staicele Staicele parish Stalbe Stalbe parish Stapriņi State Chancellery of Latvia Stelpe parish Stende Stende (river) Stende Manor Stende Station Stoļerova parish Stockholm School of Economics in Riga Stone Bridge, Riga Stopiņi Municipality Strūžāni parish Stradi parish Straupe Straupe parish Strazde parish Strenči Strenči Municipality Stukmaņi Manor Subate Sunākste Parish Suntaži Manor Suntaži parish Supernova (Latvian TV series) Susāji parish Sutri Parish Suži Svēte Manor Svēte parish Svariņi parish Svente Parish Svete (river) Svitene Manor Svitene parish Swedish Gate, Riga Tārgale Tārgale parish Tērvete Tērvete Municipality Tērvete parish Tīnūži parish Tīraine Station TTT Riga Tabore Tabore Parish Tadaiķi Station Tadaiķi parish Talsi Talsi District Talsi Municipality Tartaks Taurene parish Taurupe Manor Taurupe parish Teiči Nature Reserve Teika, Riga Tetele The Baltic Times The Hobos Three Brothers, Riga Tiņģere Manor Tilža parish Tirza parish Torņakalns Torņakalns Station Tore Station Torpedo Rīga Tosmare Trīsciems Transport Accident and Incident Investigation Bureau Trapene Manor Trapene Parish Trepe Station Triangula Bastion Trikāta parish Tripartite-class minehunter Tukums Tukums District Tukums I Station Tukums II Station Tukums Municipality Tume parish Turība University Turaida Turaida Castle Turlava parish Ugāle Station Ugāle parish Ukri parish Ulbroka Umurga parish Ungurmuiža Manor Union Riga Union of Social Democrats – Mensheviks and Rural Workers United for Latvia Unity (Latvian political party) University of Latvia University of Liepāja Upenieki, Biksti Parish Upeslejas Usma Station Usma parish Utroya River Užava Lighthouse Užava parish Vālodzes Vāne Manor Vāne parish Vārkava Manor Vārkava Municipality Vārkava Parish Vārme Manor Vārme parish Vārve parish Vērēmi parish Vērgale Palace Vērgale parish Vērmanes Garden Vīksna parish Vīpe parish Vītiņi parish VEF Vabole Vabole Parish Vabole Station Vadakste Manor Vadakste parish Vagonu Parks Station Vaiņode Vaiņode Air Base Vaiņode Manor Vaiņode Municipality Vaiņode parish Vaidava parish Vaide Vaivari Vaivari Station Vaive parish Valdeķi Manor Valdemārpils Valdgale parish Valgunde parish Valka Valka District Valka Municipality Valka Town Theatre Valka parish Valle Parish Valmiera Valmiera District Valmiera Drama Theatre Valmiera Glass FK/BSS Valmiera parish Valmieras FK Vandzene Vandzene Manor Vandzene parish Vangaži Vanšu Bridge Varakļāni Varakļāni Municipality Varakļāni Palace Varakļāni parish Variņi parish Varieši parish Vecāķi Vecāķi Station Vecate parish Vecauce Manor Vecbebri Manor Vecborne Manor Vecdaugava Vecdaugava Station Vecdole Castle Vecgulbene Manor Veclaicene Parish Vecliepāja Vecmēmele Manor Vecmīlgrāvis Vecpiebalga Vecpiebalga Castle Vecpiebalga Municipality Vecpiebalga parish Vecpils parish Vecrīga Vecsaliena Manor Vecsaliena Parish Vecsaule parish Vectilža parish Vecumi parish Vecumnieki Vecumnieki Municipality Vecumnieki parish Vecvārkava Velnciems Vends Venta (river) Venta Rapid Ventspils Ventspils Castle Ventspils Coach Terminal Ventspils District Ventspils Gymnasium No.1 Ventspils I Station Ventspils II Station Ventspils International Airport Ventspils Lighthouse Ventspils Municipality Ventspils Olimpiskais Stadions Ventspils Starptautiskais Radioastronomijas Centrs Ventspils University College Veselava Manor Veselava parish Vestiena Manor Vestiena parish Viļāni Viļāni Municipality Viļāni parish Viļķene parish Viļaka Viļaka Castle Viļaka Municipality Victory Memorial to Soviet Army Vidriži parish Vidzeme Vidzeme Suburb, Riga Vidzeme University of Applied Sciences Vidzeme Upland Viesīte Viesīte Municipality Viesīte parish Viesati parish Viesturi Station Viesturi parish Vietalva Parish Vijciems parish Vilce parish Vilkupe Vilpulka parish Virbi parish Vircava parish Vireši Parish Virga parish Višķi Višķi Parish Voleri Vulkāns Kuldīga Walk, Livonia Workers' Party (Latvia) Young Latvians Zālīte Zīlāni Zaķumuiža Zaķusala Zaļā Manor Zaļa birze Zaļenieki Manor Zaļenieki parish Zaļesje Zaļesje Parish Zaņa parish Zalve Parish Zante Manor Zante parish Zasa Manor Zasa parish Zasulauks Zasulauks Station Zaube Zaube parish Zebrene Zebrene Parish Zelmeņi Zeltiņi Parish Zemīte Manor Zemgale Suburb, Riga Zemitāni Station Zentene Palace Zentene parish Ziedlejas Ziemeļblāzma Station Ziemeļu priekšpilsēta (Liepāja) Ziemeri Manor Ziemeri Parish Ziepniekkalns Zilaiskalns parish Zilupe Zilupe Municipality Zionist Party Zirņi parish Ziras parish Zlēkas parish Zolitūde Zolitūde Station Zorģi Zosēni parish Zvārde parish Zvāre Station Zvārtava Manor Zvārtava parish Zvejniekciems Station Zvirgzdene parish Šēnheida Manor Šķēde Šķēde Manor Šķēde parish Šķaune parish Šķeltova parish Šķibe Šķilbēni parish Šķirotava Šķirotava Station Šampēteris Šlokenbeka Castle Šmerlis Šventoji (Baltic) Žīguri parish Õhne

Results
In frwiki, not in enwiki 1995 IIHF European Women Championships 2005 Boys' Youth European Volleyball Championship 2008–09 KHL season 2009–10 KHL season 2010–11 KHL season 2010–11 MHL season 2011 Latvian Higher League 2011–12 KHL season 2011–12 MHL season 2012–13 KHL season 2013 World Women's Curling Championship 2013–14 KHL season 2014–15 KHL season 2015 FIL World Luge Championships ASK/Brocēni/LMT1995 IIHF European Women Championships 2008–09 KHL season 2009–10 KHL season 2010–11 KHL season 2010–11 MHL season 2011–12 KHL season 2011–12 MHL season 2012–13 KHL season 2013–14 KHL season 2014–15 KHL season 2015 FIL World Luge Championships Baltic Romani Bishopric of Ösel–Wiek Chaya Mushka Schneerson Duke Louis Ernest of Brunswick-Lüneburg Eastern European Hockey League Eliyahu Eliezer Dessler Emilia Unda EuroBasket 2015 squads Frederick William, Duke of Courland Friedrich Amelung Hermann Wilken In the Fog Junior Hockey League (Russia) Louise Elisabeth of Courland Ludwig August Mellin Marseille 13-KTM Nechama Leibowitz Old Believers Oleg Artemyev Selonian language Shlomo Pines Social Democratic Party "Harmony South Estonian language Terra Mariana#Livonian Confederation Treaty of Pozvol Treaty of Vilnius (1561) Yosef Yitzchak Schneersohn

in ruwiki, not in enwiki 1987 Individual Speedway Junior European Championship 1990 Baltic League Aleksandr Perfilyev Androphagi Anton Volkov Aušrinė Baltic Chess Championship Baltic song festivals Blodpalt Dartz Fastelavn Indra Devi Jacob W. Davis Kreis Friedrichstadt Langa Livonian Chronicle Nikolai Chagin Philippe Hirschhorn Plater Principality of Polotsk Science Illustrated Sinyaya River Treaty of Vilnius (1559) Treaty of Vilnius (1561) Vladislavs Gutkovskis

In dewiki, not enwiki - Lette Anatole Abragam Bill Rebane Boris Lurie Elena Skuin Esther Takeuchi George Nagobads Harry Domela Henry Stolow Isaac Zieman Jascha Brodsky Juris Zarins Kristian Kiehling Lina Stern Martin Latsis Peter von Blanckenhagen Ralf Rinke Robert Eikhe Roman Vishniac Vera Mukhina Vic Anselmo Viktoria Modesta Viktorija Ni Walter R. Gross Youri Messen-Jaschin

Res2

 * 1995 IIHF European Women Championships
 * 2005 Boys' Youth European Volleyball Championship
 * 2008–09 KHL season
 * 2009–10 KHL season
 * 2010–11 KHL season
 * 2010–11 MHL season
 * 2011 Latvian Higher League
 * 2011–12 KHL season
 * 2011–12 MHL season
 * 2012–13 KHL season
 * 2013 World Women's Curling Championship
 * 2013–14 KHL season
 * 2014–15 KHL season
 * 2015 FIL World Luge Championships
 * ASK/Brocēni/LMT
 * 1995 IIHF European Women Championships
 * Baltic Romani
 * Bishopric of Ösel–Wiek
 * Chaya Mushka Schneerson
 * Duke Louis Ernest of Brunswick-Lüneburg
 * Eastern European Hockey League
 * Eliyahu Eliezer Dessler
 * Emilia Unda
 * EuroBasket 2015 squads
 * Frederick William, Duke of Courland
 * Friedrich Amelung
 * Hermann Wilken
 * In the Fog
 * Junior Hockey League (Russia)
 * Louise Elisabeth of Courland
 * Ludwig August Mellin
 * Marseille 13-KTM
 * Nechama Leibowitz
 * Old Believers
 * Oleg Artemyev
 * Selonian language
 * Shlomo Pines
 * Social Democratic Party "Harmony"
 * South Estonian language
 * Terra Mariana
 * Treaty of Pozvol
 * Treaty of Vilnius (1561)
 * Yosef Yitzchak Schneersohn
 * 1987 Individual Speedway Junior European Championship
 * 1990 Baltic League
 * Aleksandr Perfilyev
 * Androphagi
 * Anton Volkov
 * Aušrinė
 * Baltic Chess Championship
 * Baltic song festivals
 * Blodpalt
 * Dartz
 * Fastelavn
 * Indra Devi
 * Jacob W. Davis
 * Kreis Friedrichstadt
 * Langa
 * Livonian Chronicle
 * Nikolai Chagin
 * Philippe Hirschhorn
 * Plater
 * Principality of Polotsk
 * Science Illustrated
 * Sinyaya River
 * Treaty of Vilnius (1559)
 * Vladislavs Gutkovskis
 * Anatole Abragam
 * Bill Rebane
 * Boris Lurie
 * Elena Skuin
 * Esther Takeuchi
 * George Nagobads
 * Harry Domela
 * Henry Stolow
 * Isaac Zieman
 * Jascha Brodsky
 * Juris Zarins
 * Kristian Kiehling
 * Lina Stern
 * Martin Latsis
 * Peter von Blanckenhagen
 * Ralf Rinke
 * Robert Eikhe
 * Roman Vishniac
 * Vera Mukhina
 * Vic Anselmo
 * Viktoria Modesta
 * Viktorija Ni
 * Walter R. Gross
 * Youri Messen-Jaschin