Notice (8): Undefined index: HTTP_REFERER [APP/Controller/BookingController.php, line 116]
Monsoon: Travel Offbeat Destinations for Monsoon | TripOffBeat

Monsoon Magic

Filter My View

Monsoon Magic

Revel in the monsoon and add an element of romance in your life. When the grueling summer becomes a thing of the past. The sizzling sun gives way to a cloudy sky and falling raindrops in a rhythm. It's time to enjoy the rains and bring in a sense of romance and wellness too and that can be done you move out of your home and go explore the places which are breathtakingly beautiful and inviting every nature lover to praise it and soak in its beauty. Check out the best places here which you can go explore this monsoon.

(default) 787 queries took 297 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 33110
2SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (79)880
3SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
4SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
5SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
6SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
7SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
8SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 48110
9SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
10SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
11SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (79)330
12SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (79)220
13SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 193 AND `RoomPrice`.`resort_id` = 79 LIMIT 1110
14SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 193 AND `Price`.`resort_id` = 79 AND `available_date` = '2017-11-20' LIMIT 1004
15SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 81 AND `ResortRoom`.`room_id` >= 196 AND `ResortRoom`.`status` = 1 LIMIT 1110
16SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48318110
17SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 33110
18SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (81)660
19SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
20SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
21SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
22SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
23SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 48110
24SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
25SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (81)330
26SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (81)110
27SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 196 AND `RoomPrice`.`resort_id` = 81 LIMIT 1110
28SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 196 AND `Price`.`resort_id` = 81 AND `available_date` = '2017-11-20' LIMIT 1004
29SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 88 AND `ResortRoom`.`room_id` >= 210 AND `ResortRoom`.`status` = 1 LIMIT 1111
30SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 2431110
31SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 33110
32SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (88)880
33SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
34SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
35SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
36SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
37SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
38SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 48110
39SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
40SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
41SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (88)330
42SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (88)110
43SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 210 AND `RoomPrice`.`resort_id` = 88 LIMIT 1110
44SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 210 AND `Price`.`resort_id` = 88 AND `available_date` = '2017-11-20' LIMIT 1004
45SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 90 AND `ResortRoom`.`room_id` >= 213 AND `ResortRoom`.`status` = 1 LIMIT 1111
46SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 3414110
47SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 33110
48SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (90)660
49SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
50SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
51SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 44110
52SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
53SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
54SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
55SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (90)330
56SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (90)110
57SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 213 AND `RoomPrice`.`resort_id` = 90 LIMIT 1110
58SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 213 AND `Price`.`resort_id` = 90 AND `available_date` = '2017-11-20' LIMIT 1004
59SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 91 AND `ResortRoom`.`room_id` >= 214 AND `ResortRoom`.`status` = 1 LIMIT 1111
60SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 3796110
61SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 35110
62SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (91)880
63SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
64SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
65SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
66SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 44110
67SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
68SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
69SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 48110
70SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
71SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (91)550
72SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (91)330
73SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 214 AND `RoomPrice`.`resort_id` = 91 LIMIT 1110
74SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 214 AND `Price`.`resort_id` = 91 AND `available_date` = '2017-11-20' LIMIT 1004
75SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 93 AND `ResortRoom`.`room_id` >= 349 AND `ResortRoom`.`status` = 1 LIMIT 1111
76SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 4639110
77SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 38110
78SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (93)000
79SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (93)220
80SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (93)220
81SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 349 AND `RoomPrice`.`resort_id` = 93 LIMIT 1110
82SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 349 AND `Price`.`resort_id` = 93 AND `available_date` = '2017-11-20' LIMIT 1004
83SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 117 AND `ResortRoom`.`room_id` >= 279 AND `ResortRoom`.`status` = 1 LIMIT 1110
84SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48324110
85SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 39110
86SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (117)660
87SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
88SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
89SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
90SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 44110
91SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
92SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
93SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (117)220
94SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (117)110
95SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 279 AND `RoomPrice`.`resort_id` = 117 LIMIT 1110
96SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 279 AND `Price`.`resort_id` = 117 AND `available_date` = '2017-11-20' LIMIT 1004
97SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 120 AND `ResortRoom`.`room_id` >= 290 AND `ResortRoom`.`status` = 1 LIMIT 1111
98SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48375110
99SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 39110
100SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (120)660
101SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
102SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
103SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
104SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
105SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 48110
106SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
107SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (120)330
108SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (120)220
109SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 290 AND `RoomPrice`.`resort_id` = 120 LIMIT 1110
110SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 290 AND `Price`.`resort_id` = 120 AND `available_date` = '2017-11-20' LIMIT 1004
111SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 122 AND `ResortRoom`.`room_id` >= 294 AND `ResortRoom`.`status` = 1 LIMIT 1111
112SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48368110
113SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 39110
114SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (122)770
115SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
116SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
117SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
118SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
119SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
120SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 48110
121SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
122SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (122)330
123SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (122)110
124SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 294 AND `RoomPrice`.`resort_id` = 122 LIMIT 1110
125SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 294 AND `Price`.`resort_id` = 122 AND `available_date` = '2017-11-20' LIMIT 1004
126SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 124 AND `ResortRoom`.`room_id` >= 303 AND `ResortRoom`.`status` = 1 LIMIT 1111
127SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48324110
128SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 39110
129SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (124)660
130SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
131SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
132SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
133SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 44110
134SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
135SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
136SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (124)220
137SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (124)110
138SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 303 AND `RoomPrice`.`resort_id` = 124 LIMIT 1110
139SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 303 AND `Price`.`resort_id` = 124 AND `available_date` = '2017-11-20' LIMIT 1004
140SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 130 AND `ResortRoom`.`room_id` >= 325 AND `ResortRoom`.`status` = 1 LIMIT 1111
141SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48320110
142SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 39110
143SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (130)770
144SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
145SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
146SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 44110
147SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
148SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
149SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
150SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 51110
151SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (130)330
152SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (130)110
153SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 325 AND `RoomPrice`.`resort_id` = 130 LIMIT 1110
154SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 325 AND `Price`.`resort_id` = 130 AND `available_date` = '2017-11-20' LIMIT 1005
155SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 132 AND `ResortRoom`.`room_id` >= 332 AND `ResortRoom`.`status` = 1 LIMIT 1111
156SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 48320110
157SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 39110
158SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (132)770
159SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
160SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 41110
161SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 42110
162SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 44110
163SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 45110
164SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 46110
165SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 43110
166SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (132)330
167SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (132)220
168SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 332 AND `RoomPrice`.`resort_id` = 132 LIMIT 1110
169SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 332 AND `Price`.`resort_id` = 132 AND `available_date` = '2017-11-20' LIMIT 1005
170SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status`, `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`status`, `Resort`.`is_delete` FROM `hotel_booking_v3`.`resort_rooms` AS `ResortRoom` LEFT JOIN `hotel_booking_v3`.`resorts` AS `Resort` ON (`ResortRoom`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) WHERE `ResortRoom`.`resort_id` = 144 AND `ResortRoom`.`room_id` >= 360 AND `ResortRoom`.`status` = 1 LIMIT 1111
171SELECT `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`id` = 1965110
172SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` = 19110
173SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `hotel_booking_v3`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (144)550
174SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 2110
175SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 5110
176SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 20110
177SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 23110
178SELECT `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`id` = 40110
179SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `hotel_booking_v3`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (144)330
180SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `hotel_booking_v3`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (144)330
181SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete` FROM `hotel_booking_v3`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 360 AND `RoomPrice`.`resort_id` = 144 LIMIT 1110
182SELECT `Price`.`id`, `Price`.`resort_id`, `Price`.`room_id`, `Price`.`1A`, `Price`.`2A`, `Price`.`eab`, `Price`.`ecb`, `Price`.`ecnb`, `Price`.`bf`, `Price`.`lunch`, `Price`.`dinner`, `Price`.`full_board`, `Price`.`c_bf`, `Price`.`c_lunch`, `Price`.`c_dinner`, `Price`.`c_fb`, `Price`.`available_date`, `Price`.`created_on`, `Price`.`updated_on`, `Price`.`is_delete` FROM `hotel_booking_v3`.`prices` AS `Price` WHERE `Price`.`room_id` = 360 AND `Price`.`resort_id` = 144 AND `available_date` = '2017-11-20' LIMIT 1005
183SELECT `ListingBanner`.`id`, `ListingBanner`.`slug`, `ListingBanner`.`title`, `ListingBanner`.`meta_title`, `ListingBanner`.`meta_keywords`, `ListingBanner`.`meta_desc`, `ListingBanner`.`description`, `ListingBanner`.`banner`, `ListingBanner`.`update_on`, `ListingBanner`.`create_on`, `ListingBanner`.`is_delete` FROM `hotel_booking_v3`.`listing_banners` AS `ListingBanner` WHERE `ListingBanner`.`slug` = 'monsoon-magic' LIMIT 1110
184SELECT `Activity`.`id`, `Activity`.`activity_name` FROM `hotel_booking_v3`.`activities` AS `Activity` WHERE `Activity`.`parent_id` = 010100
185SELECT `Category`.`name`, `Category`.`id` FROM `hotel_booking_v3`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 010100
186SELECT `Accomondation`.`title`, `Accomondation`.`id` FROM `hotel_booking_v3`.`accomondations` AS `Accomondation` WHERE `Accomondation`.`is_delete` = 018180
187SELECT `Resort`.`id`, `Resort`.`state_id` FROM `hotel_booking_v3`.`resorts` AS `Resort` WHERE 1 = 1 GROUP BY `Resort`.`state_id`21210
188SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`id` IN (11, 12, 13, 14, 15, 16, 17, 19, 2, 21, 22, 24, 2576, 26, 32, 33, 35, 38, 39, 4, 41)21210
189SELECT WpPost.post_content,WpPost.guid,WpPost.post_date,WpPost.post_title,WpPostmeta2.meta_value FROM `hotel_booking_v3`.`wp_posts` AS `WpPost` left JOIN `hotel_booking_v3`.`wp_postmeta` AS `WpPostmeta1` ON (`WpPostmeta1`.`post_id` = `WpPost`.`ID` AND `WpPostmeta1`.`meta_key` = "_thumbnail_id") left JOIN `hotel_booking_v3`.`wp_postmeta` AS `WpPostmeta2` ON (`WpPostmeta2`.`post_id` = `WpPostmeta1`.`meta_value` AND `WpPostmeta2`.`meta_key` = "_wp_attachment_metadata") WHERE `WpPost`.`post_type` = 'post' AND `WpPost`.`post_status` = 'publish' ORDER BY `WpPost`.`post_date` desc17173
190SELECT `City`.`id`, `City`.`name` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc880
191SELECT `City`.`id`, `City`.`name` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc880
192SELECT `City`.`id`, `City`.`name` FROM `hotel_booking_v3`.`cities` AS `City` WHERE `City`.`is_offsites` = 1 ORDER BY `City`.`name` asc880
193SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `hotel_booking_v3`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_weekends` = 1990
194SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `hotel_booking_v3`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_vacations` = 1990
195SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `hotel_booking_v3`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_destinations` = 1990
196SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `hotel_booking_v3`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_offsites` = 1990
197SELECT `State`.`id`, `State`.`name` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`is_destinations` = 1 ORDER BY `State`.`name` asc14140
198SELECT `State`.`id`, `State`.`name`, `State`.`slug`, `State`.`thumb` FROM `hotel_booking_v3`.`states` AS `State` WHERE `State`.`is_weekends` = 1 ORDER BY `State`.`name` asc660
199SELECT `Vacation`.`id`, `Vacation`.`title`, `Vacation`.`slug`, `Vacation`.`thumb`, `Vacation`.`banner`, `Vacation`.`descn`, `Vacation`.`large_content`, `Vacation`.`order`, `Vacation`.`status`, `Vacation`.`is_delete`, `Vacation`.`update_on`, `Vacation`.`create_on` FROM `hotel_booking_v3`.`vacations` AS `Vacation` WHERE `Vacation`.`slug` = 'monsoon-magic'110
200SELECT `VacationRelation`.`id`, `VacationRelation`.`vacation_id`, `VacationRelation`.`vacation_flag`, `VacationRelation`.`vacation_type`, `VacationRelation`.`vacation_value`, `VacationRelation`.`status` FROM `hotel_booking_v3`.`vacation_relations` AS `VacationRelation` WHERE `VacationRelation`.`vacation_id` = (2)41410