SELECT *  FROM INFO2024_multi_booking_hotels_MENORCA WHERE  live=1 AND  hotel_type in ('Rural Hotel' ) AND `hotel_city`  in (  )   AND hotel_category <> -1 ORDER BY hotel_city