WordPress database error: [Table 'natuhqqt_wp763.wp3t_byt_tour_schedule' doesn't exist]
SELECT IFNULL(MIN(the_date), 0) min_date
FROM
(
SELECT DISTINCT (avc.number_of_available_places - IFNULL(bc.number_of_booked_places, 0)) available_places, avc.the_date, avc.price FROM
(
SELECT SUM(max_people) number_of_available_places, possible_dates.the_date, price
FROM wp3t_byt_tour_schedule availabilities
INNER JOIN (
select d.the_date from
(
select adddate('2024-11-18',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-11-18' and '2029-01-18'
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 availabilities.end_date IS NULL
WHERE availabilities.tour_id = 2402 GROUP BY possible_dates.the_date, availabilities.price
) as avc
LEFT JOIN
(
SELECT SUM(bookings.adults + bookings.children) number_of_booked_places, possible_dates.the_date booking_date
FROM wp3t_byt_tour_booking bookings
INNER JOIN (
select d.the_date from
(
select adddate('2024-11-18',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-11-18' and '2029-01-18'
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.tour_date)
WHERE bookings.tour_id = 2402 AND IFNULL(bookings.woo_status, '') IN ('completed') GROUP BY possible_dates.the_date
) as bc
ON bc.booking_date = avc.the_date
HAVING available_places > 0
) as pr
Ganga River Rafting In Rishikesh
Ganga River Rafting In Rishikesh
Experience the thrill of Ganga River rafting in Rishikesh with our exciting 1 Night 2 Days package. This adventure-filled package offers an unforgettable journey down the majestic Ganga River, combined with comfortable accommodation and delectable meals.
Our package includes everything you need for a memorable rafting experience. From breakfast, lunch, and dinner to evening snacks around a cozy bonfire, we ensure that you are well-fed and energized throughout your stay. You can indulge in the flavors of local cuisine while enjoying the serene beauty of Rishikesh.
With prices starting from just Rs. 500/- per person onwards, this package offers incredible value for money. Whether you're an adrenaline junkie or a nature lover seeking tranquility, Ganga River rafting in Rishikesh is an experience that should not be missed.
Join us on this thrilling adventure as we navigate through the rapids of the Ganga River and witness the breathtaking landscapes along its banks. Our professional guides will ensure your safety while providing an exhilarating experience that will leave you wanting more.
Don't miss out on this opportunity to explore the beauty of Rishikesh from a unique perspective. Book your 1 Night 2 Days Ganga River rafting package now and get ready for an unforgettable adventure filled with fun, excitement, and memories that will last a lifetime.
Package Cost
Only Rafting @ Rs. 500/- Per Person (Rates May Be Vary)
With Camp Stay and Meals @ Rs. 2,200/- Per Person (Rates May Be Vary)
WordPress database error: [Table 'natuhqqt_wp763.wp3t_byt_tour_schedule' doesn't exist]
SELECT IFNULL(MIN(price), 0) min_price
FROM
(
SELECT DISTINCT (avc.number_of_available_places - IFNULL(bc.number_of_booked_places, 0)) available_places, avc.the_date, avc.price FROM
(
SELECT SUM(max_people) number_of_available_places, possible_dates.the_date, price
FROM wp3t_byt_tour_schedule availabilities
INNER JOIN (
select d.the_date from
(
select adddate('2024-11-18',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-11-18' and '2026-11-18'
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 availabilities.end_date IS NULL
WHERE availabilities.tour_id = 2402 GROUP BY possible_dates.the_date, availabilities.price
) as avc
LEFT JOIN
(
SELECT SUM(bookings.adults + bookings.children) number_of_booked_places, possible_dates.the_date booking_date
FROM wp3t_byt_tour_booking bookings
INNER JOIN (
select d.the_date from
(
select adddate('2024-11-18',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-11-18' and '2026-11-18'
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.tour_date)
WHERE bookings.tour_id = 2402 AND IFNULL(bookings.woo_status, '') IN ('completed') GROUP BY possible_dates.the_date
) as bc
ON bc.booking_date = avc.the_date
HAVING available_places > 0
) as pr