A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by rand() ,boat_lenght desc limit 12' at line 7

SELECT *,vs.lat,vs.lng FROM boats_bookings as bb inner join venue_sites as vs on vs.venue_site_id=bb.venue_site_id inner join venues as v on v.venue_id=bb.venue_id inner join zones as z on z.zone_id=bb.zone_id inner join boats as b on b.boat_id=bb.boat_id where 1 and bb.zone_id= order by rand() ,boat_lenght desc limit 12

Filename: modules/rentals/views/rental_detail.php

Line Number: 556