Blog listing by tag Top Things In Mai Chau

What To Do In Mai Chau? Top 06 Activities Not To Be Missed In Mai Chau, Viet Nam

19 February, 2024 Sunny Nguyen Duong

You're looking to switch up the atmosphere, away from the bustling, lively cities, venture into peaceful and tranquil villages. Mai Chau, far west of Hoa Binh province, is an excellent choice… Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00092983245849609
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00035810470581055
3	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.0019998550415039
4	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.0025160312652588
5	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.0019431114196777
6	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.0019638538360596
7	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.0018720626831055
8	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.0018320083618164
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00020384788513184
10	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.00082111358642578
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001978874206543
12	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.00091409683227539
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017976760864258
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='top-things-in-mai-chau' limit 0,1	0.00205397605896
15	SELECT * FROM default_tag WHERE tag_id='918'	0.00015497207641602
16	SELECT title FROM default_tag WHERE tag_id='918'	0.00014686584472656
17	SELECT * FROM default_tag WHERE tag_id='918'	0.0001368522644043
18	SELECT * FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%\|918\|%')	0.0040979385375977
19	SELECT blog_id,cat_id,reg_date,publish_date FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and (list_tag_id like '%\|918\|%') order by order_no ASC LIMIT 0,6	0.0023698806762695
20	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.0008540153503418
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019598007202148
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.00086092948913574
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018000602722168
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.0018270015716553
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='/blog/tag/top-things-in-mai-chau' or config_link='/blog/tag/top-things-in-mai-chau') limit 1	0.0027668476104736
26	SELECT slug FROM default_country WHERE country_id='1'	0.00020909309387207
27	SELECT slug FROM default_country WHERE country_id='64'	0.00020098686218262
28	SELECT slug FROM default_country WHERE country_id='3'	0.00018692016601562
29	SELECT slug FROM default_country WHERE country_id='7'	0.00017285346984863
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.00085282325744629
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875
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.0018851757049561
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.001845121383667
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.0017938613891602
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.0018160343170166
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.0018811225891113
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00019598007202148
38	SELECT slug FROM default_country WHERE country_id='1'	0.00019097328186035
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00017595291137695
40	SELECT slug FROM default_country WHERE country_id='1'	0.00016403198242188
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00014901161193848
42	SELECT slug FROM default_country WHERE country_id='1'	0.0001378059387207
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00011992454528809
44	SELECT slug FROM default_country WHERE country_id='1'	0.00021100044250488
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00019192695617676
46	SELECT slug FROM default_country WHERE country_id='1'	0.00017690658569336
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00015783309936523
48	SELECT slug FROM default_country WHERE country_id='1'	0.00014209747314453
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00014805793762207
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.0017979145050049
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00019598007202148
52	SELECT slug FROM default_country WHERE country_id='64'	0.00018191337585449
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00016498565673828
54	SELECT slug FROM default_country WHERE country_id='64'	0.00015020370483398
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00013208389282227
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.0017800331115723
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00017786026000977
58	SELECT slug FROM default_country WHERE country_id='3'	0.00016903877258301
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.0001518726348877
60	SELECT slug FROM default_country WHERE country_id='3'	0.0001380443572998
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00012612342834473
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.0018408298492432
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00013399124145508
64	SELECT slug FROM default_country WHERE country_id='7'	0.00022006034851074
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.0002281665802002
66	SELECT slug FROM default_country WHERE country_id='7'	0.00021696090698242
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00020098686218262
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00020098686218262
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00018596649169922
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00018596649169922
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00016212463378906
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00014305114746094
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00011801719665527
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.0001988410949707
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00017404556274414
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00015401840209961
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00012803077697754
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00020790100097656
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00019001960754395
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00017213821411133
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00014805793762207
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00012803077697754
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00020313262939453
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00018405914306641
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00015997886657715
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.00084710121154785
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.0017619132995605
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00014901161193848
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.0017538070678711
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.0017421245574951
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00012612342834473
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.0018768310546875
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.0017569065093994
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.0001368522644043
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.0018520355224609
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.0018291473388672
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00021100044250488
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.0018110275268555
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.001798152923584
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00018000602722168
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.0018041133880615
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.0018298625946045
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00021100044250488
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.0020480155944824
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.0017240047454834
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.00088191032409668
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018191337585449
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.001917839050293
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.0001988410949707
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.0017638206481934
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.0018241405487061
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00020694732666016
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.001784086227417
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.0017609596252441
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.00092101097106934
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018095970153809
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.0018689632415771
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.00082015991210938
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875
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.001802921295166
122	SELECT title FROM default_tag WHERE tag_id='918'	0.0001990795135498
123	SELECT title FROM default_blog WHERE blog_id='129'	0.00021696090698242
124	SELECT slug FROM default_blog WHERE blog_id='129'	0.00022983551025391
125	SELECT author FROM default_blog WHERE blog_id='129'	0.0001380443572998
126	SELECT author FROM default_blog WHERE blog_id='129'	0.00021505355834961
127	SELECT image FROM default_blog WHERE blog_id='129'	0.00019311904907227
128	SELECT image FROM default_blog WHERE blog_id='129'	0.00017595291137695
129	SELECT intro FROM default_blog WHERE blog_id='129'	0.00015997886657715
130	SELECT blogcat_id, title,slug FROM default_blogcat WHERE lang_id='' and is_trash=0 and is_online=1 order by order_no asc	0.0018391609191895
131	SELECT blog_id,slug,title FROM default_blog WHERE lang_id='' and is_trash=0 and is_approve=1 and is_online=1 and num_view > 0 order by num_view desc limit 0,5	0.0022480487823486
132	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_blog WHERE is_trash=0 and is_online=1) order by order_no asc	0.0023579597473145
133	SELECT blog_extension_id,tour_id FROM default_blog_extension WHERE lang_id='' and blog_id = '' and table_name='tour' and tour_id IN (SELECT tour_id FROM default_tour WHERE is_trash=0 and is_online=1) order by order_no ASC	0.0020570755004883
134	SELECT slug FROM default_country WHERE country_id='1'	0.00017809867858887
135	SELECT slug FROM default_country WHERE country_id='64'	0.00017285346984863
136	SELECT slug FROM default_country WHERE country_id='3'	0.00019097328186035
137	SELECT slug FROM default_country WHERE country_id='7'	0.00017786026000977
138	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.00090193748474121
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
140	SELECT testimonial_id,title,slug,image,reg_date,rates,name,intro FROM default_testimonial WHERE lang_id='' and is_trash=0 and is_online = 1 and image<>'' order by order_no ASC limit 0,9	0.0019710063934326
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00015711784362793
142	SELECT title FROM _country WHERE country_id='193'	0.00015807151794434
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.0001680850982666
144	SELECT title FROM _country WHERE country_id='103'	0.00014901161193848
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00015592575073242
146	SELECT title FROM _country WHERE country_id='229'	0.0001368522644043
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00014400482177734
148	SELECT title FROM _country WHERE country_id='14'	0.00014615058898926
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.0001521110534668
150	SELECT title FROM _country WHERE country_id='175'	0.00013208389282227
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.0001380443572998
152	SELECT title FROM _country WHERE country_id='228'	0.00022006034851074
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00012683868408203
154	SELECT title FROM _country WHERE country_id='42'	0.00020813941955566
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.0002129077911377
156	SELECT title FROM _country WHERE country_id='134'	0.00019407272338867
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00020098686218262
158	SELECT title FROM _country WHERE country_id='77'	0.00018000602722168
159	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.0008389949798584
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018000602722168
161	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.00078678131103516
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527
163	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.00093293190002441
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017881393432617
165	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.00087094306945801
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527
167	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.00085306167602539
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018000602722168
169	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.00079703330993652
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019311904907227

Blog listing by tag Top Things In Mai Chau

What To Do In Mai Chau? Top 06 Activities Not To Be Missed In Mai Chau, Viet Nam

WHAT DO CUSTOMERS SAY ABOUT US?

Dream Trip In Vietnam

Fantastic Indochina

Vietnam Heritage Trail

Exotic Vietnam & Cambodia

Vietnam Holiday 15 Days

The Best Of Vietnam

Vietnam Family Vacation

Vietnam In Capture

The Essence Of Vietnam

Information

Travel Styles

Other

Follow Us

Payment Channel