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.0010309219360352
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00038504600524902
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.0030510425567627
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.0037848949432373
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.0029840469360352
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.0031678676605225
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.0020449161529541
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.0019478797912598
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00024700164794922
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.0010249614715576
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026798248291016
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.0010712146759033
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025296211242676
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='mai-chau-info' limit 0,1	0.0025880336761475
15	SELECT * FROM default_tag WHERE tag_id='290'	0.00025701522827148
16	SELECT title FROM default_tag WHERE tag_id='290'	0.00018405914306641
17	SELECT * FROM default_tag WHERE tag_id='290'	0.0002288818359375
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.0048809051513672
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.0023880004882812
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.00081586837768555
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018811225891113
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.00082516670227051
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017499923706055
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.00180983543396
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.0027990341186523
26	SELECT slug FROM default_country WHERE country_id='1'	0.00026202201843262
27	SELECT slug FROM default_country WHERE country_id='64'	0.00018811225891113
28	SELECT slug FROM default_country WHERE country_id='3'	0.00020503997802734
29	SELECT slug FROM default_country WHERE country_id='7'	0.00022196769714355
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.0010719299316406
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022602081298828
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.0020229816436768
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.0019090175628662
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.0019230842590332
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.0018930435180664
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.0018801689147949
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00021719932556152
38	SELECT slug FROM default_country WHERE country_id='1'	0.00023508071899414
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00014901161193848
40	SELECT slug FROM default_country WHERE country_id='1'	0.00016379356384277
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00017714500427246
42	SELECT slug FROM default_country WHERE country_id='1'	0.00018715858459473
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.0001981258392334
44	SELECT slug FROM default_country WHERE country_id='1'	0.00021004676818848
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00022006034851074
46	SELECT slug FROM default_country WHERE country_id='1'	0.00023794174194336
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00014495849609375
48	SELECT slug FROM default_country WHERE country_id='1'	0.00015687942504883
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00017094612121582
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.0018868446350098
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.0002129077911377
52	SELECT slug FROM default_country WHERE country_id='64'	0.00022482872009277
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00024104118347168
54	SELECT slug FROM default_country WHERE country_id='64'	0.00014996528625488
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00016283988952637
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.0018939971923828
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00026583671569824
58	SELECT slug FROM default_country WHERE country_id='3'	0.0001828670501709
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00019288063049316
60	SELECT slug FROM default_country WHERE country_id='3'	0.00021100044250488
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00023293495178223
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.0017969608306885
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00022292137145996
64	SELECT slug FROM default_country WHERE country_id='7'	0.00023698806762695
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00015687942504883
66	SELECT slug FROM default_country WHERE country_id='7'	0.00023388862609863
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00028014183044434
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00023603439331055
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00027298927307129
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00022387504577637
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00025582313537598
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00019097328186035
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00022697448730469
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00026893615722656
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00020503997802734
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00025200843811035
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00019097328186035
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00023412704467773
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.0002739429473877
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00021696090698242
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00025701522827148
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00020313262939453
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00025200843811035
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00019717216491699
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00024604797363281
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.00096988677978516
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024890899658203
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.0019569396972656
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00020313262939453
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.0020720958709717
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.0019900798797607
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00023603439331055
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.0019340515136719
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.0019791126251221
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00022602081298828
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.001957893371582
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.0019481182098389
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00016498565673828
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.0018088817596436
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.0018839836120605
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00020480155944824
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.0022242069244385
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.0018699169158936
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00015807151794434
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.0017440319061279
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.0019388198852539
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.00084900856018066
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001981258392334
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.0018129348754883
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.0002138614654541
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.001788854598999
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.0017790794372559
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00018405914306641
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.0017929077148438
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.0018248558044434
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.00087690353393555
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019502639770508
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.0017650127410889
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.00082206726074219
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.0017900466918945
122	SELECT title FROM default_tag WHERE tag_id='290'	0.00020384788513184
123	SELECT title FROM default_blog WHERE blog_id='365'	0.00023484230041504
124	SELECT slug FROM default_blog WHERE blog_id='365'	0.00022006034851074
125	SELECT author FROM default_blog WHERE blog_id='365'	0.00014901161193848
126	SELECT author FROM default_blog WHERE blog_id='365'	0.00012898445129395
127	SELECT image FROM default_blog WHERE blog_id='365'	0.00021100044250488
128	SELECT image FROM default_blog WHERE blog_id='365'	0.0001990795135498
129	SELECT intro FROM default_blog WHERE blog_id='365'	0.00018787384033203
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.0019338130950928
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.0021858215332031
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.0023159980773926
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.002039909362793
134	SELECT slug FROM default_country WHERE country_id='1'	0.00017118453979492
135	SELECT slug FROM default_country WHERE country_id='64'	0.0001671314239502
136	SELECT slug FROM default_country WHERE country_id='3'	0.00015807151794434
137	SELECT slug FROM default_country WHERE country_id='7'	0.00014901161193848
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.00089907646179199
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019502639770508
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.0018839836120605
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00020599365234375
142	SELECT title FROM _country WHERE country_id='193'	0.00020694732666016
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00022292137145996
144	SELECT title FROM _country WHERE country_id='103'	0.00023388862609863
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00014996528625488
146	SELECT title FROM _country WHERE country_id='229'	0.00013494491577148
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00014591217041016
148	SELECT title FROM _country WHERE country_id='14'	0.00012993812561035
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00013899803161621
150	SELECT title FROM _country WHERE country_id='175'	0.00022101402282715
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00013113021850586
152	SELECT title FROM _country WHERE country_id='228'	0.00021505355834961
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00012493133544922
154	SELECT title FROM _country WHERE country_id='42'	0.00022578239440918
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.0001368522644043
156	SELECT title FROM _country WHERE country_id='134'	0.00021910667419434
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00012898445129395
158	SELECT title FROM _country WHERE country_id='77'	0.00021004676818848
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.00082492828369141
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001978874206543
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.00080323219299316
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018095970153809
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.00086092948913574
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001828670501709
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.00082778930664062
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018405914306641
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.00081515312194824
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.00084996223449707
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875

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