no title...

no date...
no content...
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-04' ORDER BY r.date DESC LIMIT 1 - Array