24/7 Support number +91 9368 776 756

WordPress database error: [Table 'natuhqqt_wp763.wp3t_byt_accommodation_vacancies' doesn't exist]
SELECT IFNULL(MIN(the_date), 0) min_date FROM ( SELECT DISTINCT (avc.number_of_available_rooms - IFNULL(bc.number_of_booked_rooms, 0)) available_rooms, avc.the_date, IFNULL(avc.price_per_day, 0) price_per_day FROM ( SELECT SUM(room_count) number_of_available_rooms, possible_dates.the_date, MIN(price_per_day) price_per_day FROM wp3t_byt_accommodation_vacancies availabilities INNER JOIN ( select d.the_date from ( select adddate('2024-05-20',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-05-20' and '2028-07-20' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date > DATE(availabilities.start_date) AND possible_dates.the_date <= DATE(availabilities.end_date) WHERE availabilities.accommodation_id = 1940 GROUP BY possible_dates.the_date ) as avc LEFT JOIN ( SELECT SUM(bookings.room_count) number_of_booked_rooms, possible_dates.the_date booking_date FROM wp3t_byt_accommodation_bookings bookings INNER JOIN ( select d.the_date from ( select adddate('2024-05-20',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-05-20' and '2028-07-20' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date <= DATE(bookings.date_to) WHERE bookings.accommodation_id = 1940 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr

  • Affordable Camps In Shivpuri Rishikesh

Affordable Camps In Shivpuri Rishikesh

Welcome to The Unicorn Camp and Resort (Affordable Camps In Shivpuri Rishikesh), where affordability meets adventure in the heart of Shivpuri Rishikesh. Our resort offers an unforgettable experience for both friends and family, with a range of in-house facilities that are sure to delight every guest.

At The Unicorn Camp and Resort, we understand the importance of providing a memorable stay without breaking the bank. That’s why we offer affordable camps in Shivpuri Rishikesh, allowing you to enjoy a fantastic getaway without compromising on quality.

Our resort boasts a wide range of amenities designed to cater to all your needs. Take a dip in our refreshing swimming pool or challenge your loved ones to some friendly competition with our indoor games. As the sun sets, gather around our cozy bonfire for an evening filled with laughter and camaraderie.

For those seeking an adrenaline rush, we have you covered. Experience the thrill of our zip line or indulge in a variety of adventure sports that will get your heart racing. Whether you’re an adventure enthusiast or simply looking for some fun-filled activities, The Unicorn Camp and Resort has something for everyone.

We take pride in providing exceptional service and ensuring that every guest leaves with cherished memories. Our dedicated staff is always on hand to assist you throughout your stay, ensuring that your experience is nothing short of extraordinary.

Discover the magic of The Unicorn Camp and Resort today – where affordability meets adventure in Shivpuri Rishikesh. Book your stay now and embark on an unforgettable journey filled with excitement, relaxation, and cherished moments with your loved ones.

WordPress database error: [Table 'natuhqqt_wp763.wp3t_byt_accommodation_vacancies' doesn't exist]
SELECT price_per_day min_price FROM ( SELECT DISTINCT (avc.number_of_available_rooms - IFNULL(bc.number_of_booked_rooms, 0)) available_rooms, avc.the_date, IFNULL(avc.price_per_day, 0) price_per_day FROM ( SELECT SUM(room_count) number_of_available_rooms, possible_dates.the_date, MIN(price_per_day) price_per_day FROM wp3t_byt_accommodation_vacancies availabilities INNER JOIN ( select d.the_date from ( select adddate('2024-05-20',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-05-20' and '2026-05-20' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date > DATE(availabilities.start_date) AND possible_dates.the_date <= DATE(availabilities.end_date) WHERE availabilities.accommodation_id = 1940 GROUP BY possible_dates.the_date ) as avc LEFT JOIN ( SELECT SUM(bookings.room_count) number_of_booked_rooms, possible_dates.the_date booking_date FROM wp3t_byt_accommodation_bookings bookings INNER JOIN ( select d.the_date from ( select adddate('2024-05-20',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) the_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4 having the_date between '2024-05-20' and '2026-05-20' ORDER BY the_date ) d where DATE(d.the_date) > DATE(CURDATE()) group by d.the_date order by d.the_date ) possible_dates ON possible_dates.the_date >= DATE(bookings.date_from) AND possible_dates.the_date <= DATE(bookings.date_to) WHERE bookings.accommodation_id = 1940 GROUP BY possible_dates.the_date ) as bc ON bc.booking_date = avc.the_date HAVING available_rooms > 0 ) as pr