Umaid BhawanJaipur, Rajasthan
About Umaid Bhawan
Umaid Bhawan Jaipur is a modern heritage hotel with a budget hotel tariff providing world class Rajasthani style accommodation. Our hotel is highly recommended by Lonely Planet, Let's go, Foot print travel guides on Jaipur Hotels and Jaipur Budget Hotels.
Available Rooms
Royal Deluxe Room
- Max Guests:
- 3 persons
Royal Suites
- Max Guests:
- 3 persons
Amenities
Things to Do
Umaid BhawanJaipur, Rajasthan
TOB rates it Good 8/10
Need TripOffBeat Help?
We would be more than happy to help you. Our team advisor are 24/7 at your service to help you.
+91-999 0124 333booking(at)tripoffbeat.com
Similar Listings
Lebua Resort Jaipur
TOB rates it Good 8/10
Lebua Lodge at Amer
TOB rates it Good 8/10
Hari Mahal Palace
TOB rates it Good 8/10
Karnot Mahal
TOB rates it Good 8/10
Hotel Diggi Palace
TOB rates it Good 8/10
Hotel Rani Mahal
TOB rates it Good 8/10
Vanaashrya
TOB rates it Wonderful 9/10
Tree house Resort
TOB rates it Wonderful 9/10
Why trust TripOffbeat
One Stop Shop
Verified Resorts And Hotels
Choice Of Destinations
Custom Itineraries
Experts on Call
Emergency Assistance
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT WpPost.post_content,WpPost.guid,WpPost.post_date,WpPost.post_title,WpPostmeta2.meta_value FROM `u407119412_tripoffbeat2`.`wp_posts` AS `WpPost` left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta1` ON (`WpPostmeta1`.`post_id` = `WpPost`.`ID` AND `WpPostmeta1`.`meta_key` = "_thumbnail_id") left JOIN `u407119412_tripoffbeat2`.`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` desc | 63 | 63 | 5 | |
| 2 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 3 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_weekends` = 1 | 9 | 9 | 0 | |
| 5 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_vacations` = 1 | 9 | 9 | 0 | |
| 6 | SELECT `Category`.`id`, `Category`.`name` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_destinations` = 1 | 9 | 9 | 0 | |
| 7 | SELECT `State`.`id`, `State`.`name`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_destinations` = 1 ORDER BY `State`.`name` asc | 14 | 14 | 0 | |
| 8 | SELECT `State`.`id`, `State`.`name`, `State`.`thumb`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_weekends` = 1 ORDER BY `State`.`name` asc | 6 | 6 | 0 | |
| 9 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
| 10 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`activity_id` IN (40, 43, 44, 45, 46, 50) | 624 | 624 | 1 | |
| 11 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete`, `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`, `State`.`id`, `State`.`state_code`, `State`.`tin_no`, `State`.`name`, `State`.`slug`, `State`.`meta_title`, `State`.`meta_desc`, `State`.`meta_keywords`, `State`.`thumb`, `State`.`banner`, `State`.`alt_text`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn`, `State`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` LEFT JOIN `u407119412_tripoffbeat2`.`cities` AS `City` ON (`Resort`.`city_id` = `City`.`id`) LEFT JOIN `u407119412_tripoffbeat2`.`states` AS `State` ON (`Resort`.`state_id` = `State`.`id`) WHERE `Resort`.`slug` = 'umaid-bhawan' LIMIT 1 | 1 | 1 | 1 | |
| 12 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`city_id` = 3378 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 7 | 7 | 1 | |
| 13 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`state_id` = 33 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 50 | 50 | 1 | |
| 14 | SELECT `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` FROM `u407119412_tripoffbeat2`.`resort_rooms` AS `ResortRoom` WHERE `ResortRoom`.`resort_id` = (208) | 2 | 2 | 1 | |
| 15 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`id` = 208 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 0 | 0 | 0 | |
| 16 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`id` = 208 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 0 | 0 | 0 | |
| 17 | SELECT `RoomType`.`id`, `RoomType`.`room_name`, `RoomType`.`room_desc`, `RoomType`.`status`, `RoomType`.`add_date`, `RoomType`.`is_delete` FROM `u407119412_tripoffbeat2`.`room_types` AS `RoomType` WHERE `RoomType`.`id` = 459 | 1 | 1 | 0 | |
| 18 | SELECT `RoomType`.`id`, `RoomType`.`room_name`, `RoomType`.`room_desc`, `RoomType`.`status`, `RoomType`.`add_date`, `RoomType`.`is_delete` FROM `u407119412_tripoffbeat2`.`room_types` AS `RoomType` WHERE `RoomType`.`id` = 460 | 1 | 1 | 0 | |
| 19 | SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`ec_lunch`, `RoomPrice`.`ec_dinner`, `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`, `RoomPrice`.`price_date`, `RoomPrice`.`meal_flag` FROM `u407119412_tripoffbeat2`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 457 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
| 20 | SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`ec_lunch`, `RoomPrice`.`ec_dinner`, `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`, `RoomPrice`.`price_date`, `RoomPrice`.`meal_flag` FROM `u407119412_tripoffbeat2`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`room_id` = 458 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
| 21 | SELECT `RoomAmenity`.`id`, `RoomAmenity`.`amenity_id`, `RoomAmenity`.`room_id`, `RoomAmenity`.`resort_id`, `RoomAmenity`.`created_on`, `RoomAmenity`.`updated_on`, `RoomAmenity`.`is_delete`, `RoomAmenity`.`status` FROM `u407119412_tripoffbeat2`.`room_amenities` AS `RoomAmenity` WHERE `RoomAmenity`.`room_id` IN (457, 458) | 12 | 12 | 0 | |
| 22 | SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`ec_lunch`, `RoomPrice`.`ec_dinner`, `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`, `RoomPrice`.`price_date`, `RoomPrice`.`meal_flag` FROM `u407119412_tripoffbeat2`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`resort_id` = (208) | 0 | 0 | 1 | |
| 23 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (208) | 0 | 0 | 0 | |
| 24 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (208) | 1 | 1 | 0 | |
| 25 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`id` = 208 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 0 | 0 | 0 | |
| 26 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug`, `Category`.`meta_title`, `Category`.`meta_desc`, `Category`.`meta_keywords`, `Category`.`thumb`, `Category`.`thumb2`, `Category`.`thumb_alt`, `Category`.`banner_img`, `Category`.`banner_alt`, `Category`.`is_weekends`, `Category`.`is_vacations`, `Category`.`is_destinations`, `Category`.`is_home_weekends`, `Category`.`is_index_weekends`, `Category`.`description`, `Category`.`cat_order`, `Category`.`update_on`, `Category`.`create_on`, `Category`.`status`, `Category`.`is_delete` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`id` = 6 | 1 | 1 | 0 | |
| 27 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (208) | 1 | 1 | 0 | |
| 28 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`id` = 208 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 0 | 0 | 0 | |
| 29 | SELECT `Accomondation`.`id`, `Accomondation`.`title`, `Accomondation`.`ceated_on`, `Accomondation`.`updated_on`, `Accomondation`.`is_delete` FROM `u407119412_tripoffbeat2`.`accomondations` AS `Accomondation` WHERE `Accomondation`.`id` = 1 | 1 | 1 | 0 | |
| 30 | SELECT `ResortImage`.`id`, `ResortImage`.`resort_id`, `ResortImage`.`resort_thumb`, `ResortImage`.`title`, `ResortImage`.`img_type`, `ResortImage`.`is_quote`, `ResortImage`.`status` FROM `u407119412_tripoffbeat2`.`resort_images` AS `ResortImage` WHERE `ResortImage`.`resort_id` = (208) | 0 | 0 | 0 | |
| 31 | SELECT `ResortAmenity`.`id`, `ResortAmenity`.`amenity_id`, `ResortAmenity`.`resort_id`, `ResortAmenity`.`created_on`, `ResortAmenity`.`updated_on`, `ResortAmenity`.`is_delete`, `ResortAmenity`.`status` FROM `u407119412_tripoffbeat2`.`resort_amenities` AS `ResortAmenity` WHERE `ResortAmenity`.`resort_id` = (208) | 0 | 0 | 1 | |
| 32 | SELECT `RoomImage`.`id`, `RoomImage`.`resort_id`, `RoomImage`.`room_id`, `RoomImage`.`room_thumb`, `RoomImage`.`add_date`, `RoomImage`.`status` FROM `u407119412_tripoffbeat2`.`room_images` AS `RoomImage` WHERE `RoomImage`.`resort_id` = 208 AND `RoomImage`.`status` = 1 | 0 | 0 | 0 | |
| 33 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id`, `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete`, `Activity`.`id`, `Activity`.`parent_id`, `Activity`.`slug`, `Activity`.`activity_name`, `Activity`.`activity_thumb`, `Activity`.`activity_thumb_alt`, `Activity`.`banner`, `Activity`.`activity_desc`, `Activity`.`meta_title`, `Activity`.`meta_desc`, `Activity`.`meta_keywords`, `Activity`.`status`, `Activity`.`created_on`, `Activity`.`updated_on`, `Activity`.`is_delete`, `Activity`.`is_weekends` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` LEFT JOIN `u407119412_tripoffbeat2`.`resorts` AS `Resort` ON (`ResortActivity`.`resort_id` = `Resort`.`id` AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0) LEFT JOIN `u407119412_tripoffbeat2`.`activities` AS `Activity` ON (`ResortActivity`.`activity_id` = `Activity`.`id`) WHERE `ResortActivity`.`resort_id` = 208 | 0 | 0 | 0 | |
| 34 | SELECT `Testimonial`.`id`, `Testimonial`.`tl_author`, `Testimonial`.`tl_author_profile_thumb`, `Testimonial`.`tl_from`, `Testimonial`.`tl_desc`, `Testimonial`.`tl_type`, `Testimonial`.`created_on`, `Testimonial`.`updated_on`, `Testimonial`.`is_delete`, `Testimonial`.`status` FROM `u407119412_tripoffbeat2`.`testimonials` AS `Testimonial` WHERE `Testimonial`.`tl_type` = 'normal' | 24 | 24 | 0 | |
| 35 | SELECT `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` FROM `u407119412_tripoffbeat2`.`resort_rooms` AS `ResortRoom` WHERE `resort_id` = 208 | 2 | 2 | 0 | |
| 36 | select amenities.* from room_amenities inner join amenities on amenities.id=room_amenities.amenity_id where room_amenities.room_id in (459,460) | 8 | 8 | 0 | |
| 37 | SELECT `ResortAmenity`.`id`, `ResortAmenity`.`amenity_id`, `ResortAmenity`.`resort_id`, `ResortAmenity`.`created_on`, `ResortAmenity`.`updated_on`, `ResortAmenity`.`is_delete`, `ResortAmenity`.`status`, `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`resort_amenities` AS `ResortAmenity` LEFT JOIN `u407119412_tripoffbeat2`.`amenities` AS `Amenity` ON (`ResortAmenity`.`amenity_id` = `Amenity`.`id`) WHERE `ResortAmenity`.`resort_id` = 208 | 0 | 0 | 1 | |
| 38 | SELECT `Faq`.`id`, `Faq`.`question`, `Faq`.`answer`, `Faq`.`keyword`, `Faq`.`created_on`, `Faq`.`is_delete`, `Faq`.`status` FROM `u407119412_tripoffbeat2`.`faqs` AS `Faq` WHERE 1 = 1 | 37 | 37 | 0 | |
| 39 | SELECT WpPost.post_content,WpPost.guid,WpPost.post_date,WpPost.post_title,WpPostmeta2.meta_value FROM `u407119412_tripoffbeat2`.`wp_posts` AS `WpPost` left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta1` ON (`WpPostmeta1`.`post_id` = `WpPost`.`ID` AND `WpPostmeta1`.`meta_key` = "_thumbnail_id") left JOIN `u407119412_tripoffbeat2`.`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` desc | 63 | 63 | 7 | |
| 40 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 41 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 42 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_weekends` = 1 | 9 | 9 | 0 | |
| 43 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_vacations` = 1 | 9 | 9 | 0 | |
| 44 | SELECT `Category`.`id`, `Category`.`name` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_destinations` = 1 | 9 | 9 | 0 | |
| 45 | SELECT `State`.`id`, `State`.`name`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_destinations` = 1 ORDER BY `State`.`name` asc | 14 | 14 | 0 | |
| 46 | SELECT `State`.`id`, `State`.`name`, `State`.`thumb`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_weekends` = 1 ORDER BY `State`.`name` asc | 6 | 6 | 0 | |
| 47 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
| 48 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`activity_id` IN (40, 43, 44, 45, 46, 50) | 624 | 624 | 0 | |
| 49 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete`, `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`, `State`.`id`, `State`.`state_code`, `State`.`tin_no`, `State`.`name`, `State`.`slug`, `State`.`meta_title`, `State`.`meta_desc`, `State`.`meta_keywords`, `State`.`thumb`, `State`.`banner`, `State`.`alt_text`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn`, `State`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` LEFT JOIN `u407119412_tripoffbeat2`.`cities` AS `City` ON (`Resort`.`city_id` = `City`.`id`) LEFT JOIN `u407119412_tripoffbeat2`.`states` AS `State` ON (`Resort`.`state_id` = `State`.`id`) WHERE `Resort`.`latitude` > '26.828626' AND `Resort`.`latitude` < '27.028626' AND `Resort`.`longitude` > '75.692405' AND `Resort`.`longitude` < '75.892405' LIMIT 3 | 3 | 3 | 1 | |
| 50 | SELECT `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` FROM `u407119412_tripoffbeat2`.`resort_rooms` AS `ResortRoom` WHERE `ResortRoom`.`resort_id` IN (193, 194, 199) | 2 | 2 | 0 | |
| 51 | SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`ec_lunch`, `RoomPrice`.`ec_dinner`, `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`, `RoomPrice`.`price_date`, `RoomPrice`.`meal_flag` FROM `u407119412_tripoffbeat2`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`resort_id` IN (193, 194, 199) | 0 | 0 | 0 | |
| 52 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (193, 194, 199) | 2 | 2 | 0 | |
| 53 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (193, 194, 199) | 1 | 1 | 0 | |
| 54 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (193, 194, 199) | 1 | 1 | 0 | |
| 55 | SELECT `ResortImage`.`id`, `ResortImage`.`resort_id`, `ResortImage`.`resort_thumb`, `ResortImage`.`title`, `ResortImage`.`img_type`, `ResortImage`.`is_quote`, `ResortImage`.`status` FROM `u407119412_tripoffbeat2`.`resort_images` AS `ResortImage` WHERE `ResortImage`.`resort_id` IN (193, 194, 199) | 0 | 0 | 0 | |
| 56 | SELECT `ResortAmenity`.`id`, `ResortAmenity`.`amenity_id`, `ResortAmenity`.`resort_id`, `ResortAmenity`.`created_on`, `ResortAmenity`.`updated_on`, `ResortAmenity`.`is_delete`, `ResortAmenity`.`status` FROM `u407119412_tripoffbeat2`.`resort_amenities` AS `ResortAmenity` WHERE `ResortAmenity`.`resort_id` IN (193, 194, 199) | 0 | 0 | 1 | |
| 57 | SELECT WpPost.post_content,WpPost.guid,WpPost.post_date,WpPost.post_title,WpPostmeta2.meta_value FROM `u407119412_tripoffbeat2`.`wp_posts` AS `WpPost` left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta1` ON (`WpPostmeta1`.`post_id` = `WpPost`.`ID` AND `WpPostmeta1`.`meta_key` = "_thumbnail_id") left JOIN `u407119412_tripoffbeat2`.`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` desc | 63 | 63 | 5 | |
| 58 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 59 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 60 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_weekends` = 1 | 9 | 9 | 0 | |
| 61 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_vacations` = 1 | 9 | 9 | 0 | |
| 62 | SELECT `Category`.`id`, `Category`.`name` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_destinations` = 1 | 9 | 9 | 0 | |
| 63 | SELECT `State`.`id`, `State`.`name`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_destinations` = 1 ORDER BY `State`.`name` asc | 14 | 14 | 0 | |
| 64 | SELECT `State`.`id`, `State`.`name`, `State`.`thumb`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_weekends` = 1 ORDER BY `State`.`name` asc | 6 | 6 | 0 | |
| 65 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
| 66 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`activity_id` IN (40, 43, 44, 45, 46, 50) | 624 | 624 | 1 | |
| 67 | SELECT `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`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `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`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete`, `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`, `State`.`id`, `State`.`state_code`, `State`.`tin_no`, `State`.`name`, `State`.`slug`, `State`.`meta_title`, `State`.`meta_desc`, `State`.`meta_keywords`, `State`.`thumb`, `State`.`banner`, `State`.`alt_text`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn`, `State`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` LEFT JOIN `u407119412_tripoffbeat2`.`cities` AS `City` ON (`Resort`.`city_id` = `City`.`id`) LEFT JOIN `u407119412_tripoffbeat2`.`states` AS `State` ON (`Resort`.`state_id` = `State`.`id`) WHERE `Resort`.`latitude` > '26.828626' AND `Resort`.`latitude` < '27.028626' AND `Resort`.`longitude` > '75.692405' AND `Resort`.`longitude` < '75.892405' | 9 | 9 | 1 | |
| 68 | SELECT `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` FROM `u407119412_tripoffbeat2`.`resort_rooms` AS `ResortRoom` WHERE `ResortRoom`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 16 | 16 | 0 | |
| 69 | SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`ec_lunch`, `RoomPrice`.`ec_dinner`, `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`, `RoomPrice`.`price_date`, `RoomPrice`.`meal_flag` FROM `u407119412_tripoffbeat2`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 4 | 4 | 0 | |
| 70 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 33 | 33 | 0 | |
| 71 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 10 | 10 | 0 | |
| 72 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 11 | 11 | 0 | |
| 73 | SELECT `ResortImage`.`id`, `ResortImage`.`resort_id`, `ResortImage`.`resort_thumb`, `ResortImage`.`title`, `ResortImage`.`img_type`, `ResortImage`.`is_quote`, `ResortImage`.`status` FROM `u407119412_tripoffbeat2`.`resort_images` AS `ResortImage` WHERE `ResortImage`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 38 | 38 | 0 | |
| 74 | SELECT `ResortAmenity`.`id`, `ResortAmenity`.`amenity_id`, `ResortAmenity`.`resort_id`, `ResortAmenity`.`created_on`, `ResortAmenity`.`updated_on`, `ResortAmenity`.`is_delete`, `ResortAmenity`.`status` FROM `u407119412_tripoffbeat2`.`resort_amenities` AS `ResortAmenity` WHERE `ResortAmenity`.`resort_id` IN (193, 194, 199, 204, 206, 207, 208, 247, 274) | 41 | 41 | 1 |