Found 6 "Mu Cang Chai"

Tours 1
Blog 5

Found 1 Tours

Enchanting Mu Cang Chai Delight 3 Days

5.0 (5)

" Great experience in the North Vietnam with..." - Lewis Barrie

From

Per traveler

Found 5 Blog

Travel tips • 14 March, 2024

How To Get To Mu Cang Chai From Hanoi: A Guide For Adventurous Travelers

Mu Cang Chai is a stunning rural district located in the Yen Bai Province of northern Vietnam and renowned for its breathtaking terraced rice fields, Mu Cang Chai attracts travelers seeking natural beauty...

Travel tips • 14 March, 2024

Mu Cang Chai Weather: Discover The Best Time To Visit Mu Cang Chai, Yen Bai

Situated in the Northwest mountainous region, Mu Cang Chai is a district within Yen Bai province, renowned for its distinctive landscapes and designated as a national scenic relic...

Accommodations • 07 March, 2024

Top Best Places To Stay In Mu Cang Chai, Vietnam

Mu Cang Chai is one of the destinations not to be missed if visitors want to see the magnificent rice terraces of Vietnam, it will bring visitors back to mother nature, hidden beauty of the Northwest mountains...

Cuisine • 27 February, 2024

Top 08 Best Delicious Specialties In Mu Cang Chai, Vietnam

Mu Cang Chai emerges as a destination that evokes a genuine connection with travelers embarking on their quest to uncover the enchantments of the Northwest...

Destination • 21 February, 2024

Top 07 Best Things To Do In Mu Cang Chai, Vietnam

