view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUT | Austria | ep | 1995-01-01 | 8 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 13 | 66 | 294 | 973 | |
AUT | Austria | ep | 1995-01-01 | 6 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 13 | 66 | 294 | 1013 | |
AUT | Austria | ep | 1995-01-01 | 5 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 13 | 66 | 294 | 50 | |
AUT | Austria | ep | 1995-01-01 | 1 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 13 | 66 | 294 | 955 | |
AUT | Austria | ep | 1995-01-01 | 1 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 13 | 66 | 294 | 1429 | |
AUT | Austria | ep | 1996-10-13 | 29.65 | 7 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 22 | 162 | 323 | 1013 |
AUT | Austria | ep | 1996-10-13 | 27.53 | 6 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 22 | 162 | 323 | 50 |
AUT | Austria | ep | 1996-10-13 | 29.15 | 6 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 22 | 162 | 323 | 973 |
AUT | Austria | ep | 1996-10-13 | 4.26 | 1 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 22 | 162 | 323 | 955 |
AUT | Austria | ep | 1996-10-13 | 6.81 | 1 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 22 | 162 | 323 | 1429 |
AUT | Austria | ep | 1996-10-13 | 1.28 | 0 | 21 | N | Die Neutralen – Bürgerinitiative | Citizens' Initiative for the retention of neutrality | 59 | 22 | 162 | 323 | 1750 | |
AUT | Austria | ep | 1999-06-13 | 31.71 | 7 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 16 | 162 | 412 | 973 |
AUT | Austria | ep | 1999-06-13 | 30.67 | 7 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 16 | 162 | 412 | 1013 |
AUT | Austria | ep | 1999-06-13 | 23.4 | 5 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 16 | 162 | 412 | 50 |
AUT | Austria | ep | 1999-06-13 | 9.29 | 2 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 16 | 162 | 412 | 1429 |
AUT | Austria | ep | 1999-06-13 | 2.66 | 0 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 16 | 162 | 412 | 955 |
AUT | Austria | ep | 1999-06-13 | 1.54 | 0 | 21 | CSA | Christlich Soziale Allianz (Liste Karl Habsburg) | Christian Social Alliance (Karl Habsburg List) | 6.2 | 59 | 16 | 162 | 412 | 1752 |
AUT | Austria | ep | 2004-06-13 | 33.33 | 7 | 18 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 45 | 365 | 257 | 973 |
AUT | Austria | ep | 2004-06-13 | 32.7 | 6 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 45 | 365 | 257 | 1013 |
AUT | Austria | ep | 2004-06-13 | 13.98 | 2 | 18 | Martin | Liste Dr. Hans-Peter Martin | Hans-Peter Martin's List | 4.2 | 59 | 45 | 365 | 257 | 669 |
AUT | Austria | ep | 2004-06-13 | 12.89 | 2 | 18 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 45 | 365 | 257 | 1429 |
AUT | Austria | ep | 2004-06-13 | 6.31 | 1 | 18 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 45 | 365 | 257 | 50 |
AUT | Austria | ep | 2004-06-13 | 0.78 | 0 | 18 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 45 | 365 | 257 | 769 |
AUT | Austria | ep | 2009-06-07 | 30.0 | 6 | 17 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 232 | 607 | 268 | 1013 |
AUT | Austria | ep | 2009-06-07 | 23.7 | 4 | 17 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 232 | 607 | 268 | 973 |
AUT | Austria | ep | 2009-06-07 | 17.7 | 3 | 17 | Martin | Liste Dr. Hans-Peter Martin | Hans-Peter Martin's List | 4.2 | 59 | 232 | 607 | 268 | 669 |
AUT | Austria | ep | 2009-06-07 | 9.9 | 2 | 17 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 232 | 607 | 268 | 1429 |
AUT | Austria | ep | 2009-06-07 | 12.7 | 2 | 17 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 232 | 607 | 268 | 50 |
AUT | Austria | ep | 2009-06-07 | 4.6 | 0 | 17 | BZO | Bündnis Zukunft Österreich | Alliance for the Future of Austria | 8.83 | 59 | 232 | 607 | 268 | 1536 |
AUT | Austria | ep | 2014-05-25 | 26.98 | 5 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 818 | 802 | 1070 | 1013 |
AUT | Austria | ep | 2014-05-25 | 24.09 | 5 | 18 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 818 | 802 | 1070 | 973 |
AUT | Austria | ep | 2014-05-25 | 19.72 | 4 | 18 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 818 | 802 | 1070 | 50 |
AUT | Austria | ep | 2014-05-25 | 14.52 | 3 | 18 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 818 | 802 | 1070 | 1429 |
AUT | Austria | ep | 2014-05-25 | 8.14 | 1 | 18 | NEOS | NEOS – Das Neue Österreich | NEOS -- The New Austria | 6.0 | 59 | 818 | 802 | 1070 | 2255 |
AUT | Austria | ep | 2014-05-25 | 1.18 | 0 | 18 | REKOS | Die Reformkonservativen – REKOS | The Reform Conservatives | 7.4 | 59 | 818 | 802 | 1070 | 2339 |
AUT | Austria | ep | 2014-05-25 | 2.14 | 0 | 18 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 818 | 802 | 1070 | 769 |
AUT | Austria | ep | 2014-05-25 | 2.76 | 0 | 18 | EU-STOP | EU-Austritt, Direkte Demokratie, Neutralität | EU Withdrawal, Direct Democracy, Neutrality | 59 | 818 | 802 | 1070 | 2340 | |
AUT | Austria | ep | 2019-05-26 | 34.6 | 7 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1074 | 1019 | 1521 | 1013 |
AUT | Austria | ep | 2019-05-26 | 23.9 | 5 | 18 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 1074 | 1019 | 1521 | 973 |
AUT | Austria | ep | 2019-05-26 | 17.2 | 3 | 18 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 1074 | 1019 | 1521 | 50 |
AUT | Austria | ep | 2019-05-26 | 14.1 | 2 | 18 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 1074 | 1019 | 1521 | 1429 |
AUT | Austria | ep | 2019-05-26 | 8.4 | 1 | 18 | NEOS | NEOS – Das Neue Österreich | NEOS -- The New Austria | 6.0 | 59 | 1074 | 1019 | 1521 | 2255 |
AUT | Austria | ep | 2019-05-26 | 1.0 | 0 | 18 | PILZ | JETZT – Liste Pilz | JETZT -- Pilz List | 2.5 | 59 | 1074 | 1019 | 1521 | 2651 |
BEL | Belgium | ep | 1979-06-10 | 29.54 | 7 | 24 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 442 | 663 | 521 | 723 |
BEL | Belgium | ep | 1979-06-10 | 10.58 | 4 | 24 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 442 | 663 | 521 | 1378 |
BEL | Belgium | ep | 1979-06-10 | 12.84 | 3 | 24 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 442 | 663 | 521 | 1029 |
BEL | Belgium | ep | 1979-06-10 | 8.19 | 3 | 24 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 442 | 663 | 521 | 1192 |
BEL | Belgium | ep | 1979-06-10 | 7.62 | 2 | 24 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 442 | 663 | 521 | 969 |
BEL | Belgium | ep | 1979-06-10 | 6.85 | 2 | 24 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 442 | 663 | 521 | 454 |
BEL | Belgium | ep | 1979-06-10 | 9.41 | 2 | 24 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 442 | 663 | 521 | 1110 |
BEL | Belgium | ep | 1979-06-10 | 5.96 | 1 | 24 | VU | Volksunie | People's Union | 6.5321 | 64 | 442 | 663 | 521 | 290 |
BEL | Belgium | ep | 1979-06-10 | 1.98 | 0 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 442 | 663 | 521 | 161 |
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 | ep | 1979-06-10 | 2.68 | 0 | 24 | KPB-PCB | Kommunistische Partij – Parti Communiste | Communist Party | 1.4 | 64 | 442 | 663 | 521 | 708 |
BEL | Belgium | ep | 1984-06-17 | 13.32 | 5 | 24 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 10 | 501 | 724 | 1378 |
BEL | Belgium | ep | 1984-06-17 | 17.12 | 4 | 24 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 10 | 501 | 724 | 1029 |
BEL | Belgium | ep | 1984-06-17 | 19.8 | 4 | 24 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 10 | 501 | 724 | 723 |
BEL | Belgium | ep | 1984-06-17 | 9.45 | 3 | 24 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 10 | 501 | 724 | 454 |
BEL | Belgium | ep | 1984-06-17 | 8.64 | 2 | 24 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 10 | 501 | 724 | 1110 |
BEL | Belgium | ep | 1984-06-17 | 7.62 | 2 | 24 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 10 | 501 | 724 | 1192 |
BEL | Belgium | ep | 1984-06-17 | 8.47 | 2 | 24 | VU | Volksunie | People's Union | 6.5321 | 64 | 10 | 501 | 724 | 290 |
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 | ep | 1984-06-17 | 3.86 | 1 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 10 | 501 | 724 | 161 |
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 | ep | 1984-06-17 | 1.53 | 0 | 24 | KPB-PCB | Kommunistische Partij – Parti Communiste | Communist Party | 1.4 | 64 | 10 | 501 | 724 | 708 |
BEL | Belgium | ep | 1984-06-17 | 2.5 | 0 | 24 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 10 | 501 | 724 | 969 |
BEL | Belgium | ep | 1989-06-18 | 21.14 | 5 | 24 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 553 | 191 | 457 | 723 |
BEL | Belgium | ep | 1989-06-18 | 14.48 | 5 | 24 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 553 | 191 | 457 | 1378 |
BEL | Belgium | ep | 1989-06-18 | 12.43 | 3 | 24 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 553 | 191 | 457 | 1029 |
BEL | Belgium | ep | 1989-06-18 | 7.18 | 2 | 24 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 553 | 191 | 457 | 454 |
BEL | Belgium | ep | 1989-06-18 | 8.08 | 2 | 24 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 553 | 191 | 457 | 1192 |
BEL | Belgium | ep | 1989-06-18 | 6.29 | 2 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 553 | 191 | 457 | 161 |
BEL | Belgium | ep | 1989-06-18 | 10.6 | 2 | 24 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 553 | 191 | 457 | 1110 |
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 | ep | 1989-06-18 | 7.57 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 553 | 191 | 457 | 1594 |
BEL | Belgium | ep | 1989-06-18 | 5.39 | 1 | 24 | VU | Volksunie | People's Union | 6.5321 | 64 | 553 | 191 | 457 | 290 |
BEL | Belgium | ep | 1989-06-18 | 1.46 | 0 | 24 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 553 | 191 | 457 | 969 |
BEL | Belgium | ep | 1994-06-12 | 16.98 | 4 | 25 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 536 | 418 | 624 | 723 |
BEL | Belgium | ep | 1994-06-12 | 11.37 | 3 | 25 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 536 | 418 | 624 | 1110 |
BEL | Belgium | ep | 1994-06-12 | 10.92 | 3 | 25 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 536 | 418 | 624 | 1029 |
BEL | Belgium | ep | 1994-06-12 | 9.08 | 3 | 25 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 536 | 418 | 624 | 454 |
BEL | Belgium | ep | 1994-06-12 | 11.4 | 3 | 25 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 536 | 418 | 624 | 1378 |
BEL | Belgium | ep | 1994-06-12 | 7.04 | 2 | 25 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 536 | 418 | 624 | 1192 |
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 | ep | 1994-06-12 | 4.87 | 1 | 25 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 536 | 418 | 624 | 161 |
BEL | Belgium | ep | 1994-06-12 | 4.39 | 1 | 25 | VU | Volksunie | People's Union | 6.5321 | 64 | 536 | 418 | 624 | 290 |
BEL | Belgium | ep | 1994-06-12 | 0.2 | 1 | 25 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 536 | 418 | 624 | 119 |
BEL | Belgium | ep | 1994-06-12 | 2.95 | 1 | 25 | FN | Front National | National Front | 9.655 | 64 | 536 | 418 | 624 | 171 |
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 | ep | 1994-06-12 | 2.14 | 0 | 25 | WOW | Waardig Ouder Worden | Growing Old in Dignity | 8.8 | 64 | 536 | 418 | 624 | 470 |
BEL | Belgium | ep | 1999-06-13 | 13.49 | 3 | 25 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 624 | 332 | 95 | 723 |
BEL | Belgium | ep | 1999-06-13 | 10.03 | 3 | 25 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 624 | 332 | 95 | 454 |
BEL | Belgium | ep | 1999-06-13 | 8.44 | 3 | 25 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 624 | 332 | 95 | 161 |
BEL | Belgium | ep | 1999-06-13 | 9.59 | 3 | 25 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 624 | 332 | 95 | 1378 |
BEL | Belgium | ep | 1999-06-13 | 13.61 | 3 | 25 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 624 | 332 | 95 | 1110 |
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 | ep | 1999-06-13 | 7.46 | 2 | 25 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 624 | 332 | 95 | 1594 |
BEL | Belgium | ep | 1999-06-13 | 8.84 | 2 | 25 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 624 | 332 | 95 | 1029 |
BEL | Belgium | ep | 1999-06-13 | 7.57 | 2 | 25 | VU | Volksunie | People's Union | 6.5321 | 64 | 624 | 332 | 95 | 290 |
BEL | Belgium | ep | 1999-06-13 | 4.95 | 1 | 25 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 624 | 332 | 95 | 1192 |
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;