SELECT *
FROM projectcontributor
LEFT JOIN party USING (party_id)