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.00094318389892578
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00033211708068848
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.0021061897277832
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.002615213394165
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.002147912979126
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.0021340847015381
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.002007007598877
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.0020120143890381
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00022697448730469
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.00086283683776855
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022101402282715
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.00087118148803711
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021505355834961
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='hoi-an-4star-hotels' limit 0,1	0.0021190643310547
15	SELECT * FROM default_tag WHERE tag_id='512'	0.00024890899658203
16	SELECT title FROM default_tag WHERE tag_id='512'	0.00015592575073242
17	SELECT * FROM default_tag WHERE tag_id='512'	0.00017309188842773
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.0047550201416016
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.0025317668914795
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.00089406967163086
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021791458129883
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.00087308883666992
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021195411682129
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.0019400119781494
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.0030038356781006
26	SELECT slug FROM default_country WHERE country_id='1'	0.00023698806762695
27	SELECT slug FROM default_country WHERE country_id='64'	0.0001671314239502
28	SELECT slug FROM default_country WHERE country_id='3'	0.00018787384033203
29	SELECT slug FROM default_country WHERE country_id='7'	0.00020289421081543
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.0010099411010742
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021815299987793
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.001953125
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.0019049644470215
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.0019791126251221
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.0019218921661377
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.0019199848175049
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00025701522827148
38	SELECT slug FROM default_country WHERE country_id='1'	0.00018191337585449
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00019383430480957
40	SELECT slug FROM default_country WHERE country_id='1'	0.00020813941955566
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00022101402282715
42	SELECT slug FROM default_country WHERE country_id='1'	0.00023102760314941
43	SELECT title,slug FROM default_tour_category WHERE tourcat_id='3'	0.00024104118347168
44	SELECT slug FROM default_country WHERE country_id='1'	0.00015401840209961
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00016307830810547
46	SELECT slug FROM default_country WHERE country_id='1'	0.00017690658569336
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00018501281738281
48	SELECT slug FROM default_country WHERE country_id='1'	0.00020003318786621
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00021481513977051
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.0020160675048828
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00025606155395508
52	SELECT slug FROM default_country WHERE country_id='64'	0.00021100044250488
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.00022411346435547
54	SELECT slug FROM default_country WHERE country_id='64'	0.00023508071899414
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.0002439022064209
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.0019221305847168
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00024199485778809
58	SELECT slug FROM default_country WHERE country_id='3'	0.00016403198242188
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00016188621520996
60	SELECT slug FROM default_country WHERE country_id='3'	0.00017309188842773
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00018715858459473
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.0019891262054443
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00022006034851074
64	SELECT slug FROM default_country WHERE country_id='7'	0.00023984909057617
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00014996528625488
66	SELECT slug FROM default_country WHERE country_id='7'	0.00016093254089355
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00017189979553223
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.0001988410949707
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00020408630371094
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00021600723266602
71	SELECT slug FROM default_tour_category WHERE tourcat_id='16'	0.00022006034851074
72	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='19'	0.00023102760314941
73	SELECT slug FROM default_tour_category WHERE tourcat_id='19'	0.00023603439331055
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.00021886825561523
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00022292137145996
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00023317337036133
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00023698806762695
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.0002601146697998
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00013518333435059
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.0002448558807373
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00017809867858887
82	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='14'	0.00018811225891113
83	SELECT slug FROM default_tour_category WHERE tourcat_id='14'	0.00016689300537109
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00015902519226074
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.0001378059387207
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.00021600723266602
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.0019938945770264
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.00020980834960938
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.0020229816436768
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.002018928527832
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00023078918457031
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.0019431114196777
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.0018720626831055
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00019216537475586
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.0018661022186279
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.0019659996032715
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00015592575073242
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.0018939971923828
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.0020589828491211
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00016999244689941
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.0019090175628662
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.0019280910491943
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00024104118347168
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.0019772052764893
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.0019121170043945
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.00090599060058594
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021505355834961
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.0020298957824707
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.00020885467529297
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.0019550323486328
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.0018970966339111
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.0001990795135498
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.0019481182098389
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.0019078254699707
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.00090599060058594
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021719932556152
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.0019469261169434
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.00082588195800781
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021481513977051
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.0018889904022217
122	SELECT title FROM default_tag WHERE tag_id='512'	0.00021696090698242
123	SELECT title FROM default_blog WHERE blog_id='286'	0.00025510787963867
124	SELECT slug FROM default_blog WHERE blog_id='286'	0.00016403198242188
125	SELECT author FROM default_blog WHERE blog_id='286'	0.00019598007202148
126	SELECT author FROM default_blog WHERE blog_id='286'	0.00020408630371094
127	SELECT image FROM default_blog WHERE blog_id='286'	0.00021100044250488
128	SELECT image FROM default_blog WHERE blog_id='286'	0.00022196769714355
129	SELECT intro FROM default_blog WHERE blog_id='286'	0.00023794174194336
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.0019850730895996
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.0023148059844971
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.0024502277374268
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.0021319389343262
134	SELECT slug FROM default_country WHERE country_id='1'	0.00024199485778809
135	SELECT slug FROM default_country WHERE country_id='64'	0.00016498565673828
136	SELECT slug FROM default_country WHERE country_id='3'	0.00018000602722168
137	SELECT slug FROM default_country WHERE country_id='7'	0.00019311904907227
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.00087499618530273
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00022101402282715
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.0021789073944092
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00023698806762695
142	SELECT title FROM _country WHERE country_id='193'	0.0002601146697998
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00019621849060059
144	SELECT title FROM _country WHERE country_id='103'	0.00020718574523926
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00023913383483887
146	SELECT title FROM _country WHERE country_id='229'	0.00025200843811035
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00018811225891113
148	SELECT title FROM _country WHERE country_id='14'	0.00019598007202148
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00022602081298828
150	SELECT title FROM _country WHERE country_id='175'	0.00023293495178223
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00016593933105469
152	SELECT title FROM _country WHERE country_id='228'	0.00019192695617676
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00022101402282715
154	SELECT title FROM _country WHERE country_id='42'	0.00022697448730469
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00015807151794434
156	SELECT title FROM _country WHERE country_id='134'	0.00016498565673828
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00019693374633789
158	SELECT title FROM _country WHERE country_id='77'	0.00018000602722168
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.00087308883666992
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021004676818848
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.00089597702026367
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020813941955566
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.00079989433288574
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021100044250488
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.00089001655578613
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021004676818848
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.00081396102905273
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002288818359375
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.00083208084106445
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002140998840332

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