view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by seats_total
This data as json, CSV (advanced)
election_date (date) >30 ✖
- 2014-05-25 239
- 2019-05-26 234
- 2009-06-07 217
- 2004-06-13 193
- 1999-06-13 148
- 1989-06-18 122
- 1994-06-12 109
- 1984-06-17 87
- 1979-06-10 85
- 1996-10-20 36
- 2014-05-24 36
- 2019-05-25 36
- 1992-06-06 30
- 2011-12-04 30
- 2022-11-01 30
- 2004-06-12 26
- 1991-10-20 25
- 2006-04-09 25
- 2019-05-23 25
- 2007-11-25 24
- 2009-06-04 24
- 2012-06-17 24
- 1993-06-06 23
- 1994-03-27 22
- 1995-10-01 22
- 1990-06-09 21
- 1991-10-27 21
- 1990-04-08 19
- 1996-11-03 19
- 2015-11-08 19
- …
country_name_short | country_name | election_type | election_date | vote_share | seats | seats_total ▼ | party_name_short | party_name | party_name_english | left_right | country_id | election_id | previous_parliament_election_id | previous_cabinet_id | party_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LUX | Luxembourg | ep | 1999-06-13 | 8.99 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 505 | 306 | 621 | 1582 |
LUX | Luxembourg | ep | 1999-06-13 | 2.77 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 505 | 306 | 621 | 457 |
LUX | Luxembourg | ep | 1999-06-13 | 1.83 | 0 | 6 | GLEI | Greng Lëscht Ekologesch Initiativ | Green Left Ecological Initiative | 2.5 | 7 | 505 | 306 | 621 | 1158 |
LUX | Luxembourg | ep | 2004-06-13 | 37.13 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 593 | 299 | 196 | 1234 |
LUX | Luxembourg | ep | 2004-06-13 | 14.87 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 593 | 299 | 196 | 967 |
LUX | Luxembourg | ep | 2004-06-13 | 15.02 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 593 | 299 | 196 | 310 |
LUX | Luxembourg | ep | 2004-06-13 | 22.09 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 593 | 299 | 196 | 701 |
LUX | Luxembourg | ep | 2004-06-13 | 8.03 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 593 | 299 | 196 | 1582 |
LUX | Luxembourg | ep | 2004-06-13 | 1.69 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 593 | 299 | 196 | 457 |
LUX | Luxembourg | ep | 2004-06-13 | 1.17 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 593 | 299 | 196 | 151 |
LUX | Luxembourg | ep | 2009-06-07 | 31.32 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 662 | 383 | 12 | 1234 |
LUX | Luxembourg | ep | 2009-06-07 | 16.82 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 662 | 383 | 12 | 310 |
LUX | Luxembourg | ep | 2009-06-07 | 18.65 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 662 | 383 | 12 | 967 |
LUX | Luxembourg | ep | 2009-06-07 | 19.49 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 662 | 383 | 12 | 701 |
LUX | Luxembourg | ep | 2009-06-07 | 1.54 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 662 | 383 | 12 | 151 |
LUX | Luxembourg | ep | 2009-06-07 | 7.38 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 662 | 383 | 12 | 1582 |
LUX | Luxembourg | ep | 2009-06-07 | 3.41 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 662 | 383 | 12 | 457 |
LUX | Luxembourg | ep | 2009-06-07 | 1.38 | 0 | 6 | Bl | Biergerlëscht | Citizens' List | 7 | 662 | 383 | 12 | 1130 | |
LUX | Luxembourg | ep | 2014-05-25 | 37.65 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 835 | 803 | 1069 | 1234 |
LUX | Luxembourg | ep | 2014-05-25 | 14.77 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 835 | 803 | 1069 | 967 |
LUX | Luxembourg | ep | 2014-05-25 | 11.75 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 835 | 803 | 1069 | 701 |
LUX | Luxembourg | ep | 2014-05-25 | 15.01 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 835 | 803 | 1069 | 310 |
LUX | Luxembourg | ep | 2014-05-25 | 7.53 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 835 | 803 | 1069 | 1582 |
LUX | Luxembourg | ep | 2014-05-25 | 1.49 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 835 | 803 | 1069 | 151 |
LUX | Luxembourg | ep | 2014-05-25 | 5.76 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 835 | 803 | 1069 | 457 |
LUX | Luxembourg | ep | 2014-05-25 | 4.23 | 0 | 6 | Pi | Piratepartei Lëtzebuerg | Pirate Party Luxembourg | 7 | 835 | 803 | 1069 | 2256 | |
LUX | Luxembourg | ep | 2014-05-25 | 1.82 | 0 | 6 | PID | Partei fir Integral Demokratie | Party for Full Democracy | 7.4 | 7 | 835 | 803 | 1069 | 2257 |
LUX | Luxembourg | ep | 2019-05-26 | 21.44 | 2 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 1065 | 1043 | 1588 | 967 |
LUX | Luxembourg | ep | 2019-05-26 | 21.1 | 2 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 1065 | 1043 | 1588 | 1234 |
LUX | Luxembourg | ep | 2019-05-26 | 18.91 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 1065 | 1043 | 1588 | 310 |
LUX | Luxembourg | ep | 2019-05-26 | 12.19 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 1065 | 1043 | 1588 | 701 |
LUX | Luxembourg | ep | 2019-05-26 | 4.83 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 1065 | 1043 | 1588 | 457 |
LUX | Luxembourg | ep | 2019-05-26 | 10.04 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 1065 | 1043 | 1588 | 1582 |
LUX | Luxembourg | ep | 2019-05-26 | 7.7 | 0 | 6 | Pi | Piratepartei Lëtzebuerg | Pirate Party Luxembourg | 7 | 1065 | 1043 | 1588 | 2256 | |
LUX | Luxembourg | ep | 2019-05-26 | 1.14 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 1065 | 1043 | 1588 | 151 |
LUX | Luxembourg | ep | 2019-05-26 | 2.11 | 0 | 6 | VL | Volt Luxembourg | Volt Luxembourg | 7 | 1065 | 1043 | 1588 | 2766 | |
MLT | Malta | ep | 2014-05-25 | 53.39 | 3 | 6 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 836 | 790 | 1046 | 1003 |
MLT | Malta | ep | 2014-05-25 | 40.02 | 3 | 6 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 836 | 790 | 1046 | 984 |
MLT | Malta | ep | 2014-05-25 | 2.68 | 0 | 6 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 836 | 790 | 1046 | 1400 |
MLT | Malta | ep | 2014-05-25 | 2.95 | 0 | 6 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 836 | 790 | 1046 | 360 |
MLT | Malta | ep | 2019-05-25 | 54.29 | 4 | 6 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 1066 | 1010 | 1504 | 1003 |
MLT | Malta | ep | 2019-05-25 | 37.9 | 2 | 6 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 1066 | 1010 | 1504 | 984 |
MLT | Malta | ep | 2019-05-25 | 2.03 | 0 | 6 | PD | Partit Demokratiku | Democratic Party | 6.0 | 72 | 1066 | 1010 | 1504 | 2759 |
MLT | Malta | ep | 2019-05-25 | 3.17 | 0 | 6 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 1066 | 1010 | 1504 | 1400 |
SVN | Slovenia | ep | 2004-06-13 | 23.57 | 2 | 7 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 659 | 525 | 292 | 1047 |
SVN | Slovenia | ep | 2004-06-13 | 21.91 | 2 | 7 | LDS | Liberalna demokracija Slovenije | Liberal Democracy of Slovenia | 3.7351 | 60 | 659 | 525 | 292 | 1252 |
SVN | Slovenia | ep | 2004-06-13 | 17.65 | 2 | 7 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 659 | 525 | 292 | 179 |
SVN | Slovenia | ep | 2004-06-13 | 14.15 | 1 | 7 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 659 | 525 | 292 | 706 |
SVN | Slovenia | ep | 2004-06-13 | 8.41 | 0 | 7 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 659 | 525 | 292 | 16 |
SVN | Slovenia | ep | 2004-06-13 | 5.02 | 0 | 7 | SNS | Slovenska nacionalna stranka | Slovenian National Party | 4.7941 | 60 | 659 | 525 | 292 | 981 |
SVN | Slovenia | ep | 2004-06-13 | 4.11 | 0 | 7 | SO | Slovenija je naša | Slovenia is Ours | 60 | 659 | 525 | 292 | 2019 | |
SVN | Slovenia | ep | 2004-06-13 | 2.3 | 0 | 7 | SMS | Stranka mladih Slovenije | Youth Party of Slovenia | 4.2263 | 60 | 659 | 525 | 292 | 1512 |
SVN | Slovenia | ep | 2004-06-13 | 1.2 | 0 | 7 | GZS | Glas žensk Slovenije | Voice of Slovenian women | 60 | 659 | 525 | 292 | 2022 | |
SVN | Slovenia | ep | 2009-06-07 | 26.66 | 2 | 7 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 195 | 522 | 803 | 179 |
SVN | Slovenia | ep | 2009-06-07 | 18.43 | 2 | 7 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 195 | 522 | 803 | 706 |
SVN | Slovenia | ep | 2009-06-07 | 9.76 | 1 | 7 | Zares | Zares | For Real | 3.3 | 60 | 195 | 522 | 803 | 326 |
SVN | Slovenia | ep | 2009-06-07 | 11.48 | 1 | 7 | LDS | Liberalna demokracija Slovenije | Liberal Democracy of Slovenia | 3.7351 | 60 | 195 | 522 | 803 | 1252 |
SVN | Slovenia | ep | 2009-06-07 | 16.58 | 1 | 7 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 195 | 522 | 803 | 1047 |
SVN | Slovenia | ep | 2009-06-07 | 7.18 | 0 | 7 | DeSUS | Demokratična stranka upokojencev Slovenije | Democratic Party of Pensioners of Slovenia | 3.2292 | 60 | 195 | 522 | 803 | 1587 |
SVN | Slovenia | ep | 2009-06-07 | 3.58 | 0 | 7 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 195 | 522 | 803 | 16 |
SVN | Slovenia | ep | 2009-06-07 | 2.85 | 0 | 7 | SNS | Slovenska nacionalna stranka | Slovenian National Party | 4.7941 | 60 | 195 | 522 | 803 | 981 |
SVN | Slovenia | ep | 2009-06-07 | 1.96 | 0 | 7 | SMS | Stranka mladih Slovenije | Youth Party of Slovenia | 4.2263 | 60 | 195 | 522 | 803 | 1512 |
LVA | Latvia | ep | 2009-06-07 | 19.57 | 2 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 302 | 52 | 477 | 1100 |
LVA | Latvia | ep | 2009-06-07 | 24.32 | 2 | 8 | PS | Pilsoniskā savienība | Civic Union | 7.4 | 55 | 302 | 52 | 477 | 445 |
LVA | Latvia | ep | 2009-06-07 | 7.45 | 1 | 8 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 302 | 52 | 477 | 521 |
LVA | Latvia | ep | 2009-06-07 | 9.66 | 1 | 8 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 302 | 52 | 477 | 1520 |
LVA | Latvia | ep | 2009-06-07 | 6.66 | 1 | 8 | JL | Jaunais Laiks | New Era | 7.3026 | 55 | 302 | 52 | 477 | 1518 |
LVA | Latvia | ep | 2009-06-07 | 7.49 | 1 | 8 | LPP/LC | Latvijas Pirmā partija / Latvijas Ceļš | Latvian First Party / Latvian Way Party | 7.4 | 55 | 302 | 52 | 477 | 662 |
LVA | Latvia | ep | 2009-06-07 | 3.85 | 0 | 8 | SCP | Sabiedrība citai politikai | Society for Other Politics | 6.0 | 55 | 302 | 52 | 477 | 962 |
LVA | Latvia | ep | 2009-06-07 | 2.78 | 0 | 8 | TP | Tautas Partija | People's Party | 7.7544 | 55 | 302 | 52 | 477 | 811 |
LVA | Latvia | ep | 2009-06-07 | 2.81 | 0 | 8 | VL | Visu Latvijai! | All For Latvia! | 7.4 | 55 | 302 | 52 | 477 | 801 |
LVA | Latvia | ep | 2009-06-07 | 3.79 | 0 | 8 | LSDSP | Latvijas Sociāldemokrātiskā Strādnieku Partija | Latvian Social Democratic Workers' Party | 2.5 | 55 | 302 | 52 | 477 | 1656 |
LVA | Latvia | ep | 2009-06-07 | 4.3 | 0 | 8 | Lib | Libertas.lv | Libertas.lv | 7.4 | 55 | 302 | 52 | 477 | 500 |
LVA | Latvia | ep | 2009-06-07 | 3.72 | 0 | 8 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 302 | 52 | 477 | 466 |
LVA | Latvia | ep | 2014-05-24 | 46.19 | 4 | 8 | V | Vienotība | Unity | 7.4 | 55 | 848 | 765 | 1073 | 1666 |
LVA | Latvia | ep | 2014-05-24 | 13.04 | 1 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 848 | 765 | 1073 | 1100 |
LVA | Latvia | ep | 2014-05-24 | 14.25 | 1 | 8 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 848 | 765 | 1073 | 521 |
LVA | Latvia | ep | 2014-05-24 | 8.26 | 1 | 8 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 848 | 765 | 1073 | 466 |
LVA | Latvia | ep | 2014-05-24 | 6.38 | 1 | 8 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 848 | 765 | 1073 | 1520 |
LVA | Latvia | ep | 2014-05-24 | 2.49 | 0 | 8 | LRa | Latvijas Reģionu apvienība | Latvian Association of Regions | 7.4 | 55 | 848 | 765 | 1073 | 2366 |
LVA | Latvia | ep | 2014-05-24 | 1.54 | 0 | 8 | LSP | Latvijas Sociālistiskā partija | Socialist Party of Latvia | 1.25 | 55 | 848 | 765 | 1073 | 309 |
LVA | Latvia | ep | 2014-05-24 | 2.12 | 0 | 8 | LA | Latvijas attīstībai | For Latvia's Development | 6.0 | 55 | 848 | 765 | 1073 | 2392 |
LVA | Latvia | ep | 2014-05-24 | 3.73 | 0 | 8 | PPA | Politiskā Partija "Alternative" | Political Party "Alternative" | 3.3 | 55 | 848 | 765 | 1073 | 2393 |
LVA | Latvia | ep | 2019-05-25 | 26.24 | 2 | 8 | V | Vienotība | Unity | 7.4 | 55 | 1063 | 1042 | 1592 | 1666 |
LVA | Latvia | ep | 2019-05-25 | 16.4 | 2 | 8 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 1063 | 1042 | 1592 | 521 |
LVA | Latvia | ep | 2019-05-25 | 17.45 | 2 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 1063 | 1042 | 1592 | 1100 |
LVA | Latvia | ep | 2019-05-25 | 12.42 | 1 | 8 | LA | Latvijas attīstībai | For Latvia's Development | 6.0 | 55 | 1063 | 1042 | 1592 | 2392 |
LVA | Latvia | ep | 2019-05-25 | 6.24 | 1 | 8 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 1063 | 1042 | 1592 | 1520 |
LVA | Latvia | ep | 2019-05-25 | 5.34 | 0 | 8 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 1063 | 1042 | 1592 | 466 |
LVA | Latvia | ep | 2019-05-25 | 4.98 | 0 | 8 | LRa | Latvijas Reģionu apvienība | Latvian Association of Regions | 7.4 | 55 | 1063 | 1042 | 1592 | 2366 |
LVA | Latvia | ep | 2019-05-25 | 4.35 | 0 | 8 | JKP | Jaunā konservatīvā partija | New Conservative Party | 7.4 | 55 | 1063 | 1042 | 1592 | 2717 |
LVA | Latvia | ep | 2019-05-25 | 2.9 | 0 | 8 | P | Progresīvie | The Progressive | 3.3 | 55 | 1063 | 1042 | 1592 | 2716 |
SVN | Slovenia | ep | 2014-05-25 | 24.78 | 3 | 8 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 844 | 778 | 1047 | 179 |
SVN | Slovenia | ep | 2014-05-25 | 16.6 | 2 | 8 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 844 | 778 | 1047 | 1047 |
SVN | Slovenia | ep | 2014-05-25 | 8.12 | 1 | 8 | DeSUS | Demokratična stranka upokojencev Slovenije | Democratic Party of Pensioners of Slovenia | 3.2292 | 60 | 844 | 778 | 1047 | 1587 |
SVN | Slovenia | ep | 2014-05-25 | 8.08 | 1 | 8 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 844 | 778 | 1047 | 706 |
SVN | Slovenia | ep | 2014-05-25 | 10.33 | 1 | 8 | V | Verjamem | I Believe | 3.3 | 60 | 844 | 778 | 1047 | 2384 |
SVN | Slovenia | ep | 2014-05-25 | 6.63 | 0 | 8 | LZJ-PS | Lista Zorana Jankovića – Pozitivna Slovenija | Zoran Jankovic's List -- Positive Slovenia | 3.3 | 60 | 844 | 778 | 1047 | 1987 |
SVN | Slovenia | ep | 2014-05-25 | 5.47 | 0 | 8 | ZdLe | Združena levica | United Left | 1.3 | 60 | 844 | 778 | 1047 | 2334 |
SVN | Slovenia | ep | 2014-05-25 | 4.03 | 0 | 8 | SNS | Slovenska nacionalna stranka | Slovenian National Party | 4.7941 | 60 | 844 | 778 | 1047 | 981 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_election AS SELECT c.name_short AS country_name_short, c.name AS country_name, ii.short AS election_type, e.date AS election_date, vote_share, seats, seats_total, p.name_short AS party_name_short, p.name AS party_name, p.name_english AS party_name_english, vpp.left_right AS left_right, e.country_id AS country_id, er.election_id AS election_id, e.previous_parliament_election_id AS previous_parliament_election_id, e.previous_cabinet_id AS previous_cabinet_id, er.party_id AS party_id FROM (SELECT * FROM election_result WHERE vote_share NOT NULL OR seats NOT NULL) er LEFT OUTER JOIN election e ON er.election_id = e.id LEFT OUTER JOIN party p ON er.party_id = p.id LEFT OUTER JOIN viewcalc_party_position AS vpp ON er.party_id = vpp.party_id LEFT OUTER JOIN country c ON e.country_id = c.id LEFT OUTER JOIN info_id ii ON e.type_id = ii.id ORDER BY c.name_short, e.date, er.seats DESC;