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