Blog listing by tag Halong Bay Best Hotels

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.00082302093505859
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00030612945556641
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.001816987991333
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.0023090839385986
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.0017979145050049
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.0018978118896484
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.0017549991607666
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.001716136932373
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.0002140998840332
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.00079703330993652
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020694732666016
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.00082302093505859
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018215179443359
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='halong-bay-best-hotels' limit 0,1	0.0018420219421387
15	SELECT * FROM default_tag WHERE tag_id='452'	0.00014495849609375
16	SELECT title FROM default_tag WHERE tag_id='452'	0.00012612342834473
17	SELECT * FROM default_tag WHERE tag_id='452'	0.00021696090698242
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 '%\|452\|%')	0.0040159225463867
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 '%\|452\|%') order by order_no ASC LIMIT 0,6	0.002155065536499
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.00082707405090332
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021219253540039
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.00082707405090332
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001838207244873
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.0017998218536377
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-best-hotels' or config_link='/blog/tag/halong-bay-best-hotels') limit 1	0.0026900768280029
26	SELECT slug FROM default_country WHERE country_id='1'	0.00014996528625488
27	SELECT slug FROM default_country WHERE country_id='64'	0.00013089179992676
28	SELECT slug FROM default_country WHERE country_id='3'	0.00020289421081543
29	SELECT slug FROM default_country WHERE country_id='7'	0.00017499923706055
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.0008540153503418
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017404556274414
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.0016491413116455
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.0015799999237061
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.0016598701477051
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.0015881061553955
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.0018000602722168
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00021481513977051
38	SELECT slug FROM default_country WHERE country_id='1'	0.00019216537475586
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00016117095947266
40	SELECT slug FROM default_country WHERE country_id='1'	0.00013995170593262
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.0001070499420166
42	SELECT slug FROM default_country WHERE country_id='1'	0.00017786026000977
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00014400482177734
44	SELECT slug FROM default_country WHERE country_id='1'	0.00011396408081055
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00019598007202148
46	SELECT slug FROM default_country WHERE country_id='1'	0.00019598007202148
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016403198242188
48	SELECT slug FROM default_country WHERE country_id='1'	0.00017094612121582
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00014495849609375
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.001615047454834
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00021696090698242
52	SELECT slug FROM default_country WHERE country_id='64'	0.00018787384033203
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00015592575073242
54	SELECT slug FROM default_country WHERE country_id='64'	0.00012516975402832
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00019407272338867
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.0016179084777832
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00020480155944824
58	SELECT slug FROM default_country WHERE country_id='3'	0.00017714500427246
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00014400482177734
60	SELECT slug FROM default_country WHERE country_id='3'	0.00011396408081055
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00018787384033203
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.0016400814056396
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.00020694732666016
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00017499923706055
66	SELECT slug FROM default_country WHERE country_id='7'	0.00014495849609375
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00011301040649414
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.0001981258392334
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00016307830810547
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00013208389282227
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00019311904907227
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.0001680850982666
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00012898445129395
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00019598007202148
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.00012302398681641
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00018501281738281
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.0001518726348877
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00011420249938965
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00018000602722168
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00015497207641602
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.0001218318939209
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00018501281738281
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00015091896057129
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00011301040649414
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.00078201293945312
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016689300537109
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.0016219615936279
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00019407272338867
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.0016720294952393
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.0015921592712402
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00016117095947266
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.0015580654144287
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.0015311241149902
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00019717216491699
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.0016071796417236
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.0015830993652344
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00015902519226074
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.0015769004821777
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.0016078948974609
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.0015938282012939
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.0016391277313232
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00023508071899414
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.0017530918121338
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.0015730857849121
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.00077700614929199
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017595291137695
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.0015859603881836
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00015711784362793
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.0015869140625
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.0015819072723389
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00015687942504883
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.0015828609466553
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.0015790462493896
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.00077009201049805
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017380714416504
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.0016119480133057
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.00084877014160156
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.0015711784362793
122	SELECT title FROM default_tag WHERE tag_id='452'	0.00019001960754395
123	SELECT title FROM default_blog WHERE blog_id='308'	0.0001990795135498
124	SELECT slug FROM default_blog WHERE blog_id='308'	0.00017309188842773
125	SELECT author FROM default_blog WHERE blog_id='308'	0.00017189979553223
126	SELECT author FROM default_blog WHERE blog_id='308'	0.00014185905456543
127	SELECT image FROM default_blog WHERE blog_id='308'	0.00011491775512695
128	SELECT image FROM default_blog WHERE blog_id='308'	0.00019311904907227
129	SELECT intro FROM default_blog WHERE blog_id='308'	0.00017285346984863
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.0017008781433105
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.0019650459289551
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.002086877822876
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.0018839836120605
134	SELECT slug FROM default_country WHERE country_id='1'	0.00020599365234375
135	SELECT slug FROM default_country WHERE country_id='64'	0.00019097328186035
136	SELECT slug FROM default_country WHERE country_id='3'	0.00017118453979492
137	SELECT slug FROM default_country WHERE country_id='7'	0.00015115737915039
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.00077915191650391
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017905235290527
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.0017440319061279
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00014781951904297
142	SELECT title FROM _country WHERE country_id='193'	0.00015616416931152
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00016117095947266
144	SELECT title FROM _country WHERE country_id='103'	0.00013494491577148
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00013399124145508
146	SELECT title FROM _country WHERE country_id='229'	0.00020718574523926
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00020503997802734
148	SELECT title FROM _country WHERE country_id='14'	0.00017905235290527
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00017404556274414
150	SELECT title FROM _country WHERE country_id='175'	0.00014591217041016
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00014185905456543
152	SELECT title FROM _country WHERE country_id='228'	0.00011682510375977
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00011610984802246
154	SELECT title FROM _country WHERE country_id='42'	0.00018787384033203
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.0001838207244873
156	SELECT title FROM _country WHERE country_id='134'	0.00017285346984863
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00017213821411133
158	SELECT title FROM _country WHERE country_id='77'	0.00014710426330566
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.00081801414489746
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017786026000977
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.0008389949798584
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017499923706055
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.00074291229248047
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017404556274414
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.00071811676025391
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017213821411133
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.00074195861816406
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017404556274414
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.00073504447937012
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017309188842773

Blog listing by tag Halong Bay Best Hotels

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