SELECT *
FROM taxonobservation
LEFT JOIN taxoninterpretation USING (taxonobservation_id)
LEFT JOIN party collector ON collector.party_id = taxoninterpretation.collector_id
LEFT JOIN plantconcept_ USING (plantconcept_id)
;