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")

;