select `hotel_facility_types`.`id`, `hotel_facility_types`.`title`, `hotel_facility_types`.`title_en`, `hotel_facility_types`.`icon`, `hotel_facility_types`.`notes`, `hotel_facility_relation`.`hotel_id` as `pivot_hotel_id`, `hotel_facility_relation`.`facility_id` as `pivot_facility_id` from `hotel_facility_types` innerjoin `hotel_facility_relation` on `hotel_facility_types`.`id` = `hotel_facility_relation`.`facility_id` where `hotel_facility_relation`.`hotel_id` in (128, 130, 132, 134)
select `hotel_policies`.`id`, `hotel_policies`.`title`, `hotel_policies`.`title_en`, `hotel_policies`.`notes`, `hotel_policies_relation`.`hotel_id` as `pivot_hotel_id`, `hotel_policies_relation`.`policy_id` as `pivot_policy_id` from `hotel_policies` innerjoin `hotel_policies_relation` on `hotel_policies`.`id` = `hotel_policies_relation`.`policy_id` where `hotel_policies_relation`.`hotel_id` in (128, 130, 132, 134)
select `promotions`.*, `hotel_promotion_relation`.`room_id` as `pivot_room_id`, `hotel_promotion_relation`.`promotion_id` as `pivot_promotion_id`, `hotel_promotion_relation`.`description` as `pivot_description`, `hotel_promotion_relation`.`discount` as `pivot_discount`, `hotel_promotion_relation`.`from_date` as `pivot_from_date`, `hotel_promotion_relation`.`to_date` as `pivot_to_date` from `promotions` innerjoin `hotel_promotion_relation` on `promotions`.`id` = `hotel_promotion_relation`.`promotion_id` where `hotel_promotion_relation`.`room_id` in (1799, 1800, 1801, 1867, 1868, 1869, 1870, 1871, 1872, 1873) and `from_date` <='2025-07-22'and `to_date` >='2025-07-23'
select `room_id` from `hotel_promotion_relation` where `hotel_id` =128and `room_id` in (467, 468, 469) and ((`from_date` <='2025-07-22'and `to_date` >='2025-07-23'))
select `simple_hotel_rates`.*, `books`.`hotel_id` as `laravel_through_key` from `simple_hotel_rates` innerjoin `books` on `books`.`id` = `simple_hotel_rates`.`book_id` where `books`.`hotel_id` =128orderby `id` desc
select `room_id` from `hotel_promotion_relation` where `hotel_id` =130and `room_id` in (470, 1535) and ((`from_date` <='2025-07-22'and `to_date` >='2025-07-23'))
select `simple_hotel_rates`.*, `books`.`hotel_id` as `laravel_through_key` from `simple_hotel_rates` innerjoin `books` on `books`.`id` = `simple_hotel_rates`.`book_id` where `books`.`hotel_id` =130orderby `id` desc
select `room_id` from `hotel_promotion_relation` where `hotel_id` =132and `room_id` in (471, 472, 473) and ((`from_date` <='2025-07-22'and `to_date` >='2025-07-23'))
select `simple_hotel_rates`.*, `books`.`hotel_id` as `laravel_through_key` from `simple_hotel_rates` innerjoin `books` on `books`.`id` = `simple_hotel_rates`.`book_id` where `books`.`hotel_id` =132orderby `id` desc
select `room_id` from `hotel_promotion_relation` where `hotel_id` =134and `room_id` in (474, 475, 476, 477) and ((`from_date` <='2025-07-22'and `to_date` >='2025-07-23'))
select `simple_hotel_rates`.*, `books`.`hotel_id` as `laravel_through_key` from `simple_hotel_rates` innerjoin `books` on `books`.`id` = `simple_hotel_rates`.`book_id` where `books`.`hotel_id` =134orderby `id` desc