SELECT *
FROM taxonobservation
LEFT JOIN taxoninterpretation USING (taxonobservation_id)
LEFT JOIN party               USING (party_id)
LEFT JOIN plantconcept_       USING (plantconcept_id)
LEFT JOIN plantname           USING (plantname_id)
; -- runtime: 25 s ("23094.379 ms") @starscream