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-14',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-14' and '2029-01-14'
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 = 2399 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-14',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-14' and '2029-01-14'
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 = 2399 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
Chopta Tungnath Chandrashila Trek
Short itinerary
Day 0 Delhi to Chopta | Overnight Journey
Day 1 Chopta Arrival | Day at Leisure & Chill Scenes
Day 2 Trek to Chandrashila via Tungnath Mahadev Temple
Day 3 Trek to Deoriatal | Depart for Delhi
Day 4 Reach Delhi | Trip Ends
Day 0 Delhi To Chopta | Overnight Journey
Assemble at boarding point in Delhi - Akshardham Metro Station and meet your Trip Captain. Start an overnight journey to Chopta and socialize with your co- travellers.
Day 1 Devprayag Sangam | Chopta Arrival
Enroute Chopta, we will take a pit stop at Devprayag in early morning to witness the beautiful confluence of Bhagirathi & Alaknanda rivers ultimately becoming Ganga river.
Further we will take a halt around Rudraprayag to grab a satisfying breakfast and continue our journey towards Chopta.
After arriving in Chopta Valley, check-in to our scenic property, freshen-up and have some leisure.
Go for a forest walk and absorb in the charming Himalayan beauty.
In the evening, enjoy warm bonfire and mouth-watering snacks under a million stars.
Savour home-style cooked dinner and overnight stay in camps/hotel.
Day 2 Trek to Chandrashila via Tungnath Mahadev Temple
Wake up early to witness the beautiful sunrise and post breakfast, drive to the starting point of our trek.
Begin your trek to Tungnath - one of the Panch Kedar and World’s highest temple dedicated to Lord Shiva.
Trek further to magnificent Chandrashila Peak situated at 13,000 ft (if weather & conditions permits) and gather for an #InstaPerfect group picture.
Trek back to Chopta village and drive back to our property and have some leisure.
Savour home-style cooked dinner and overnight stay in a camps/hotel.
Day 3 Drive To Sari Village | Trek To Deoriatal | Depart For Delhi
Wake up to a peaceful mountain morning and post breakfast, drive to Sari Village.
Begin your trek to mesmerising Deoriatal Lake. Trek back to Sari village and post lunch start-off your return journey to Delhi.
Take a halt at Rishikesh in the night to explore the local market, go for cafe hopping, visit temples and serene Ganga ghats (if time permits).
Day4 Delhi Arrival | Trip Ends
Reach Delhi early morning with lots of amazing memories and unforgettable experiences.
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-14',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-14' and '2026-11-14'
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 = 2399 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-14',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-14' and '2026-11-14'
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 = 2399 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