/*[sqlquery[*/ SELECT DISTINCT parlamentarier.*, rat.parlament_id as council_fk, partei.abkuerzung as party_fk
FROM
"lobbywatch".."parlamentarier" AS parlamentarier
LEFT JOIN
"lobbywatch".."rat" AS rat
ON
parlamentarier.rat_id = rat_id
LEFT JOIN
"lobbywatch".."partei" AS partei
ON
partei.id = parlamentarier.partei_id
/*]sqlquery]*/