Mu Cang Chai in Yen Bai, Vietnam, presents a breathtaking natural tapestry that captures the heart and soul of the country's beauty...

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='search'	0.0010700225830078
2	SELECT COUNT(*) AS totalitem FROM default_module WHERE site='FRONTPAGE' and name='search'	0.00028300285339355
3	SELECT * FROM default_setting WHERE setting_id='1'	0.00034499168395996
4	SELECT country_id,title,slug,intro,image,image_menu FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no ASC	0.0024058818817139
5	SELECT country_id,title,slug FROM default_country WHERE lang_id='' and is_trash=0 and is_online=1 AND country_id IN (SELECT country_id FROM default_hotel WHERE is_trash=0 and is_online=1) order by order_no asc	0.0029480457305908
6	SELECT tourcat_id,title,slug,image FROM default_tour_category WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0022530555725098
7	SELECT tour_id,list_cat_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and is_multi_country=1	0.0023829936981201
8	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0022602081298828
9	SELECT tour_property_id FROM default_tour_property WHERE lang_id='' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.002295970916748
10	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00023889541625977
11	SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00091195106506348
12	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023198127746582
13	SELECT * FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00092315673828125
14	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
15	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and (title LIKE '%Mu Cang Chai%' OR slug LIKE '%mu-cang-chai%') order by order_no asc	0.0026059150695801
16	SELECT fullname,content FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and type='tour' and table_id='612' order by reg_date DESC limit 0,1	0.0051469802856445
17	SELECT cruise_id,title,slug,star_number,about,image,departure_port FROM default_cruise WHERE lang_id='' and is_trash=0 and is_online=1 and (title LIKE '%Mu Cang Chai%' OR slug LIKE '%mu-cang-chai%') order by order_no asc	0.0024340152740479
18	SELECT hotel_id,order_no FROM default_hotel WHERE lang_id='' and is_trash=0 and is_online=1 and (title LIKE '%Mu Cang Chai%' OR slug LIKE '%mu-cang-chai%') order by order_no asc	0.0026800632476807
19	SELECT voucher_id,slug,title,image,price,unit FROM default_voucher WHERE lang_id='' and is_trash=0 and is_online=1 and (title LIKE '%Mu Cang Chai%' OR slug LIKE '%mu-cang-chai%') order by order_no asc	0.0022118091583252
20	SELECT news_id,title,slug,intro,reg_date,newscat_id,order_no,image FROM default_news WHERE lang_id='' and is_trash=0 and is_online=1 and (title LIKE '%Mu Cang Chai%' OR slug LIKE '%mu-cang-chai%') order by order_no asc	0.0025291442871094
21	SELECT blog_id,title,slug,intro,publish_date,order_no,cat_id FROM default_blog WHERE lang_id='' and is_trash=0 and is_online=1 and is_approve=1 and (title LIKE '%Mu Cang Chai%' OR slug LIKE '%mu-cang-chai%') order by order_no asc	0.0029878616333008
22	SELECT * FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0009009838104248
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024509429931641
24	SELECT page_id,title,slug FROM default_page WHERE lang_id='' and is_trash=0 and is_online=1 and page_id <>'1' order by order_no asc	0.0022118091583252
25	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/search?keyword=Mu+Cang+Chai' or config_link='/search?keyword=Mu Cang Chai') limit 1	0.0031790733337402
26	SELECT slug FROM default_country WHERE country_id='1'	0.00022792816162109
27	SELECT slug FROM default_country WHERE country_id='64'	0.00015997886657715
28	SELECT slug FROM default_country WHERE country_id='3'	0.00018501281738281
29	SELECT slug FROM default_country WHERE country_id='7'	0.0002129077911377
30	SELECT * FROM default_featurepackage WHERE mod_page='tour_exhautive' and act_page='category_country' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00098896026611328
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021815299987793
32	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0021581649780273
33	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC	0.0022039413452148
34	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC	0.002269983291626
35	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC	0.0021610260009766
36	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' order by order_no ASC	0.0022068023681641
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00024294853210449
38	SELECT slug FROM default_country WHERE country_id='1'	0.00016021728515625
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00022196769714355
40	SELECT slug FROM default_country WHERE country_id='1'	0.00029611587524414
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00021910667419434
42	SELECT slug FROM default_country WHERE country_id='1'	0.00023198127746582
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00024914741516113
44	SELECT slug FROM default_country WHERE country_id='1'	0.00016307830810547
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00017404556274414
46	SELECT slug FROM default_country WHERE country_id='1'	0.00018906593322754
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00020098686218262
48	SELECT slug FROM default_country WHERE country_id='1'	0.00021100044250488
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00022983551025391
50	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='64' order by order_no ASC	0.0021719932556152
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.0002138614654541
52	SELECT slug FROM default_country WHERE country_id='64'	0.00024104118347168
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00016188621520996
54	SELECT slug FROM default_country WHERE country_id='64'	0.00017786026000977
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00019311904907227
56	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='3' order by order_no ASC	0.002251148223877
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00018000602722168
58	SELECT slug FROM default_country WHERE country_id='3'	0.00019407272338867
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00021004676818848
60	SELECT slug FROM default_country WHERE country_id='3'	0.00022792816162109
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.0002439022064209
62	SELECT category_country_id,cat_id FROM default_category_country WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='7' order by order_no ASC	0.0021810531616211
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00021219253540039
64	SELECT slug FROM default_country WHERE country_id='7'	0.0002291202545166
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00024890899658203
66	SELECT slug FROM default_country WHERE country_id='7'	0.0001680850982666
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00018000602722168
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.0002129077911377
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00022602081298828
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00023889541625977
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00024700164794922
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00015807151794434
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00016283988952637
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00017094612121582
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.0001828670501709
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00019216537475586
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00020003318786621
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00022006034851074
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00025296211242676
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00017404556274414
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00029206275939941
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00024509429931641
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00017905235290527
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00019693374633789
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00022411346435547
86	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00085616111755371
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022697448730469
88	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='51' and is_trash=0 and is_online=1 order by order_no ASC	0.0022289752960205
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00025177001953125
90	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC	0.0021889209747314
91	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='49' and is_trash=0 and is_online=1 order by order_no ASC	0.0021560192108154
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00016999244689941
93	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC	0.002161979675293
94	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='6' and is_trash=0 and is_online=1 order by order_no ASC	0.0021331310272217
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00024509429931641
96	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC	0.0022151470184326
97	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='50' and is_trash=0 and is_online=1 order by order_no ASC	0.0022320747375488
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00025606155395508
99	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC	0.0021138191223145
100	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='7' and is_trash=0 and is_online=1 order by order_no ASC	0.0021998882293701
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00021505355834961
102	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC	0.0021679401397705
103	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='4' and is_trash=0 and is_online=1 order by order_no ASC	0.0021681785583496
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00018596649169922
105	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC	0.0021719932556152
106	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='2' and is_trash=0 and is_online=1 order by order_no ASC	0.0021731853485107
107	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00091290473937988
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021219253540039
109	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='57' and is_trash=0 and is_online=1 order by order_no ASC	0.0021710395812988
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00018310546875
111	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC	0.0021309852600098
112	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='58' and is_trash=0 and is_online=1 order by order_no ASC	0.0022289752960205
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00024294853210449
114	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC	0.0021169185638428
115	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='59' and is_trash=0 and is_online=1 order by order_no ASC	0.0021810531616211
116	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00091195106506348
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020909309387207
118	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='60' and is_trash=0 and is_online=1 order by order_no ASC	0.0021519660949707
119	SELECT * FROM default_featurepackage WHERE mod_page='cruise' and act_page='cruise_sub_category' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00089001655578613
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
121	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='54' and is_trash=0 and is_online=1 order by order_no ASC	0.0022459030151367
122	SELECT title FROM default_news WHERE news_id=''	0.00019598007202148
123	SELECT intro FROM default_news WHERE news_id=''	0.00019693374633789
124	SELECT slug FROM default_country WHERE country_id='1'	0.00025510787963867
125	SELECT title FROM default_country WHERE country_id='1'	0.00019097328186035
126	SELECT title FROM default_country WHERE country_id='1'	0.00020480155944824
127	SELECT * FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00093603134155273
128	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
129	SELECT * FROM default_reviews WHERE lang_id='' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '612' and type='tour'	0.0052008628845215
130	SELECT reviews_id,country_id FROM default_reviews WHERE lang_id='' and table_id = '612' AND type ='tour' AND is_trash=0 AND is_online = 1 ORDER BY order_no DESC	0.0048890113830566
131	SELECT image FROM default_tour WHERE tour_id='612'	0.00022196769714355
132	SELECT fullname FROM default_reviews WHERE reviews_id='292'	0.00024890899658203
133	SELECT title FROM _country WHERE country_id='42'	0.00018095970153809
134	SELECT content FROM default_reviews WHERE reviews_id='292'	0.00019693374633789
135	SELECT class_flag FROM _country WHERE country_id='42'	0.00024008750915527
136	SELECT author FROM default_blog WHERE blog_id='351'	0.0001978874206543
137	SELECT image FROM default_blog WHERE blog_id='351'	0.00018692016601562
138	SELECT title FROM default_blogcat WHERE blogcat_id='1'	0.00020909309387207
139	SELECT author FROM default_blog WHERE blog_id='350'	0.00015401840209961
140	SELECT image FROM default_blog WHERE blog_id='350'	0.00015687942504883
141	SELECT title FROM default_blogcat WHERE blogcat_id='1'	0.00016999244689941
142	SELECT author FROM default_blog WHERE blog_id='254'	0.00018906593322754
143	SELECT image FROM default_blog WHERE blog_id='254'	0.00020194053649902
144	SELECT title FROM default_blogcat WHERE blogcat_id='19'	0.00021600723266602
145	SELECT author FROM default_blog WHERE blog_id='177'	0.0001521110534668
146	SELECT image FROM default_blog WHERE blog_id='177'	0.00015878677368164
147	SELECT title FROM default_blogcat WHERE blogcat_id='5'	0.00017499923706055
148	SELECT author FROM default_blog WHERE blog_id='144'	0.0002281665802002
149	SELECT image FROM default_blog WHERE blog_id='144'	0.00024104118347168
150	SELECT title FROM default_blogcat WHERE blogcat_id='6'	0.00015902519226074
151	SELECT * FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0010249614715576
152	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022506713867188
153	SELECT * FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00091290473937988
154	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021100044250488
155	SELECT * FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0009009838104248
156	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021100044250488
157	SELECT * FROM default_featurepackage WHERE mod_page='download' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00088596343994141
158	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
159	SELECT * FROM default_featurepackage WHERE mod_page='news' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.000885009765625
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002129077911377
161	SELECT * FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00093507766723633
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021004676818848

Found 1 Tours

Enchanting Mu Cang Chai Delight 3 Days

Found 5 Blog

How To Get To Mu Cang Chai From Hanoi: A Guide For Adventurous Travelers

Mu Cang Chai Weather: Discover The Best Time To Visit Mu Cang Chai, Yen Bai

Top Best Places To Stay In Mu Cang Chai, Vietnam

Top 08 Best Delicious Specialties In Mu Cang Chai, Vietnam

Top 07 Best Things To Do In Mu Cang Chai, Vietnam

Information

Travel Styles

Other

Follow Us

Payment Channel