SELECT r.report_id, r.date, r.subject, r.description,
a.author, r.image, a.url, r.audio_report, b.boat_name, ba.boat_name AS author_boat_name,
COALESCE(b.small_image, ba.small_image) AS small_image
FROM reports r
LEFT JOIN author a ON (r.author = a.author_id)
LEFT JOIN boats b ON (r.boat_id = b.boat_id)
LEFT JOIN boats ba ON (a.boat_id = ba.boat_id)
WHERE (b.boat_id = 92 OR ba.boat_id = 92) AND r.date <= '2018-08-09'
ORDER BY r.date DESC LIMIT 1 - Array