error getting bookings hotels

SELECT hotel_id, name AS ad_title, latitude, longitude, ( 6371 * acos( cos( radians(53.29727000) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(-4.41844000) ) + sin( radians(53.29727000) ) * sin( radians( latitude ) ) ) ) AS distance FROM `booking_hotels` WHERE ( latitude BETWEEN 53.117405932901 AND 53.477134067099 ) AND ( longitude BETWEEN -4.7193854527063 AND -4.1174945472937 ) AND hoteltype_id IN(217,231,204,216,203,202,221,218,205,208,227,209,225,229,220,228,232,219,206,222,201,210,224,213,207,226,223) ORDER BY FIELD(hoteltype_id,217,231,204,216,203,202,221,218,205,208,227,209,225,229,220,228,232,219,206,222,201,210,224,213,207,226,223), distance ASC, CASE WHEN minrate <1 THEN 1 ELSE 0 END, gabino_date_update DESC, review_score DESC LIMIT 0,20