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!

 
 
 
 
 
Pokhara Royal Trek 10 Day
Prokharan Royal Trek-10days-test

Known as the "Royal Trek" because this route was traversed by Prince Charles of England and luminaries like Mick Jagger. It’s a small trek in the Annaupurna region starting from Pokhara after driving to Bijaypur Khola, taking you on a four-day loop through the Himalayan foothills ending up at Begnas where we catch a boat across the lake then drive back to Pokhara. This is a very enjoyable short trek, especially for those who don't have time for a longer trek or an expedition. The beauty of this trek is that it still offers spectacular views of Annapurna I, Annapurna II, Annapurna III, Annapurna IV, Machapuchre, Lamjung Himal, Dhaulagiri and other surrounding peaks providing an insight to the simple way of village life. There are no facilities, hotels or lodges, so groups and their staff must be fully self-sufficient, this trek is only possible as a camping trek.

Tour Type Trekking
Tour Route KTM-Pokhara-Shaklung-Begnas Lake-Pokhara-KTM.
Country Nepal
Activity Guided Tour & Trekking
Best Season February,March,April,May,June,September,October,November,December
Altitude 1,730 m /5674.4 ft
Activity per day Approx. 5-6 hrs

Private city guided tour in Kathmandu – Explore Annapurna’s Royal visited trail, encounter different varied cultural regions in front of Himalayas – dramatic views of the snow capped Annapurna Himalayan panorama, Mt Manaslu, Western Himalayan range’s giant Dhaulagiri- view point visit for best photographic, Ideal for both camping and lodge trek beautiful eco hamlet lodges foods and typical hill terraced cultural lifestyle and more…. Ideal for every age groups … family holiday destination.

  • Privat

    P

    Private city guided tour in Kathmandu – Explore Annapurna’s Royal visited trail, encounter different varied cultural regions in front of Himalayas – dramatic views of the snow capped Annapurna Himalayan panorama, Mt Manaslu, Western Himalayan range’s giant Dhaulagiri- view point visit for best photographic, Ideal for both camping and lodge trek beautiful eco hamlet lodges foods and typical hill terraced cultural lifestyle and more…. Ideal for every age groups … family holiday destination.

    Private city guided tour in Kathmandu – Explore Annapurna’s Royal visited trail, encounter different varied cultural regions in front of Himalayas – dramatic views of the snow capped Annapurna Himalayan panorama, Mt Manaslu, Western Himalayan range’s giant Dhaulagiri- view point visit for best photographic, Ideal for both camping and lodge trek beautiful eco hamlet lodges foods and typical hill terraced cultural lifestyle and more…. Ideal for every age groups … family holiday destination.

    Private city guided tour in Kathmandu – Explore Annapurna’s Royal visited trail, encounter different varied cultural regions in front of Himalayas – dramatic views of the snow capped Annapurna Himalayan panorama, Mt Manaslu, Western Himalayan range’s giant Dhaulagiri- view point visit for best photographic, Ideal for both camping and lodge trek beautiful eco hamlet lodges foods and typical hill terraced cultural lifestyle and more…. Ideal for every age groups … family holiday destination.

    rivate city guided tour in Kathmandu – Explore Annapurna’s Royal visited trail, encounter different varied cultural regions in front of Himalayas – dramatic views of the snow capped Annapurna Himalayan panorama, Mt Manaslu, Western Himalayan range’s giant Dhaulagiri- view point visit for best photographic, Ideal for both camping and lodge trek beautiful eco hamlet lodges foods and typical hill terraced cultural lifestyle and more…. Ideal for every age groups … family holiday destination.

    e city guided tour in Kathmandu – Explore Annapurna’s Royal visited trail, encounter different varied cultural regions in front of Himalayas – dramatic views of the snow capped Annapurna Himalayan panorama, Mt Manaslu, Western Himalayan range’s giant Dhaulagiri- view point visit for best photographic, Ideal for both camping and lodge trek beautiful eco hamlet lodges foods and typical hill terraced cultural lifestyle and more…. Ideal for every age groups … family holiday destination.

    Exploring the temples, shrines, bazaars and restaurants of Kathmandu
  • Scenic flight to and from Lukla
  • Step inside and experience life as the “mountain people” live, in the heart of Himalaya
  • Visiting Tengboche Monastery
  • Impressive views of Khumbu Ice fall
  • Everest Base Camp, walking on the Khumbu glacier, Climbing Kalapattar
  • Attempting Island Peak

