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.0010139942169189
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00026202201843262
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.0020301342010498
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.0025920867919922
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.0019171237945557
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.0020761489868164
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.0018751621246338
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.0018420219421387
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00020599365234375
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.00086593627929688
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
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.00082087516784668
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='halong-bay-best-hotels' limit 0,1	0.0020720958709717
15	SELECT * FROM default_tag WHERE tag_id='452'	0.00017595291137695
16	SELECT title FROM default_tag WHERE tag_id='452'	0.00015401840209961
17	SELECT * FROM default_tag WHERE tag_id='452'	0.00014495849609375
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.0045099258422852
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.0025010108947754
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.00090599060058594
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020003318786621
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.00081801414489746
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018692016601562
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.0019011497497559
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.0028648376464844
26	SELECT slug FROM default_country WHERE country_id='1'	0.00022983551025391
27	SELECT slug FROM default_country WHERE country_id='64'	0.0002291202545166
28	SELECT slug FROM default_country WHERE country_id='3'	0.00022006034851074
29	SELECT slug FROM default_country WHERE country_id='7'	0.00021195411682129
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.0010230541229248
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020194053649902
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.0018448829650879
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.0018110275268555
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.0018680095672607
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.0018229484558105
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.00193190574646
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00016498565673828
38	SELECT slug FROM default_country WHERE country_id='1'	0.00015997886657715
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00014615058898926
40	SELECT slug FROM default_country WHERE country_id='1'	0.00013399124145508
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00021791458129883
42	SELECT slug FROM default_country WHERE country_id='1'	0.00020503997802734
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00019001960754395
44	SELECT slug FROM default_country WHERE country_id='1'	0.00017714500427246
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00018405914306641
46	SELECT slug FROM default_country WHERE country_id='1'	0.00017499923706055
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00016188621520996
48	SELECT slug FROM default_country WHERE country_id='1'	0.0001518726348877
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00014209747314453
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.0017731189727783
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00017309188842773
52	SELECT slug FROM default_country WHERE country_id='64'	0.00016403198242188
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.0001518726348877
54	SELECT slug FROM default_country WHERE country_id='64'	0.00015091896057129
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00014114379882812
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.0018301010131836
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00012779235839844
58	SELECT slug FROM default_country WHERE country_id='3'	0.00021696090698242
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00020003318786621
60	SELECT slug FROM default_country WHERE country_id='3'	0.00018596649169922
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00017595291137695
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.0018150806427002
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.0002140998840332
64	SELECT slug FROM default_country WHERE country_id='7'	0.00020289421081543
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00018787384033203
66	SELECT slug FROM default_country WHERE country_id='7'	0.00017499923706055
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00015878677368164
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00016021728515625
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00014019012451172
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00012803077697754
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00020599365234375
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00019001960754395
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00016903877258301
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.0001530647277832
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00013303756713867
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00021910667419434
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.0001981258392334
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00018215179443359
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00016093254089355
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00014686584472656
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00012683868408203
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00023913383483887
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00022006034851074
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00020694732666016
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00027704238891602
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.00086307525634766
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018882751464844
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.0002129077911377
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.0017950534820557
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.0018219947814941
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00021004676818848
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.0017831325531006
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.0019478797912598
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00013303756713867
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.0018279552459717
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.001910924911499
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00020098686218262
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.0018079280853271
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.0018250942230225
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00021195411682129
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.0018329620361328
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.0018398761749268
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00016307830810547
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.0017499923706055
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.0017409324645996
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.00085306167602539
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018882751464844
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.0017631053924561
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00014591217041016
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.0018448829650879
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.0017380714416504
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00022411346435547
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.0018379688262939
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.0018289089202881
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.00089621543884277
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
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.0018501281738281
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.000823974609375
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.001835823059082
122	SELECT title FROM default_tag WHERE tag_id='452'	0.00016188621520996
123	SELECT title FROM default_blog WHERE blog_id='308'	0.00017809867858887
124	SELECT slug FROM default_blog WHERE blog_id='308'	0.00015902519226074
125	SELECT author FROM default_blog WHERE blog_id='308'	0.00016498565673828
126	SELECT author FROM default_blog WHERE blog_id='308'	0.00014305114746094
127	SELECT image FROM default_blog WHERE blog_id='308'	0.0001380443572998
128	SELECT image FROM default_blog WHERE blog_id='308'	0.00012588500976562
129	SELECT intro FROM default_blog WHERE blog_id='308'	0.0002131462097168
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.0019369125366211
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.002241849899292
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.0022628307342529
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.002047061920166
134	SELECT slug FROM default_country WHERE country_id='1'	0.00022315979003906
135	SELECT slug FROM default_country WHERE country_id='64'	0.00021696090698242
136	SELECT slug FROM default_country WHERE country_id='3'	0.00020790100097656
137	SELECT slug FROM default_country WHERE country_id='7'	0.0001978874206543
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.0008699893951416
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019288063049316
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.0019381046295166
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00022792816162109
142	SELECT title FROM _country WHERE country_id='193'	0.00024700164794922
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00016498565673828
144	SELECT title FROM _country WHERE country_id='103'	0.0001518726348877
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00017690658569336
146	SELECT title FROM _country WHERE country_id='229'	0.00016498565673828
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00017499923706055
148	SELECT title FROM _country WHERE country_id='14'	0.00016212463378906
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00017213821411133
150	SELECT title FROM _country WHERE country_id='175'	0.00015997886657715
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.0001680850982666
152	SELECT title FROM _country WHERE country_id='228'	0.0001528263092041
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00016188621520996
154	SELECT title FROM _country WHERE country_id='42'	0.00014710426330566
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00015497207641602
156	SELECT title FROM _country WHERE country_id='134'	0.00013899803161621
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00015401840209961
158	SELECT title FROM _country WHERE country_id='77'	0.00015997886657715
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.000885009765625
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.00085687637329102
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018596649169922
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.00093293190002441
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018620491027832
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.00081896781921387
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019407272338867
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.0008537769317627
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018501281738281
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.00088810920715332
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018692016601562

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