For us, TripOffbeat is a long-term love. We know almost everything there is to know about the different places as well as things to do and see. We make sure we have a finger on the pulse so that we can give you accurate information and make the right recommendations – for honeymooners, babymooners, young families and even bucket listers. Expertise is a TripOffbeat business principle – ‘we know because we go’ to every destination we sell. From your home to hotel and back again via a beach bungalow, safari tent or luxury suite, you are in the safe hands of Indian travel experts.
You don’t need a reason for a holiday. You just want it for a million reasons. Travel has the ability to change your life in the most unexpected way. Travelling around the world is something that has crossed everyone’s mind at some point of time. At the same time, planning a perfect holiday can be overwhelming. Leave it to our holiday experts. From deciding the perfect destination to finding the best hotels to stay – we bring to you a collection of curated holiday ideas that will make your travel much more fun.
In the midst of hustle and bustle of city and work life, you need to unplug from reality and escape to your fantasyland with weekend gateways. A small excursion for a day or two is the best way to get away from stress and tensions of routine city life. Keeping in mind, we all have time constraints; a weekend getaway from the city is an ideal option. In such weekend trips of one or two days, one can actually explore some amazing places nearby, can partake in interesting recreational activities, can indulge in shopping and can feast on some mouth-watering local delicacies etc. So, just pack your bags and get all set to treat yourself with an exciting and relaxing weekend break where you enjoy your life to the fullest. TripOffbeat has innumerable options for you.
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 | 6 | |
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 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 | |
12 | 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 | |
13 | SELECT `Testimonial`.* FROM `u407119412_tripoffbeat2`.`testimonials` AS `Testimonial` WHERE `Testimonial`.`tl_type` = 'normal' AND `Testimonial`.`is_delete` = 0 AND `Testimonial`.`status` = 1 ORDER BY `Testimonial`.`id` desc | 24 | 24 | 0 | |
14 | SELECT `Category`.* FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`is_home_weekends` = 1 | 9 | 9 | 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`, `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`.`tob_rating` > 9 AND `Resort`.`status` = 1 | 10 | 10 | 1 | |
16 | 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 (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 24 | 24 | 0 | |
17 | 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 (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 24 | 24 | 0 | |
18 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 70 | 70 | 0 | |
19 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 39 | 39 | 0 | |
20 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 17 | 17 | 0 | |
21 | 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 (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 439 | 439 | 1 | |
22 | 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 (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 44 | 44 | 0 | |
23 | SELECT `HomeBanner`.`id`, `HomeBanner`.`banner_title`, `HomeBanner`.`banner_link`, `HomeBanner`.`banner_img`, `HomeBanner`.`banner_order`, `HomeBanner`.`banner_alt_txt`, `HomeBanner`.`status`, `HomeBanner`.`is_delete`, `HomeBanner`.`created_at`, `HomeBanner`.`updated_at` FROM `u407119412_tripoffbeat2`.`home_banners` AS `HomeBanner` WHERE `HomeBanner`.`is_delete` = 0 AND `HomeBanner`.`status` = 1 ORDER BY `HomeBanner`.`banner_order` ASC | 3 | 3 | 0 | |
24 | SELECT `HomePageSetting`.`id`, `HomePageSetting`.`title_below_banner_section`, `HomePageSetting`.`desc_below_banner_section`, `HomePageSetting`.`first_slug`, `HomePageSetting`.`first_slug_alt_text`, `HomePageSetting`.`first_slug_url`, `HomePageSetting`.`second_slug`, `HomePageSetting`.`second_slug_alt_text`, `HomePageSetting`.`second_slug_url`, `HomePageSetting`.`created_at`, `HomePageSetting`.`updated_at` FROM `u407119412_tripoffbeat2`.`home_page_settings` AS `HomePageSetting` WHERE `HomePageSetting`.`id` = 1 LIMIT 1 | 1 | 1 | 0 |