Loading...10%
Tours for you
Trip Map
Trip Gallery
If this is right trip for you?

For any queries please send email on info@trekasur.com and we will trek back to you with all details within 48 hours!

 
 
 
 
 
Goecha La Trek 16days
Unforgettable trail

Goechala is situated in the state of Sikkim which is a perfect destination for adventure lovers. Trekking in Sikkim is extravagant with flourishing valleys, fine-looking orchards and dark forests. Its unrivaled collection of flora and fauna, add charisma to the adventure of trekking expedition with verdant green peak trails of Sikkim. Darjeeling is the doorway to Sikkim. These base camps have many splendid peaks like Kanchenjunga peak, which is one of the most superlative and stunning peaks of the Himalayan Range. The tremendously tough terrains that are often the preference of the qualified trekkers are on the peak, with snowy crest of the famed Himalayas. There are many peaks like Kabru, Yokhum, Ratong peaks which look very pretty and gives are breathtaking view.

Tour Type Trekking
Tour Route Kol-NJP--Yuksom-Bakhim-Dzongri-Thangsing-Lumini-Simiti Lake-Gochala-Kokchrung-Tsoka-Yuksom-Gangtok-NJP-Kol
Country India
Activity Sightseeing/High Altitude Trekking
Best Season April,May,June,September,October,November
Altitude From 1780 mtr to 5000 mtr
Activity per day Approximately 4-6 hrs walking per day
  • Pictorial route and magnificent mass views 
  • The route passes through tropical and coniferous woodland
  • Sikkim is renowned for its orchid's flowers garland 
  • The Himalayan bear, multicolored pheasants and a fusion of birds
  • Views of awesome summits of  Pandim, Tenzing Khang, Kabru South, Frey and more peaks of the Himalayas
  • The southeast face of Kanchenjunga, the worlds third highest mountain, is viewable from the pass

Goechala trek is an admired trek which will add cherishable memories. The trek starts from Yuksom and through Sachen pass, it joins the conventional Dzongri-Goechala trail. The Ridge is really gorgeous and full of exciting activity whereas the Goechala pass is the decisive destination for the magnificent sight of Mountain Kabru and Kanchenjunga. Next day you will trail descend steep forest to the overpass on the Dzongri-Goechala track after walking an hour from then you will reach to Tshoka.

The trek comprises the big grazing land and opaque forest which comes in way. Day by day you are enjoying your trek more and more as you can feel the essence of beautiful landscape views. The climb to the Dzongri top is very pretty and hefty too. There when you will move further to Black Kabru Pandim, Kabru North, Kabru Dome and many peaks. The feeling of the sun waves warming our solid bodies is really a wonderful experience. After packing our bags we started for another destination to other camp spot for the day Thensing.

A very striking place, opaque mist packed forest, bubble RathongChu river and fat mat of grassland and plants on the ground. Next stop is Pandim and the preliminary part of the journey takes you down to the bank of the river. It overlook the Talung dale and guidelines a very inspiring view of the mountain. The way down is swift and the night halt is at Kokchurung where you can stay and enjoy luscious dinner.

After the finishing point of your trek you will move early in the morning and return back to Yuksom by air route or by road. Finally an unforgettable trek came to an end and all travelogues have enjoyed wonderful experience.

 

Day 01 :: Kolkata- Morning flight Arrival Kolkata – 7:55am

Arrive Kokata Airport and Go to hotel freshen up, hire a taxi for a Day, Day visit Kolkata, Return to Station in the evening, catch a train to New Jalpaiguri

Day 02 :: New Jalpai Guri – Yuksom Reach New JalpaiGuri in the Morning freshen up and after breakfast , take a shared taxi drive to Yuksum (1780 M) by covering approx. 123 kms in 7 hrs. Yuksum is the oldest capital of Sikkim where the first king was consecrated at 1642 A.D. It also has the oldest existing Monastery built during 1700 A.D. Overnight stay in hotel.

Day 03 :: Stop over at Yuksom due to rain

