view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by left_right descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEU | Germany | parliament | 1965-09-19 | 2.0 | 0 | 496 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 250 | 381 | 31 | 1537 |
DEU | Germany | parliament | 1969-09-28 | 4.3 | 0 | 496 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 447 | 250 | 170 | 1537 |
DEU | Germany | parliament | 1972-11-19 | 0.6 | 0 | 496 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 95 | 447 | 358 | 1537 |
DEU | Germany | parliament | 1976-10-03 | 0.3 | 0 | 496 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 163 | 95 | 252 | 1537 |
DEU | Germany | parliament | 1983-03-06 | 0.2 | 0 | 498 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 484 | 547 | 642 | 1537 |
DEU | Germany | parliament | 1987-01-25 | 0.6 | 0 | 497 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 588 | 484 | 346 | 1537 |
DEU | Germany | parliament | 2005-09-18 | 1.6 | 0 | 614 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 118 | 385 | 529 | 1537 |
DEU | Germany | parliament | 2009-09-27 | 1.5 | 0 | 622 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 93 | 118 | 85 | 1537 |
DEU | Germany | parliament | 2013-09-22 | 1.3 | 0 | 631 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 800 | 93 | 472 | 1537 |
DEU | Germany | ep | 2014-05-25 | 1.0 | 1 | 96 | NPD | Nationaldemokratische Partei Deutschlands | National Democratic Party | 9.8246 | 54 | 825 | 800 | 1071 | 1537 |
ESP | Spain | parliament | 1979-03-01 | 2.11 | 1 | 350 | UN | Unión Nacional | National Union | 9.8 | 27 | 493 | 42 | 205 | 1407 |
FRA | France | ep | 1979-06-10 | 1.3 | 0 | 81 | PFN | Parti des forces nouvelles | Party of New Forces | 9.8 | 43 | 677 | 496 | 72 | 670 |
LTU | Lithuania | parliament | 1992-11-15 | 3.55 | 1 | 141 | JL | Jaunoji Lietuva | Young Lithuania | 9.8 | 15 | 439 | 462 | 512 | 383 |
LTU | Lithuania | parliament | 1996-10-20 | 1.57 | 1 | 141 | LPKTS | Lietuvos politinių kalinių ir terminių sąjunga | Union of Lithuanian Political Prisoners and Deportees | 9.8 | 15 | 566 | 439 | 91 | 1447 |
LTU | Lithuania | parliament | 1996-10-20 | 4.01 | 1 | 141 | JL | Jaunoji Lietuva | Young Lithuania | 9.8 | 15 | 566 | 439 | 91 | 383 |
LTU | Lithuania | parliament | 2000-10-08 | 1.15 | 1 | 141 | JL | Jaunoji Lietuva | Young Lithuania | 9.8 | 15 | 59 | 566 | 735 | 383 |
LTU | Lithuania | parliament | 2008-10-12 | 1.75 | 0 | 141 | JL | Jaunoji Lietuva | Young Lithuania | 9.8 | 15 | 646 | 214 | 579 | 383 |
CZE | Czech Republic | parliament | 1990-06-09 | 1.0 | 0 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 63 | 872 | ||
CZE | Czech Republic | parliament | 1992-06-06 | 5.98 | 14 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 39 | 63 | 262 | 872 |
CZE | Czech Republic | parliament | 1996-06-01 | 8.01 | 18 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 301 | 39 | 835 | 872 |
CZE | Czech Republic | parliament | 1998-06-20 | 3.9 | 0 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 27 | 301 | 76 | 872 |
POL | Poland | parliament | 1991-10-27 | 2.3 | 3 | 460 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 211 | 158 | 75 | 1549 |
POL | Poland | parliament | 1993-09-19 | 3.2 | 0 | 460 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 268 | 211 | 730 | 1549 |
POL | Poland | parliament | 1997-09-21 | 2.033 | 0 | 460 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 477 | 268 | 437 | 1549 |
POL | Poland | ep | 2004-06-13 | 1.87 | 0 | 54 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 199 | 565 | 322 | 1549 |
POL | Poland | parliament | 2005-09-25 | 1.57 | 0 | 460 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 188 | 565 | 322 | 1549 |
POL | Poland | ep | 2009-06-07 | 1.1 | 0 | 50 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 255 | 560 | 164 | 1549 |
POL | Poland | parliament | 2011-10-09 | 1.06 | 0 | 460 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 766 | 560 | 164 | 1549 |
POL | Poland | ep | 2014-05-25 | 7.15 | 4 | 51 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 837 | 766 | 985 | 1549 |
DEU | Germany | ep | 1989-06-18 | 1.6 | 0 | 81 | DVU | Deutsche Volksunion | German People's Union | 9.7256 | 54 | 296 | 588 | 286 | 1506 |
DEU | Germany | parliament | 1998-09-27 | 1.2 | 0 | 669 | DVU | Deutsche Volksunion | German People's Union | 9.7256 | 54 | 679 | 595 | 778 | 1506 |
FRA | France | ep | 1984-06-17 | 10.95 | 10 | 81 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 415 | 20 | 428 | 270 |
FRA | France | parliament | 1986-03-16 | 9.8 | 35 | 556 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 623 | 20 | 843 | 270 |
FRA | France | parliament | 1988-06-12 | 9.8 | 1 | 555 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 643 | 623 | 1150 | 270 |
FRA | France | ep | 1989-06-18 | 11.73 | 10 | 81 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 360 | 643 | 712 | 270 |
FRA | France | parliament | 1993-03-28 | 12.4 | 0 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 664 | 643 | 199 | 270 |
FRA | France | ep | 1994-06-12 | 10.5 | 11 | 87 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 680 | 664 | 318 | 270 |
FRA | France | parliament | 1997-06-01 | 14.95 | 1 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 479 | 664 | 422 | 270 |
FRA | France | ep | 1999-06-13 | 5.7 | 5 | 87 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 273 | 479 | 481 | 270 |
FRA | France | parliament | 2002-06-16 | 11.34 | 0 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 403 | 479 | 711 | 270 |
FRA | France | ep | 2004-06-13 | 9.8 | 7 | 78 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 160 | 403 | 802 | 270 |
FRA | France | parliament | 2007-06-17 | 4.29 | 0 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 171 | 403 | 807 | 270 |
FRA | France | ep | 2009-06-07 | 6.34 | 3 | 72 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 219 | 171 | 306 | 270 |
FRA | France | parliament | 2012-06-17 | 13.6 | 2 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 782 | 171 | 1037 | 270 |
FRA | France | ep | 2014-05-24 | 24.86 | 24 | 74 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 824 | 782 | 1103 | 270 |
FRA | France | parliament | 2017-06-18 | 13.2 | 8 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 1014 | 782 | 1508 | 270 |
FRA | France | ep | 2019-05-26 | 23.34 | 22 | 74 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 1054 | 1014 | 1509 | 270 |
FRA | France | parliament | 2022-06-19 | 18.68 | 89 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 1110 | 1014 | 1673 | 270 |
BEL | Belgium | parliament | 1978-12-17 | 1.4 | 1 | 212 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 663 | 420 | 233 | 993 |
BEL | Belgium | parliament | 1981-11-08 | 1.1 | 1 | 212 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 501 | 663 | 429 | 993 |
BEL | Belgium | ep | 1984-06-17 | 1.28 | 0 | 24 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 10 | 501 | 724 | 993 |
BEL | Belgium | parliament | 1985-10-13 | 1.41 | 1 | 212 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 396 | 501 | 724 | 993 |
BEL | Belgium | parliament | 1987-12-13 | 1.9 | 2 | 212 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 191 | 396 | 92 | 993 |
BEL | Belgium | ep | 1989-06-18 | 4.09 | 1 | 24 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 553 | 191 | 457 | 993 |
BEL | Belgium | parliament | 1991-11-24 | 6.6 | 12 | 212 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 418 | 191 | 457 | 993 |
BEL | Belgium | ep | 1994-06-12 | 7.78 | 2 | 25 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 536 | 418 | 624 | 993 |
BEL | Belgium | parliament | 1995-05-21 | 7.83 | 11 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 332 | 418 | 624 | 993 |
BEL | Belgium | parliament | 1999-06-13 | 9.87 | 15 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 2 | 332 | 95 | 993 |
BEL | Belgium | ep | 1999-06-13 | 9.39 | 2 | 25 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 624 | 332 | 95 | 993 |
BEL | Belgium | parliament | 2003-05-18 | 11.59 | 18 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 143 | 2 | 193 | 993 |
BEL | Belgium | ep | 2004-06-13 | 14.34 | 3 | 24 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 656 | 143 | 449 | 993 |
BEL | Belgium | parliament | 2007-06-10 | 12.0 | 17 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 401 | 143 | 449 | 993 |
BEL | Belgium | ep | 2009-06-07 | 9.85 | 2 | 22 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 638 | 401 | 80 | 993 |
BEL | Belgium | parliament | 2010-06-13 | 7.76 | 12 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 486 | 401 | 431 | 993 |
BEL | Belgium | parliament | 2014-05-25 | 3.67 | 3 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 816 | 486 | 987 | 993 |
BEL | Belgium | ep | 2014-05-25 | 4.26 | 1 | 21 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 832 | 486 | 987 | 993 |
BEL | Belgium | parliament | 2019-05-26 | 11.95 | 18 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 1048 | 816 | 1586 | 993 |
BEL | Belgium | ep | 2019-05-26 | 12.05 | 3 | 21 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 1058 | 816 | 1586 | 993 |
BEL | Belgium | parliament | 1991-11-24 | 1.0 | 1 | 212 | FN | Front National | National Front | 9.655 | 64 | 418 | 191 | 457 | 171 |
BEL | Belgium | ep | 1994-06-12 | 2.95 | 1 | 25 | FN | Front National | National Front | 9.655 | 64 | 536 | 418 | 624 | 171 |
BEL | Belgium | parliament | 1995-05-21 | 2.28 | 2 | 150 | FN | Front National | National Front | 9.655 | 64 | 332 | 418 | 624 | 171 |
BEL | Belgium | parliament | 1999-06-13 | 1.45 | 1 | 150 | FN | Front National | National Front | 9.655 | 64 | 2 | 332 | 95 | 171 |
BEL | Belgium | ep | 1999-06-13 | 1.52 | 0 | 25 | FN | Front National | National Front | 9.655 | 64 | 624 | 332 | 95 | 171 |
BEL | Belgium | parliament | 2003-05-18 | 1.98 | 1 | 150 | FN | Front National | National Front | 9.655 | 64 | 143 | 2 | 193 | 171 |
BEL | Belgium | ep | 2004-06-13 | 2.79 | 0 | 24 | FN | Front National | National Front | 9.655 | 64 | 656 | 143 | 449 | 171 |
BEL | Belgium | parliament | 2007-06-10 | 2.0 | 1 | 150 | FN | Front National | National Front | 9.655 | 64 | 401 | 143 | 449 | 171 |
BEL | Belgium | ep | 2009-06-07 | 1.33 | 0 | 22 | FN | Front National | National Front | 9.655 | 64 | 638 | 401 | 80 | 171 |
HUN | Hungary | parliament | 1994-05-29 | 1.6 | 0 | 386 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 620 | 257 | 13 | 95 |
HUN | Hungary | parliament | 1998-05-24 | 5.5 | 14 | 386 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 671 | 620 | 488 | 95 |
HUN | Hungary | parliament | 2002-04-21 | 4.37 | 0 | 386 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 463 | 671 | 827 | 95 |
HUN | Hungary | ep | 2004-06-13 | 2.35 | 0 | 24 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 224 | 463 | 302 | 95 |
HUN | Hungary | parliament | 2006-04-09 | 2.2 | 0 | 386 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 194 | 463 | 188 | 95 |
ISR | Israel | parliament | 1999-05-17 | 3.0 | 3 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 718 | 717 | 1159 | 1357 |
ISR | Israel | parliament | 2003-01-28 | 5.53 | 7 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 719 | 718 | 1124 | 1357 |
ISR | Israel | parliament | 2006-03-28 | 7.1 | 9 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 720 | 719 | 1129 | 1357 |
ISR | Israel | parliament | 2009-02-10 | 3.3 | 4 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 721 | 720 | 1135 | 1357 |
ISR | Israel | parliament | 2021-03-23 | 5.12 | 6 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 1100 | 1090 | 1645 | 1357 |
ISR | Israel | parliament | 2022-11-01 | 10.84 | 14 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 1117 | 1100 | 1677 | 1357 |
ITA | Italy | ep | 1999-06-13 | 1.59 | 1 | 87 | MSFT | Fiamma Tricolore | Fiamma Tricolore | 9.5762 | 26 | 363 | 551 | 214 | 176 |
ITA | Italy | ep | 2004-06-12 | 0.73 | 1 | 78 | MSFT | Fiamma Tricolore | Fiamma Tricolore | 9.5762 | 26 | 329 | 498 | 256 | 176 |
ITA | Italy | parliament | 2008-04-13 | 2.46 | 0 | 630 | MSFT | Fiamma Tricolore | Fiamma Tricolore | 9.5762 | 26 | 111 | 107 | 117 | 176 |
CHE | Switzerland | parliament | 1967-10-29 | 0.6 | 1 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 373 | 108 | 513 | 628 |
CHE | Switzerland | parliament | 1971-10-31 | 3.2 | 4 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 176 | 373 | 777 | 628 |
CHE | Switzerland | parliament | 1975-10-26 | 2.5 | 2 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 371 | 176 | 79 | 628 |
CHE | Switzerland | parliament | 1979-10-21 | 1.32 | 2 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 435 | 371 | 20 | 628 |
CHE | Switzerland | parliament | 1983-10-23 | 2.9 | 4 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 631 | 435 | 723 | 628 |
CHE | Switzerland | parliament | 1987-10-18 | 2.5 | 3 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 358 | 631 | 129 | 628 |
CHE | Switzerland | parliament | 1991-10-20 | 3.4 | 5 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 521 | 358 | 426 | 628 |
CHE | Switzerland | parliament | 1995-10-22 | 3.1 | 3 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 105 | 521 | 773 | 628 |
CHE | Switzerland | parliament | 1999-10-24 | 1.8 | 1 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 427 | 105 | 38 | 628 |
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;