Sitabani Jungle ResortCorbett, Uttarakhand
Sitabani Jungle Resort Corbett is between natural flora and fauna. Set amid the dense forests with Pawalgarh Conservation Reserve on the outskirts. The resort features 4 types of rooms and suites made with keeping in mind the necessities of nature-lover. Rooms have a king-size bed and comfortable seating with a private bathroom highlighting modern amenities. Cottages with attached balcony or poolside view. Rooms with personal lawns and scenic views of the valley. The resort offers a spa, an outdoor swimming pool, a BBQ restaurant and also a bonfire during winters for musical nights. A conference/meeting room is also available. Explore Corbett and enjoy bird watching, nature trails, wild animal camping. Go for treks, gypsy safaris or have a riverside feast and nature walks.
Explore unexplored India on two wheels. Measure the unpaved roads, far-flung villages, hilly sojourns of India. Meet local people and experience their local food, and get an unforgettable biking experience. Enjoy nature and give your trip a thrilling touch.
Explore unexplored India on two wheels. Measure the unpaved non-motorable roads, far-flung villages, hilly sojourns and many more hidden jewels of India. Nothing is more enjoyable than morning cycling or exploring the nature of bicycles. Have a one-of-a-king cycling experience for your vacation.
Nature tourism is defined as responsible travel to natural areas, which conserves the environment and helps improve the welfare and well-being of local people by engaging them into tourism and earning their livelihoods from tourism. It is tourism based on the natural attractions of an area which might include birdwatching, photography, stargazing, camping, hiking, hunting, fishing, and visiting national parks or wildlife sanctuaries. The tourists going for nature tourism are mostly interested in a exploring and understanding the diversity of natural and cultural resources available in these places. They want what is real, and they want to be immersed in a rich natural, cultural, or historical experience while they undertake such nature tours. For the people who love to spend time with nature and explore more about the real nature and diversity we have handpicked lot of places which would fulfill your desire of nature tours.
Jungle Jeep Safari is a delight for wildlife photographers, adventure seekers and people having a problem walking on long unpaved trails. In fact, these Jungle Jeep Safari adds extra fun to the journey and the exploration of the forest you are in. You will encounter animals and will have a scenic view of flora and fauna. Explore the wildlife and add a great experience to your travel diaries with Tripoffbeat.
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.
Wildlife tourism unlocks the doors of diverse wildlife sanctuaries and over 100 national parks scattered throughout the nation. Taking a wildlife tour gives ample opportunities to scout the exquisiteness of the wildlife and natural world. India is a favored wildlife place among wildlife enthusiasts and nature lovers from across the world visit India to explore the rich flora and fauna of these forests. Visit famous national parks of India to experience the different adventurous activities and enjoy amazing safaris in these destinations.
The world of birds is a colourful and spectacular affair. There is nothing better than bird watching to enjoy the vibrant bird culture in India. A task that requires complete patience and perseverance, watching beautiful birds in their natural habitats brings about a strange feeling of exhilaration and contentment. Build uniquely beautiful memories with your loved ones and click snapshots of lovely birds when you go for a bird watching vacation through TripOffbeat!
India is a vast land of different cultures and traditions. Each place in India is unique in its own culture, food, clothing and have a one-of-its-kind aura. Go and explore the Indian village and their culture and you will understand why India is a country of all joys. You will learn that every culture has its uniqueness. We at Tripoffbeat will allow interacting with the local people and you can feel the love and sheer happiness. Enjoy the village walks and have a unique experience.
Please type Activity description...
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 | 10 | |
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` = 'sitabani-jungle-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` = 48324 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` = 39 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 48 | 48 | 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` = (216) | 4 | 4 | 0 | |
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` = 216 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` = 216 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
18 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 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` = 470 | 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` = 471 | 1 | 1 | 0 | |
21 | 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` = 472 | 1 | 1 | 0 | |
22 | 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` = 473 | 1 | 1 | 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` = 468 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
24 | 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` = 469 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
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`.`room_id` = 470 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
26 | 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` = 471 AND `RoomPrice`.`resort_id` = 'ResortRoom.resort_id' | 0 | 0 | 0 | |
27 | 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 (468, 469, 470, 471) | 17 | 17 | 1 | |
28 | 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` = (216) | 0 | 0 | 1 | |
29 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` = (216) | 10 | 10 | 0 | |
30 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 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` = 216 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` = 216 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
34 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
35 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
36 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
37 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
38 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
40 | 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` = 2 | 1 | 1 | 0 | |
41 | 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` = 3 | 1 | 1 | 0 | |
42 | 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` = 7 | 1 | 1 | 0 | |
43 | 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` = 18 | 1 | 1 | 0 | |
44 | 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 | |
45 | 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` = 41 | 1 | 1 | 0 | |
46 | 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` = 43 | 1 | 1 | 0 | |
47 | 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` = 45 | 1 | 1 | 0 | |
48 | 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` = 86 | 1 | 1 | 0 | |
49 | 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` = 88 | 1 | 1 | 0 | |
50 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` = (216) | 2 | 2 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
52 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
53 | 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` = 1 | 1 | 1 | 0 | |
54 | 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` = 5 | 1 | 1 | 0 | |
55 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` = (216) | 1 | 1 | 0 | |
56 | 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` = 216 AND `Resort`.`status` = 1 AND `Resort`.`is_delete` = 0 | 1 | 1 | 0 | |
57 | 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 | |
58 | 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` = (216) | 0 | 0 | 0 | |
59 | 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` = (216) | 7 | 7 | 1 | |
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` = 29 | 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` = 39 | 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` = 42 | 1 | 1 | 0 | |
63 | 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 | |
64 | 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` = 46 | 1 | 1 | 0 | |
65 | 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 | |
66 | 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` = 60 | 1 | 1 | 0 | |
67 | 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` = 216 AND `RoomImage`.`status` = 1 | 0 | 0 | 1 | |
68 | 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` = 216 | 10 | 10 | 0 | |
69 | 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 | |
70 | 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` = 216 | 4 | 4 | 1 | |
71 | select amenities.* from room_amenities inner join amenities on amenities.id=room_amenities.amenity_id where room_amenities.room_id in (470,471,472,473) | 20 | 20 | 0 | |
72 | 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` = 216 | 7 | 7 | 1 | |
73 | 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 | |
74 | 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 | |
75 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
76 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
77 | 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 | |
78 | 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 | |
79 | 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 | |
80 | 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 | |
81 | 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 | |
82 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
83 | 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 | |
84 | 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` > '29.44252' AND `Resort`.`latitude` < '29.64252' AND `Resort`.`longitude` > '79.124272' AND `Resort`.`longitude` < '79.324272' LIMIT 3 | 3 | 3 | 1 | |
85 | 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 (117, 124, 216) | 11 | 11 | 0 | |
86 | 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 (117, 124, 216) | 7 | 7 | 1 | |
87 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (117, 124, 216) | 22 | 22 | 0 | |
88 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (117, 124, 216) | 10 | 10 | 0 | |
89 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (117, 124, 216) | 3 | 3 | 0 | |
90 | 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 (117, 124, 216) | 59 | 59 | 1 | |
91 | 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 (117, 124, 216) | 19 | 19 | 0 | |
92 | 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 | |
93 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
94 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
95 | 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 | |
96 | 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 | |
97 | 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 | |
98 | 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 | |
99 | 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 | |
100 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
101 | 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 | |
102 | 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` > '29.44252' AND `Resort`.`latitude` < '29.64252' AND `Resort`.`longitude` > '79.124272' AND `Resort`.`longitude` < '79.324272' | 3 | 3 | 1 | |
103 | 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 (117, 124, 216) | 11 | 11 | 0 | |
104 | 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 (117, 124, 216) | 7 | 7 | 1 | |
105 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (117, 124, 216) | 22 | 22 | 0 | |
106 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (117, 124, 216) | 10 | 10 | 0 | |
107 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (117, 124, 216) | 3 | 3 | 0 | |
108 | 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 (117, 124, 216) | 59 | 59 | 0 | |
109 | 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 (117, 124, 216) | 19 | 19 | 1 |