Day 04 :: Yuksom (1780m) - Bakhim (3035m) (Trek) Morning after breakfast start the first leg of trekking to reach Bhakim (3035 m) by covering approx. 13 kms in 9 hrs. The track is a Gradual Ascent and descent through the dense Verdant semi-tropical forest following the Pairag Chu. Overnight stay in tent, You would have never seen sky so clear and so many stars. Day 05 :: Bakhim (3035 m)- Dzongri (4030 m) (Trek) Morning start trekking to reach Dzongri (4030 m) along a well marked track by covering approx. 12 kms in 8 hrs. Initially the track climbs steeply. But as the track is through fascinating Rhododendron bushes running riot with color. Arrive at Dzongri. Last two days were killing in ascend. We covered 2250 meters roughly 7500 feet in just two days. Due such a heavy, trek and sweat last two days , I was feeling miserable. The camping in Dzongri was next the river of melted ice from snow peaks. I soon as we settled down in the came in the night , I decide to take bath in that chilling water coming from melted snow river. Everyone in team got shock with idea , my guide cum cook Shyam said “ Mat nahao, saab, aap mar jayega “ (don’t take bath sir you will die ) , but I was determined that would not sleep tonight without bath and change of clothes, which I did. Yes I am alive to write the experience but at that time bath was really a very very painful process, what is called numbness and uncontrolled shivering, before death I experienced that day. I goes down like a shiver in my spine even today. I would not recommend anyone in my life time for this adventure. People might not be alive to tell the tale. Day 06 :: Dzongri (4030 m) – Thangsing (3800 m) (Trek) Early morning you have to trek to have a great view of Kanchenjunga snow peak with sun rise. Takes 2 hours to go up and come down.

Have breakfast and start trekking to reach Thangsing (3800 m) by covering approx. 8 kms in 6 hrs. One can have Fantastic view of Mt. Kanchenjunga. Mt. Pandim, Mt. Kabri etc. From the Dzongri pass. Continue to reach Thangsing. Overnight stay in wooden hut.

Day 07 :: Thangsing (3800 m) - Lumini (Trek) Trekking to reach Lumini l (4000 m) by covering approx. 8 kms in 5 hrs. Almost flat.  Near to Simiti lake , is one of the high altitude fresh water lakes found in the Bosom of mighty Himalayan ranges. This is also considered a very sacred lake. Arrive and camp by the side of the lake. Camp next to river relax, prepare for early morning 3am ascend.

Day 08 :: Lumini - Simiti Lake (4200 m) - Gochala (5000 m) –to Kokchrung (Trek) Trekking to reach Gochala (5000 m) by covering approx. 14 kms in 8 hrs. From the pass one can see the lofty and majestic Mt. Kanchenjunga, Mt. Kabru and Kabru Dome etc. Retrace the route back to Kokchrung passing through Thanmsing. It is decend so you can cover more. Overnight stay in trekkers hut. Day 09 :: Kokchrung - Tsoka (Trek) Trekking to reach Tsoka (3710 m) in about 5 - 6 hrs. The trek winds its way down upto Phedong, the start of the Rhododendron trail. Overnight stay in trekkers hut. The guide warned us not the venture in the night out of the trekkers that hut as the place is cursed and hounded by spirits. There were deaths of tourist and locals, who got lost in mountain forest and never made it back to camp alive. Kind of scary place.

Day 10:: Tsoka - Yuksom (Trek) Covering approx. 7kms in 4 hrs. relax in Hotel, in the nigh we sent o town had some snacks and back to civilization again.Overnight stay in hotel.

 Day 11 :: Yuksom - Gangtok (Jeep) Morning after breakfast drive to Pemayangste (2085 m) by covering approx. 30 kms in 1 hr. Pemayangtse is one of the oldest and important Monasteries in Sikkim. Visit the Monastery, proceed to reach Gangtok (1810 m) by covering approx. 110 kms in 5 hrs. Arrive Gangtok and check into hotel for overnight stay.

Day 12 ,13 and 14 :: Gangtok (Local site seeing ) Excursion to Rumtek monastery, enroute visit the Institute of Tibetology and discover other place. Team did river rafting also.

Day 15 :: Gangtok – New Jalpai Guri  Shared Taxi. Early morning, transfer to New Jalpai Guri reach Jalpai guri in the evening catch a train to Kalkata

Day 16  :: Arrive Kolkata in the morning and take flight to onward destination.

 

1-Good Jacket -1

16-Gloves-1 pair

2-Thermo suite -1

17-Note book -1

3-Full slivers T -shirts -2

18-Pen-1

4-Trousers -2

