MySQL returned error

Error Description :

Error No : 1064
Description : 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 'AND room_type.status='Active' AND (room_type.hotel_ids='all' OR FIND_IN_SET(,...' at line 1

SQL Query
SELECT hotel_room_type_relation.*, room_type.id AS room_type_id, room_type.name AS room_type_name, room_type.hotel_ids AS room_type_hotel_ids, room_type.status AS room_type_status, room_type.created AS room_type_created FROM hotel_room_type_relation LEFT JOIN room_type AS room_type ON(room_type.id=hotel_room_type_relation.room_type_id) WHERE hotel_room_type_relation.id!=0 AND (hotel_room_type_relation.status='Active' AND hotel_room_type_relation.hotel_id= AND room_type.status='Active' AND (room_type.hotel_ids='all' OR FIND_IN_SET(, room_type.hotel_ids)))