User:Edgars2007/Latvia1

Home Talk Projects Sandboxes Cheatsheet Vital

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  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)
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
#having count(l.ll_lang)>10
#order by count(l.ll_lang) desc

frwiki

use frwiki_p;
select REPLACE(l.ll_title, '_', ' ')
from langlinks l
#join page p on p.page_id=l.ll_from
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
#having count(l.ll_lang)>10
#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
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc

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

enwiki

dewiki

frwiki

ruwiki

wd

Results

Res2