19-Camera-1

5-Shocks warm cotton -3 pairs

20-small rope  (1 meter , 1- match box )

6-Good Shoes -1 pair

21-Small Knife-1

7-Wind proof Suite   -1

22-Tooth brush

8-Light Rain/coat Sheet -1

23-tooth paste

9-Tourch Light -1

24-paper soap

10- Basic Medicine

25-Toilet roll -2

11-Sun Glass -1

26-small towel-1

12-Sun Burn Cream -

27-small mug-1

13-Lips guard

28-Water bottle-1

14- P- cap  -1

29-walking stick-1

15-Scarp cotton -1

30-Extra pair of cloth -1 pair

 

are the basic  things which used to  carry by a trekker .

 

Do not carry   any heavy things with you , do not hope any luxury there, because trekking is a survival with  less  equipment .

 

Related Tours
0

Sandakphu & Singalila Trek 10days

Sandakphu is a wonderland for the trekkers. It's located at an altitud ...

Book Now
0

Unforgettable Roopkund 8days

Roopkund a pristine nestled lake situated at 5229mts above sea level,i ...

Book Now
0

Trekking in Ladakh

Think of the Himalayas and you'll inevitably think of Mount Everest. B ...

Book Now
Leave a Comment
If you want to post comments, you need to login first.
(default) 37 queries took 73 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`record_id`, `User`.`id`, `User`.`username`, `User`.`profile_picture`, `User`.`slug`, `User`.`password`, `User`.`password_token`, `User`.`email`, `User`.`country_code`, `User`.`phone`, `User`.`email_verified`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`tos`, `User`.`active`, `User`.`last_login`, `User`.`last_action`, `User`.`is_admin`, `User`.`role`, `User`.`created`, `User`.`modified` FROM `trekasur_db1`.`users` AS `User` WHERE `User`.`role` = 'admin' LIMIT 11148
2SELECT `UserDetail`.`id`, `UserDetail`.`user_id`, `UserDetail`.`position`, `UserDetail`.`field`, `UserDetail`.`value`, `UserDetail`.`input`, `UserDetail`.`data_type`, `UserDetail`.`label`, `UserDetail`.`created`, `UserDetail`.`modified` FROM `trekasur_db1`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = ('51b4296d-03c8-4e3b-8b43-3416ae2593b8') 94941
3SELECT `UserDetail`.`field`, `UserDetail`.`value` FROM `trekasur_db1`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = '51b4296d-03c8-4e3b-8b43-3416ae2593b8' AND `UserDetail`.`field` LIKE 'User.%'94941
4SELECT `TourStyle`.`id`, `TourStyle`.`stylename` FROM `trekasur_db1`.`tour_styles` AS `TourStyle` WHERE 1 = 111110
5SELECT `TourType`.`id`, `TourType`.`typename` FROM `trekasur_db1`.`tour_types` AS `TourType` WHERE 1 = 1440
6SELECT `TourCountry`.`id`, `TourCountry`.`countryname` FROM `trekasur_db1`.`tour_countries` AS `TourCountry` WHERE 1 = 1440
7SELECT `TourActivity`.`id`, `TourActivity`.`activityname` FROM `trekasur_db1`.`tour_activities` AS `TourActivity` WHERE 1 = 112120
8SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`name`, `Review`.`email`, `Review`.`mobile`, `Review`.`city`, `Review`.`country`, `Review`.`subject`, `Review`.`message`, `Review`.`scrapped_message`, `Review`.`type`, `Review`.`is_testimonial`, `Review`.`priority`, `Review`.`status`, `Review`.`created`, `Review`.`modified` FROM `trekasur_db1`.`reviews` AS `Review` WHERE ((`Review`.`is_testimonial` = 1) AND (`Review`.`status` = 1)) ORDER BY `Review`.`priority` asc LIMIT 10111
9SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trekking' AND `Tour`.`status` = 'active' LIMIT 1111
10SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (5) 000
11SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (5) 220
12SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (5) 000
13SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trekking' AND `Tour`.`status` = 'active'112
14SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Expeditions' AND `Tour`.`status` = 'active' LIMIT 1111
15SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (57) 000
16SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (57) 000
17SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (57) 000
18SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Expeditions' AND `Tour`.`status` = 'active'110
19SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Climbing' AND `Tour`.`status` = 'active' LIMIT 10014
20SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Climbing' AND `Tour`.`status` = 'active'110
21SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trips' AND `Tour`.`status` = 'active' LIMIT 1002
22SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Trips' AND `Tour`.`status` = 'active'110
23SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Adventure for Women' AND `Tour`.`status` = 'active' LIMIT 1110
24SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (74) 770
25SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (74) 000
26SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (74) 000
27SELECT COUNT(*) AS `count` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`tourstyle` = 'Adventure for Women' AND `Tour`.`status` = 'active'110
28SELECT `Seo`.`meta` FROM `trekasur_db1`.`seos` AS `Seo` WHERE `Seo`.`id` = 'trekasur' LIMIT 1110
29SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE `Tour`.`status` = 'active' AND `Tour`.`title_url` = 'goecha-la-trek-16days' LIMIT 1111
30SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` = (60) 990
31SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` = (60) 000
32SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` = (60) 000
33SELECT `Tour`.`id`, `Tour`.`title`, `Tour`.`title_url`, `Tour`.`tagline`, `Tour`.`shortdetails`, `Tour`.`tourtype`, `Tour`.`tourcountry`, `Tour`.`tourstart`, `Tour`.`tourend`, `Tour`.`tourroute`, `Tour`.`activity`, `Tour`.`activity_per_day`, `Tour`.`bestseason`, `Tour`.`tourstyle`, `Tour`.`difficulty_level`, `Tour`.`groupsize`, `Tour`.`maxseats`, `Tour`.`dayspan`, `Tour`.`cost`, `Tour`.`offeredcost`, `Tour`.`videoframe`, `Tour`.`locationtitle`, `Tour`.`lattitude`, `Tour`.`longitude`, `Tour`.`altitude`, `Tour`.`locationdescription`, `Tour`.`body`, `Tour`.`detailedItinery`, `Tour`.`priceAndDeparture`, `Tour`.`includesAndExcludes`, `Tour`.`equipment`, `Tour`.`faqs`, `Tour`.`highlights`, `Tour`.`extensions`, `Tour`.`author`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`user_id`, `Tour`.`status`, `Tour`.`priority`, `Tour`.`banner`, `Tour`.`liked`, `Tour`.`wished`, `Tour`.`offer` FROM `trekasur_db1`.`tours` AS `Tour` WHERE NOT (`Tour`.`id` = 60) AND `Tour`.`tourstyle` = 'Trekking' AND `Tour`.`tourcountry` = 'India' AND `Tour`.`status` = 'active' LIMIT 3331
34SELECT `TourSchedule`.`id`, `TourSchedule`.`tour_id`, `TourSchedule`.`start_date`, `TourSchedule`.`end_date`, `TourSchedule`.`status`, `TourSchedule`.`created`, `TourSchedule`.`modified` FROM `trekasur_db1`.`tour_schedules` AS `TourSchedule` WHERE `TourSchedule`.`tour_id` IN (66, 67, 69) 14140
35SELECT `UserActivity`.`id`, `UserActivity`.`tour_id`, `UserActivity`.`activity_value`, `UserActivity`.`user_id`, `UserActivity`.`created`, `UserActivity`.`modified` FROM `trekasur_db1`.`user_activities` AS `UserActivity` WHERE `UserActivity`.`tour_id` IN (66, 67, 69) 000
36SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`is_spam`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `trekasur_db1`.`comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (66, 67, 69) 000
37SELECT `Comment`.`author_email`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`id`, `Comment`.`user_id`, `Comment`.`foreign_key`, `Comment`.`parent_id`, `Comment`.`approved`, `Comment`.`title`, `Comment`.`body`, `Comment`.`slug`, `Comment`.`created`, `Tour`.`id`, `UserModel`.`id`, `UserModel`.`username`, `UserModel`.`slug` FROM `trekasur_db1`.`comments` AS `Comment` LEFT JOIN `trekasur_db1`.`tours` AS `Tour` ON (`Comment`.`foreign_key` = `Tour`.`id`) LEFT JOIN `trekasur_db1`.`users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Tour`.`id` = 60 AND `Comment`.`model` = 'Tour' AND `Comment`.`is_spam` IN ('clean', 'ham') ORDER BY `Comment`.`parent_id` asc, `Comment`.`created` asc000