Reunification Palace

Post on : 09 December, 2016

Also known as the Independence Palace, this building marks, for many, the end of the Vietnam War. Free tours with an English-speaking guide can be arranged in the lobby.

1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='guide'	0.0017881393432617
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00085687637329102
3	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.0049700736999512
4	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0038208961486816
5	SELECT distinct country_id FROM default_region where region_id=2 LIMIT 0,1	0.0003821849822998
6	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='2' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0049629211425781
7	SELECT distinct country_id FROM default_region where region_id=3 LIMIT 0,1	0.00034904479980469
8	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='3' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0039820671081543
9	SELECT distinct country_id FROM default_region where region_id=1 LIMIT 0,1	0.00033092498779297
10	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and region_id='1' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.00406813621521
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no ASC	0.0045609474182129
12	SELECT tourcat_id,title,slug 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.0035018920898438
13	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.0040318965911865
14	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.0040199756622314
15	SELECT distinct short FROM default_property where property_id=951 LIMIT 0,1	0.00063920021057129
16	SELECT * FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and guide_id='198' and slug='reunification-palace'	0.0029220581054688
17	SELECT * FROM default_guide WHERE guide_id='198'	0.00037217140197754
18	SELECT guidecat_id FROM default_guidecat WHERE lang_id='' and is_trash=0 and is_online=1	0.002763032913208
19	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and (cat_id='2' or list_cat_id like '%\|2\|%') and country_id='1' and city_id='399' and guide_id<>'198' order by rand() LIMIT 0,10	0.010780096054077
20	SELECT title FROM default_guide WHERE guide_id='198'	0.00030303001403809
21	SELECT intro FROM default_guide WHERE guide_id='198'	0.00031518936157227
22	SELECT slug FROM default_guide WHERE guide_id='198'	0.00029492378234863
23	SELECT meta_id,image FROM default_meta WHERE lang_id='' and config_link='/en/g198-reunification-palace.html'	0.0044319629669189
24	SELECT distinct image FROM default_guide where guide_id=198 LIMIT 0,1	0.00034594535827637
25	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.0034599304199219
26	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='' and (config_link='/en/g198-reunification-palace.html' or config_link='/en/g198-reunification-palace.html') limit 1	0.0051920413970947
27	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.0046029090881348
28	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.0044319629669189
29	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.0044748783111572
30	SELECT slug FROM default_cruise_cat WHERE cruise_cat_id='47'	0.00034308433532715
31	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='47' and is_trash=0 and is_online=1 order by order_no ASC	0.0044558048248291
32	SELECT cruise_cat_id,title FROM default_cruise_cat WHERE lang_id='' and parent_id='47' and is_trash=0 and is_online=1 order by order_no ASC	0.0048470497131348
33	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.0057342052459717
34	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.0044732093811035
35	SELECT title FROM default_guidecat WHERE guidecat_id='2'	0.00026893615722656
36	SELECT slug FROM default_country WHERE country_id='1'	0.00035309791564941
37	SELECT slug FROM default_city WHERE city_id='399'	0.00025200843811035
38	SELECT slug FROM default_guidecat WHERE guidecat_id='2'	0.00025415420532227
39	SELECT title FROM default_guide WHERE guide_id='198'	0.00026297569274902
40	SELECT title FROM default_guide WHERE guide_id='198'	0.00028109550476074
41	SELECT distinct publish_date FROM default_guide where guide_id=198 LIMIT 0,1	0.00029206275939941
42	SELECT image FROM default_guide WHERE guide_id='198'	0.00032782554626465
43	SELECT slug FROM default_guide WHERE guide_id='198'	0.00024318695068359
44	SELECT title FROM default_guide WHERE guide_id='198'	0.00023794174194336
45	SELECT * FROM default_guide WHERE guide_id='198'	0.00029802322387695
46	SELECT content FROM default_guide WHERE guide_id='198'	0.00029087066650391
47	SELECT slug FROM default_guide WHERE guide_id='198'	0.00031089782714844
48	SELECT tour_id FROM default_tour WHERE lang_id='' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='1' and city_id='399') order by order_no ASC limit 0,5	0.0036959648132324
49	SELECT * FROM default_blogcat WHERE lang_id='' and is_trash=0 order by order_no asc	0.0033888816833496
50	SELECT * FROM default_tag WHERE lang_id='' and tag_id IN (SELECT tag_id FROM default_tag_module WHERE 1=1 and type='GUIDE')	0.0036830902099609
51	SELECT title FROM default_country WHERE country_id='1'	0.00035500526428223
52	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '12'	0.0056140422821045
53	SELECT slug FROM default_country WHERE country_id='1'	0.0003049373626709
54	SELECT slug FROM default_city WHERE city_id='399'	0.00035190582275391
55	SELECT slug FROM default_guidecat WHERE guidecat_id='12'	0.00026893615722656
56	SELECT title FROM default_guidecat WHERE guidecat_id='12'	0.00029897689819336
57	SELECT title FROM default_guidecat WHERE guidecat_id='12'	0.00028610229492188
58	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '13'	0.0059919357299805
59	SELECT slug FROM default_country WHERE country_id='1'	0.00028896331787109
60	SELECT slug FROM default_city WHERE city_id='399'	0.00031900405883789
61	SELECT slug FROM default_guidecat WHERE guidecat_id='13'	0.00034117698669434
62	SELECT title FROM default_guidecat WHERE guidecat_id='13'	0.00026202201843262
63	SELECT title FROM default_guidecat WHERE guidecat_id='13'	0.00025820732116699
64	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '14'	0.0052528381347656
65	SELECT slug FROM default_country WHERE country_id='1'	0.00038385391235352
66	SELECT slug FROM default_city WHERE city_id='399'	0.00031614303588867
67	SELECT slug FROM default_guidecat WHERE guidecat_id='14'	0.00035285949707031
68	SELECT title FROM default_guidecat WHERE guidecat_id='14'	0.00026702880859375
69	SELECT title FROM default_guidecat WHERE guidecat_id='14'	0.0002739429473877
70	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '15'	0.0052249431610107
71	SELECT slug FROM default_country WHERE country_id='1'	0.00034093856811523
72	SELECT slug FROM default_city WHERE city_id='399'	0.00027203559875488
73	SELECT slug FROM default_guidecat WHERE guidecat_id='15'	0.00026798248291016
74	SELECT title FROM default_guidecat WHERE guidecat_id='15'	0.00030708312988281
75	SELECT title FROM default_guidecat WHERE guidecat_id='15'	0.00032305717468262
76	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '16'	0.0054738521575928
77	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '2'	0.0054659843444824
78	SELECT slug FROM default_country WHERE country_id='1'	0.00038790702819824
79	SELECT slug FROM default_city WHERE city_id='399'	0.00032591819763184
80	SELECT slug FROM default_guidecat WHERE guidecat_id='2'	0.00035500526428223
81	SELECT title FROM default_guidecat WHERE guidecat_id='2'	0.00025796890258789
82	SELECT title FROM default_guidecat WHERE guidecat_id='2'	0.0002899169921875
83	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '9'	0.0055279731750488
84	SELECT slug FROM default_country WHERE country_id='1'	0.00041007995605469
85	SELECT slug FROM default_city WHERE city_id='399'	0.00033211708068848
86	SELECT slug FROM default_guidecat WHERE guidecat_id='9'	0.00026297569274902
87	SELECT title FROM default_guidecat WHERE guidecat_id='9'	0.00027799606323242
88	SELECT title FROM default_guidecat WHERE guidecat_id='9'	0.00030016899108887
89	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '1'	0.005483865737915
90	SELECT slug FROM default_country WHERE country_id='1'	0.00041818618774414
91	SELECT slug FROM default_city WHERE city_id='399'	0.00035190582275391
92	SELECT slug FROM default_guidecat WHERE guidecat_id='1'	0.00029587745666504
93	SELECT title FROM default_guidecat WHERE guidecat_id='1'	0.00030708312988281
94	SELECT title FROM default_guidecat WHERE guidecat_id='1'	0.0003361701965332
95	SELECT guide_id FROM default_guide WHERE lang_id='' and is_trash=0 and is_online=1 and country_id='1' and city_id = '399' and cat_id = '23'	0.0055019855499268
96	SELECT slug FROM default_tour WHERE tour_id='245'	0.00064682960510254
97	SELECT title FROM default_tour WHERE tour_id='245'	0.00029683113098145
98	SELECT COUNT(*) AS totalitem FROM default_reviews WHERE is_trash=0 and is_online=1 and profile_id >0 and table_id = '245' and type='tour'	0.00069618225097656
99	SELECT tour_store_id FROM default_tour_store WHERE lang_id='' and tour_id='245' and _type='DEPARTURE' limit 0,1	0.0038020610809326
100	SELECT tour_start_date_id,price_type,price FROM default_tour_start_date WHERE lang_id='' and is_trash=0 and tour_id='245' and start_date > '1686070800' order by start_date ASC limit 0,1	0.0038549900054932
101	SELECT image FROM default_tour WHERE tour_id='245'	0.0004580020904541
102	SELECT duration_type,duration_custom,number_day,number_night FROM default_tour WHERE tour_id='245'	0.00034904479980469
103	SELECT slug FROM default_guide WHERE guide_id='93'	0.0002892017364502
104	SELECT title FROM default_guide WHERE guide_id='93'	0.00034594535827637
105	SELECT image FROM default_guide WHERE guide_id='93'	0.00028800964355469
106	SELECT slug FROM default_guide WHERE guide_id='51'	0.00035285949707031
107	SELECT title FROM default_guide WHERE guide_id='51'	0.00027012825012207
108	SELECT image FROM default_guide WHERE guide_id='51'	0.00029397010803223
109	SELECT slug FROM default_guide WHERE guide_id='52'	0.0003359317779541
110	SELECT title FROM default_guide WHERE guide_id='52'	0.00026988983154297
111	SELECT image FROM default_guide WHERE guide_id='52'	0.00028109550476074
112	SELECT slug FROM default_guide WHERE guide_id='96'	0.00029301643371582
113	SELECT title FROM default_guide WHERE guide_id='96'	0.00035190582275391
114	SELECT image FROM default_guide WHERE guide_id='96'	0.00027799606323242
115	SELECT slug FROM default_guide WHERE guide_id='95'	0.00033187866210938
116	SELECT title FROM default_guide WHERE guide_id='95'	0.00035285949707031
117	SELECT image FROM default_guide WHERE guide_id='95'	0.00026082992553711
118	SELECT slug FROM default_guide WHERE guide_id='94'	0.0003359317779541
119	SELECT title FROM default_guide WHERE guide_id='94'	0.00023198127746582
120	SELECT image FROM default_guide WHERE guide_id='94'	0.00032496452331543
121	SELECT slug FROM default_guide WHERE guide_id='98'	0.00027894973754883
122	SELECT title FROM default_guide WHERE guide_id='98'	0.00032281875610352
123	SELECT image FROM default_guide WHERE guide_id='98'	0.00033783912658691
124	SELECT slug FROM default_guide WHERE guide_id='87'	0.00028085708618164
125	SELECT title FROM default_guide WHERE guide_id='87'	0.00034403800964355
126	SELECT image FROM default_guide WHERE guide_id='87'	0.00031399726867676
127	SELECT slug FROM default_guide WHERE guide_id='97'	0.00031399726867676
128	SELECT title FROM default_guide WHERE guide_id='97'	0.00034189224243164
129	SELECT image FROM default_guide WHERE guide_id='97'	0.00031018257141113
130	SELECT slug FROM default_guide WHERE guide_id='88'	0.00036001205444336
131	SELECT title FROM default_guide WHERE guide_id='88'	0.00028395652770996
132	SELECT image FROM default_guide WHERE guide_id='88'	0.00028681755065918

Reunification Palace

See more

VietISO Company

About isoCMS

Travel Styles

Other

Follow Us

Payment Channel