Error: SELECT mv.property_id, mv.name, mv.description, mv.area_description, mv.short_description, mv.owners_url, mv.address, mv.town, mv.region, mv.postcode, mv.country, mv.checkin, mv.checkout, mv.pricetype, mv.nearest_airport, mv.nearest_airport_2, mv.nearest_airport_other, mv.nobedrooms, mv.nobathrooms, mv.nooccupants, mv.distancebeach, mv.distanceairport, mv.distanceairport_2, mv.breakages, mv.bookingdeposit, mv.main_currency_id, mv.seo_url, mv.hidden, mv.lowseason, c.symbol, c.currency FROM module_villas AS mv INNER JOIN module_villas_users_link AS vl ON vl.property_id = mv.property_id INNER JOIN villas_user_details AS u ON u.user_id = vl.user_id INNER JOIN villas_currencies c ON mv.main_currency_id = c.currency_id WHERE u.credits > 0 AND mv.town = '1553' ORDER BY () LIMIT 0, 5

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0, 5' at line 12