Blog listing by tag Halong Bay Hotels Reviews

The 12 Best Hotels In Halong Bay, Vietnam

13 March, 2024 Sunny Nguyen Duong

When it comes to the natural beauty of Vietnam, it is impossible to overlook Ha Long Bay, this hidden gem in the northeast of the country is a wonder in its own right, a destination that ignites the imagination... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.0011501312255859
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00034904479980469
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.0021500587463379
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.0026500225067139
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.0020811557769775
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.0022881031036377
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.002047061920166
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.0019979476928711
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00029611587524414
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.001392126083374
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00029587745666504
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.0014960765838623
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002739429473877
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='halong-bay-hotels-reviews' limit 0,1	0.0019760131835938
15	SELECT * FROM default_tag WHERE tag_id='454'	0.00023698806762695
16	SELECT title FROM default_tag WHERE tag_id='454'	0.00027203559875488
17	SELECT * FROM default_tag WHERE tag_id='454'	0.00022983551025391
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 '%\|454\|%')	0.0041868686676025
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 '%\|454\|%') order by order_no ASC LIMIT 0,6	0.0025858879089355
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.0010108947753906
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002598762512207
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.00092792510986328
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002448558807373
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.0020339488983154
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/halong-bay-hotels-reviews' or config_link='/blog/tag/halong-bay-hotels-reviews') limit 1	0.0029380321502686
26	SELECT slug FROM default_country WHERE country_id='1'	0.00022792816162109
27	SELECT slug FROM default_country WHERE country_id='64'	0.00019097328186035
28	SELECT slug FROM default_country WHERE country_id='3'	0.00023698806762695
29	SELECT slug FROM default_country WHERE country_id='7'	0.00019097328186035
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.0010111331939697
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00024700164794922
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.0020630359649658
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.0020029544830322
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.0020081996917725
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.0021319389343262
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.0019600391387939
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00022602081298828
38	SELECT slug FROM default_country WHERE country_id='1'	0.00027799606323242
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00021696090698242
40	SELECT slug FROM default_country WHERE country_id='1'	0.00027203559875488
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00022697448730469
42	SELECT slug FROM default_country WHERE country_id='1'	0.00034213066101074
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.0001680850982666
44	SELECT slug FROM default_country WHERE country_id='1'	0.00021600723266602
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00026082992553711
46	SELECT slug FROM default_country WHERE country_id='1'	0.00020909309387207
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.0002598762512207
48	SELECT slug FROM default_country WHERE country_id='1'	0.00020599365234375
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00025010108947754
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.00201416015625
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00026607513427734
52	SELECT slug FROM default_country WHERE country_id='64'	0.00022792816162109
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00017714500427246
54	SELECT slug FROM default_country WHERE country_id='64'	0.00022315979003906
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00027012825012207
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.0019831657409668
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00024008750915527
58	SELECT slug FROM default_country WHERE country_id='3'	0.0002131462097168
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00025200843811035
60	SELECT slug FROM default_country WHERE country_id='3'	0.00019979476928711
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00024914741516113
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.0021538734436035
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00021195411682129
64	SELECT slug FROM default_country WHERE country_id='7'	0.0002601146697998
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00020599365234375
66	SELECT slug FROM default_country WHERE country_id='7'	0.00028800964355469
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00023221969604492
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00019383430480957
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00023698806762695
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00019001960754395
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00022697448730469
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00026988983154297
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00020098686218262
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00024795532226562
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00015091896057129
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00019598007202148
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00023293495178223
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.0002748966217041
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00021600723266602
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00026106834411621
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.0001990795135498
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00024700164794922
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.0001981258392334
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.0002140998840332
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00025701522827148
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.00092196464538574
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002439022064209
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.0020580291748047
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00021004676818848
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.0019869804382324
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.0019159317016602
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00023698806762695
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.0020148754119873
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.0020031929016113
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00025200843811035
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.0019159317016602
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.0019931793212891
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00024104118347168
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.001939058303833
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.0019569396972656
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00020980834960938
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.0020129680633545
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.0019979476928711
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00024199485778809
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.0019018650054932
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.0019819736480713
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.00096487998962402
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021982192993164
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.0020110607147217
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00026822090148926
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.0019278526306152
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.0020310878753662
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.0002899169921875
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.0019550323486328
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.0019590854644775
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.00093603134155273
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00023484230041504
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.001945972442627
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.0009009838104248
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025010108947754
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.0019619464874268
122	SELECT title FROM default_tag WHERE tag_id='454'	0.00028610229492188
123	SELECT title FROM default_blog WHERE blog_id='308'	0.00026297569274902
124	SELECT slug FROM default_blog WHERE blog_id='308'	0.00021004676818848
125	SELECT author FROM default_blog WHERE blog_id='308'	0.00017499923706055
126	SELECT author FROM default_blog WHERE blog_id='308'	0.00021195411682129
127	SELECT image FROM default_blog WHERE blog_id='308'	0.0002601146697998
128	SELECT image FROM default_blog WHERE blog_id='308'	0.00020408630371094
129	SELECT intro FROM default_blog WHERE blog_id='308'	0.00025296211242676
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.0020740032196045
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.0023519992828369
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.0025289058685303
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.0023159980773926
134	SELECT slug FROM default_country WHERE country_id='1'	0.00022220611572266
135	SELECT slug FROM default_country WHERE country_id='64'	0.00028014183044434
136	SELECT slug FROM default_country WHERE country_id='3'	0.00024890899658203
137	SELECT slug FROM default_country WHERE country_id='7'	0.00020194053649902
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.00092101097106934
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00025200843811035
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.0021328926086426
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00026702880859375
142	SELECT title FROM _country WHERE country_id='193'	0.0002291202545166
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00020289421081543
144	SELECT title FROM _country WHERE country_id='103'	0.00023508071899414
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00019001960754395
146	SELECT title FROM _country WHERE country_id='229'	0.00023388862609863
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00021004676818848
148	SELECT title FROM _country WHERE country_id='14'	0.00026082992553711
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00023007392883301
150	SELECT title FROM _country WHERE country_id='175'	0.00027608871459961
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00025200843811035
152	SELECT title FROM _country WHERE country_id='228'	0.00019979476928711
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00026297569274902
154	SELECT title FROM _country WHERE country_id='42'	0.00021100044250488
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00017809867858887
156	SELECT title FROM _country WHERE country_id='134'	0.00022602081298828
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00019192695617676
158	SELECT title FROM _country WHERE country_id='77'	0.00024700164794922
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.0010049343109131
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00049376487731934
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.00085210800170898
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018000602722168
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.00082492828369141
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.00087213516235352
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.00083804130554199
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017809867858887
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.000762939453125
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019121170043945

Blog listing by tag Halong Bay Hotels Reviews

The 12 Best Hotels In Halong Bay, Vietnam

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