SELECT *
FROM taxonobservation
LEFT JOIN taxoninterpretation USING (taxonobservation_id)
LEFT JOIN plantconcept_ USING (plantconcept_id)
LEFT JOIN plantname USING (plantname_id)
; -- runtime: 15 s ("Time: 14639.599 ms") @starscream
