Blog listing by tag Hoi An 4-Star Hotels

Top 10 Best 4-star Hotels In Hoi An

09 March, 2024 Sunny Nguyen Duong

Hoi An, one of Vietnam's top tourist destinations, is famous for its ancient architecture, poetic scenery and peaceful atmosphere... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00093603134155273
2	SELECT * FROM default_setting WHERE setting_id='1'	0.0002589225769043
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.0017709732055664
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.0022990703582764
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.0017311573028564
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.0019190311431885
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.0017220973968506
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.0016829967498779
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00019502639770508
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.00088787078857422
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020503997802734
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.00074505805969238
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017309188842773
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='hoi-an-4star-hotels' limit 0,1	0.0018548965454102
15	SELECT * FROM default_tag WHERE tag_id='512'	0.00014996528625488
16	SELECT title FROM default_tag WHERE tag_id='512'	0.00011801719665527
17	SELECT * FROM default_tag WHERE tag_id='512'	0.00019598007202148
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 '%\|512\|%')	0.004065990447998
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 '%\|512\|%') order by order_no ASC LIMIT 0,6	0.0021591186523438
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.00079894065856934
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022387504577637
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.00075697898864746
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017690658569336
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.0016341209411621
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/hoi-an-4star-hotels' or config_link='/blog/tag/hoi-an-4star-hotels') limit 1	0.0025532245635986
26	SELECT slug FROM default_country WHERE country_id='1'	0.00020909309387207
27	SELECT slug FROM default_country WHERE country_id='64'	0.00019192695617676
28	SELECT slug FROM default_country WHERE country_id='3'	0.00017094612121582
29	SELECT slug FROM default_country WHERE country_id='7'	0.00014901161193848
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.00076413154602051
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017690658569336
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.0016510486602783
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.0016310214996338
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.0016369819641113
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.0016138553619385
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.0016520023345947
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00014710426330566
38	SELECT slug FROM default_country WHERE country_id='1'	0.00013113021850586
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00020599365234375
40	SELECT slug FROM default_country WHERE country_id='1'	0.00018215179443359
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00015497207641602
42	SELECT slug FROM default_country WHERE country_id='1'	0.00015497207641602
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00012803077697754
44	SELECT slug FROM default_country WHERE country_id='1'	0.00020503997802734
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00017714500427246
46	SELECT slug FROM default_country WHERE country_id='1'	0.0001530647277832
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00012612342834473
48	SELECT slug FROM default_country WHERE country_id='1'	0.00020194053649902
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00018000602722168
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.0016210079193115
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00020599365234375
52	SELECT slug FROM default_country WHERE country_id='64'	0.00018405914306641
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00015902519226074
54	SELECT slug FROM default_country WHERE country_id='64'	0.00013494491577148
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00020813941955566
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.0016629695892334
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00014805793762207
58	SELECT slug FROM default_country WHERE country_id='3'	0.00012707710266113
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00020194053649902
60	SELECT slug FROM default_country WHERE country_id='3'	0.00017714500427246
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00015401840209961
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.001629114151001
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00021791458129883
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.00019598007202148
66	SELECT slug FROM default_country WHERE country_id='7'	0.00017499923706055
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.0001518726348877
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00014114379882812
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00011301040649414
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00018787384033203
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00015687942504883
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00013017654418945
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00019693374633789
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00016999244689941
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.0001378059387207
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00021505355834961
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.0001828670501709
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00015687942504883
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00012397766113281
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.0001978874206543
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00016593933105469
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00013995170593262
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00021004676818848
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00018811225891113
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00018000602722168
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.00073981285095215
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017189979553223
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.0016591548919678
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.0001368522644043
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.0016651153564453
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.0015637874603271
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.0001380443572998
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.0016648769378662
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.0015640258789062
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.0001380443572998
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.0017321109771729
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.0016288757324219
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.0016279220581055
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.0016400814056396
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.0002140998840332
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.0016131401062012
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.0016310214996338
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00020408630371094
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.001662015914917
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.0015771389007568
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.00077390670776367
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017309188842773
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.0015690326690674
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00014114379882812
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.0016958713531494
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.0015850067138672
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00015592575073242
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.0015819072723389
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.0015819072723389
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.00077104568481445
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001838207244873
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.0016019344329834
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.00078797340393066
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017213821411133
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.0015769004821777
122	SELECT title FROM default_tag WHERE tag_id='512'	0.00015616416931152
123	SELECT title FROM default_blog WHERE blog_id='286'	0.00016212463378906
124	SELECT slug FROM default_blog WHERE blog_id='286'	0.00013303756713867
125	SELECT author FROM default_blog WHERE blog_id='286'	0.00012493133544922
126	SELECT author FROM default_blog WHERE blog_id='286'	0.00019311904907227
127	SELECT image FROM default_blog WHERE blog_id='286'	0.00016212463378906
128	SELECT image FROM default_blog WHERE blog_id='286'	0.00013995170593262
129	SELECT intro FROM default_blog WHERE blog_id='286'	0.00011801719665527
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.0016200542449951
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.0020279884338379
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.0021069049835205
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.0018689632415771
134	SELECT slug FROM default_country WHERE country_id='1'	0.00017595291137695
135	SELECT slug FROM default_country WHERE country_id='64'	0.00015997886657715
136	SELECT slug FROM default_country WHERE country_id='3'	0.00013899803161621
137	SELECT slug FROM default_country WHERE country_id='7'	0.00011706352233887
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.00078392028808594
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017499923706055
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.0016818046569824
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00021004676818848
142	SELECT title FROM _country WHERE country_id='193'	0.00020885467529297
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.0016939640045166
144	SELECT title FROM _country WHERE country_id='103'	0.0001671314239502
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00016403198242188
146	SELECT title FROM _country WHERE country_id='229'	0.00012803077697754
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00011897087097168
148	SELECT title FROM _country WHERE country_id='14'	0.00018310546875
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00017309188842773
150	SELECT title FROM _country WHERE country_id='175'	0.0001370906829834
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00012707710266113
152	SELECT title FROM _country WHERE country_id='228'	0.00019121170043945
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00018000602722168
154	SELECT title FROM _country WHERE country_id='42'	0.00015401840209961
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00014710426330566
156	SELECT title FROM _country WHERE country_id='134'	0.00011086463928223
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00021004676818848
158	SELECT title FROM _country WHERE country_id='77'	0.00017404556274414
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.00085616111755371
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017499923706055
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.00078511238098145
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016498565673828
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.00076699256896973
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016307830810547
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.00073504447937012
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016403198242188
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.00074505805969238
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016498565673828
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.0008399486541748
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00016403198242188

Blog listing by tag Hoi An 4-Star Hotels

Top 10 Best 4-star Hotels In Hoi An

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