Blog listing by tag Lan Ha Bay Travel Guide

Tips For Your Camping Trip On Lan Ha Bay

14 March, 2024 Sunny Nguyen Duong

Having a camping trip on Lan Ha Bay feels like stepping into a magical sanctuary and it's calm waters and stunning limestone formations create a scene that's a far cry from the usual crowded spots... Read more

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='blog'	0.00087404251098633
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00029993057250977
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.0019910335540771
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.0023050308227539
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.0057809352874756
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.0019137859344482
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.0017769336700439
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.001723051071167
9	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00020480155944824
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.00082111358642578
11	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020098686218262
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.00084304809570312
13	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018310546875
14	SELECT tag_id FROM default_tag WHERE lang_id='' and slug='lan-ha-bay-travel-guide' limit 0,1	0.0054819583892822
15	SELECT * FROM default_tag WHERE tag_id='392'	0.00017309188842773
16	SELECT title FROM default_tag WHERE tag_id='392'	0.0001370906829834
17	SELECT * FROM default_tag WHERE tag_id='392'	0.00021195411682129
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 '%\|392\|%')	0.0043118000030518
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 '%\|392\|%') order by order_no ASC LIMIT 0,6	0.0023019313812256
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.00079917907714844
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019001960754395
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.00084114074707031
23	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00017213821411133
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.0017240047454834
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/lan-ha-bay-travel-guide' or config_link='/blog/tag/lan-ha-bay-travel-guide') limit 1	0.0025570392608643
26	SELECT slug FROM default_country WHERE country_id='1'	0.00020194053649902
27	SELECT slug FROM default_country WHERE country_id='64'	0.0001990795135498
28	SELECT slug FROM default_country WHERE country_id='3'	0.0002140998840332
29	SELECT slug FROM default_country WHERE country_id='7'	0.00020003318786621
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.00087809562683105
31	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00018692016601562
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.0017459392547607
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.0020239353179932
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.0017468929290771
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.0017571449279785
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.0018100738525391
37	SELECT title,slug FROM default_tour_category WHERE tourcat_id='6'	0.00031304359436035
38	SELECT slug FROM default_country WHERE country_id='1'	0.00023603439331055
39	SELECT title,slug FROM default_tour_category WHERE tourcat_id='5'	0.00012707710266113
40	SELECT slug FROM default_country WHERE country_id='1'	0.00024294853210449
41	SELECT title,slug FROM default_tour_category WHERE tourcat_id='4'	0.00012612342834473
42	SELECT slug FROM default_country WHERE country_id='1'	0.00021195411682129
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.00016903877258301
45	SELECT title,slug FROM default_tour_category WHERE tourcat_id='2'	0.00014400482177734
46	SELECT slug FROM default_country WHERE country_id='1'	0.00012111663818359
47	SELECT title,slug FROM default_tour_category WHERE tourcat_id='1'	0.00019502639770508
48	SELECT slug FROM default_country WHERE country_id='1'	0.00017118453979492
49	SELECT image_menu FROM default_country WHERE country_id='1'	0.00016403198242188
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.0016829967498779
51	SELECT title,slug FROM default_tour_category WHERE tourcat_id='12'	0.00017213821411133
52	SELECT slug FROM default_country WHERE country_id='64'	0.0001530647277832
53	SELECT title,slug FROM default_tour_category WHERE tourcat_id='11'	0.0001521110534668
54	SELECT slug FROM default_country WHERE country_id='64'	0.0001380443572998
55	SELECT image_menu FROM default_country WHERE country_id='64'	0.00021815299987793
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.0017330646514893
57	SELECT title,slug FROM default_tour_category WHERE tourcat_id='8'	0.00012993812561035
58	SELECT slug FROM default_country WHERE country_id='3'	0.0002140998840332
59	SELECT title,slug FROM default_tour_category WHERE tourcat_id='7'	0.00018906593322754
60	SELECT slug FROM default_country WHERE country_id='3'	0.0001680850982666
61	SELECT image_menu FROM default_country WHERE country_id='3'	0.00015091896057129
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.0016570091247559
63	SELECT title,slug FROM default_tour_category WHERE tourcat_id='10'	0.00014615058898926
64	SELECT slug FROM default_country WHERE country_id='7'	0.00012588500976562
65	SELECT title,slug FROM default_tour_category WHERE tourcat_id='9'	0.00020718574523926
66	SELECT slug FROM default_country WHERE country_id='7'	0.00019311904907227
67	SELECT image_menu FROM default_country WHERE country_id='7'	0.00017595291137695
68	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='20'	0.00017309188842773
69	SELECT slug FROM default_tour_category WHERE tourcat_id='20'	0.00014591217041016
70	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='16'	0.00012397766113281
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.0001370906829834
74	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='15'	0.0002131462097168
75	SELECT slug FROM default_tour_category WHERE tourcat_id='15'	0.00018215179443359
76	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='17'	0.00015711784362793
77	SELECT slug FROM default_tour_category WHERE tourcat_id='17'	0.00012588500976562
78	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='18'	0.00020098686218262
79	SELECT slug FROM default_tour_category WHERE tourcat_id='18'	0.00016999244689941
80	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='13'	0.00014495849609375
81	SELECT slug FROM default_tour_category WHERE tourcat_id='13'	0.00014495849609375
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.00019097328186035
84	SELECT title,is_online,is_trash FROM default_tour_category WHERE tourcat_id='22'	0.00019407272338867
85	SELECT slug FROM default_tour_category WHERE tourcat_id='22'	0.00016593933105469
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.00088882446289062
87	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0002281665802002
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.001741886138916
89	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='49'	0.0001528263092041
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.0016770362854004
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.0017428398132324
92	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='6'	0.00015091896057129
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.0017111301422119
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.0017619132995605
95	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='50'	0.00017809867858887
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.0017139911651611
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.0017249584197998
98	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='7'	0.00025010108947754
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.0016739368438721
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.0016868114471436
101	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='4'	0.00019502639770508
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.0017540454864502
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.0016670227050781
104	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='2'	0.00016903877258301
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.0017468929290771
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.0016942024230957
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.00087594985961914
108	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00021791458129883
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.0017650127410889
110	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='58'	0.0001671314239502
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.0016989707946777
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.0017831325531006
113	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='59'	0.00019001960754395
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.0017189979553223
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.0017490386962891
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.00081205368041992
117	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020408630371094
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.0016720294952393
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.00086212158203125
120	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00026512145996094
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.00166916847229
122	SELECT title FROM default_tag WHERE tag_id='392'	0.00019383430480957
123	SELECT title FROM default_blog WHERE blog_id='330'	0.00023913383483887
124	SELECT slug FROM default_blog WHERE blog_id='330'	0.00014185905456543
125	SELECT author FROM default_blog WHERE blog_id='330'	0.00017786026000977
126	SELECT author FROM default_blog WHERE blog_id='330'	0.00018501281738281
127	SELECT image FROM default_blog WHERE blog_id='330'	0.00018596649169922
128	SELECT image FROM default_blog WHERE blog_id='330'	0.00020599365234375
129	SELECT intro FROM default_blog WHERE blog_id='330'	0.00021791458129883
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.0019040107727051
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.0020179748535156
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.0022249221801758
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.0020020008087158
134	SELECT slug FROM default_country WHERE country_id='1'	0.00023603439331055
135	SELECT slug FROM default_country WHERE country_id='64'	0.00018191337585449
136	SELECT slug FROM default_country WHERE country_id='3'	0.00020194053649902
137	SELECT slug FROM default_country WHERE country_id='7'	0.0002288818359375
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.00090885162353516
139	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00019192695617676
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.0018229484558105
141	SELECT country_id FROM default_testimonial WHERE testimonial_id='7'	0.00022506713867188
142	SELECT title FROM _country WHERE country_id='193'	0.00026202201843262
143	SELECT country_id FROM default_testimonial WHERE testimonial_id='12'	0.00020194053649902
144	SELECT title FROM _country WHERE country_id='103'	0.00020503997802734
145	SELECT country_id FROM default_testimonial WHERE testimonial_id='10'	0.00023794174194336
146	SELECT title FROM _country WHERE country_id='229'	0.0002448558807373
147	SELECT country_id FROM default_testimonial WHERE testimonial_id='5'	0.00019001960754395
148	SELECT title FROM _country WHERE country_id='14'	0.00019598007202148
149	SELECT country_id FROM default_testimonial WHERE testimonial_id='8'	0.00023078918457031
150	SELECT title FROM _country WHERE country_id='175'	0.00023221969604492
151	SELECT country_id FROM default_testimonial WHERE testimonial_id='6'	0.00018000602722168
152	SELECT title FROM _country WHERE country_id='228'	0.00017881393432617
153	SELECT country_id FROM default_testimonial WHERE testimonial_id='9'	0.00022721290588379
154	SELECT title FROM _country WHERE country_id='42'	0.00023198127746582
155	SELECT country_id FROM default_testimonial WHERE testimonial_id='11'	0.00016498565673828
156	SELECT title FROM _country WHERE country_id='134'	0.0001680850982666
157	SELECT country_id FROM default_testimonial WHERE testimonial_id='3'	0.00020718574523926
158	SELECT title FROM _country WHERE country_id='77'	0.00021100044250488
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.00086593627929688
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020599365234375
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.00020313262939453
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.0010001659393311
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020194053649902
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.0008552074432373
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020098686218262
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.00085806846618652
168	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020217895507812
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.00086688995361328
170	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00020289421081543

Blog listing by tag Lan Ha Bay Travel Guide

Tips For Your Camping Trip On Lan Ha Bay

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