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-04-26',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-04-26' and '2028-06-26'
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-04-26',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-04-26' and '2028-06-26'
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 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
Chopta Tungnath Chandrashila Trek Itinerary
Embark on an unforgettable adventure with the Chopta Tungnath Chandrashila Trek, a mesmerizing journey that takes you through breathtaking landscapes and ancient temples. This 4-day itinerary from Delhi is meticulously designed to ensure you make the most of your time and experience the true beauty of this region.
On Day 1, your adventure begins as you depart from Delhi and head towards Devprayag. This charming town, nestled at the confluence of the Alaknanda and Bhagirathi rivers, offers a serene atmosphere to relax and rejuvenate before your trek.
Day 2 takes you further into the heart of nature as you make your way from Devprayag to Chopta. Known as the “Mini Switzerland of India,” Chopta is a picturesque hill station surrounded by lush green meadows and snow-capped mountains. Take in the panoramic views and immerse yourself in the tranquility of this enchanting destination.
On Day 3, prepare for an exhilarating trek to Chandrashilla via Tungnath Mahadev Temple. Tungnath is one of the highest Shiva temples in the world, located at an altitude of 3,680 meters. As you ascend towards Chandrashilla Peak, at an elevation of 4,000 meters, be prepared to be awe-struck by stunning vistas that stretch as far as the eye can see.
Day 4 marks the final leg of your journey as you trek to Deoriatal before bidding farewell to this captivating region. Deoriatal is a pristine lake surrounded by dense forests and offers a tranquil setting for reflection and relaxation. Afterward, it’s time to drive back to Delhi with memories that will last a lifetime.
The Chopta Tungnath Chandrashila Trek promises not only breathtaking natural beauty but also spiritual encounters with ancient temples along the way. Whether you are an avid trekker or a nature enthusiast, this itinerary ensures an unforgettable experience that will leave you longing for more. So pack your bags, lace up your boots, and get ready to embark on a journey of a lifetime.
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-04-26',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-04-26' and '2026-04-26'
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-04-26',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-04-26' and '2026-04-26'
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 GROUP BY possible_dates.the_date
) as bc
ON bc.booking_date = avc.the_date
HAVING available_places > 0
) as pr