Known as the "Royal Trek" because this route was traversed by Prince Charles of England and luminaries like Mick Jagger. It’s a small trek in the Annaupurna region starting from Pokhara after driving to Bijaypur Khola, taking you on a four-day loop through the Himalayan foothills ending up at Begnas where we catch a boat across the lake then drive back to Pokhara. This is a very enjoyable short trek, especially for those who don't have time for a longer trek or an expedition. The beauty of this trek is that it still offers spectacular views of Annapurna I, Annapurna II, Annapurna III, Annapurna IV, Machapuchre, Lamjung Himal, Dhaulagiri and other surrounding peaks providing an insight to the simple way of village life. There are no facilities, hotels or lodges, so groups and their staff must be fully self-sufficient, this trek is only possible as a camping trek.

Itinerary

Day  01 - Arrival at the Tribuwan International Airport in Kathmandu (1,345m).Overnight at a hotel.

Day  02 - Pre-trip meeting and sightseeing around the Kathmandu valley. Overnight at a hotel.

Day 03 - Drive to Pokhara (200km m) by tourist bus - 7 hrs. Overnight at a hotel.

Day 04 - Drive to Bijayapur - 30 mins. Trek to Kalikathan (1,370m) - 4 hrs. Overnight at Tea House.

Day 05 - Trek to Shaklung (1,730m) - 4 hrs. Overnight at Tea House.

Day 06 - Trek to Chisopani - 4 hrs. Overnight at Tea House.

Day 07 - Trek to Begnas Lake. Drive to Pokhara - 30 mins. Overnight at a hotel.

Day 08 - Pokhara City tour. Overnight at a hotel.

Day 09 - Drive back to Kathmandu (1,345m) and farewell dinner. Overnight at a hotel.

Day 10 - Transfer to international airport for your final departure.

Day 01: Arrival at Kathmandu International Airport and transfer to hotel. 1350m/4428ft.

 Stay overnight at hotel in Kathmandu.  Welcome to Himalayan country of Nepal. Upon your arrival at the Tribhuvan International Airport our representative welcomes you and assists to transfer in your hotel in Kathmandu. After time to get refreshed, evening you'll meet and transfer for welcome dinner in one of the typical Nepalese restaurant in the heart of Kathmandu and briefing about your trip and overnight at Hotel.

(No Meal Included)

Day 02: Kathmandu valley sightseeing Day 1350m/4428ft.

Today you explore around Kathmandu valley which includes visit around historical and spiritual attractions; including Durbar Square, Bouddhanath; one of the largest stupas in Nepal, Swayambhunath; top on the hill in the city knows as the Monkey Temple, Pashupatinath; Hindus holy place. Stay overnight at hotel.

(Breakfast Included)

Day 03 - Drive to Pokhara (200km) by tourist bus - 7 hrs
Our trekking staff will pick you up at the hotel at 6:30am and escort you to the bus station. The bus to Pokhara leaves at around 7:30am. A beautiful valley set on the banks of the Phewa Lake, Pokhara is also known for its panoramic views of Annapurna, Machapuchare (shape of fish tail) in the north, Dhaulagiri in the west, Lamjung Himal and Manaslu in the east. It is smaller and much less hectic than Kathmandu, hence providing the perfect starting point for our trek. Overnight at a hotel.
(Breakfast Included)

Day 04 - Drive to Bijayapur - 30 mins. Trek to Kalikathan (1,370m) - 4 hrs
The journey starts in the morning at 8am with a 30-minute road drive that takes you to the Bajayapur after which you trek uphill for about 3-4 hours through Brahman and Chettri villages. Skyline camp will be set up around the Kalikasthan area. Overnight at Tea House.
(Breakfast, Lunch and Dinner Included)

