Aravali ResortEllenabad, Haryana
About Aravali Resort
Aravali Resort Haryana is an ideal gateway for an exotic weekend, away from the hubbub of the city. The resort features a seasonal outdoor pool multi-cuisine restaurant with a bar. A wide range of spacious and comfortable rooms having a private bathroom with modern amenities. The facility of free Wi-fi and free parking is also available. Enjoy DJ, Bollywood and Sufi Nights with an exotic aura. Play billiards and darts while enjoying evening beers. Sohna is just 39 km from the property, visit Sohna Hot Springs. Delhi International Airport is 64 km away and nearest to the site.
Available Rooms
Executive Room
- Max Guests:
- 2 persons
Super Deluxe Room
- Max Guests:
- 2 persons
Luxury Room
- Max Guests:
- 2 persons
Amenities
-
Intercom Facility
-
Hot/Cold Running Water
-
Bathroom Toiletries
-
Swimming Pool
-
Sun Beds (pool)
-
Conference Hall*
-
Wi-Fi Internet*
-
Restaurant
-
Bar*
-
Parking facility
Things to Do
Spa
What is better than giving your body a peaceful and refreshing spa therapy or massage therapy? The answer is nothing. Leave the hubbub of the city and give your body a rejuvenating experience. Spa and massage therapy is the best way to refresh your body and mind. Relax in hot and blend in the water. Let your muscles relax and reduce tension. Experience one-of-a-kind Spa Therapy with our great service at Tripoffbeat.
Candle Light Dinner
There is nothing more romantic than a candlelight dinner with an astounding view with the person you adore. After a day full of enjoyment or adventure dine in the low light of candles. Enjoy cuisines native to the place and feel the ambiance of nighty sounds. Make your vacation a memorable one with complete leisure and romance, one which will be a memory lasting forever.
Swimming
Aravali ResortEllenabad, Haryana
TOB rates it Average 3/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
Chandelao Garh
TOB rates it Good 8/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 | 11 | |
| 2 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 1 | |
| 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` = 'aravali-resort' 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` = 1117 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 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` = 13 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 8 | 8 | 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` = (224) | 3 | 3 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 17 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 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` = 487 | 1 | 1 | 0 | |
| 19 | 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` = 508 | 1 | 1 | 0 | |
| 20 | 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` = 509 | 1 | 1 | 0 | |
| 21 | 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` = 485 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 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`.`room_id` = 506 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
| 23 | 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` = 507 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
| 24 | 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 (485, 506, 507) | 12 | 12 | 1 | |
| 25 | 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` = (224) | 2 | 2 | 1 | |
| 26 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 27 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 28 | 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` = 508 | 1 | 1 | 0 | |
| 29 | 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` = 509 | 1 | 1 | 0 | |
| 30 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (224) | 3 | 3 | 0 | |
| 31 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 32 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 33 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 34 | SELECT `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`.`activities` AS `Activity` WHERE `Activity`.`id` = 30 | 1 | 1 | 0 | |
| 35 | SELECT `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`.`activities` AS `Activity` WHERE `Activity`.`id` = 74 | 1 | 1 | 0 | |
| 36 | SELECT `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`.`activities` AS `Activity` WHERE `Activity`.`id` = 75 | 1 | 1 | 0 | |
| 37 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (224) | 0 | 0 | 0 | |
| 38 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (224) | 1 | 1 | 0 | |
| 39 | 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` = 224 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
| 40 | SELECT `Accomondation`.`id`, `Accomondation`.`title`, `Accomondation`.`ceated_on`, `Accomondation`.`updated_on`, `Accomondation`.`is_delete` FROM `u407119412_tripoffbeat2`.`accomondations` AS `Accomondation` WHERE `Accomondation`.`id` = 17 | 1 | 1 | 0 | |
| 41 | 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` = (224) | 10 | 10 | 0 | |
| 42 | 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` = 224 | 1 | 1 | 0 | |
| 43 | 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` = 224 | 1 | 1 | 0 | |
| 44 | 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` = 224 | 1 | 1 | 0 | |
| 45 | 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` = 224 | 1 | 1 | 0 | |
| 46 | 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` = 224 | 1 | 1 | 0 | |
| 47 | 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` = 224 | 1 | 1 | 0 | |
| 48 | 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` = 224 | 1 | 1 | 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` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE `Resort`.`id` = 224 | 1 | 1 | 0 | |
| 50 | 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` = 224 | 1 | 1 | 0 | |
| 51 | 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` = 224 | 1 | 1 | 0 | |
| 52 | 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` = (224) | 10 | 10 | 1 | |
| 53 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 5 | 1 | 1 | 0 | |
| 54 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 22 | 1 | 1 | 0 | |
| 55 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 23 | 1 | 1 | 0 | |
| 56 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 29 | 1 | 1 | 0 | |
| 57 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 34 | 1 | 1 | 0 | |
| 58 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 39 | 1 | 1 | 0 | |
| 59 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 41 | 1 | 1 | 0 | |
| 60 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 43 | 1 | 1 | 0 | |
| 61 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 48 | 1 | 1 | 0 | |
| 62 | SELECT `Amenity`.`id`, `Amenity`.`aminity_name`, `Amenity`.`type`, `Amenity`.`icon`, `Amenity`.`created_on`, `Amenity`.`updated_on`, `Amenity`.`is_delete`, `Amenity`.`status` FROM `u407119412_tripoffbeat2`.`amenities` AS `Amenity` WHERE `Amenity`.`id` = 64 | 1 | 1 | 0 | |
| 63 | 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` = 224 AND `RoomImage`.`status` = 1 | 11 | 11 | 1 | |
| 64 | 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` = 224 | 3 | 3 | 0 | |
| 65 | 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 | |
| 66 | 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` = 224 | 3 | 3 | 1 | |
| 67 | select amenities.* from room_amenities inner join amenities on amenities.id=room_amenities.amenity_id where room_amenities.room_id in (487,508,509) | 22 | 22 | 1 | |
| 68 | 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` = 224 | 10 | 10 | 1 | |
| 69 | 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 | |
| 70 | 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 | |
| 71 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 72 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 73 | 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 | |
| 74 | 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 | |
| 75 | 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 | |
| 76 | 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 | |
| 77 | 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 | |
| 78 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
| 79 | 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 | |
| 80 | 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.150863' AND `Resort`.`latitude` < '26.350863' AND `Resort`.`longitude` > '73.296381' AND `Resort`.`longitude` < '73.496381' LIMIT 3 | 2 | 2 | 1 | |
| 81 | 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 (69, 224) | 4 | 4 | 1 | |
| 82 | 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 (69, 224) | 3 | 3 | 0 | |
| 83 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (69, 224) | 11 | 11 | 0 | |
| 84 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (69, 224) | 3 | 3 | 0 | |
| 85 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (69, 224) | 2 | 2 | 0 | |
| 86 | 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 (69, 224) | 48 | 48 | 0 | |
| 87 | 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 (69, 224) | 14 | 14 | 0 | |
| 88 | 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 | |
| 89 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 90 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
| 91 | 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 | |
| 92 | 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 | |
| 93 | 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 | |
| 94 | 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 | |
| 95 | 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 | |
| 96 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
| 97 | 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 | |
| 98 | 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.150863' AND `Resort`.`latitude` < '26.350863' AND `Resort`.`longitude` > '73.296381' AND `Resort`.`longitude` < '73.496381' | 2 | 2 | 5 | |
| 99 | 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 (69, 224) | 4 | 4 | 1 | |
| 100 | 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 (69, 224) | 3 | 3 | 1 | |
| 101 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (69, 224) | 11 | 11 | 0 | |
| 102 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (69, 224) | 3 | 3 | 1 | |
| 103 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (69, 224) | 2 | 2 | 0 | |
| 104 | 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 (69, 224) | 48 | 48 | 0 | |
| 105 | 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 (69, 224) | 14 | 14 | 1 |