Blog listing by tag Mai Chau Info

Top Best Ways To Travel From Hanoi To Mai Chau, Viet Nam

14 March, 2024 Sunny Nguyen Duong

Mai Chau, nestled in the Hoa Binh Province of northern Vietnam, is a serene valley ensconced by lush mountains and vibrant rice paddies and renowned for its breathtaking natural beauty... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00093221664428711
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00033998489379883
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.0024130344390869
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.0019209384918213
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.0020129680633545
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.0018210411071777
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.0017800331115723
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.0001978874206543
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.00087404251098633
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020503997802734
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.00085616111755371
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001828670501709
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='mai-chau-info' limit 0,1	0.0020549297332764
15	SELECT * FROM default_tag WHERE tag_id='290'	0.00015902519226074
16	SELECT title FROM default_tag WHERE tag_id='290'	0.00013589859008789
17	SELECT * FROM default_tag WHERE tag_id='290'	0.00022697448730469
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 '%\|290\|%')	0.004274845123291
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 '%\|290\|%') order by order_no ASC LIMIT 0,6	0.0023751258850098
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.00082612037658691
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018882751464844
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.00083804130554199
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.001802921295166
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/mai-chau-info' or config_link='/blog/tag/mai-chau-info') limit 1	0.0028998851776123
26	SELECT slug FROM default_country WHERE country_id='1'	0.0002439022064209
27	SELECT slug FROM default_country WHERE country_id='64'	0.0001370906829834
28	SELECT slug FROM default_country WHERE country_id='3'	0.00012588500976562
29	SELECT slug FROM default_country WHERE country_id='7'	0.0002140998840332
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.0009160041809082
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.0017421245574951
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.0017580986022949
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.0017540454864502
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.0018060207366943
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.0018680095672607
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00017619132995605
38	SELECT slug FROM default_country WHERE country_id='1'	0.00017094612121582
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00015711784362793
40	SELECT slug FROM default_country WHERE country_id='1'	0.00015497207641602
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00014185905456543
42	SELECT slug FROM default_country WHERE country_id='1'	0.00012993812561035
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.0002140998840332
44	SELECT slug FROM default_country WHERE country_id='1'	0.00020194053649902
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00018692016601562
46	SELECT slug FROM default_country WHERE country_id='1'	0.00017404556274414
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.00014400482177734
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00013208389282227
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.0017309188842773
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00012803077697754
52	SELECT slug FROM default_country WHERE country_id='64'	0.00023102760314941
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00025606155395508
54	SELECT slug FROM default_country WHERE country_id='64'	0.00014710426330566
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00013399124145508
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.0017571449279785
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00015401840209961
58	SELECT slug FROM default_country WHERE country_id='3'	0.00014305114746094
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00012683868408203
60	SELECT slug FROM default_country WHERE country_id='3'	0.0002140998840332
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00020194053649902
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.0017979145050049
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00019598007202148
64	SELECT slug FROM default_country WHERE country_id='7'	0.00018310546875
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00016617774963379
66	SELECT slug FROM default_country WHERE country_id='7'	0.0001521110534668
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00013494491577148
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00013589859008789
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00021696090698242
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00020313262939453
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00018095970153809
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00016593933105469
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00014400482177734
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00012779235839844
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00020599365234375
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00019001960754395
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00016903877258301
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00016283988952637
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00014710426330566
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00013208389282227
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00021004676818848
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00019598007202148
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00017309188842773
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00015616416931152
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00013399124145508
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.0012080669403076
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022506713867188
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.0029220581054688
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00024986267089844
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.0029881000518799
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.0029499530792236
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00017499923706055
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.0029170513153076
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.0024120807647705
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00019478797912598
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.0017621517181396
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.0017111301422119
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00019502639770508
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.0017750263214111
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.0017349720001221
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00022220611572266
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.0018050670623779
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.0017530918121338
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.0001368522644043
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.0017819404602051
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.0018460750579834
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.00081491470336914
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.0018119812011719
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00019598007202148
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.0017580986022949
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.0017509460449219
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.0001370906829834
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.0017809867858887
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.0017478466033936
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.00082516670227051
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.0018010139465332
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.0008552074432373
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018215179443359
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.0018010139465332
122	SELECT title FROM default_tag WHERE tag_id='290'	0.00022196769714355
123	SELECT title FROM default_blog WHERE blog_id='365'	0.00014090538024902
124	SELECT slug FROM default_blog WHERE blog_id='365'	0.00012302398681641
125	SELECT author FROM default_blog WHERE blog_id='365'	0.00013184547424316
126	SELECT author FROM default_blog WHERE blog_id='365'	0.0002131462097168
127	SELECT image FROM default_blog WHERE blog_id='365'	0.00019407272338867
128	SELECT image FROM default_blog WHERE blog_id='365'	0.00017786026000977
129	SELECT intro FROM default_blog WHERE blog_id='365'	0.00016689300537109
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.0018570423126221
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.0021231174468994
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.0022850036621094
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.0020220279693604
134	SELECT slug FROM default_country WHERE country_id='1'	0.00020694732666016
135	SELECT slug FROM default_country WHERE country_id='64'	0.00020098686218262
136	SELECT slug FROM default_country WHERE country_id='3'	0.00019192695617676
137	SELECT slug FROM default_country WHERE country_id='7'	0.0001828670501709
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.00086688995361328
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.0018999576568604
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.0002129077911377
142	SELECT title FROM _country WHERE country_id='193'	0.00022220611572266
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00013899803161621
144	SELECT title FROM _country WHERE country_id='103'	0.00022292137145996
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00013399124145508
146	SELECT title FROM _country WHERE country_id='229'	0.00021696090698242
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00012803077697754
148	SELECT title FROM _country WHERE country_id='14'	0.00020980834960938
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00021910667419434
150	SELECT title FROM _country WHERE country_id='175'	0.00020313262939453
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00021195411682129
152	SELECT title FROM _country WHERE country_id='228'	0.00019502639770508
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00020599365234375
154	SELECT title FROM _country WHERE country_id='42'	0.00018882751464844
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.0001988410949707
156	SELECT title FROM _country WHERE country_id='134'	0.00018119812011719
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00018906593322754
158	SELECT title FROM _country WHERE country_id='77'	0.00017213821411133
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.00089502334594727
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018692016601562
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.00084805488586426
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875
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.00081491470336914
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018119812011719
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.00077700614929199
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018095970153809
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.00087094306945801
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018119812011719
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.00081014633178711
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018000602722168

Blog listing by tag Mai Chau Info

Top Best Ways To Travel From Hanoi To 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