Day 05 - Trek to Shaklung (1,730m) - 4 hrs
The trail continues along the forested ridge top through Thulokot to Mati Thana, where there are a few tea shop, then a moderate climb to Naudanda (not to be confused with the Naudanda west of Pokhara). Continuing along the ridge to a school at Lipini village, we make a steep but short climb through the forest to the Gurung village of Shuanmklung at 1,730m. Overnight at Tea House.
(Breakfast, Lunch and Dinner Included)

Day 06 - Trek to Chisopani - 4 hrs
The trail drops steeply down the south side of the hill to a large tree, a chautaara several tea shops and a police check post. This is a trail junction, trails lead from here west to Begnas Tal and east to the Madi Khola. The Royal Trek route climbs Chisopani winding around back of the hill to the village. A short distance above Chisopani village is a high knoll where there is a small temple. This is the Chisopani Danda, or the Chisapani ridge-top. The camp here has splendid mountain views. Overnight at Tea House.
(Breakfast, Lunch and Dinner Included)

Day 07 - Trek to Begnas Lake. Drive to Pokhara - 30 mins
The trail descends along the field for an hour or so, and then descends steeply on the stone step into a small valley near Rupa Tal. Continue for a short distance through the rice field. Then make a final ascent to the ridge that separates Begnas Tal and Rupa Tal, on a wide path you will share with many local people. From the ridge, descend into the Begnas Bajar and 30 minutes drive to Pokhara. Overnight at a hotel.
(Breakfast, Lunch Included)

Day 08 - Pokhara City tour
Your sightseeing trip will start at 9am after breakfast. Places we visit are Fewa Lake, Begnas Lake, Devi’s water fall, museums, Tibetan refugee settlement and Gupteshower cave. You will have a relaxing afternoon. Overnight at a hotel.
(Breakfast Included)

Day 09 - Drive back to Kathmandu (1,345m) 

Today, we bid goodbye to the beautiful city of Pokhara and take bus back to Kathmandu. After the Check in at hotel in Kathmandu, we are free to explore the city. Kathmandu offers a variety of activities. We can go for souvenir shopping, relax in a spa or enjoy the happening nightlife of Kathmandu. Overnight in Kathmandu

 (Breakfast Farewell Dinner Include)

 Day 10 - Transfer to international airport for your final departure.

 The journey within the mountains of Nepal comes to an end today! There is nothing to do but we just trade emails to travel companions and organize our photos. If we have more time we can do some shopping or sightseeing. At last approximately 3 hours before our scheduled flight, a representative from Touristsaga Tourism Trek escorts us to the airport. On our way to home we will have plenty of time to plan our next adventure trip in the wonderful country of Nepal.

The price Two person for the Small group Journey is fixed as stated below. Group Discounts of 15% is available for booking of Three or more than Three person. A group booking of 10 or more people is subjected to a maximum discount with the availability of free trip for one person.  If your group is much larger please contact us to discuss about the discount. There is also the option of private and tailor made journey best suited for you, your family and friends!

 

Cost Includes

Airport / Hotel / Airport pick up & drop by private tourist vehicle.

Guided city tour in Kathmandu and Pokhra by private tourist vehicle.

3 Nights accommodation with breakfast in 2/3 Star hotel on twin sharing basis in Kathmandu.

3 Nights accommodation with breakfast in 2/3 Star hotel on twin sharing basis in Pokhara.

3 Nights accommodation with all meal (Breakfast, Lunch and Dinner during Trekking in Guesthouse on twin sharing basis and occasionally dormitory style).

Touristsaga Tourism Licensed English speaking guide.

The required number of local staff and porters to carry your luggage during the trek (We assign one porter for every two guests).

Food, accommodation, salary, insurance, equipment and medicine for all staff.

Annapurna National  Park permits and TIMS permit for trekking.

All the Transfer and the transportation by tourist bus/car depending on group size.

Down Jacket and sleeping bag by TouristSaga Tourism  (which need to be returned after the trek).

Free Touristsaga Tourism Cap and  T-shirt (yours to keep).

Exclusive Medical Kit Bag.

Sightseeing/Monument entrance fees in Kathmandu..

Farewell dinner in typical Nepali Restaurant.

government taxes, vat, tourist service charges.

Official expenses.

Cost Does not Include

Lunch and dinner whilst in Kathmandu and Pokhara . (Requires approximately USD 15 to 25 per person per day)

