Blog listing by tag Hanoi and Mai Chau Travel Tips

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.00097298622131348
2	SELECT * FROM default_setting WHERE setting_id='1'	0.0002439022064209
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.0020151138305664
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.0025548934936523
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.0018899440765381
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.0019950866699219
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.0019290447235107
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.0018858909606934
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.0002129077911377
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.00092387199401855
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020718574523926
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.0008540153503418
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='hanoi-and-mai-chau-travel-tips' limit 0,1	0.0019290447235107
15	SELECT * FROM default_tag WHERE tag_id='292'	0.00024008750915527
16	SELECT title FROM default_tag WHERE tag_id='292'	0.00022697448730469
17	SELECT * FROM default_tag WHERE tag_id='292'	0.00022506713867188
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 '%\|292\|%')	0.0044999122619629
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 '%\|292\|%') order by order_no ASC LIMIT 0,6	0.0025341510772705
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.00091004371643066
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024080276489258
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.00091099739074707
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018906593322754
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.0018851757049561
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/hanoi-and-mai-chau-travel-tips' or config_link='/blog/tag/hanoi-and-mai-chau-travel-tips') limit 1	0.0027618408203125
26	SELECT slug FROM default_country WHERE country_id='1'	0.00019598007202148
27	SELECT slug FROM default_country WHERE country_id='64'	0.0001978874206543
28	SELECT slug FROM default_country WHERE country_id='3'	0.00021600723266602
29	SELECT slug FROM default_country WHERE country_id='7'	0.00021004676818848
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.00090599060058594
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018882751464844
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.0018529891967773
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.0018069744110107
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.0018219947814941
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.0018618106842041
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.0018019676208496
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00021600723266602
38	SELECT slug FROM default_country WHERE country_id='1'	0.00021219253540039
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.0001990795135498
40	SELECT slug FROM default_country WHERE country_id='1'	0.00018906593322754
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00018596649169922
42	SELECT slug FROM default_country WHERE country_id='1'	0.00018596649169922
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00019598007202148
44	SELECT slug FROM default_country WHERE country_id='1'	0.00018882751464844
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00018620491027832
46	SELECT slug FROM default_country WHERE country_id='1'	0.00017905235290527
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016593933105469
48	SELECT slug FROM default_country WHERE country_id='1'	0.00015592575073242
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00014591217041016
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.001741886138916
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00014710426330566
52	SELECT slug FROM default_country WHERE country_id='64'	0.00014209747314453
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00013613700866699
54	SELECT slug FROM default_country WHERE country_id='64'	0.0001530647277832
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00015902519226074
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.0017850399017334
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00018715858459473
58	SELECT slug FROM default_country WHERE country_id='3'	0.00017809867858887
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00016498565673828
60	SELECT slug FROM default_country WHERE country_id='3'	0.00015497207641602
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00014686584472656
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.0017838478088379
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00019288063049316
64	SELECT slug FROM default_country WHERE country_id='7'	0.00019502639770508
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00018310546875
66	SELECT slug FROM default_country WHERE country_id='7'	0.00017404556274414
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00016188621520996
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00016498565673828
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00014996528625488
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.0001378059387207
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00022196769714355
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00020790100097656
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00018882751464844
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00017499923706055
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00015711784362793
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00014305114746094
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00012302398681641
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00022101402282715
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00020313262939453
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00021815299987793
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00020313262939453
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00019192695617676
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00017404556274414
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00016188621520996
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00014591217041016
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.00089216232299805
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018906593322754
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.0018250942230225
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00021791458129883
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.0017898082733154
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.0018200874328613
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00021100044250488
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.0017640590667725
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.0017440319061279
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00017595291137695
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.0017800331115723
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.0026791095733643
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00020289421081543
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.002781867980957
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.0023930072784424
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00018405914306641
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.0018310546875
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.0017919540405273
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00017905235290527
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.0017750263214111
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.0017321109771729
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.00082588195800781
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019192695617676
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.001784086227417
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00017094612121582
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.0017390251159668
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.0019199848175049
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00021100044250488
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.0018200874328613
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.0018610954284668
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.00084614753723145
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
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.0017209053039551
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.00092911720275879
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018811225891113
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.0017910003662109
122	SELECT title FROM default_tag WHERE tag_id='292'	0.0001990795135498
123	SELECT title FROM default_blog WHERE blog_id='365'	0.00022101402282715
124	SELECT slug FROM default_blog WHERE blog_id='365'	0.00020909309387207
125	SELECT author FROM default_blog WHERE blog_id='365'	0.00021791458129883
126	SELECT author FROM default_blog WHERE blog_id='365'	0.00020098686218262
127	SELECT image FROM default_blog WHERE blog_id='365'	0.00018596649169922
128	SELECT image FROM default_blog WHERE blog_id='365'	0.00017499923706055
129	SELECT intro FROM default_blog WHERE blog_id='365'	0.00016522407531738
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.0018000602722168
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.0021607875823975
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.002302885055542
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.0020389556884766
134	SELECT slug FROM default_country WHERE country_id='1'	0.00022292137145996
135	SELECT slug FROM default_country WHERE country_id='64'	0.00022196769714355
136	SELECT slug FROM default_country WHERE country_id='3'	0.00021600723266602
137	SELECT slug FROM default_country WHERE country_id='7'	0.00021004676818848
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.0009160041809082
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.0019030570983887
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00021600723266602
142	SELECT title FROM _country WHERE country_id='193'	0.00022387504577637
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00014495849609375
144	SELECT title FROM _country WHERE country_id='103'	0.00013494491577148
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00015091896057129
146	SELECT title FROM _country WHERE country_id='229'	0.00014019012451172
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00018596649169922
148	SELECT title FROM _country WHERE country_id='14'	0.00017499923706055
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00020003318786621
150	SELECT title FROM _country WHERE country_id='175'	0.0002129077911377
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00023102760314941
152	SELECT title FROM _country WHERE country_id='228'	0.00021791458129883
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00013089179992676
154	SELECT title FROM _country WHERE country_id='42'	0.00021696090698242
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00012993812561035
156	SELECT title FROM _country WHERE country_id='134'	0.00021600723266602
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00012898445129395
158	SELECT title FROM _country WHERE country_id='77'	0.00021505355834961
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.00088906288146973
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020694732666016
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.00093507766723633
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024199485778809
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.00089406967163086
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018811225891113
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.00088095664978027
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018811225891113
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.0009000301361084
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020194053649902
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.000885009765625
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922

Blog listing by tag Hanoi and Mai Chau Travel Tips

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