view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name_english
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | parliament | 1990-06-09 | 4.11 | 0 | 200 | SZV | Spojenectví zemědělců a venkova | Alliance of Farmers and the Countryside | 5.3 | 68 | 63 | 2101 | ||
SVK | Slovakia | ep | 2019-05-25 | 2.06 | 0 | 13 | KDZP | Kresťanská demokracia – Život a prosperita | Christian Democracy -- Life and Prosperity | 6.2 | 1 | 1070 | 1003 | 1529 | 2783 |
BEL | Belgium | parliament | 1936-05-24 | 0.94 | 2 | 202 | DC | Démocrates Chrétiens | Christian Democrats | 6.2 | 64 | 881 | 880 | 1270 | 2569 |
ITA | Italy | parliament | 2013-02-25 | 0.49 | 6 | 630 | CD | Centro Democratico | Democratic Centre | 6.0 | 26 | 789 | 111 | 983 | 2153 |
ITA | Italy | parliament | 2018-03-04 | 1 | 630 | CD | Centro Democratico | Democratic Centre | 6.0 | 26 | 1024 | 789 | 1501 | 2153 | |
HRV | Croatia | parliament | 2003-11-23 | 3 | 152 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 795 | 797 | 1051 | 2133 | |
HRV | Croatia | parliament | 2007-11-25 | 1.5 | 3 | 153 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 793 | 795 | 1053 | 2133 |
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 792 | 793 | 1057 | 2133 | |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1001 | 792 | 1056 | 2133 | |
HRV | Croatia | parliament | 2016-09-11 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1007 | 1001 | 1408 | 2133 | |
HRV | Croatia | ep | 2019-05-26 | 2.66 | 0 | 11 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1062 | 1007 | 1512 | 2133 |
HRV | Croatia | parliament | 2020-07-05 | 0.78 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1094 | 1007 | 1512 | 2133 |
NOR | Norway | parliament | 1903-09-16 | 2 | 117 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 944 | 943 | 1378 | 2415 | |
NOR | Norway | parliament | 1906-08-27 | 4.8 | 4 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 945 | 944 | 1380 | 2415 |
NOR | Norway | parliament | 1909-10-25 | 3.7 | 2 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 946 | 945 | 1382 | 2415 |
NOR | Norway | parliament | 1912-10-21 | 6 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 947 | 946 | 1384 | 2415 | |
NOR | Norway | parliament | 1915-10-21 | 4.2 | 6 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 948 | 947 | 1240 | 2415 |
NOR | Norway | parliament | 1918-10-21 | 3.3 | 3 | 126 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 949 | 948 | 1239 | 2415 |
NOR | Norway | parliament | 1921-10-24 | 2.5 | 2 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 950 | 949 | 1235 | 2415 |
NOR | Norway | parliament | 1924-10-21 | 1.8 | 2 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 951 | 950 | 1233 | 2415 |
NOR | Norway | parliament | 1927-10-17 | 1.35 | 1 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 867 | 951 | 1231 | 2415 |
NOR | Norway | parliament | 1930-10-20 | 0.77 | 1 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 866 | 867 | 1229 | 2415 |
NOR | Norway | parliament | 1933-10-16 | 0.55 | 1 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 865 | 866 | 1225 | 2415 |
FRA | France | parliament | 1932-05-08 | 0.82 | 11 | 605 | PUP | Parti de l'Unité Prolétarienne | Proletarian Unity Party | 1.3 | 43 | 984 | 985 | 1338 | 2584 |
BGR | Bulgaria | parliament | 1994-12-18 | 1.49 | 0 | 240 | SNI | Suyuz "Nov izbor" | "New Choice" Union | 6.0 | 10 | 355 | 32 | 109 | 2176 |
NLD | Netherlands | parliament | 2012-09-12 | 1.88 | 2 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 785 | 530 | 1028 | 2109 | |
NLD | Netherlands | ep | 2014-05-25 | 3.69 | 0 | 26 | 50+ | 50PLUS | 50PLUS | 8 | 846 | 785 | 1041 | 2109 | |
NLD | Netherlands | parliament | 2017-03-15 | 3.1 | 4 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 1012 | 785 | 1041 | 2109 | |
NLD | Netherlands | ep | 2019-05-23 | 3.91 | 1 | 26 | 50+ | 50PLUS | 50PLUS | 8 | 1052 | 1012 | 1530 | 2109 | |
NLD | Netherlands | parliament | 2021-03-17 | 1.02 | 1 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 1097 | 1012 | 1648 | 2109 | |
SVK | Slovakia | parliament | 2012-03-10 | 1.58 | 0 | 150 | 99% | 99% – občiansky hlas | 99 Percent -- Civic Voice | 1.3 | 1 | 781 | 524 | 982 | 2015 |
NZL | New Zealand | parliament | 1996-10-12 | 6.1 | 8 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 561 | 634 | 830 | 617 |
NZL | New Zealand | parliament | 1999-11-27 | 7.04 | 9 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 451 | 561 | 388 | 617 |
NZL | New Zealand | parliament | 2002-07-27 | 7.14 | 9 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 572 | 451 | 212 | 617 |
NZL | New Zealand | parliament | 2005-09-17 | 1.51 | 2 | 121 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 675 | 572 | 845 | 617 |
NZL | New Zealand | parliament | 2008-11-08 | 3.65 | 5 | 122 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 660 | 675 | 427 | 617 |
NZL | New Zealand | parliament | 2011-11-26 | 1.07 | 1 | 121 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 776 | 660 | 251 | 617 |
NZL | New Zealand | parliament | 2014-09-20 | 0.69 | 1 | 121 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 829 | 776 | 986 | 617 |
NZL | New Zealand | parliament | 2017-09-23 | 0.5 | 1 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 1018 | 829 | 1499 | 617 |
NZL | New Zealand | parliament | 2020-10-17 | 7.59 | 10 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 1092 | 1018 | 1518 | 617 |
GRC | Greece | parliament | 2012-05-06 | 1.8 | 0 | 300 | D-FS | Drasi – Fileleytheri Symmachia | Action -- Liberal Alliance | 6.0 | 41 | 783 | 651 | 984 | 2096 |
LUX | Luxembourg | parliament | 1989-06-18 | 7.29 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 526 | 183 | 175 | 1582 |
LUX | Luxembourg | parliament | 1994-06-12 | 8.16 | 5 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 306 | 526 | 418 | 1582 |
LUX | Luxembourg | ep | 1994-06-12 | 6.94 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 594 | 526 | 418 | 1582 |
LUX | Luxembourg | parliament | 1999-06-13 | 10.36 | 7 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 299 | 306 | 621 | 1582 |
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 | parliament | 2004-06-13 | 9.04 | 5 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 383 | 299 | 196 | 1582 |
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 | parliament | 2009-06-07 | 8.13 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 172 | 383 | 12 | 1582 |
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 | parliament | 2013-10-20 | 6.64 | 3 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 803 | 172 | 1063 | 1582 |
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 | parliament | 2018-10-14 | 8.02 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 1043 | 803 | 1069 | 1582 |
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 |
ITA | Italy | parliament | 1946-06-02 | 1.45 | 7 | 556 | PAz | Partito d'Azione | Action Party | 1.3 | 26 | 503 | 1330 | ||
CZE | Czech Republic | parliament | 2013-10-25 | 18.65 | 47 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 805 | 599 | 1062 | 2263 |
CZE | Czech Republic | ep | 2014-05-24 | 16.13 | 4 | 21 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 820 | 805 | 1072 | 2263 |
CZE | Czech Republic | parliament | 2017-10-21 | 29.64 | 78 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1020 | 805 | 1072 | 2263 |
CZE | Czech Republic | ep | 2019-05-25 | 21.18 | 6 | 21 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1057 | 1020 | 1534 | 2263 |
CZE | Czech Republic | parliament | 2021-10-09 | 27.13 | 72 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1099 | 1020 | 1534 | 2263 |
CYP | Cyprus | parliament | 2021-05-30 | 3.27 | 0 | 56 | EP | Energi Polites | Active Citizens | 1.3 | 51 | 1095 | 1004 | 1628 | 2815 |
SVN | Slovenia | parliament | 2004-10-03 | 3.97 | 0 | 90 | AS | Aktivna Slovenija | Active Slovenia | 4.6 | 60 | 80 | 525 | 292 | 380 |
BEL | Belgium | ep | 1979-06-10 | 1.43 | 0 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 442 | 663 | 521 | 1594 |
BEL | Belgium | parliament | 1981-11-08 | 2.3 | 2 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 501 | 663 | 429 | 1594 |
BEL | Belgium | ep | 1984-06-17 | 4.31 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 10 | 501 | 724 | 1594 |
BEL | Belgium | parliament | 1985-10-13 | 3.74 | 4 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 396 | 501 | 724 | 1594 |
BEL | Belgium | parliament | 1987-12-13 | 4.49 | 6 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 191 | 396 | 92 | 1594 |
BEL | Belgium | ep | 1989-06-18 | 7.57 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 553 | 191 | 457 | 1594 |
BEL | Belgium | parliament | 1991-11-24 | 4.9 | 7 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 418 | 191 | 457 | 1594 |
BEL | Belgium | ep | 1994-06-12 | 6.64 | 1 | 25 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 536 | 418 | 624 | 1594 |
BEL | Belgium | parliament | 1995-05-21 | 4.43 | 5 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 332 | 418 | 624 | 1594 |
BEL | Belgium | parliament | 1999-06-13 | 6.99 | 9 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 2 | 332 | 95 | 1594 |
BEL | Belgium | ep | 1999-06-13 | 7.46 | 2 | 25 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 624 | 332 | 95 | 1594 |
BEL | Belgium | parliament | 2003-05-18 | 2.47 | 0 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 143 | 2 | 193 | 1594 |
BEL | Belgium | ep | 2004-06-13 | 4.94 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 656 | 143 | 449 | 1594 |
BEL | Belgium | parliament | 2007-06-10 | 3.98 | 4 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 401 | 143 | 449 | 1594 |
BEL | Belgium | ep | 2009-06-07 | 4.9 | 1 | 22 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 638 | 401 | 80 | 1594 |
BEL | Belgium | parliament | 2010-06-13 | 4.38 | 5 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 486 | 401 | 431 | 1594 |
BEL | Belgium | parliament | 2014-05-25 | 5.32 | 6 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 816 | 486 | 987 | 1594 |
BEL | Belgium | ep | 2014-05-25 | 6.69 | 1 | 21 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 832 | 486 | 987 | 1594 |
BEL | Belgium | parliament | 2019-05-26 | 6.1 | 8 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 1048 | 816 | 1586 | 1594 |
BEL | Belgium | ep | 2019-05-26 | 7.81 | 1 | 21 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 1058 | 816 | 1586 | 1594 |
HUN | Hungary | parliament | 1990-04-08 | 3.1 | 2 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 257 | 1183 | ||
HUN | Hungary | parliament | 1994-05-29 | 2.1 | 1 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 620 | 257 | 13 | 1183 |
ITA | Italy | parliament | 1946-06-02 | 0.44 | 1 | 556 | PaCoI | Partito dei Contadini d'Italia | Agrarian Party | 5.3 | 26 | 503 | 618 | ||
ITA | Italy | parliament | 1948-04-18 | 0.37 | 1 | 574 | PaCoI | Partito dei Contadini d'Italia | Agrarian Party | 5.3 | 26 | 467 | 503 | 501 | 618 |
BGR | Bulgaria | parliament | 1991-10-13 | 3.86 | 0 | 240 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 32 | 353 | ||
BGR | Bulgaria | parliament | 1994-12-18 | 6.51 | 18 | 240 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 355 | 32 | 109 | 353 |
BGR | Bulgaria | ep | 2007-05-20 | 1.54 | 0 | 18 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 468 | 618 | 425 | 353 |
BGR | Bulgaria | ep | 2009-06-07 | 2.25 | 0 | 17 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 432 | 618 | 425 | 353 |
CHE | Switzerland | parliament | 1979-10-21 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 435 | 371 | 20 | 1964 | ||
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 521 | 358 | 426 | 1964 | ||
ISR | Israel | parliament | 1951-07-30 | 1.1 | 1 | 120 | HU | Hakla'ut Ufituah | Agriculture and Development | 34 | 705 | 704 | 1137 | 1835 | |
ISR | Israel | parliament | 1955-07-26 | 1.1 | 1 | 120 | HU | Hakla'ut Ufituah | Agriculture and Development | 34 | 706 | 705 | 928 | 1835 | |
ISR | Israel | parliament | 1959-11-03 | 1.1 | 1 | 120 | HU | Hakla'ut Ufituah | Agriculture and Development | 34 | 707 | 706 | 1083 | 1835 | |
ISR | Israel | parliament | 1951-07-30 | 1.6 | 2 | 120 | PAY | Poalei Agudat Yisrael | Agudat Israel Workers | 34 | 705 | 704 | 1137 | 1832 | |
ISR | Israel | parliament | 1961-08-15 | 1.9 | 2 | 120 | PAY | Poalei Agudat Yisrael | Agudat Israel Workers | 34 | 708 | 707 | 1136 | 1832 | |
ISR | Israel | parliament | 1965-11-01 | 1.8 | 2 | 120 | PAY | Poalei Agudat Yisrael | Agudat Israel Workers | 34 | 709 | 708 | 935 | 1832 | |
ISR | Israel | parliament | 1969-10-28 | 1.9 | 2 | 120 | PAY | Poalei Agudat Yisrael | Agudat Israel Workers | 34 | 710 | 709 | 938 | 1832 | |
ISR | Israel | parliament | 1977-05-17 | 1.3 | 1 | 120 | PAY | Poalei Agudat Yisrael | Agudat Israel Workers | 34 | 712 | 711 | 944 | 1832 |
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;