Travel insurance which covers emergency Rescue and Evacuation.

International airfare and airport departure tax.

Nepal entry visa; you can obtain a visa easily upon your arrival at Tribhuwan International Airport in Kathmandu. (Tourist Visa with Multiple Entries for 30 days can be obtained by paying US $ 40 or equivalent foreign currency. Similarly, Tourist Visa with Multiple Entries for 90 days can be obtained by paying US $ 100. Please bring 2 copies of passport size photos).

Personal Trekking equipments

Alcoholic, hot and cold drinks.

Personal expenses (phone calls, laundry, bar bills, battery recharge, extra porters, bottled/boiled water, shower, etc.)

Tips for trekking staff (Tipping is expected).                                                 

Any others expenses which are not mentioned on 'Price Includes' section.  

The following gives you a general idea of the personal items that you can bring for the trek. The personal items are of individual interest, and choice. The most important fact that one should keep on mind is that one should have enough clothes to tackle the cold weather in the Himalayas.

In a supported trek, heavy items are carried by porters or yaks and personal belongings that you may need for the day like money, water bottle, rain gear, camera, sun cream and toilet paper etc. should be carried by yourself. So you are briefed to pack items in two different bags.

General

4 seasons Sleeping bag (Optional/we can provide one if you need it but is to be returned after the trek)

Down Jacket (Optional/we can provide if you need one but is to be returned after the trek)

Upper Body - Head / Ears / Eyes

Shade hat or baseball cap - some people drape a bandana down the back of their head and then put a baseball cap on to hold it is place. This can be a flexible alternative while keeping the sun off your ears and neck.

Warm wool or synthetic hat that cover your ears.

Balaclava - lightweight, thinner variety.

Glacier glasses-100% UV protection with side shields and a hard-sided storage case (i.e. Julbo or Cebe). This is to protect your eyes from the stronger rays of the sun due to the thinner atmosphere which can cause a painful condition known as snow blindness. Regular sunglasses are not sufficient. If you wear prescription glasses, speak to your doctor about prescription glacier glasses, perhaps with transitional lenses.

Headlamp - Black Diamond and Petzl both make several good ones. Make sure to bring extra batteries and that they are lithium batteries so that they will last in the colder temperatures. These are indispensable for getting around at night, reading, etc. so, don't go cheap here.

Some people like ear-muffs; these are optional; a good hat, balaclava, and hooded jacket should really be sufficient, but this is a personal choice for some people (optional).

A neck warmer is another piece of gear for extra warmth if you feel you will need it (optional).

Hand

1 pair liner gloves, thin wool or synthetic, useful alone on mild days or as a layer inside other gloves / mitts for additional warmth.

1 pair warm gloves (heavier fleece or wool).

1 pair shell gloves or mitts; Gore-Tex is preferred for keeping hands dry.

Instant hand warmers are always nice in a pinch, but really shouldn't be necessary on the trek. Bringing appropriate hand protection as recommended above, should be sufficient (optional).

Core Body

T-shirts (2).

Light and expedition weight thermal tops.

Fleece jacket or pullover.

Fleece Wind-Stopper jacket (optional).

Waterproof (preferably breathable fabric) shell jacket.

2 women sports bras, Synthetic, no cotton!

Lower Body – Legs

2 pairs nylon hiking shorts - Quick drying type, not cotton!

Underwear, stay away from cotton (4).

2 pairs lightweight long underwear - capilene or other synthetic.

1 pair soft shell pants - synthetic, full zip from top and bottom preferable.

2 pairs trekking pants, preferably that zip on/off at the knees so they double as shorts.

1 pair hard shell pants. Waterproof / breathable, Gore-Tex or equivalent is best. Should zip from the top and bottom - this makes it easier to put on over boots without getting undressed should the weather change once you are underway for the day.

1 pair cotton pants (loose jeans/khakis).

 All clothing should be kept dry using waterproof stuff sacks or large puncture resistant plastic bags.

Feet

 4 pairs of liner socks, synthetic or capilene.

3 pairs heavy weight socks to be worn over liner socks.

1 pair light weight socks, a good option for the lower / warmer parts of the trail.

