SELECT *
FROM observationcontributor
LEFT JOIN party USING (party_id)