view_party (view)
Data source: ParlGov · About: simonw/parlgov-datasette
274 rows where family_name = "Liberal"
This data as json, CSV (advanced)
country_name_short | country_name | party_name_short | party_name_english | party_name | party_name_ascii | family_name_short | family_name | left_right | state_market | liberty_authority | eu_anti_pro | cmp | euprofiler | ees | castles_mair | huber_inglehart | ray | benoit_laver | chess | country_id | party_id | family_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FRA | France | d-center | other centre | divers centre | divers centre | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 43 | 2858 | 6 | ||||||||
GBR | United Kingdom | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2731 | 6 | ||||||||
GBR | United Kingdom | CoLib | Coalition Liberal | Coalition Liberal | Coalition Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2501 | 6 | ||||||||
GBR | United Kingdom | IL | Independent Liberal | Independent Liberal | Independent Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 2517 | 6 | ||||||||
GBR | United Kingdom | Lib | Liberals | Liberals | Liberals | lib | Liberal | 4.2875 | 4.1064 | 2.6109 | 9.2231 | 51420 | 1605 | 1104 | 1104 | 44 | 659 | 6 | ||||
GBR | United Kingdom | NLP | National Liberal Party | National Liberal Party | National Liberal Party | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 44 | 1017 | 6 | ||||||||
GRC | Greece | D-FS | Action -- Liberal Alliance | Drasi – Fileleytheri Symmachia | Drasi -- Fileleytheri Symmachia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2096 | 6 | ||||||||
GRC | Greece | DISY | Democratic Alliance | Dimokratiki Symmachia | Dimokratiki Symmachia | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2094 | 6 | ||||||||
GRC | Greece | EDIK | Union of the Democratic Centre | Enosi Dimokratikou Kentrou | Enosi Dimokratikou Kentrou | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 34510 | 41 | 489 | 6 | |||||||
GRC | Greece | EEP | Greek European Citizens | Ellines Eyropaioi Polites | Ellines Eyropaioi Polites | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2347 | 6 | ||||||||
GRC | Greece | KF | Liberal Party | Komma ton Fileleftheron | Komma ton Fileleftheron | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2125 | 6 | ||||||||
GRC | Greece | KN | Party of New Liberals | Komma Neofileleftheron | Komma Neofileleftheron | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 463 | 6 | ||||||||
GRC | Greece | OF | The Liberals | Oi Fileleftheroi | Oi Fileleftheroi | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 41 | 2166 | 6 | ||||||||
HRV | Croatia | DC | Democratic Centre | Demokratski centar | Demokratski centar | lib | Liberal | 5.9649 | 4.8421 | 6.4912 | 7.3684 | 1042 | 62 | 1081 | 6 | |||||||
HRV | Croatia | HNS-LD | Croatian People's Party -- Liberal Democrats | Hrvatska narodna stranka – Liberalni demokrati | Hrvatska narodna stranka -- Liberalni demokrati | lib | Liberal | 1.8421 | 6.5789 | 1.7544 | 8.9474 | 81712 | 1120 | 3105 | 62 | 1384 | 6 | |||||
HRV | Croatia | HSLS | Croatian Social Liberal Party | Hrvatska socijalno liberalna stranka | Hrvatska socijalno liberalna stranka | lib | Liberal | 7.193 | 4.6491 | 5.5263 | 5.0877 | 81410 | 1146 | 3104 | 62 | 1102 | 6 | |||||
HRV | Croatia | IDS | Istrian Democratic Assembly | Istarski demokratski sabor | Istarski demokratski sabor | lib | Liberal | 3.4211 | 6.2281 | 2.5439 | 9.2105 | 81953 | 1224 | 62 | 1627 | 6 | ||||||
HRV | Croatia | LIBRA | Party of Liberal Democrats | LIBRA – Stranka liberalnih demokrata | LIBRA -- Stranka liberalnih demokrata | lib | Liberal | 3.7719 | 6.7544 | 3.2456 | 8.6842 | 1250 | 62 | 90 | 6 | |||||||
HRV | Croatia | LS | Liberal Party | Liberalna stranka | Liberalna stranka | lib | Liberal | 2.807 | 6.5789 | 1.4035 | 8.5965 | 1276 | 62 | 1457 | 6 | |||||||
HRV | Croatia | NS | People's Party -- Reformists | Narodna stranka – Reformisti | Narodna stranka -- Reformisti | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 62 | 2614 | 6 | ||||||||
HRV | Croatia | P | Intelligently | Pametno | Pametno | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 62 | 2772 | 6 | ||||||||
HUN | Hungary | MEMO | Solution Movement | Megoldás Mozgalom | Megoldas Mozgalom | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 39 | 2855 | 6 | ||||||||
HUN | Hungary | SzDSz | Alliance of Free Democrats | Szabad Demokraták Szövetsége | Szabad Demokratak Szovetsege | lib | Liberal | 3.9659 | 7.7361 | 1.4381 | 9.7873 | 86422 | 163 | 1348422 | 1602 | 2028 | 2304 | 39 | 1426 | 6 | ||
HUN | Hungary | VP | Entrepreneurs' Party | Vállalkozók Pártja Egyesület | Vallalkozok Partja Egyesulet | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 39 | 1203 | 6 | ||||||||
IRL | Ireland | BP | Business and Professional Group | Business and Professional Group | Business and Professional Group | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 37 | 2523 | 6 | ||||||||
IRL | Ireland | I-PC | Independent -- Pat Cox | Independent – Pat Cox | Independent -- Pat Cox | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 37 | 2328 | 6 | ||||||||
IRL | Ireland | PD | Progressive Democrats | Progressive Democrats | Progressive Democrats | lib | Liberal | 8.0109 | 8.3901 | 3.7011 | 8.4528 | 53420 | 1905 | 706 | 6367 | 706 | 37 | 651 | 6 | |||
ISL | Iceland | B-H | Civic Movement -- The Movement | Borgarahreyfingin – Hreyfingin | Borgarahreyfingin -- Hreyfingin | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 587 | 6 | |||||||||
ISL | Iceland | BF | Bright Future | Björt framtíð | Bjort framtid | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2204 | 6 | |||||||||
ISL | Iceland | FF | Liberal Party | Frjálslyndi flokkurinn | Frjlslyndi flokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2441 | 6 | |||||||||
ISL | Iceland | Ff | Liberal Party | Frjálslyndi flokkurinn | Frjalslyndi flokkurinn | lib | Liberal | 6.2201 | 5.5981 | 3.0 | 15420 | 6231 | 56 | 506 | 6 | |||||||
ISL | Iceland | Fr | Liberals | Frjálslyndir | Frjalslyndir | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2114 | 6 | |||||||||
ISL | Iceland | HG | RIght-Green People's Party | Hægri Grænir flokkur fólksins | Haegri Graenir flokkur folksins | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2209 | 6 | |||||||||
ISL | Iceland | He | Home Rule Party | Heimastjórnarflokkurinn | Heimastjrnarflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2440 | 6 | |||||||||
ISL | Iceland | M | Centre Party | Miðflokkurinn | Midflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 56 | 2655 | 6 | |||||||||
ISL | Iceland | Thva | National Preservation Party | Þjóðvarnarflokkurinn | Thjodvarnarflokkurinn | lib | Liberal | 6.0 | 6.7 | 3.6 | 15710 | 56 | 1172 | 6 | ||||||||
ISR | Israel | DS | The Third Way | HaDerekh HaShlishit | HaDerekh HaShlishit | lib | Liberal | 6.0 | 6.7 | 3.6 | 72427 | 34 | 279 | 6 | ||||||||
ISR | Israel | G | Bridge | Gesher | Gesher | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2787 | 6 | |||||||||
ISR | Israel | HLY | Israel Resilience Party | Hosen L'Yisrael | Hosen L'Yisrael | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2799 | 6 | |||||||||
ISR | Israel | Hat | The Movement | Hatnuah | Hatnuah | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2320 | 6 | |||||||||
ISR | Israel | KL | Blue and White | Kahol Lavan | Kahol Lavan | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2725 | 6 | |||||||||
ISR | Israel | Kadima | Forward | Kadima | Kadima | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1870 | 6 | |||||||||
ISR | Israel | Kulanu | All of Us | Kulanu | Kulanu | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2410 | 6 | |||||||||
ISR | Israel | LA | Independent Liberals | Libralim Atzma'im | Libralim Atzma'im | lib | Liberal | 6.0 | 6.7 | 3.6 | 72410 | 34 | 188 | 6 | ||||||||
ISR | Israel | MP | Progressive Party | Miflaga Progresivit | Miflaga Progresivit | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1822 | 6 | |||||||||
ISR | Israel | MeHo | Free Centre | HaMerkaz HaHofshi | HaMerkaz HaHofshi | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1889 | 6 | |||||||||
ISR | Israel | MiHa | Centre Party | Mifleget Hamerkaz | Mifleget Hamerkaz | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 1863 | 6 | |||||||||
ISR | Israel | MiHal | Liberal Party | Miflaga Haliberalit | Miflaga Haliberalit | lib | Liberal | 6.0 | 6.7 | 3.6 | 72411 | 34 | 765 | 6 | ||||||||
ISR | Israel | O | Courage | Ometz | Ometz | lib | Liberal | 6.0 | 6.7 | 3.6 | 72425 | 34 | 61 | 6 | ||||||||
ISR | Israel | Shinui | Change | Shinui | Shinui | lib | Liberal | 5.4776 | 8.6207 | 1.7423 | 72413 | 6572 | 34 | 1850 | 6 | |||||||
ISR | Israel | TDL | Democratic Movement for Change | Tnu'a Demokratit LeShinu | Tnu'a Demokratit LeShinu | lib | Liberal | 5.4776 | 8.6207 | 1.7423 | 72412 | 6572 | 34 | 1471 | 6 | |||||||
ISR | Israel | Telem | Telem | Telem | Telem | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2800 | 6 | |||||||||
ISR | Israel | YA | There is a Future | Yesh Atid | Yesh Atid | lib | Liberal | 6.0 | 6.7 | 3.6 | 34 | 2321 | 6 | |||||||||
ISR | Israel | YBA | Israel for Immigration | Yisrael Ba-Aliya | Yisrael Ba-Aliya | lib | Liberal | 6.0 | 6.7 | 3.6 | 72428 | 34 | 277 | 6 | ||||||||
ISR | Israel | Ya-84 | Together | Yahad | Yahad | lib | Liberal | 6.0 | 6.7 | 3.6 | 72414 | 34 | 1269 | 6 | ||||||||
ISR | Israel | ZK | General Zionists | Zionim Klalim | Zionim Klalim | lib | Liberal | 6.0 | 6.7 | 3.6 | 72420 | 34 | 1472 | 6 | ||||||||
ITA | Italy | +EU | More Europe | +Europa | +Europa | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2737 | 6 | ||||||||
ITA | Italy | ALD | Autonomy Liberty Democracy | Autonomie Liberté Démocratie | Autonomie Liberte Democratie | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 1063 | 6 | ||||||||
ITA | Italy | CD | Democratic Centre | Centro Democratico | Centro Democratico | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2153 | 6 | ||||||||
ITA | Italy | CDR | Republican Democratic Concentration | Concentrazione Democratica Repubblicana | Concentrazione Democratica Repubblicana | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2044 | 6 | ||||||||
ITA | Italy | DL-M | Democracy is Freedom -- The Daisy | Democrazia è Libertà – La Margherita | Democrazia e Liberta -- La Margherita | lib | Liberal | 3.9893 | 4.2347 | 4.7353 | 9.2935 | 32421 | 6746 | 819 | 26 | 1005 | 6 | |||||
ITA | Italy | FiD | Stop the Decline | Fermare il Declino | Fermare il Declino | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2158 | 6 | ||||||||
ITA | Italy | IV | Italy Alive | Italia Viva | Italia Viva | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2794 | 6 | ||||||||
ITA | Italy | IdV | Italy of Values | Italia dei Valori | Italia dei Valori | lib | Liberal | 4.8712 | 4.5664 | 5.5255 | 7.1295 | 32902 | 176 | 1380902 | 6686 | 828 | 26 | 693 | 6 | |||
ITA | Italy | LD | Liberal Democrats | Liberal Democratici | Liberal Democratici | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 906 | 6 | ||||||||
ITA | Italy | MRE | European Republicans Movement | Movimento Repubblicani Europei | Movimento Repubblicani Europei | lib | Liberal | 4.33 | 4.75 | 3.83 | 10.0 | 832 | 26 | 760 | 6 | |||||||
ITA | Italy | PLD | Liberal Democratic Pole | Polo Liberal-Democratico | Polo Liberal-Democratico | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 671 | 6 | ||||||||
ITA | Italy | PLI | Italian Liberal Party | Partito Liberale Italiano | Partito Liberale Italiano | lib | Liberal | 6.45 | 6.7 | 3.6 | 7.5 | 32420 | 1009 | 2108 | 810 | 26 | 487 | 6 | ||||
ITA | Italy | PRI | Republican Party | Partito Repubblicano Italiano | Partito Repubblicano Italiano | lib | Liberal | 4.9704 | 5.8 | 5.1667 | 9.0278 | 32410 | 1006 | 2106 | 806 | 806 | 26 | 93 | 6 | |||
ITA | Italy | SC | Civic Choice | Scelta Civica | Scelta Civica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 2156 | 6 | ||||||||
ITA | Italy | UD | Democratic Union | Unione Democratica | Unione Democratica | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 475 | 6 | ||||||||
ITA | Italy | UdCe | Democratic Union of the Centre | Unione Democratica di Centro | Unione Democratica di Centro | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 26 | 397 | 6 | ||||||||
JPN | Japan | JNP | Japan New Party | Nihon Shintō | Nihon Shin-to | lib | Liberal | 8.2556 | 6.7 | 3.6 | 71952 | 2205 | 5 | 1327 | 6 | |||||||
JPN | Japan | LL | Liberal League | Jiyu Rengo | Jiyu Rengo | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1165 | 6 | |||||||||
JPN | Japan | NCoP | National Cooperative Party | Kokumin Kyôdô Tô | Kokumin Kyodo To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1733 | 6 | |||||||||
JPN | Japan | NPD | New Party Daichi | Shintō Daichi | Shinto Daichi | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 247 | 6 | |||||||||
JPN | Japan | NPN | New Party Nippon | Shintō Nippon | Shinto Nippon | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1175 | 6 | |||||||||
JPN | Japan | YP | Your Party | Minna no Tō | Minna no To | lib | Liberal | 6.0 | 6.7 | 3.6 | 5 | 1124 | 6 | |||||||||
LTU | Lithuania | DP | Labour Party | Darbo partija | Darbo partija | lib | Liberal | 3.86 | 4.29 | 5.8 | 8.5667 | 199 | 1440322 | 2516 | 15 | 581 | 6 | |||||
LTU | Lithuania | LCS | Centre Union of Lithuania | Lietuvos centro sąjunga | Lietuvos centro sajunga | lib | Liberal | 4.8833 | 6.25 | 4.2 | 9.0 | 88420 | 2403 | 2509 | 15 | 887 | 6 | |||||
LTU | Lithuania | LDP | Lithuanian Democratic Party | Lietuvos demokratų partija | Lietuvos demokratu partija | lib | Liberal | 5.8333 | 6.7 | 3.6 | 8.7 | 88522 | 2407 | 15 | 1144 | 6 | ||||||
LTU | Lithuania | LLS | Lithuanian Freedom Union (Liberals) | Lietuvos laisvės sąjunga (liberalai) | Lietuvos laisves sajunga (liberalai) | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2634 | 6 | ||||||||
LTU | Lithuania | LP | Freedom Party | Laisvės partija | Laisves partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2805 | 6 | ||||||||
LTU | Lithuania | LRLS | Liberals Movement of the Republic of Lithuania | Lietuvos Respublikos liberalų sąjūdis | Lietuvos Respublikos liberaly sajudis | lib | Liberal | 7.7562 | 8.2271 | 2.8532 | 9.2244 | 202 | 1440421 | 2348 | 2518 | 15 | 482 | 6 | ||||
LTU | Lithuania | LiCS | Liberal and Centre Union | Liberalų ir centro sąjunga | Liberalc ir centro sajunga | lib | Liberal | 7.7562 | 8.2271 | 2.8532 | 9.2244 | 200 | 1440420 | 2348 | 15 | 983 | 6 | |||||
LTU | Lithuania | NS-SL | New Union (Social Liberals) | Naujoji sąjunga (socialliberalai) | Naujoji sajunga (socialliberalai) | lib | Liberal | 4.2686 | 4.1125 | 4.9071 | 8.6647 | 88410 | 1440410 | 2376 | 2504 | 15 | 856 | 6 | ||||
LTU | Lithuania | PDP | Civic Democratic Party | Pilietinės demokratijos partija | Pilietines demokratijos partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 676 | 6 | ||||||||
LTU | Lithuania | TAIP | YES -- Homeland Revival and Perspective | Tėvynės atgimimas ir perspektyva | Tevynes atgimimas ir perspektyva | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 15 | 2122 | 6 | ||||||||
LTU | Lithuania | TPP | National Resurrection Party | Tautos prisikėlimo partija | Tautos prisikelimo partija | lib | Liberal | 6.0 | 6.7 | 3.6 | 8.7 | 208 | 1440001 | 2517 | 15 | 1502 | 6 | |||||
LUX | Luxembourg | DP | Democratic Party | Demokratesch Partei | Demokratesch Partei | lib | Liberal | 6.5789 | 7.3684 | 2.7632 | 23420 | 212 | 1442420 | 903 | 6926 | 7 | 967 | 6 | ||||
LUX | Luxembourg | DeLe | Democratic List | Demokratesch Lëscht | Demokratesch Lescht | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2448 | 6 | |||||||||
LUX | Luxembourg | LL | Liberal League | Liberal Liga | Liberal Liga | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2453 | 6 | |||||||||
LUX | Luxembourg | LiLe | Left Liberals | Liberal Lénk | Left Liberals | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2531 | 6 | |||||||||
LUX | Luxembourg | PDPN | Progressive Democratic Party of the North | Fortschrëttlech-demokratesch Partei | Fortschrettlech-demokratesch Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2538 | 6 | |||||||||
LUX | Luxembourg | PICM | Independent Party of the Middle Class | Parti Indépendant des Classes Moyennes | Parti Independant des Classes Moyennes | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2139 | 6 | |||||||||
LUX | Luxembourg | PL | Liberal Party | Parti Libéral | Parti Liberal | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2140 | 6 | |||||||||
LUX | Luxembourg | PRL | Radical Liberal Party | Radikal-Liberal Partei | Radikal-Liberal Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2455 | 6 | |||||||||
LUX | Luxembourg | RP | Radical Left / Radical Party | Gauche radicale / Parti radical | Gauche radicale / Parti radical | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2533 | 6 | |||||||||
LUX | Luxembourg | RPMC | Radical Party (Marcel Cahen) | Radikal Partei (Marcel Cahen) | Radikal Partei (Marcel Cahen) | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2535 | 6 | |||||||||
LUX | Luxembourg | RSP | Radical Socialist Party | Radikal-Sozialistesch Partei | Radikal-Sozialistesch Partei | lib | Liberal | 6.0 | 6.7 | 3.6 | 7 | 2456 | 6 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_party AS SELECT c.name_short AS country_name_short, c.name AS country_name, p.name_short AS party_name_short, p.name_english AS party_name_english, p.name AS party_name, p.name_ascii AS party_name_ascii, ii.short AS family_name_short, ii.name AS family_name, left_right, state_market, liberty_authority, eu_anti_pro, cmp, euprofiler, ees, castles_mair, huber_inglehart, ray, benoit_laver, chess, country_id, p.id AS party_id, family_id FROM party p LEFT OUTER JOIN info_id ii ON p.family_id = ii.id LEFT OUTER JOIN viewcalc_party_position vpp ON p.id = vpp.party_id LEFT OUTER JOIN (SELECT id, name, name_short FROM country) c -- avoid name conflict with party table ON p.country_id = c.id ORDER BY c.name_short, p.name_short;