1 pair light to medium weight water proof hiking/trekking boots. Ensure a good fit with layered socks and you have worn then before to get used to it (otherwise you will get lots of blister).

1 pair light trekking shoes or sneakers. Good for around the camp/lodges and in Kathmandu.

1 pair hiking gaiters, good for keeping dust and rocks out of your shoes / boots as well as keep your feet dry as necessary (Optional).

1 pair sandals (Optional).

Medicines and First Aid Kits

(Please note our guide will also carry the first aid kit bag during the trek. However we still recommend you to bring your personal first aid kit as well)

Extra Strength Excedrin for altitude related headaches.

Ibuprofen for general aches and pains.

Imodium or Pepto bismol capsules for upset stomach or diarrhea.

Diamox (commonly prescribed as Acetazolamide) 125 or 250mg tablets for altitude sickness. Please discuss with us before starting to take this medicine.

1 small personal sized first-aid kit with blister treatments such as mole skin, band-aids, some waterproof tape, anti-infection ointments, etc. Your guides will have more extensive medical gear, but you should have the basics for general use.

Miscellaneous, but Important !

Passport and extra passport photos (4 copies).

Airline ticket (Please make a copy and leave on at our office in KTM just in case if you need to change the date of your).

Durable wallet / pouch for travel documents, money & passport.

Lip balm. At least SPF 20, 2 sticks. A string taped to the stick is helpful, to hang around your neck and some are now being sold with a cord already attached. Handy as it avoids you from having to stop and look for it.

Pocket knife or small Swiss Army type.

Water purification Iodine tablets or Polar-pure crystals.

Toiletry kit. Be sure to include toilet paper stored in a plastic bag, hand wipes, and liquid hand sanitizer, towel, soap, etc.

2 bandanas.

Optional

1 pair adjustable trekking poles. Although these are listed as optional, these can be of great assistance to people who may think of themselves and generally clumsy or with bad knees, ankles, etc, especially when going downhill (Optional).

Favorite snack foods, no more than 2 pounds (Optional).

Paperback books, cards, mp3 player (there are a couple of stops where you could recharge. Avoid players with moving hardware as it may not function. Remember, keep these items light weight (Optional).

Binoculars (Optional).

1 light weight point & shoot camera or 1 large SLR. Digital cameras are ok, but you must keep the batteries warm when not in use (Optional).

Hydration bladder with drinking tube and tube insulator (Optional).

A pee bottle for men and pee funnel for woman, some swear by them to avoid that chilly late night trip (Optional).

1 small stainless steel thermos (Optional).

This list is only a guide. While you are required to bring everything on this list, there are numerous options, brands, and versions of each piece of equipment. Use your experience and the listed features to find the best gear for you. Some of the above equipment’s can be easily found in stores in Kathmandu for cheaper prices.

Please Note: Tight fitting, figure-hugging clothing, such as those made with Lycra can often be offensive to locals, especially to women. If you find these items comfortable as a base layer, please pack something to wear on top of them.

Related Tours
0

Everest Base Camp Luxury Trek 15days

(3 Night Kathmandu 11 Night Tea House) Everest Base Camp Trek, which ...

Book Now
0

Everest View Trek 8days

360 deg view of world's tallest mountain peaks Everest View Trek pac ...

Book Now
0

Everest Panorama Trek 10 days

(3 Night Kathmandu 6 Night Tea House) 360 deg view of world's tallest ...

Book Now
Leave a Comment
If you want to post comments, you need to login first.
(default) 37 queries took 4 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 1110
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') 94940
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.%'94940
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 10110
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 1110
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'110
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 1001
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 1001
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` = 'pokharan-royal-trek-9days' LIMIT 1110
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` = (5) 000
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` = (5) 220
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` = (5) 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` = 5) AND `Tour`.`tourstyle` = 'Trekking' AND `Tour`.`tourcountry` = 'Nepal' 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 (59, 63, 77) 000
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 (59, 63, 77) 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 (59, 63, 77) 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` = 5 AND `Comment`.`model` = 'Tour' AND `Comment`.`is_spam` IN ('clean', 'ham') ORDER BY `Comment`.`parent_id` asc, `Comment`.`created` asc000