SELECT *
FROM "taxonObservation"
LEFT JOIN "taxonInterpretation" USING ("TAXONOBSERVATION_ID")
LEFT JOIN party USING ("PARTY_ID")
LEFT JOIN "plantConcept_" USING ("PLANTCONCEPT_ID")
; -- runtime: 10 s ("12372.322 ms") @starscream