Han s Royal Garden Hotel Beijing

Globe Secret est né de l'association de professionnels du tourisme, de l’hotellerie et du e-commerce. Les équipes de Globe Secret garantissent à ses utilisateurs une sélection rigoureuse d'hôtels de charme. Immatriculation d'agent de voyages n° IM075100403 - Garantie Financière : BPRP - Membre de l' APST - RCP : Hiscox n° HA PRC0055186 - CNIL 1517931. SSL, AmericanExpress, MasterCard, Visa, VisaElectron

History
+ –
Request History
4 previous requests available
====
Session
+ –
Session
- Config
  userAgent96a2135195cee4dc19bc11b4bba8d8cd
  time1679665903
  timeout10
  languagefre
====
Request
+ –
Request

Cake Params
- controllerhotels
- actionview
- named(empty)
- pass
 0937
 1han-s-royal-garden-hotel-beijing
- languagefr
- plugin(null)
- url
 exthtml
 urlfr/hotels/voir/937/han-s-royal-garden-hotel-beijing
- form(empty)
- isAjax(false)
$_GET
- urlfr/hotels/voir/937/han-s-royal-garden-hotel-beijing
Cookie
- languagefr
Current Route
- keys(empty)
- options(empty)
- defaults
 controllerhotels
 actionview
 languagefr
 plugin(null)
- template/fr/hotels/voir/*
- _greedy(true)
- _compiledRoute#^/fr/hotels/voir(?:/(?P<_args_>.*))?[/]*$#
- __headerMap
 typecontent_type
 methodrequest_method
 serverserver_name
====

Sql Log

+ –

Sql Logs

default

Query	Affected	Num. rows	Took (ms)	Actions
SHOW FULL COLUMNS FROM `hotels`	34	34	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	0
SHOW FULL COLUMNS FROM `cities`	6	6	0
SHOW FULL COLUMNS FROM `states`	3	3	0
SHOW FULL COLUMNS FROM `countries`	3	3	0
SHOW FULL COLUMNS FROM `weather_forecasts`	15	15	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	0
SHOW FULL COLUMNS FROM `news`	4	4	0
SHOW FULL COLUMNS FROM `i18n`	6	6	0
SHOW FULL COLUMNS FROM `home_hotels`	4	4	0
SHOW FULL COLUMNS FROM `hotel_images`	6	6	0
SHOW FULL COLUMNS FROM `rooms`	15	15	0
SHOW FULL COLUMNS FROM `rooms_rates`	8	8	0
SHOW FULL COLUMNS FROM `rates_periods`	6	6	0
SHOW FULL COLUMNS FROM `rates_period_i18n`	6	6	0
SHOW FULL COLUMNS FROM `unavailabilities`	4	4	1	maybe slow
SHOW FULL COLUMNS FROM `envies`	3	3	0
SHOW FULL COLUMNS FROM `envie_i18n`	6	6	0
SHOW FULL COLUMNS FROM `envies_hotels`	2	2	0
SHOW FULL COLUMNS FROM `comments`	19	19	0
SHOW FULL COLUMNS FROM `users`	16	16	0
SHOW FULL COLUMNS FROM `addresses`	12	12	0
SHOW FULL COLUMNS FROM `janrain_profiles`	9	9	0
SHOW FULL COLUMNS FROM `admins`	15	15	0
SHOW FULL COLUMNS FROM `favorites`	8	8	0
SHOW FULL COLUMNS FROM `hotel_i18n`	6	6	0
SHOW FULL COLUMNS FROM `configs`	3	3	0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';	1	1	0
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'fre') WHERE 1 = 1	1	1	0
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1)	2	2	0
SELECT `Hotel`., `City`., `Country`., `State`., `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'fre') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) WHERE `Hotel`.`id` = 937 LIMIT 1	1	1	1
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`maintrack_id`, `City`.`name`, `City`.`main_key` FROM `cities` AS `City` WHERE `City`.`id` = 731	1	1	0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'CN'	1	1	0
SELECT `HotelImage`.`id`, `HotelImage`.`hotel_id`, `HotelImage`.`order`, `HotelImage`.`uri`, `HotelImage`.`ratio_hw`, `HotelImage`.`on_wall` FROM `hotel_images` AS `HotelImage` WHERE `HotelImage`.`hotel_id` = (937)	42	42	0
SELECT `Room`.`id`, `Room`.`type`, `Room`.`hotel_id`, `Room`.`name`, `Room`.`description`, `Room`.`name_fre`, `Room`.`description_fre`, `Room`.`lowest_rate`, `Room`.`lr_currency`, `Room`.`lr_people`, `Room`.`breakfast_included`, `Room`.`half_board`, `Room`.`all_inclusive`, `Room`.`full_board`, `Room`.`accomodation_only` FROM `rooms` AS `Room` WHERE `Room`.`hotel_id` = (937)	4	4	2	maybe slow
SELECT `RoomsRate`.`id`, `RoomsRate`.`rates_period_id`, `RoomsRate`.`room_id`, `RoomsRate`.`rate_regular`, `RoomsRate`.`rate_special`, `RoomsRate`.`rate_currency`, `RoomsRate`.`created`, `RoomsRate`.`modified` FROM `rooms_rates` AS `RoomsRate` WHERE `RoomsRate`.`room_id` IN (3705, 3706, 3707, 3708)	0	0	0
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`to` >= NOW() AND `RatesPeriod`.`hotel_id` = (937) ORDER BY `RatesPeriod`.`from` ASC LIMIT 5	0	0	0
SELECT `News`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content` FROM `news` AS `News` INNER JOIN `i18n` AS `I18n__name` ON (`News`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'News' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__description` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'News' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__link` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'News' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'fre') WHERE `News`.`country_id` = 'CN' ORDER BY `News`.`created` DESC	0	0	1	maybe slow
SELECT `Hotel`., `HomeHotel`., `City`., `Country`., `State`.*, `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'fre') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`published` = 1 AND `Hotel`.`id` != 937 AND `Hotel`.`longitude` BETWEEN 115.23163354632 AND 117.58058345368 AND `Hotel`.`latitude` BETWEEN 39.03582414058 AND 40.83690005942 ORDER BY ABS(`Hotel`.`longitude` - 116.4061085) + ABS(`Hotel`.`latitude` - 39.9363621) ASC LIMIT 3	3	3	7	maybe slow
SELECT `HotelImage`.`id`, `HotelImage`.`hotel_id`, `HotelImage`.`order`, `HotelImage`.`uri`, `HotelImage`.`ratio_hw`, `HotelImage`.`on_wall` FROM `hotel_images` AS `HotelImage` WHERE `HotelImage`.`hotel_id` IN (1504, 752, 995)	36	36	0
SELECT `Room`.`id`, `Room`.`type`, `Room`.`hotel_id`, `Room`.`name`, `Room`.`description`, `Room`.`name_fre`, `Room`.`description_fre`, `Room`.`lowest_rate`, `Room`.`lr_currency`, `Room`.`lr_people`, `Room`.`breakfast_included`, `Room`.`half_board`, `Room`.`all_inclusive`, `Room`.`full_board`, `Room`.`accomodation_only` FROM `rooms` AS `Room` WHERE `Room`.`hotel_id` IN (1504, 752, 995)	13	13	2	maybe slow
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (1504, 752, 995)	0	0	0
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1504, 752, 995)	0	0	0
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (1504, 752, 995)	0	0	0
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`foreign_key`, `Favorite`.`model`, `Favorite`.`type`, `Favorite`.`position`, `Favorite`.`created`, `Favorite`.`modified` FROM `favorites` AS `Favorite` WHERE `Favorite`.`model` = 'Hotel' AND `Favorite`.`foreign_key` IN (1504, 752, 995)	0	0	0
SELECT `Taglines`.`id`, `Taglines`.`locale`, `Taglines`.`model`, `Taglines`.`foreign_key`, `Taglines`.`field`, `Taglines`.`content` FROM `hotel_i18n` AS `Taglines` WHERE `model` = 'Hotel' AND `field` = 'tagline' AND `Taglines`.`foreign_key` IN (1504, 752, 995)	6	6	0
SELECT `Envie`.`id`, `Envie`.`created`, `Envie`.`modified`, `EnviesHotel`.`envie_id`, `EnviesHotel`.`hotel_id` FROM `envies` AS `Envie` JOIN `envies_hotels` AS `EnviesHotel` ON (`EnviesHotel`.`hotel_id` IN (1504, 752, 995) AND `EnviesHotel`.`envie_id` = `Envie`.`id`)	8	8	2	maybe slow
SHOW FULL COLUMNS FROM `events`	18	18	0
SHOW FULL COLUMNS FROM `home_events`	4	4	0
SHOW FULL COLUMNS FROM `event_images`	5	5	0
SHOW FULL COLUMNS FROM `themes`	4	4	0
SHOW FULL COLUMNS FROM `theme_i18n`	6	6	0
SHOW FULL COLUMNS FROM `events_hotels`	2	2	0
SHOW FULL COLUMNS FROM `events_themes`	2	2	0
SHOW FULL COLUMNS FROM `event_i18n`	6	6	0
SELECT `Event`., `HomeEvent`., `CreatedUser`., `Country`., `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'fre') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'fre') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE ((`Event`.`end` IS NULL) OR (`Event`.`end` >= NOW())) AND `Event`.`longitude` BETWEEN 115.23163354632 AND 117.58058345368 AND `Event`.`latitude` BETWEEN 39.03582414058 AND 40.83690005942 ORDER BY ABS(`Event`.`longitude` - 116.4061085) + ABS(`Event`.`latitude` - 39.9363621) ASC LIMIT 10	10	10	18	maybe slow
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944)	0	0	0
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944)	0	0	0
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`foreign_key`, `Favorite`.`model`, `Favorite`.`type`, `Favorite`.`position`, `Favorite`.`created`, `Favorite`.`modified` FROM `favorites` AS `Favorite` WHERE `Favorite`.`model` = 'Event' AND `Favorite`.`foreign_key` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944)	0	0	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `event_i18n` AS `Names` WHERE `model` = 'Event' AND `field` = 'name' AND `Names`.`foreign_key` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944)	20	20	1	maybe slow
SELECT `Descriptions`.`id`, `Descriptions`.`locale`, `Descriptions`.`model`, `Descriptions`.`foreign_key`, `Descriptions`.`field`, `Descriptions`.`content` FROM `event_i18n` AS `Descriptions` WHERE `model` = 'Event' AND `field` = 'description' AND `Descriptions`.`foreign_key` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944)	20	20	1	maybe slow
SELECT `Links`.`id`, `Links`.`locale`, `Links`.`model`, `Links`.`foreign_key`, `Links`.`field`, `Links`.`content` FROM `event_i18n` AS `Links` WHERE `model` = 'Event' AND `field` = 'link' AND `Links`.`foreign_key` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944)	20	20	1	maybe slow
SELECT `Hotel`.`id`, `Hotel`.`starred`, `Hotel`.`in`, `Hotel`.`maintrack_hotel_id`, `Hotel`.`brand_code`, `Hotel`.`name`, `Hotel`.`address`, `Hotel`.`zip_code`, `Hotel`.`cityarea_id`, `Hotel`.`city_id`, `Hotel`.`region_id`, `Hotel`.`state_id`, `Hotel`.`country_id`, `Hotel`.`latitude`, `Hotel`.`longitude`, `Hotel`.`zoom`, `Hotel`.`rating`, `Hotel`.`phone`, `Hotel`.`reservation_phone`, `Hotel`.`fax`, `Hotel`.`email`, `Hotel`.`created`, `Hotel`.`modified`, `Hotel`.`description`, `Hotel`.`description_fre`, `Hotel`.`amenity`, `Hotel`.`amenity_fre`, `Hotel`.`lowest_rate`, `Hotel`.`lr_currency`, `Hotel`.`lr_people`, `Hotel`.`comment_count`, `Hotel`.`cancellation_policy`, `Hotel`.`cancellation_policy_fre`, `Hotel`.`published`, `EventsHotel`.`event_id`, `EventsHotel`.`hotel_id` FROM `hotels` AS `Hotel` JOIN `events_hotels` AS `EventsHotel` ON (`EventsHotel`.`event_id` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944) AND `EventsHotel`.`hotel_id` = `Hotel`.`id`)	0	0	0
SELECT `Theme`.`id`, `Theme`.`created`, `Theme`.`modified`, `Theme`.`uri`, `EventsTheme`.`event_id`, `EventsTheme`.`theme_id` FROM `themes` AS `Theme` JOIN `events_themes` AS `EventsTheme` ON (`EventsTheme`.`event_id` IN (940, 941, 937, 942, 939, 2034, 938, 943, 836, 944) AND `EventsTheme`.`theme_id` = `Theme`.`id`)	0	0	0
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC	256	256	0
SELECT `Theme`.*, `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18n__name` ON (`Theme`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Theme' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	10	10	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9)	20	20	0
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1	10	10	0
SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC	29	29	0
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (22, 21, 25, 26, 4, 12, 14, 19, 9, 30, 3, 1, 13, 6, 24, 7, 18, 5, 10, 27, 2, 11, 29, 16, 15, 23, 17, 8, 28)	58	58	0
SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name_fre` ASC	120	120	0
SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'fre') WHERE 1 = 1 LIMIT 4	4	4	0
SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4)	8	8	0
SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 937 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham')	1	1	0
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified`, `Hotel`.`id`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 937 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5	0	0	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

+ –

Memory

Peak Memory Use 27,00 MB

Message	Memory use
Component initialization	14,00 MB
Controller action start	14,00 MB
Controller render start	16,00 MB
View render complete	20,00 MB

Timers

Total Request Time: 503 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	66,27
Component initialization and startup	4,77
Controller action	209,75
Render Controller Action	105,33
» Rendering View	101,96
» » Rendering APP/views/hotels/view.ctp	50,09
» » » Rendering APP/views/elements/sharing_widget.ctp	0,21
» » » Rendering APP/views/elements/comments/flat/main.ctp	0,39
» » » Rendering APP/views/elements/hotels/form_reservation.ctp	3,31
» » » Rendering APP/views/elements/events/related.ctp	0,95
» » » Rendering APP/views/elements/events/related.ctp #2	0,91
» » » Rendering APP/views/elements/events/related.ctp #3	0,94
» » » Rendering APP/views/elements/events/related.ctp #4	0,92
» » » Rendering APP/views/elements/events/related.ctp #5	0,94
» » » Rendering APP/views/elements/events/related.ctp #6	1,01
» » » Rendering APP/views/elements/events/related.ctp #7	0,95
» » » Rendering APP/views/elements/events/related.ctp #8	0,93
» » » Rendering APP/views/elements/events/related.ctp #9	1,02
» » » Rendering APP/views/elements/events/related.ctp #10	0,92
» » » Rendering APP/views/elements/events/legend.ctp	1,82
» » » Rendering APP/views/elements/hotels/related.ctp #11	0,54
» » » Rendering APP/views/elements/hotels/related.ctp #12	0,68
» » » Rendering APP/views/elements/hotels/related.ctp #13	0,56
» » Rendering APP/views/layouts/default.ctp	51,68
» » » Rendering APP/views/elements/google_analytics.ctp	0,09
» » » Rendering APP/views/elements/layout/top.ctp	1,56
» » » » Rendering APP/views/elements/layout/social_networks.ctp	0,30
» » » Rendering APP/views/elements/layout/header.ctp	45,31
» » » Rendering APP/views/elements/layout/extra.ctp	0,12
» » » Rendering APP/views/elements/layout/footer.ctp	3,56
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2	0,30
» » » Rendering APP/views/elements/layout/footnotes.ctp	0,09

====

Log

+ –

Logs

warning

Time	Message
2023-03-24 04:51:43	Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: StartTag: invalid element name in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92]
2023-03-24 04:51:43	Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: Extra content at the end of the document in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92]

error

Time	Message
2023-03-24 04:51:43	Impossible to access the Google API
2023-03-24 04:51:44	Impossible to access the Google API

====

Variables
+ –
View Variables
- promises_for_layout
 0
 Promise
 id1
 title Des hôtels de charme a taille humaine
 content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
 localefre
 Titles
 0
 id10143
 localeeng
 modelPromise
 foreign_key1
 fieldtitle
 content A SELECTION OF ONLY SMALL BOUTIQUE-HOTEL
 1
 id10144
 localefre
 modelPromise
 foreign_key1
 fieldtitle
 content Des hôtels de charme a taille humaine
 Contents
 0
 id10145
 localeeng
 modelPromise
 foreign_key1
 fieldcontent
 content
 1
 id10146
 localefre
 modelPromise
 foreign_key1
 fieldcontent
 content Globe Secret se distingue par l’originalité de sa sélection d’hôtels de charme. Ces quelques 1200 adresses autour du monde ont pour trait commun l’intimité (maximum 30 chambres) et un cadre préservé. Inclassables, ces adresses sont ancrées dans la culture de leur pays, revendiquant une authenticité et un accueil personnalisé. Avec Globe Secret, vous n’êtes pas prêts d’oublier vos vacances…             <meta charset="utf-8" /> 
 1
 Promise
 id2
 title RESERVATION SANS FRAIS
 content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
 localefre
 Titles
 0
 id10147
 localeeng
 modelPromise
 foreign_key2
 fieldtitle
 content BOOKING AT NO ADDITIONAL COST
 1
 id10148
 localefre
 modelPromise
 foreign_key2
 fieldtitle
 content RESERVATION SANS FRAIS
 Contents
 0
 id10149
 localeeng
 modelPromise
 foreign_key2
 fieldcontent
 content Globe Secret provides transparency of prices and booking. By booking directly through our secure system you pay exactly the same price as if you had booked with the hotel.
 1
 id10150
 localefre
 modelPromise
 foreign_key2
 fieldcontent
 content Globe Secret garantie une transparence de prix et de réservation. En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.
 2
 Promise
 id3
 title DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
 localefre
 Titles
 0
 id10151
 localeeng
 modelPromise
 foreign_key3
 fieldtitle
 content UNIQUE SELECTION CRITERIA
 1
 id10152
 localefre
 modelPromise
 foreign_key3
 fieldtitle
 content DES CRITERES DE CHOIX UNIQUES       <meta charset="utf-8" /> 
 Contents
 0
 id10153
 localeeng
 modelPromise
 foreign_key3
 fieldcontent
 content
 1
 id10154
 localefre
 modelPromise
 foreign_key3
 fieldcontent
 content   Globe Secret vous propose de nombreux critères d’entrée et originaux pour choisir l’hôtel ou l’expérience qui correspond à vos envies. Ex: la zone géographique mais aussi le climat, la galerie. Nous avons classé les hôtels par thèmes, vous permettant de faire une recherche d'hotel ou une expérience en fonction de vos goûts ou d'une envie particulière ex: équitation, culture, festival, pêche,..
 3
 Promise
 id4
 title PLUS DE SERVICES A LA CARTE
 content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
 localefre
 Titles
 0
 id10155
 localeeng
 modelPromise
 foreign_key4
 fieldtitle
 content MORE TAILORED SERVICES
 1
 id10156
 localefre
 modelPromise
 foreign_key4
 fieldtitle
 content PLUS DE SERVICES A LA CARTE
 Contents
 0
 id10157
 localeeng
 modelPromise
 foreign_key4
 fieldcontent
 content   <meta charset="utf-8" /> Globe Secret also offers its services for booking your airline tickets. And access to negotiated rates on over 500 airlines to over 1000 destinations. According to the same principle, this service is free of charge. If you do not have time to plan your next trip or if you need advice from a specialist, we build for you on your journey, adapted to your needs and your budget. Tell us about your projects! <meta content="text/html;charset=UTF-8" http-equiv="Content-Type" /> 
 1
 id10158
 localefre
 modelPromise
 foreign_key4
 fieldcontent
 content   <meta charset="utf-8" /> <div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; "> Globe Secret vous propose aussi ses services pour la réservation de vos billets d’avion. Accédez ainsi à des tarifs négociés sur + de 500 compagnies aériennes vers plus de 1000 destinations. Toujours selon le même principe, ce service est sans frais supplémentaires. Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste, nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. Faites-nous part de vos projets !</div>
- destinations_for_layout
 AFAfghanistan
 AXAland Islands
 ALAlbania
 DZAlgeria
 ASAmerican Samoa
 ADAndorra
 AOAngola
 AIAnguilla
 AQAntarctica
 AGAntigua/Barbuda
 ARArgentina
 AMArmenia
 AWAruba
 AUAustralia
 ATAustria
 AZAzerbaijan
 BSBahamas
 BHBahrain
 BDBangladesh
 BBBarbados
 BYBelarus
 BEBelgium
 BZBelize
 BJBenin
 BMBermuda
 BTBhutan
 BOBolivia
 BABosnia
 BWBotswana
 BVBouvet Island
 BRBrazil
 IOBritish Indian Ocean Territory
 WIBritish West Indies
 BNBrunei Darussalam
 BGBulgaria
 BFBurkina Faso
 BIBurundi
 KHCambodia
 CMCameroon
 CACanada
 CVCape Verde
 KYCayman Islands
 CFCentral Africa
 TDChad
 CLChile
 CNChina
 CXChristmas Island
 CCCocos (Keeling) Islands
 COColombia
 KMComoros
 CGCongo
 CDCongo
 CKCook Islands
 CRCosta Rica
 CICote D'Ivoire
 HRCroatia
 CUCuba
 CYCyprus
 CZCzech Republic
 DKDenmark
 DJDjibouti
 DMDominica
 DODominican Republic
 TPEast Timor
 ECEcuador
 EGEgypt
 SVEl Salvador
 GQEquatorial Guinea
 EREritrea
 EEEstonia
 ETEthiopia
 FOFaeroe Islands
 FKFalkland Islands
 FJFiji
 FIFinland
 FRFrance
 PFFrench Polynesia
 TFFrench Southern Territories
 GAGabon
 GMGambia
 XAGaza
 GEGeorgia
 DEGermany
 GHGhana
 GIGibraltar
 GRGreece
 GLGreenland
 GDGrenada
 GPGuadeloupe
 GUGuam
 GTGuatemala
 GGGuernsey
 GFGuiana
 GNGuinea
 GWGuinea-Bissau
 GYGuyana
 HTHaiti
 HMHeard And Mcdonald Islands
 XHHeld Territories
 HNHonduras
 HKHong Kong
 HUHungary
 ISIceland
 INIndia
 XIIndian Ocean Islands
 IDIndonesia
 IRIran
 IQIraq
 IEIreland
 IMIsle of Man
 ILIsrael
 ITItaly
 JMJamaica
 JPJapan
 JEJersey
 JOJordan
 KZKazakhstan
 KEKenya
 KIKiribati
 KRKorea
 KWKuwait
 KGKyrgyzstan
 LALaos
 LVLatvia
 LBLebanon
 LSLesotho
 LRLiberia
 LYLibya
 LILiechtenstein
 LTLithuania
 LULuxembourg
 MOMacau
 MKMacedonia
 MGMadagascar
 MWMalawi
 MYMalaysia
 MVMaldives
 MLMali
 MTMalta
 MHMarshall Islands
 MQMartinique
 MRMauritania
 MUMauritius
 YTMayotte
 MXMexico
 FMMicronesia
 MDMoldova
 MCMonaco
 MNMongolia
 MEMontenegro
 MSMontserrat
 MAMorocco
 MZMozambique
 MMMyanmar
 NANamibia
 NRNauru
 NPNepal
 NLNetherlands
 ANNetherlands Antilles
 NCNew Caledonia
 NZNew Zealand
 NINicaragua
 NENiger
 NGNigeria
 NUNiue
 NFNorfolk Island
 XBNorthern Ireland
 MPNorthern Mariana Islands
 NONorway
 OMOman
 PKPakistan
 PWPalau
 PSPalestinian Territory
 PAPanama
 PGPapua New Guinea
 PYParaguay
 PEPeru
 PHPhilippines
 PNPitcairn
 PLPoland
 PTPortugal
 PRPuerto Rico
 QAQatar
 REReunion
 RORomania
 RURussia
 RWRwanda
 LCSaint Lucia
 BLSaint-Barthelemy
 MFSaint-Martin
 SMSan Marino
 STSao Tome And Principe
 SASaudi Arabia
 WYScotland
 SNSenegal
 RSSerbia
 YUSerbia and Montenegro
 CSSerbia and Montenegro
 SCSeychelles
 SLSierra Leone
 SGSingapore
 SKSlovak Republic
 SISlovenia
 SBSolomon Islands
 SOSomalia
 ZASouth Africa
 GSSouth Georgia
 ESSpain
 LKSri Lanka
 SHSt. Helena
 KNSt. Kitts & Nevis
 PMSt. Pierre
 VCSt. Vincent & The Grenadines
 SDSudan
 SRSuriname
 SJSvalbard And Jan Mayen Islands
 SZSwaziland
 SESweden
 CHSwitzerland
 SYSyria
 TWTaiwan
 TJTajikistan
 TZTanzania
 THThailand
 TLTimor-Leste
 TGTogo
 TKTokelau
 TOTonga
 TTTrinidad And Tobago
 TNTunisia
 TRTurkey
 TMTurkmenistan
 TCTurks And Caicos Islands
 TVTuvalu
 UMU.S. Minor Outlying Islands
 UGUganda
 UAUkraine
 AEUnited Arab Emirates
 GBUnited Kingdom
 USUnited States
 UYUruguay
 UZUzbekistan
 VUVanuatu
 VAVatican City State
 VEVenezuela
 VNVietnam
 VGVirgin Islands (British)
 VIVirgin Islands (U.S.)
 WXWales
 WFWallis And Futuna Islands
 EHWestern Sahara
 WSWestern Samoa
 YEYemen
 ZRZaire
 ZMZambia
 ZWZimbabwe
- themes_for_layout
 6Arts & Culture
 10Famille & Enfant
 7Festival & Tradition
 12Gastronomie
 11Insolite & Curieux
 13Marché & Shopping
 5Musique
 8Nature
 4Parc & Jardin
 9Sport
- themes_images_for_layout
 6art0.png
 4parc1.png
 5musique0.png
 7festival0.png
 8nature0.png
 9sport0.png
 10famille0.png
 11insolite0.png
 12gastronomie0.png
 13shopping0.png
- envies_for_layout
 22ACCES HANDICAPE
 21ACCES INTERNET
 25CAMPAGNE
 26CHASSE
 4DESERT
 12ECOLOGIE
 14EQUITATION
 19GARDE ENFANT
 9GOLF
 30HELIPORT
 3ILE
 1JUNGLE
 13LAC
 6LOCATION DE VELO
 24LOUNGE CIGARE
 7PECHE
 18PISCINE
 5PLAGE
 10PLONGEE
 27POLO
 2RANDONNEE
 11SAFARI
 29SHOPPING
 16SKI
 15SPA
 23TENNIS
 17VIGNOBLE
 8VILLE
 28VOILE
- countries_for_layout
 0
 Country
 idZA
 nameSouth Africa
 name_freAfrique Du Sud
 1
 Country
 idAL
 nameAlbania
 name_freAlbanie
 2
 Country
 idDE
 nameGermany
 name_freAllemagne
 3
 Country
 idAD
 nameAndorra
 name_freAndorre
 4
 Country
 idAI
 nameAnguilla
 name_freAnguilla
 5
 Country
 idAG
 nameAntigua/Barbuda
 name_freAntigua-Et-Barbuda
 6
 Country
 idAN
 nameNetherlands Antilles
 name_freAntilles Néerlandaises
 7
 Country
 idSA
 nameSaudi Arabia
 name_freArabie Saoudite
 8
 Country
 idAR
 nameArgentina
 name_freArgentine
 9
 Country
 idAM
 nameArmenia
 name_freArménie
 10
 Country
 idAU
 nameAustralia
 name_freAustralie
 11
 Country
 idAT
 nameAustria
 name_freAutriche
 12
 Country
 idAZ
 nameAzerbaijan
 name_freAzerbaïdjan
 13
 Country
 idBS
 nameBahamas
 name_freBahamas
 14
 Country
 idBB
 nameBarbados
 name_freBarbade
 15
 Country
 idBE
 nameBelgium
 name_freBelgique
 16
 Country
 idBZ
 nameBelize
 name_freBelize
 17
 Country
 idBM
 nameBermuda
 name_freBermudes
 18
 Country
 idBT
 nameBhutan
 name_freBhoutan
 19
 Country
 idBO
 nameBolivia
 name_freBolivie
 20
 Country
 idBA
 nameBosnia
 name_freBosnie-Herzégovine
 21
 Country
 idBR
 nameBrazil
 name_freBrésil
 22
 Country
 idKH
 nameCambodia
 name_freCambodge
 23
 Country
 idCA
 nameCanada
 name_freCanada
 24
 Country
 idCL
 nameChile
 name_freChili
 25
 Country
 idCN
 nameChina
 name_freChine
 26
 Country
 idCO
 nameColombia
 name_freColombie
 27
 Country
 idCR
 nameCosta Rica
 name_freCosta Rica
 28
 Country
 idHR
 nameCroatia
 name_freCroatie
 29
 Country
 idDK
 nameDenmark
 name_freDanemark
 30
 Country
 idDM
 nameDominica
 name_freDominique
 31
 Country
 idEG
 nameEgypt
 name_freÉgypte
 32
 Country
 idAE
 nameUnited Arab Emirates
 name_freÉmirats Arabes Unis
 33
 Country
 idEC
 nameEcuador
 name_freÉquateur
 34
 Country
 idES
 nameSpain
 name_freEspagne
 35
 Country
 idEE
 nameEstonia
 name_freEstonie
 36
 Country
 idUS
 nameUnited States
 name_freÉtats-Unis
 37
 Country
 idFJ
 nameFiji
 name_freFidji
 38
 Country
 idFI
 nameFinland
 name_freFinlande
 39
 Country
 idFR
 nameFrance
 name_freFrance
 40
 Country
 idGR
 nameGreece
 name_freGrèce
 41
 Country
 idGD
 nameGrenada
 name_freGrenade
 42
 Country
 idGP
 nameGuadeloupe
 name_freGuadeloupe
 43
 Country
 idGT
 nameGuatemala
 name_freGuatemala
 44
 Country
 idHN
 nameHonduras
 name_freHonduras
 45
 Country
 idHK
 nameHong Kong
 name_freHong-Kong
 46
 Country
 idHU
 nameHungary
 name_freHongrie
 47
 Country
 idCK
 nameCook Islands
 name_freÎles Cook
 48
 Country
 idTC
 nameTurks And Caicos Islands
 name_freÎles Turks et Caïques
 49
 Country
 idVG
 nameVirgin Islands (British)
 name_freÎles Vierges Britanniques
 50
 Country
 idVI
 nameVirgin Islands (U.S.)
 name_freÎles Vierges Des États-Unis
 51
 Country
 idIN
 nameIndia
 name_freInde
 52
 Country
 idID
 nameIndonesia
 name_freIndonésie
 53
 Country
 idIE
 nameIreland
 name_freIrlande
 54
 Country
 idIS
 nameIceland
 name_freIslande
 55
 Country
 idIL
 nameIsrael
 name_freIsraël
 56
 Country
 idIT
 nameItaly
 name_freItalie
 57
 Country
 idJM
 nameJamaica
 name_freJamaïque
 58
 Country
 idJP
 nameJapan
 name_freJapon
 59
 Country
 idJO
 nameJordan
 name_freJordanie
 60
 Country
 idKE
 nameKenya
 name_freKenya
 61
 Country
 idLA
 nameLaos
 name_freLaos
 62
 Country
 idLV
 nameLatvia
 name_freLettonie
 63
 Country
 idLB
 nameLebanon
 name_freLiban
 64
 Country
 idLT
 nameLithuania
 name_freLituanie
 65
 Country
 idMO
 nameMacau
 name_freMacao
 66
 Country
 idMG
 nameMadagascar
 name_freMadagascar
 67
 Country
 idMY
 nameMalaysia
 name_freMalaisie
 68
 Country
 idMV
 nameMaldives
 name_freMaldives
 69
 Country
 idMA
 nameMorocco
 name_freMaroc
 70
 Country
 idMU
 nameMauritius
 name_freMaurice
 71
 Country
 idMX
 nameMexico
 name_freMexique
 72
 Country
 idMN
 nameMongolia
 name_freMongolie
 73
 Country
 idME
 nameMontenegro
 name_freMonténégro
 74
 Country
 idMZ
 nameMozambique
 name_freMozambique
 75
 Country
 idMM
 nameMyanmar
 name_freMyanmar
 76
 Country
 idNA
 nameNamibia
 name_freNamibie
 77
 Country
 idNI
 nameNicaragua
 name_freNicaragua
 78
 Country
 idNO
 nameNorway
 name_freNorvège
 79
 Country
 idNZ
 nameNew Zealand
 name_freNouvelle-Zélande
 80
 Country
 idOM
 nameOman
 name_freOman
 81
 Country
 idUG
 nameUganda
 name_freOuganda
 82
 Country
 idPK
 namePakistan
 name_frePakistan
 83
 Country
 idPA
 namePanama
 name_frePanama
 84
 Country
 idNL
 nameNetherlands
 name_frePays-Bas
 85
 Country
 idPE
 namePeru
 name_frePérou
 86
 Country
 idPH
 namePhilippines
 name_frePhilippines
 87
 Country
 idPL
 namePoland
 name_frePologne
 88
 Country
 idPF
 nameFrench Polynesia
 name_frePolynésie Française
 89
 Country
 idPR
 namePuerto Rico
 name_frePorto Rico
 90
 Country
 idPT
 namePortugal
 name_frePortugal
 91
 Country
 idDO
 nameDominican Republic
 name_freRépublique Dominicaine
 92
 Country
 idCZ
 nameCzech Republic
 name_freRépublique Tchèque
 93
 Country
 idRE
 nameReunion
 name_freRéunion
 94
 Country
 idRO
 nameRomania
 name_freRoumanie
 95
 Country
 idGB
 nameUnited Kingdom
 name_freRoyaume-Uni
 96
 Country
 idRU
 nameRussia
 name_freRussie
 97
 Country
 idBL
 nameSaint-Barthelemy
 name_freSaint-Barthélemy
 98
 Country
 idKN
 nameSt. Kitts & Nevis
 name_freSaint-Kitts-Et-Nevis
 99
 Country
 idVC
 nameSt. Vincent & The Grenadines
 name_freSaint-Vincent-Et-Les Grenadines
 100
 Country
 idLC
 nameSaint Lucia
 name_freSainte-Lucie
 101
 Country
 idRS
 nameSerbia
 name_freSerbie
 102
 Country
 idSC
 nameSeychelles
 name_freSeychelles
 103
 Country
 idSG
 nameSingapore
 name_freSingapour
 104
 Country
 idSK
 nameSlovak Republic
 name_freSlovaquie
 105
 Country
 idSI
 nameSlovenia
 name_freSlovénie
 106
 Country
 idLK
 nameSri Lanka
 name_freSri Lanka
 107
 Country
 idSE
 nameSweden
 name_freSuède
 108
 Country
 idCH
 nameSwitzerland
 name_freSuisse
 109
 Country
 idSJ
 nameSvalbard And Jan Mayen Islands
 name_freSvalbard Et Île Jan Mayen
 110
 Country
 idTW
 nameTaiwan
 name_freTaïwan
 111
 Country
 idTZ
 nameTanzania
 name_freTanzanie
 112
 Country
 idTH
 nameThailand
 name_freThaïlande
 113
 Country
 idTN
 nameTunisia
 name_freTunisie
 114
 Country
 idTR
 nameTurkey
 name_freTurquie
 115
 Country
 idUA
 nameUkraine
 name_freUkraine
 116
 Country
 idUY
 nameUruguay
 name_freUruguay
 117
 Country
 idVU
 nameVanuatu
 name_freVanuatu
 118
 Country
 idVN
 nameVietnam
 name_freViet Nam
 119
 Country
 idZW
 nameZimbabwe
 name_freZimbabwe
- staticSlugs
 0qui-sommes-nous
 1plan-du-site
 2termes-et-conditions
 3actualites
 4emplois
 5mentions-legales
 6credits
- userFavorites
 fav-event(empty)
 fav-hotel(empty)
- hotel
 Hotel
 id937
 starred0
 in0
 maintrack_hotel_id365759
 brand_code000194
 nameHan s Royal Garden Hotel Beijing
 address7 Beibingmasi Hutong / 20 Qinlao Hutong Dongcheng District
 zip_code100009
 cityarea_id(null)
 city_id731
 region_id(null)
 state_id(null)
 country_idCN
 latitude39.9363621
 longitude116.4061085
 zoom12
 rating4
 phone86 10 84025588
 reservation_phone(null)
 fax(null)
 emailreservationhans@yahoo.cn
 created2011-08-29 13:12:01
 modified2011-09-29 12:08:44
 descriptionA refreshing antidote to Beijing's high-rise hotels, Han's Royal Garden is a superb example of a traditional courtyard residence. Set in a quiet hutong, it is the former home of a Chinese noble family with five impressive courtyards, Cantonese and Western dining in exquisitely elegant surrounds, a soothing spa and a dedicated wine room, all within easy access to the Forbidden City. Han's Royal Garden is a charming enclave, away from the city bustle. With its characteristic grey slate roofs, intricately painted red, green and gold paintwork, elegant stone carvings and Chinese antiques, staying here is an authentic and unique experience that encompasses the best of traditional and modern Beijing. Take a pedicab through the winding alleys of the surrounding hutongs, past cafes, art shops and then on to the Bell and Drum Towers. From here, a short taxi ride takes you to Tiananmen Square and the Wangfujing shopping district. Han's Royal Garden is a Small Luxury Hotels of the World property.
 description_freUn antidote rafraîchissant à Pékin, le Royal Garden Han est un superbe exemple d'une résidence traditionnelle. Situé dans un hutong calme, c'est l'ancienne maison d'une famille chinoise noble avec cinq cours impressionnantes, une délicieuse cuisine cantonais et occidentale, un spa apaisant et une pièce dédiée aux vins, le tout dans un accès facile à la Citée Interdite. Le Han est une enclave de charme, loin de l'agitation de la ville. Avec ses toits d'ardoise grise caractéristique, ses fines peintures rouge, vert et or, des sculptures en pierre élégante et des antiquités chinoises, en restant ici c'est une expérience authentique et unique qui englobe le meilleur de la tradition et du monde moderne de Pékin. Prenez un cyclo-pousse à travers les ruelles tortueuses des hutongs environnant, ces vieux cafés, ces boutiques d'art, puis les tours de la cloche et du tambour. De là, un court trajet en taxi vous emmène à la place Tiananmen et le quartier commerçant de Wangfujing. Le Han garden est membre de Small Luxury Hotels.
 amenityConcierge Desk, Wedding Services, Family Plan, Business Center, Courtyard, 24 Hour Room Service, 24 Hour Front Desk, Porters, Safe Deposit Box, Wake-up Service, Restaurant, Multilingual, Maid Service, Laundry/Valet Services, Turndown Service, Air Conditioned, Radio, Bathrobes, Bath Tub, TV, Connecting Rooms, Internet Access, Mini Bar, TV Remote Control, Safe, Smoke Detectors, Phone with speaker, Telephone, CD Player, DVD Player, Free Newspaper, Satellite TV, Bathroom Telephone, City Center.
 amenity_freConcierge, services de mariage, Family Plan, Business Center, Cour, room service 24 heures, réception ouverte 24 heures, les porteurs, coffre-fort, Service de réveil, restaurant, multilingue, Maid Service, blanchisserie / Services, Service de couvertures, climatisation, radio, peignoirs, baignoire, télévision, chambres communicantes, accès Internet, mini bar, télévision avec télécommande, coffre-fort, détecteurs de fumée, téléphone avec haut-parleur, Téléphone, lecteur CD, lecteur DVD, journaux gratuits, télévision satellite, téléphone, Salle de bain, Centre Ville.
 lowest_rate1161.00
 lr_currencyCNY
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 City
 id731
 country_idCN
 state_id(null)
 maintrack_idBEIJING
 nameBeijing
 main_key
 Country
 idCN
 nameChina
 name_freChine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id14341
 hotel_id937
 order2
 urihttp://images.pegs.com/imageRepo/1/0/26/147/197/226_J.jpg
 ratio_hw0.67
 on_wall0
 1
 id14342
 hotel_id937
 order3
 urihttp://images.pegs.com/imageRepo/1/0/26/147/201/8_J.jpg
 ratio_hw0.67
 on_wall0
 2
 id14343
 hotel_id937
 order4
 urihttp://images.pegs.com/imageRepo/1/0/26/147/205/3_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id14344
 hotel_id937
 order5
 urihttp://images.pegs.com/imageRepo/1/0/26/147/209/11_J.jpg
 ratio_hw0.67
 on_wall0
 4
 id14345
 hotel_id937
 order6
 urihttp://images.pegs.com/imageRepo/1/0/26/147/213/10_J.jpg
 ratio_hw0.67
 on_wall0
 5
 id14346
 hotel_id937
 order7
 urihttp://images.pegs.com/imageRepo/1/0/26/147/217/7_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id14347
 hotel_id937
 order8
 urihttp://images.pegs.com/imageRepo/1/0/26/147/221/12_J.jpg
 ratio_hw0.67
 on_wall0
 7
 id14348
 hotel_id937
 order9
 urihttp://images.pegs.com/imageRepo/1/0/26/147/225/9_J.jpg
 ratio_hw0.67
 on_wall0
 8
 id14349
 hotel_id937
 order10
 urihttp://images.pegs.com/imageRepo/1/0/26/147/229/16_J.jpg
 ratio_hw1.50
 on_wall0
 9
 id14350
 hotel_id937
 order11
 urihttp://images.pegs.com/imageRepo/1/0/26/147/233/13_J.jpg
 ratio_hw0.67
 on_wall0
 10
 id14351
 hotel_id937
 order12
 urihttp://images.pegs.com/imageRepo/1/0/26/147/247/15_J.jpg
 ratio_hw0.67
 on_wall0
 11
 id14352
 hotel_id937
 order13
 urihttp://images.pegs.com/imageRepo/1/0/26/147/271/17_J.jpg
 ratio_hw1.50
 on_wall0
 12
 id14353
 hotel_id937
 order14
 urihttp://images.pegs.com/imageRepo/1/0/26/147/287/14_J.jpg
 ratio_hw0.67
 on_wall0
 13
 id14354
 hotel_id937
 order15
 urihttp://images.pegs.com/imageRepo/1/0/26/147/318/1_J.jpg
 ratio_hw0.67
 on_wall0
 14
 id14355
 hotel_id937
 order16
 urihttp://images.pegs.com/imageRepo/1/0/26/147/337/5_J.jpg
 ratio_hw0.67
 on_wall0
 15
 id14356
 hotel_id937
 order17
 urihttp://images.pegs.com/imageRepo/1/0/26/147/341/4_J.jpg
 ratio_hw0.67
 on_wall0
 16
 id14357
 hotel_id937
 order18
 urihttp://images.pegs.com/imageRepo/1/0/26/147/361/6_J.jpg
 ratio_hw1.50
 on_wall0
 17
 id14358
 hotel_id937
 order19
 urihttp://images.pegs.com/imageRepo/1/0/26/147/365/18_J.jpg
 ratio_hw0.67
 on_wall0
 18
 id14359
 hotel_id937
 order20
 urihttp://images.pegs.com/imageRepo/1/0/26/147/369/24_J.jpg
 ratio_hw1.50
 on_wall0
 19
 id14360
 hotel_id937
 order21
 urihttp://images.pegs.com/imageRepo/1/0/26/147/373/19_J.jpg
 ratio_hw0.67
 on_wall0
 20
 id14361
 hotel_id937
 order22
 urihttp://images.pegs.com/imageRepo/1/0/26/147/377/20_J.jpg
 ratio_hw0.67
 on_wall0
 21
 id14362
 hotel_id937
 order23
 urihttp://images.pegs.com/imageRepo/1/0/26/147/381/21_J.jpg
 ratio_hw0.67
 on_wall0
 22
 id14363
 hotel_id937
 order24
 urihttp://images.pegs.com/imageRepo/1/0/26/147/399/23_J.jpg
 ratio_hw0.67
 on_wall0
 23
 id14364
 hotel_id937
 order25
 urihttp://images.pegs.com/imageRepo/1/0/26/147/403/26_J.jpg
 ratio_hw0.66
 on_wall0
 24
 id14365
 hotel_id937
 order26
 urihttp://images.pegs.com/imageRepo/1/0/26/147/407/28_J.jpg
 ratio_hw0.66
 on_wall0
 25
 id14366
 hotel_id937
 order27
 urihttp://images.pegs.com/imageRepo/1/0/26/147/411/25_J.jpg
 ratio_hw0.67
 on_wall0
 26
 id14367
 hotel_id937
 order28
 urihttp://images.pegs.com/imageRepo/1/0/26/147/427/27_J.jpg
 ratio_hw0.66
 on_wall0
 27
 id14368
 hotel_id937
 order29
 urihttp://images.pegs.com/imageRepo/1/0/26/147/437/36_J.jpg
 ratio_hw0.67
 on_wall0
 28
 id14369
 hotel_id937
 order30
 urihttp://images.pegs.com/imageRepo/1/0/26/147/441/42_J.jpg
 ratio_hw0.67
 on_wall0
 29
 id14370
 hotel_id937
 order31
 urihttp://images.pegs.com/imageRepo/1/0/26/147/445/38_J.jpg
 ratio_hw0.67
 on_wall0
 30
 id14371
 hotel_id937
 order32
 urihttp://images.pegs.com/imageRepo/1/0/26/147/449/39_J.jpg
 ratio_hw0.67
 on_wall0
 31
 id14372
 hotel_id937
 order33
 urihttp://images.pegs.com/imageRepo/1/0/26/147/453/50_J.jpg
 ratio_hw0.67
 on_wall0
 32
 id14373
 hotel_id937
 order34
 urihttp://images.pegs.com/imageRepo/1/0/26/147/470/43_J.jpg
 ratio_hw0.67
 on_wall0
 33
 id14374
 hotel_id937
 order35
 urihttp://images.pegs.com/imageRepo/1/0/26/147/492/40_J.jpg
 ratio_hw0.67
 on_wall0
 34
 id14375
 hotel_id937
 order36
 urihttp://images.pegs.com/imageRepo/1/0/26/147/496/44_J.jpg
 ratio_hw0.67
 on_wall0
 35
 id14376
 hotel_id937
 order37
 urihttp://images.pegs.com/imageRepo/1/0/26/147/500/45_J.jpg
 ratio_hw0.67
 on_wall0
 36
 id14377
 hotel_id937
 order38
 urihttp://images.pegs.com/imageRepo/1/0/26/147/504/47_J.jpg
 ratio_hw0.67
 on_wall0
 37
 id14378
 hotel_id937
 order39
 urihttp://images.pegs.com/imageRepo/1/0/27/996/726/Garden2_J.jpg
 ratio_hw0.59
 on_wall0
 38
 id14379
 hotel_id937
 order40
 urihttp://images.pegs.com/imageRepo/1/0/34/588/434/_______J.jpg
 ratio_hw0.54
 on_wall0
 39
 id14380
 hotel_id937
 order41
 urihttp://images.pegs.com/imageRepo/1/0/34/588/443/_____-___J.jpg
 ratio_hw0.58
 on_wall0
 40
 id14381
 hotel_id937
 order42
 urihttp://images.pegs.com/imageRepo/1/0/34/588/452/51-HRG-__1_J.jpg
 ratio_hw0.62
 on_wall0
 41
 id14382
 hotel_id937
 order43
 urihttp://images.pegs.com/imageRepo/1/0/34/588/461/57-HRG-____4_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id3705
 typeOTH
 hotel_id937
 nameDeluxe room
 descriptionDeluxe room with King bed in Medterranean style and bath tub, 45sqm large,courtyard view
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 1
 id3706
 typeOTH
 hotel_id937
 nameHan's Suite
 descriptionHan's Suite, with King bed in Mediterranean style, and luxurious bathroom with bath tub and shower room, 60sqm large,courtyard view.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 2
 id3707
 typeOTH
 hotel_id937
 nameMediterranean style Suite
 descriptionMediterranean style suite with king bed and luxurious bath tub and shower room, 80sqm large.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 3
 id3708
 typeOTH
 hotel_id937
 nameRosewood Suite
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RoomsRate(empty)
 RatesPeriod(empty)
 Weather(false)
 News(empty)
- relatedHotels
 0
 Hotel
 id1504
 starred0
 in0
 maintrack_hotel_id377118
 brand_codeON
 nameCourtyard 7
 address7 Qiangulou Alley South Gong and Drum Lane
 zip_code100009
 cityarea_id(null)
 city_id731
 region_id(null)
 state_id(null)
 country_idCN
 latitude39.939514061550504
 longitude116.40247454232801
 zoom13
 rating0
 phone86 1064060777
 reservation_phone(null)
 fax86 1084026867
 emailcouryardsales@163.com
 created2012-02-29 12:16:46
 modified2012-03-05 14:25:23
 descriptionCourtyard 7 is a 5 star hotel which is located in the city center of Beijing. As a typical medium-sized quadrangle in the area of NanLuoGu, it consists of three rows of courtyards that contain festooned gates, main houses, wing-room, side rooms and rear houses, which are circled by galleries. The hotel has 19 guest rooms which decorated with traditional Chinese style, it utilizes a Geothermal heat pump and Solar energy technology to provide 24 hours hot water, air conditioning, TV set, IDD, DDD, bathroom with private shower, etc. Guests can enjoy free high speed internet access, free Chinese and English newspapers, etc. There is 1 meeting room in the hotel with the max carrying capacity of 30 persons. There are Chinese restaurant, western restaurant, taproom and coffee bar in the hotel, besides there are also many recreation center around the hotel too. Welcome to our hotel.
 description_freL'hôtel Courtyard 7 est un hôtel 5 étoiles qui est situé dans le centre-ville de Beijing. En tant qu'adresse de taille moyenne typique dans le quartier de Nanluogu, il se compose de trois rangées de cours qui contiennent des portes festonnées, des maisons principales, une aile, des salles latérales et arrière des maisons, qui sont encerclés par des galeries. L'hôtel dispose de 19 chambres décorées dans un style traditionnelle chinois, il utilise une pompe à chaleur géothermique et la technologie de l'énergie solaire pour fournir de l'eau chaude 24h/24, climatisation, téléviseur, IDD, DDD, salle de bains avec douche privée, etc. Les invités peuvent profiter de l'accès gratuit à internet haut débit, les journaux gratuits chinois et anglais, etc Il y a 1 salle de réunion dans l'hôtel avec la capacité maximum de 30 personnes. Il y a un restaurant chinois, restaurant occidental, buvette et bar dans l'hôtel, en plus il y a aussi de nombreux centre de loisirs autour de l'hôtel.
 amenity24 Hour Front Desk, 24 Hour Room Service, 24 Hour Security, Air Conditioned, Airline Desk, Picnic Area/Tables, Car Rental Desk, Coffee Shop, Guest Laundromat, Elevators, Express Checkout, Florist, Free Parking, News Stand, Parking, Copy Service, Public Address System, Restaurant, Translation Service, Wake-up Service, Multilingual, Porters, Lounge, No Smoking Rooms/Facilities, Turndown Service, Internet Access ? Complimentary, AM/FM Alarm Clock, Radio, Bathrobes, Bath Tub, Television with Cable, Coffee Maker in Room, TV, Hairdryers Available, Internet Access, Mini Bar, Modem Lines in Room, In Room Movies, Refrigerator, TV Remote Control, Safe, Sitting Area, Smoke Detectors, Sofa Bed, Phone with speaker, Telephone, Trouser Press, VCR, WC, Shower, Multi-line Phone, Free Newspaper, Satellite TV, Exercise Gym, Shops/Commercial Services, Night Club, High speed internet access, Audio Visual Equipment, Business Center, Meeting/Banquet Facilities, City Center.
 amenity_freRéception ouverte 24h/24, Service de chambre 24h/24, Service de sécurité permanent, Climatisation, Guichet de la compagnie aérienne, Aires/tables de pique-nique, Guichet de location de voitures, Cafétéria, Laverie automatique, Ascenseurs, Départ rapide, Fleuriste, Parking gratuit, Kiosque à journaux, Parking, Service de photocopie, Sonorisation, Restaurant, Service de réveil, Multilingue, Porteurs, Salon, Espaces/Salles non fumeurs, Préparation des lits, Radio-réveil AM/FM, Radio, Baignoire, Télévision par câble, Chambre avec cafetière électrique, TV, Sèches-cheveux, Mini-bar, Chambre avec lignes pour modems, Chambre avec films à la carte, Réfrigérateur, Télécommande TV, Coffre-fort dans la chambre, Salon, Détecteurs de fumée, Canapé-lit, Téléphone, Magnétoscope, WC, Douche, Journal gratuit, Cours de gymnastique, Magasins/Services commerciaux, Boîte de nuit, Equipement audiovisuel, Centre des affaires, Salles de réunions/banquets.
 lowest_rate1242.00
 lr_currencyCNY
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id731
 country_idCN
 state_id(null)
 maintrack_idBEIJING
 nameBeijing
 main_key
 Country
 idCN
 nameChina
 name_freChine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id22065
 hotel_id1504
 order2
 urihttp://images.pegs.com/imageRepo/1/0/25/679/884/ON1153526_Lobb1_j_J.jpg
 ratio_hw0.66
 on_wall0
 1
 id22066
 hotel_id1504
 order3
 urihttp://images.pegs.com/imageRepo/1/0/25/679/915/ON1153526_Room1_j_J.jpg
 ratio_hw0.66
 on_wall0
 2
 id22067
 hotel_id1504
 order4
 urihttp://images.pegs.com/imageRepo/1/0/25/679/919/ON1153526_Room2_j_J.jpg
 ratio_hw0.67
 on_wall0
 3
 id22068
 hotel_id1504
 order5
 urihttp://images.pegs.com/imageRepo/1/0/25/679/899/ON1153526_Msc1_j_J.jpg
 ratio_hw0.76
 on_wall0
 4
 id22069
 hotel_id1504
 order6
 urihttp://images.pegs.com/imageRepo/1/0/25/679/903/ON1153526_Msc2_j_J.jpg
 ratio_hw0.58
 on_wall0
 5
 id22070
 hotel_id1504
 order7
 urihttp://images.pegs.com/imageRepo/1/0/25/679/889/ON1153526_Lobb2_j_J.jpg
 ratio_hw0.67
 on_wall0
 6
 id22071
 hotel_id1504
 order8
 urihttp://images.pegs.com/imageRepo/1/0/25/679/894/ON1153526_Lobb3_j_J.jpg
 ratio_hw0.70
 on_wall0
 7
 id22072
 hotel_id1504
 order9
 urihttp://images.pegs.com/imageRepo/1/0/25/679/907/ON1153526_Rest1_j_J.jpg
 ratio_hw0.66
 on_wall0
 8
 id22073
 hotel_id1504
 order10
 urihttp://images.pegs.com/imageRepo/1/0/25/679/911/ON1153526_Rest2_j_J.jpg
 ratio_hw0.66
 on_wall0
 9
 id22074
 hotel_id1504
 order11
 urihttp://images.pegs.com/imageRepo/1/0/32/0/631/35689b_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id5855
 typeOTH
 hotel_id1504
 nameStandard King Room
 descriptionStandard King Room,1 king bed,15 sqm, free high speed internet, Cable TV, IDD, DDD, mini bar, writing desk.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 1
 id5856
 typeOTH
 hotel_id1504
 nameSuperior King Room
 descriptionSuperior King Room,1 king bed,25 sqm, free high speed internet, Cable TV, IDD, DDD, mini bar, writing desk.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 2
 id5857
 typeOTH
 hotel_id1504
 nameDeluxe King Room
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id2597
 localeeng
 modelHotel
 foreign_key1504
 fieldtagline
 content
 1
 id2598
 localefre
 modelHotel
 foreign_key1504
 fieldtagline
 content
 Envie
 0
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 1
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 1
 Hotel
 id752
 starred0
 in0
 maintrack_hotel_id350705
 brand_codeIQ
 nameThe Aman at Summer Palace, Beijing
 address15 Gongmenqian Street Summer Palace
 zip_code100091
 cityarea_id(null)
 city_id731
 region_id(null)
 state_id(null)
 country_idCN
 latitude39.9331336748865
 longitude116.40030814645401
 zoom12
 rating3
 phone86 105 9879999
 reservation_phone(null)
 fax(null)
 emailreservations@amanresorts.com
 created2011-07-28 08:07:44
 modified2011-07-29 12:15:51
 descriptionThe Aman at Summer Palace Beijing is a luxury resort adjacent to the East Gate of the Summer Palace grounds (the largest and the best preserved Imperial garden of the Qing Dynasty existing in Beijing) provides significant historical and cultural importance in addition to an atmosphere of peace; a common feature recognized within all Aman properties. Most suites are positioned in a traditional style, surrounding an internal courtyard that contains a structured design of pathways separating open gardens and trees. The exterior of the building maintain a traditional Chinese architecture while the interior design is residential in style with a dignified ambiance, while embracing the traditional layout, function, materials and fabrics, the property will include modern comforts to ensure a refined guest experience.
 description_freL'Aman at Summer Palace de Pékin est un hôtel de luxe situé à côté de la porte orientale de l'enceinte du Palais d'été (le plus grand et le meilleur jardin impérial préservé de la dynastie Qing existant à Beijing) fournit un important intérêt historique et culturel en plus d'une atmosphère de paix ; une caractéristique commune reconnue au sein de toutes les propriétés Aman. La plupart des suites sont positionnés dans un style traditionnel, entourant une cour intérieure qui contient une conception structurée des voies séparant les jardins et les arbres. L'extérieur du bâtiment maintient une architecture traditionnelle chinoise tandis que le design intérieur met une ambiance digne tout en embrassant la traditionnelle fonction des matériaux et des tissus; la propriété comprend tout le confort moderne pour garantir aux hôtes une expérience raffiné.
 amenity24 Hour Front Desk, 24 Hour Room Service, 24 Hour Security, Car Rental Desk, Concierge Desk, Currency Exchange, Doctor on Call, Exercise Gym, Health Club, Jacuzzi, Laundry/Valet Services, Parking, Copy Service, Pool, Restaurant, Room Service, Fitness Center or Spa, Translation Service, Valet Parking, Porters, Business Center, Golf, Hairdryers Available, Air Conditioned, Bathrobes, Bath Tub, Television with Cable, TV, High speed internet access, Mini Bar, TV Remote Control, Safe, Shower, Smoke Detectors, U.S. Government Fire Safety Approved.
 amenity_freRéception 24 heures, service en chambre 24 heures, 24 heures de sécurité, bureau location de voitures, bureau de concierge, service de change, médecin de garde, Gymnase, Club Santé, jacuzzi, blanchisserie / services, parking, service de copie, piscine, restaurant, Room Service, Centre de fitness ou Spa, service de traduction, service de voiturier, porteurs, Business Center, Golf, sèche-cheveux disponibles, Climatisation, peignoirs, baignoire, télévision par câble, télévision, accès internet haut débit, mini bar, télévision avec télécommande, coffre, douche, détecteurs de fumée sécurité incendie US gouvernementaux approuvés.
 lowest_rate1100.00
 lr_currencyUSD
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id731
 country_idCN
 state_id(null)
 maintrack_idBEIJING
 nameBeijing
 main_key
 Country
 idCN
 nameChina
 name_freChine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id11936
 hotel_id752
 order2
 urihttp://images.pegs.com/imageRepo/1/0/18/580/769/1151969cdms_img_pho_000_nc__486493_ASPBCourtyard_Entrance_J.jpg
 ratio_hw0.74
 on_wall0
 1
 id12090
 hotel_id752
 order3
 uriaspb_aerial_view4_alb0.jpg
 ratio_hw0.87
 on_wall0
 2
 id12091
 hotel_id752
 order4
 uriaspb_bar3_alb0.jpg
 ratio_hw0.87
 on_wall0
 3
 id12092
 hotel_id752
 order5
 uriaspb_dining_pavilion3_alb0.jpg
 ratio_hw0.87
 on_wall0
 4
 id12093
 hotel_id752
 order6
 uriaspb_kunming_lake2_alb0.jpg
 ratio_hw0.87
 on_wall0
 5
 id12094
 hotel_id752
 order7
 uriaspb_lobby8a_alb0.jpg
 ratio_hw0.87
 on_wall0
 6
 id12095
 hotel_id752
 order8
 uriaspb_swim_pool4_alb0.jpg
 ratio_hw0.87
 on_wall0
 Room
 0
 id3073
 typeOTH
 hotel_id752
 nameSuite
 descriptionSuites- Measuring 66 sqm; Separate shower & WC; Twin Vanities; Inroom Safe;Daybed; Bathtub; Minibar; Flat screen TV
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 1
 id3074
 typeOTH
 hotel_id752
 nameSuite
 descriptionCourtyard Suites- Measuring 90 sqm; Separate shower & WC; Twin Vanities; Inroom Safe;Daybed; Bathtub; Minibar; Flat screen TV, Separate Living Area
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 2
 id3075
 typeOTH
 hotel_id752
 nameSuite
 descriptionDeluxe Suites - Measuring between 63 ? 78 sqm; Separate shower & WC; Twin Vanities;Inroom Safe; Daybed; Bathtub; Minibar; Flat screen TV
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 3
 id3076
 typeOTH
 hotel_id752
 nameDeluxe
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id1151
 localeeng
 modelHotel
 foreign_key752
 fieldtagline
 content
 1
 id1152
 localefre
 modelHotel
 foreign_key752
 fieldtagline
 content
 Envie
 0
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
 1
 id9
 created2011-05-17 19:26:00
 modified2011-05-17 19:26:00
 2
 id15
 created2011-05-17 19:27:34
 modified2011-05-17 19:27:34
 3
 id18
 created2011-05-17 19:28:28
 modified2011-05-17 19:28:28
 4
 id21
 created2011-05-24 08:23:14
 modified2011-05-24 08:23:14
 2
 Hotel
 id995
 starred0
 in0
 maintrack_hotel_id507929
 brand_codeON
 nameRed Wall Garden Hotel Beijing
 address41 Shijia Hutong Dongcheng District
 zip_code100010
 cityarea_id(null)
 city_id731
 region_id(null)
 state_id(null)
 country_idCN
 latitude39.91856
 longitude116.421402
 zoom13
 rating0
 phone86 1051692222
 reservation_phone(null)
 fax86 1052190220
 emailreservation@rwghotel.com
 created2011-09-02 10:10:53
 modified2011-09-03 22:22:37
 descriptionRed Wall Garden Hotel has been established quietly among the alive interest and charm of the alley with ancient trees tower to the sky and deep courtyard lined one after another. This is the 1st experimental hotel by the owner designed for the westerners, with the idea to restore the Chinese courtyard culture and the ancient health culture of China. We provide Duxiana bed made in Sweden which offers you the ultimate luxury and comfort. It provides you with an equally comfortable experience as the top-level luxury hotel in Dubai: Burj Al-Arab. The hotel covered an area of 4000 square meters, with a total of 40 delicate rooms, and has been elaborately prepared for the high-end customers with a comfortable environment overflowed with tranquility and elegance as well as good wine and dainty dishes.
 description_freL'hôtel Red Wall Garden s'est tranquillement établi parmi les intérêts vivants et le charme de l'allée avec les arbres centenaires qui un à un bordent la cour. Cet hôtel fût le premier conçu pour les Occidentaux, avec l'idée de rétablir la culture chinoise et la cour de l'ancienne culture de la santé Chinoise. Nous fournissons des lits Duxiana fabriqué en Suède, qui vous offre tout le luxe et le confort. Il vous fournit une expérience tout aussi confortable que l'hôtel de luxe de haut niveau à Dubaï: Burj Al-Arab. L'hôtel est situé sur une superficie de 4000 mètres carrés, avec un total de 40 chambres élégantes, et a été minutieusement préparé pour les clients haut de gamme avec un environnement confortable et avec une tranquillité et une élégance ainsi que le bon vin et mets délicats.
 amenity24 Hour Front Desk, 24 Hour Room Service, 24 Hour Security, Air Conditioned, Airline Desk, Babysitting/Child Services, Car Rental Desk, Coffee Shop, Guest Laundromat, Currency Exchange, Doctor on Call, Executive Level, Express Check In, Free Parking, Indoor Parking, Outdoor Parking, Parking, Copy Service, Play Ground, Restaurant, Theater Desk, Multilingual, Lounge, Wireless Internet Access, No Smoking Rooms/Facilities, Turndown Service, Television with Cable, TV, Internet Access, Mini Bar, Safe, Telephone, WC, Satellite TV, Bathrobes, Bath Tub, Hairdryers Available, TV Remote Control, Sofa Bed, Shower, Sitting Area, AM/FM Alarm Clock, Radio, Bathroom Telephone, Coffee Maker in Room, Computer in Room, Fire Place, Knock Light (Hearing Impaired), Microwave, Modem Lines in Room, Refrigerator, Smoke Detectors, Trouser Press, Voicemail, Childrens Activities, FAX, High speed internet access, Audio Visual Equipment, Business Center, Meeting/Banquet Facilities, Secretarial Service, Meal Plan - Bed and Breakfast, Continental Breakfast, Meal Plan - European, Meal Plan - MAP/Half-board, City Center.
 amenity_freRéception ouverte 24h/24, Service de chambre 24h/24, Service de sécurité permanent, Climatisation, Guichet de la compagnie aérienne, Services de garderie, Guichet de location de voitures, Cafétéria, Laverie automatique, Bureau de change, Docteur de garde, Classe affaires, Enregistrement rapide, Parking gratuit, Parking couvert, Parking en plein air, Parking, Service de photocopie, Terrain de jeux, Restaurant, Guichet de théatre, Multilingue, Salon, Espaces/Salles non fumeurs, Préparation des lits, Télévision par câble, TV, Mini-bar, Coffre-fort dans la chambre, Téléphone, WC, Baignoire, Sèches-cheveux, Télécommande TV, Canapé-lit, Douche, Salon, Radio-réveil AM/FM, Radio, Téléphone dans la salle de bain, Chambre avec cafetière électrique, Chambre avec ordinateur, Cheminée, Voyant de sonnerie (pour les malentendants), Four à micro-ondes, Chambre avec lignes pour modems, Réfrigérateur, Détecteurs de fumée, FAX, Equipement audiovisuel, Centre des affaires, Salles de réunions/banquets, Service de secrétariat, Bed and breakfast, Petit déjeuner continental, Repas non compris, Demi-pension (DP).
 lowest_rate1185.00
 lr_currencyCNY
 lr_people2
 comment_count0
 cancellation_policy(null)
 cancellation_policy_fre(null)
 published1
 localefre
 tagline
 HomeHotel
 id(null)
 hotel_id(null)
 order(null)
 created(null)
 City
 id731
 country_idCN
 state_id(null)
 maintrack_idBEIJING
 nameBeijing
 main_key
 Country
 idCN
 nameChina
 name_freChine
 State
 id(null)
 country_id(null)
 name(null)
 HotelImage
 0
 id15167
 hotel_id995
 order2
 urihttp://images.pegs.com/imageRepo/1/0/33/478/630/37630b_J.jpg
 ratio_hw1.50
 on_wall0
 1
 id15168
 hotel_id995
 order3
 urihttp://images.pegs.com/imageRepo/1/0/33/478/634/37630e_J.jpg
 ratio_hw0.66
 on_wall0
 2
 id15169
 hotel_id995
 order4
 urihttp://images.pegs.com/imageRepo/1/0/33/478/638/37630i_J.jpg
 ratio_hw1.50
 on_wall0
 3
 id15171
 hotel_id995
 order6
 urihttp://images.pegs.com/imageRepo/1/0/34/985/966/37630ro95691_J.jpg
 ratio_hw1.50
 on_wall0
 4
 id15172
 hotel_id995
 order7
 urihttp://images.pegs.com/imageRepo/1/0/33/478/648/37630ro95744_J.jpg
 ratio_hw0.66
 on_wall0
 5
 id15173
 hotel_id995
 order8
 urihttp://images.pegs.com/imageRepo/1/0/33/478/653/37630s_J.jpg
 ratio_hw1.50
 on_wall0
 6
 id15174
 hotel_id995
 order9
 urihttp://images.pegs.com/imageRepo/1/0/33/478/658/37630x_J.jpg
 ratio_hw0.66
 on_wall0
 7
 id15175
 hotel_id995
 order10
 urihttp://images.pegs.com/imageRepo/1/0/34/985/970/37630ro95692_J.jpg
 ratio_hw0.66
 on_wall0
 8
 id15176
 hotel_id995
 order11
 urihttp://images.pegs.com/imageRepo/1/0/33/478/662/37630ro95745_J.jpg
 ratio_hw0.66
 on_wall0
 9
 id15177
 hotel_id995
 order12
 urihttp://images.pegs.com/imageRepo/1/0/33/478/667/37630w_J.jpg
 ratio_hw0.66
 on_wall0
 10
 id15178
 hotel_id995
 order13
 urihttp://images.pegs.com/imageRepo/1/0/33/478/671/37630y_J.jpg
 ratio_hw0.66
 on_wall0
 11
 id15179
 hotel_id995
 order14
 urihttp://images.pegs.com/imageRepo/1/0/32/759/377/Exterior_J.jpg
 ratio_hw0.66
 on_wall0
 12
 id15180
 hotel_id995
 order15
 urihttp://images.pegs.com/imageRepo/1/0/32/759/301/rooms_J.jpg
 ratio_hw1.50
 on_wall0
 13
 id15181
 hotel_id995
 order16
 urihttp://images.pegs.com/imageRepo/1/0/32/759/338/Deluxe_Double_room_J.jpg
 ratio_hw0.66
 on_wall0
 14
 id15182
 hotel_id995
 order17
 urihttp://images.pegs.com/imageRepo/1/0/32/759/362/The_Deplex_Suite_J.jpg
 ratio_hw0.66
 on_wall0
 15
 id15183
 hotel_id995
 order18
 urihttp://images.pegs.com/imageRepo/1/0/32/759/420/Junior_suite_J.jpg
 ratio_hw0.67
 on_wall0
 16
 id15184
 hotel_id995
 order19
 urihttp://images.pegs.com/imageRepo/1/0/32/759/389/Hutong_caffee_J.jpg
 ratio_hw1.50
 on_wall0
 17
 id15185
 hotel_id995
 order20
 urihttp://images.pegs.com/imageRepo/1/0/32/759/313/Chinese_Garden_J.jpg
 ratio_hw1.50
 on_wall0
 18
 id15186
 hotel_id995
 order21
 urihttp://images.pegs.com/imageRepo/1/0/32/759/326/courtyard_J.jpg
 ratio_hw0.66
 on_wall0
 Room
 0
 id3930
 typeOTH
 hotel_id995
 nameStandard Deluxe
 descriptionIndividual Air Conditioning System , International/Local Direct Dial, International Cable TV, Free Wi-Fi, Welcoming Fruit PlatteBed Type: Sweden DUX 1.8-meter bed, Size: 27sqm, Landscape: Garden Courtyard
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 1
 id3931
 typeOTH
 hotel_id995
 nameThe Duplex Suite
 descriptionDuplex Suite, Free Wi-Fi,60 sqm,1 Double bed and a Luohan Ta, a small soft bed, Garden courtyard view, separate bedroom, living room.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 2
 id3932
 typeOTH
 hotel_id995
 nameRed Wall Deluxe
 descriptionRed Wall Deluxe,42sqm, free Wi-Fi, Individual Air Conditioning system, International/Local Direct Dial, International Cable TV.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 3
 id3933
 typeOTH
 hotel_id995
 nameJunior Suite
 descriptionJunior Suite, Free Wi-Fi,50 sqm, double bed, Individual Air Conditioning system, International/Local Direct Dial, International Cable TV.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 4
 id3934
 typeOTH
 hotel_id995
 nameStandard Twin
 descriptionStandard Twin,42 sqm, Free Wi-Fi, Individual Air Conditioning system, International/Local Direct Dial, International Cable TV.
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 5
 id3935
 typeOTH
 hotel_id995
 nameDeluxe Double
 description(null)
 name_fre(null)
 description_fre(null)
 lowest_rate(null)
 lr_currency(null)
 lr_people(null)
 breakfast_included(null)
 half_board(null)
 all_inclusive0
 full_board0
 accomodation_only0
 RatesPeriod(empty)
 Unavailability(empty)
 Comment(empty)
 Favorite(empty)
 Taglines
 0
 id1629
 localeeng
 modelHotel
 foreign_key995
 fieldtagline
 content
 1
 id1630
 localefre
 modelHotel
 foreign_key995
 fieldtagline
 content
 Envie
 0
 id8
 created2011-05-17 19:25:43
 modified2011-05-17 19:25:43
- relatedEvents
 0
 Event
 id940
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location14? Banchang Hutong, District de Dongcheng, Pékin, République populaire de Chine
 latitude39.9349
 longitude116.407
 zoom13
 state_id(null)
 country_id
 created2011-08-10 09:48:37
 modified2011-08-10 09:48:37
 url(null)
 comment_count0
 former_business_id548
 localefre
 nameRESTAURANT THE SOURCE
 descriptionC'est un restaurant discret pour manger des plats épicés du Sichuan comme le Mapo Tofu.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5611
 localeeng
 modelEvent
 foreign_key940
 fieldname
 contentTHE SOURCE RESTAURANT
 1
 id5612
 localefre
 modelEvent
 foreign_key940
 fieldname
 contentRESTAURANT THE SOURCE
 Descriptions
 0
 id5613
 localeeng
 modelEvent
 foreign_key940
 fielddescription
 contentThis is quiet Sichuan restaurant with spicy dishes like Mapo Tofu.
 1
 id5614
 localefre
 modelEvent
 foreign_key940
 fielddescription
 contentC'est un restaurant discret pour manger des plats épicés du Sichuan comme le Mapo Tofu.
 Links
 0
 id5615
 localeeng
 modelEvent
 foreign_key940
 fieldlink
 content
 1
 id5616
 localefre
 modelEvent
 foreign_key940
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 1
 Event
 id941
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationTemple de Yonghe, Dongsi, District de Dongcheng, Pékin, République populaire de Chine
 latitude39.9477
 longitude116.417
 zoom12
 state_id(null)
 country_id
 created2011-08-10 09:59:38
 modified2011-08-10 09:59:38
 url(null)
 comment_count0
 former_business_id549
 localefre
 nameTEMPLE DES LAMAS
 descriptionVisitez l'un des plus beaux temple bouddhiste Tibetain de Pékin avec ses lanternes traditionnelles, ses moulins à prières et sa superbe statue en bois de santal du bouddha Maitreya, haute de 18m. vous transportent dans un autre univers.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5617
 localeeng
 modelEvent
 foreign_key941
 fieldname
 contentLAMAS TEMPLE
 1
 id5618
 localefre
 modelEvent
 foreign_key941
 fieldname
 contentTEMPLE DES LAMAS
 Descriptions
 0
 id5619
 localeeng
 modelEvent
 foreign_key941
 fielddescription
 contentThe most beautiful Tibetan buddhist temple of the city. its flickering lamps with yak butter, its traditional prayer wheels and prodigious statue of the Buddha Sandalwood maiytreya 18m high transport you to the eternal snow country.
 1
 id5620
 localefre
 modelEvent
 foreign_key941
 fielddescription
 contentVisitez l'un des plus beaux temple bouddhiste Tibetain de Pékin avec ses lanternes traditionnelles, ses moulins à prières et sa superbe statue en bois de santal du bouddha Maitreya, haute de 18m. vous transportent dans un autre univers.
 Links
 0
 id5621
 localeeng
 modelEvent
 foreign_key941
 fieldlink
 content
 1
 id5622
 localefre
 modelEvent
 foreign_key941
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 2
 Event
 id937
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationRépublique populaire de Chine Pékin District de Haidian???Cité interdite
 latitude39.917
 longitude116.391
 zoom11
 state_id(null)
 country_id
 created2011-08-10 09:31:50
 modified2011-08-10 09:31:50
 url(null)
 comment_count0
 former_business_id545
 localefre
 nameLA CITE INTERDITE
 descriptionVisitez la Cité Interdite, cette ancienne demeure des dynasties Ming et Qing composé de bâtiments impressionnants en bois et de cours abritant de nombreux trésors impériaux..
 linkhttp://www.dpm.org.cn
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5593
 localeeng
 modelEvent
 foreign_key937
 fieldname
 contentFORBIDDEN CITY
 1
 id5594
 localefre
 modelEvent
 foreign_key937
 fieldname
 contentLA CITE INTERDITE
 Descriptions
 0
 id5595
 localeeng
 modelEvent
 foreign_key937
 fielddescription
 contentFormerly the residence of the Ming and Qing Dynasties. this impressive set of wooden buildings and houses many treasures during imperial.
 1
 id5596
 localefre
 modelEvent
 foreign_key937
 fielddescription
 contentVisitez la Cité Interdite, cette ancienne demeure des dynasties Ming et Qing composé de bâtiments impressionnants en bois et de cours abritant de nombreux trésors impériaux..
 Links
 0
 id5597
 localeeng
 modelEvent
 foreign_key937
 fieldlink
 contenthttp://www.dpm.org.cn
 1
 id5598
 localefre
 modelEvent
 foreign_key937
 fieldlink
 contenthttp://www.dpm.org.cn
 Hotel(empty)
 Theme(empty)
 3
 Event
 id942
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location18? Houhai Xiyan, District de Xicheng, Pékin, République populaire de Chine
 latitude39.9439
 longitude116.379
 zoom12
 state_id(null)
 country_id
 created2011-08-10 10:12:37
 modified2011-08-10 10:12:37
 url(null)
 comment_count0
 former_business_id550
 localefre
 nameVISITEZ LES HUTONGS
 descriptionPrenez votre temps et perdez-vous dans les derniers Hutongs de Pékin, ses ruelles discrètes bordées de maisons avec des cours traditionnelles. C'est dans la zone ouest des lacs Houhai et Qianhai que se trouvent quelques-unes des mieux préservées. Le centre culturel de Chine organise des visites privées.
 linkhttp://www.chinaculturecenter.org
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5623
 localeeng
 modelEvent
 foreign_key942
 fieldname
 contentVISIT THE LAST HUTONGS
 1
 id5624
 localefre
 modelEvent
 foreign_key942
 fieldname
 contentVISITEZ LES HUTONGS
 Descriptions
 0
 id5625
 localeeng
 modelEvent
 foreign_key942
 fielddescription
 contentSpend time in the last hutongs in the city, these narrow streets lined with traditional courtyard houses. They are scattered throughout the city but in the area west of the lakes and Qianhai Houhai are some of the best preserved.
 1
 id5626
 localefre
 modelEvent
 foreign_key942
 fielddescription
 contentPrenez votre temps et perdez-vous dans les derniers Hutongs de Pékin, ses ruelles discrètes bordées de maisons avec des cours traditionnelles. C'est dans la zone ouest des lacs Houhai et Qianhai que se trouvent quelques-unes des mieux préservées. Le centre culturel de Chine organise des visites privées.
 Links
 0
 id5627
 localeeng
 modelEvent
 foreign_key942
 fieldlink
 contenthttp://www.chinaculturecenter.org
 1
 id5628
 localefre
 modelEvent
 foreign_key942
 fieldlink
 contenthttp://www.chinaculturecenter.org
 Hotel(empty)
 Theme(empty)
 4
 Event
 id939
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location2? Nanchang St, District de Xicheng, Pékin, République populaire de Chine
 latitude39.9146
 longitude116.391
 zoom12
 state_id(null)
 country_id
 created2012-02-07 16:14:39
 modified2012-02-07 16:14:39
 url(null)
 comment_count0
 former_business_id1573
 localefre
 nameBOIRE UN VERRE OU UN THE
 descriptionPurple Vine Tea House est une pure tradition chinoise pleine de charme pour cet endroit ravissant et décoré de meubles chinois anciens, à 2 min. à pied de la cité interdite. Un grand choix de thés, une vaisselle précieuse et un service attentionné vous attendent.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5605
 localeeng
 modelEvent
 foreign_key939
 fieldname
 contentTAKE A DRINK OR A TEA
 1
 id5606
 localefre
 modelEvent
 foreign_key939
 fieldname
 contentBOIRE UN VERRE OU UN THE
 Descriptions
 0
 id5607
 localeeng
 modelEvent
 foreign_key939
 fielddescription
 contentPurple Vine Tea House is a Chinese tradition of full charm for this lovely place and decorated with antique Chinese furniture, 2 min. walk from the Forbidden City. A large selection of teas, a precious dishes and attentive service await you.
 1
 id5608
 localefre
 modelEvent
 foreign_key939
 fielddescription
 contentPurple Vine Tea House est une pure tradition chinoise pleine de charme pour cet endroit ravissant et décoré de meubles chinois anciens, à 2 min. à pied de la cité interdite. Un grand choix de thés, une vaisselle précieuse et un service attentionné vous attendent.
 Links
 0
 id5609
 localeeng
 modelEvent
 foreign_key939
 fieldlink
 content
 1
 id5610
 localefre
 modelEvent
 foreign_key939
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 5
 Event
 id2034
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 location2? Fuyou St, District de Xicheng, Pékin, République populaire de Chine
 latitude39.9197
 longitude116.385
 zoom13
 state_id(null)
 country_id
 created2012-02-29 14:31:28
 modified2012-02-29 14:31:28
 url(null)
 comment_count0
 former_business_id1646
 localefre
 nameBALADE DANS LES PARCS DE PEKIN
 descriptionRendez-vous au petit matin dans le parc de la colline de charbon, celui du temple du ciel ou le parc Beihai, pour profiter des pékinois qui jouent au jeu de go, font prendre l'air à leurs oiseaux, chantent des airs d'opéra, dansent ou pratiquent le tai-chi. Toute une ambiance à ne pas rater.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id12175
 localeeng
 modelEvent
 foreign_key2034
 fieldname
 contentWALKS IN THE BEIJING PARKS
 1
 id12176
 localefre
 modelEvent
 foreign_key2034
 fieldname
 contentBALADE DANS LES PARCS DE PEKIN
 Descriptions
 0
 id12177
 localeeng
 modelEvent
 foreign_key2034
 fielddescription
 contentEarly in the morning go in the park of the hill of coal, the Temple of Heaven and Beihai Park, to enjoy playing the game of go, do take their birds to the air, singing arias opera, dance or practice tai chi. Whole atmosphere not to be missed.
 1
 id12178
 localefre
 modelEvent
 foreign_key2034
 fielddescription
 contentRendez-vous au petit matin dans le parc de la colline de charbon, celui du temple du ciel ou le parc Beihai, pour profiter des pékinois qui jouent au jeu de go, font prendre l'air à leurs oiseaux, chantent des airs d'opéra, dansent ou pratiquent le tai-chi. Toute une ambiance à ne pas rater.
 Links
 0
 id12179
 localeeng
 modelEvent
 foreign_key2034
 fieldlink
 content
 1
 id12180
 localefre
 modelEvent
 foreign_key2034
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 6
 Event
 id938
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationPanjiayuan East Rd, Chaoyang, Pékin, République populaire de Chine
 latitude39.8762
 longitude116.451
 zoom10
 state_id(null)
 country_id
 created2011-08-10 09:43:34
 modified2011-08-10 09:43:34
 url(null)
 comment_count0
 former_business_id546
 localefre
 nameMARCHE AUX PUCES PANJIAYUAN
 descriptionNégociez les souvenirs de la révolution culturelle et d'autres objets d'arts au marché aux puces qui a lieu chaque week-end.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5599
 localeeng
 modelEvent
 foreign_key938
 fieldname
 contentPANJIAYUAN FLEA MARKET
 1
 id5600
 localefre
 modelEvent
 foreign_key938
 fieldname
 contentMARCHE AUX PUCES PANJIAYUAN
 Descriptions
 0
 id5601
 localeeng
 modelEvent
 foreign_key938
 fielddescription
 contentHaggle the souvenirs of cultural revolution and others art objects in the flea market taking place each week end.
 1
 id5602
 localefre
 modelEvent
 foreign_key938
 fielddescription
 contentNégociez les souvenirs de la révolution culturelle et d'autres objets d'arts au marché aux puces qui a lieu chaque week-end.
 Links
 0
 id5603
 localeeng
 modelEvent
 foreign_key938
 fieldlink
 content
 1
 id5604
 localefre
 modelEvent
 foreign_key938
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 7
 Event
 id943
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationChaoyang Road Side Rd, Chaoyang, Pékin, République populaire de Chine
 latitude39.9133
 longitude116.507
 zoom10
 state_id(null)
 country_id
 created2011-08-10 10:20:12
 modified2011-08-10 10:20:12
 url(null)
 comment_count0
 former_business_id551
 localefre
 nameRESTAURANT DIN TAI FUNG
 descriptionC'est l'endroit réputé pour déguster les meilleures boulettes de porcs cuites à la vapeur.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5629
 localeeng
 modelEvent
 foreign_key943
 fieldname
 contentDIN TAI FUNG RESTAURANT
 1
 id5630
 localefre
 modelEvent
 foreign_key943
 fieldname
 contentRESTAURANT DIN TAI FUNG
 Descriptions
 0
 id5631
 localeeng
 modelEvent
 foreign_key943
 fielddescription
 contentThis is the place known to enjoy the best pork dumplings steamed.
 1
 id5632
 localefre
 modelEvent
 foreign_key943
 fielddescription
 contentC'est l'endroit réputé pour déguster les meilleures boulettes de porcs cuites à la vapeur.
 Links
 0
 id5633
 localeeng
 modelEvent
 foreign_key943
 fieldlink
 content
 1
 id5634
 localefre
 modelEvent
 foreign_key943
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 8
 Event
 id836
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationZhoukoudian Rd, Pékin, République populaire de Chine
 latitude39.808
 longitude116.197
 zoom12
 state_id(null)
 country_id
 created2011-08-02 18:04:42
 modified2011-08-02 18:04:42
 url(null)
 comment_count0
 former_business_id444
 localefre
 nameSITE DE L'HOMME DE PEKIN A ZHOUKOUDIAN
 descriptionÀ 42 km au sud-ouest de Pékin, le site de Zhoukoudian, dont l'exploitation scientifique continue, a permis notamment de découvrir les restes de Sinanthropus pekinensis, accompagnés d'objets variés, qui vivait au pléistocène moyen, puis des restes d'Homo sapiens sapiens, datables de -18 000 à -11 000. En plus d'un témoignage exceptionnel sur les sociétés humaines du continent asiatique à une époque très reculée, mais il illustre aussi le processus de l'évolution.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id4987
 localeeng
 modelEvent
 foreign_key836
 fieldname
 contentBEIJING MAN SITE AT ZHOUKOUDIAN
 1
 id4988
 localefre
 modelEvent
 foreign_key836
 fieldname
 contentSITE DE L'HOMME DE PEKIN A ZHOUKOUDIAN
 Descriptions
 0
 id4989
 localeeng
 modelEvent
 foreign_key836
 fielddescription
 contentAt 42 km southwest of Beijing, the site, including the scientific exploitation continues, has led to the discovery, along with various objects, the remains of Sinanthropus pekinensis, who lived in the Middle Pleistocene, and the remains of Homo sapiens sapiens, datable from -18 000 to -11 000. The site is not only an exceptional reminder of the human societies of the Asian continent in a very early period, but also illustrates the process of evolution.
 1
 id4990
 localefre
 modelEvent
 foreign_key836
 fielddescription
 contentÀ 42 km au sud-ouest de Pékin, le site de Zhoukoudian, dont l'exploitation scientifique continue, a permis notamment de découvrir les restes de Sinanthropus pekinensis, accompagnés d'objets variés, qui vivait au pléistocène moyen, puis des restes d'Homo sapiens sapiens, datables de -18 000 à -11 000. En plus d'un témoignage exceptionnel sur les sociétés humaines du continent asiatique à une époque très reculée, mais il illustre aussi le processus de l'évolution.
 Links
 0
 id4991
 localeeng
 modelEvent
 foreign_key836
 fieldlink
 content
 1
 id4992
 localefre
 modelEvent
 foreign_key836
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
 9
 Event
 id944
 deleted0
 validate1
 published1
 created_user_id0
 begin(null)
 end(null)
 locationMutianyu, District de Huairou, Pékin, République populaire de Chine
 latitude40.4297
 longitude116.568
 zoom15
 state_id(null)
 country_id
 created2011-08-10 10:26:12
 modified2011-08-10 10:26:12
 url(null)
 comment_count0
 former_business_id552
 localefre
 nameLA MURAILLE DE CHINE
 descriptionPrenez le bus 916 depuis Dongzhimen pour visiter la Grande Muraille de Chine au nord de Pékin.
 link
 HomeEvent
 id(null)
 event_id(null)
 order(null)
 created(null)
 CreatedUser
 id(null)
 deleted(null)
 active(null)
 newsletter(null)
 username(null)
 password(null)
 locale(null)
 first_name(null)
 name(null)
 email(null)
 created(null)
 modified(null)
 new_password(null)
 last_reservation_date(null)
 password_token(null)
 token_expiration(null)
 Country
 id(null)
 name(null)
 name_fre(null)
 State
 id(null)
 country_id(null)
 name(null)
 EventImage(empty)
 Comment(empty)
 Favorite(empty)
 Names
 0
 id5635
 localeeng
 modelEvent
 foreign_key944
 fieldname
 contentTHE GREAT WALL OF CHINA
 1
 id5636
 localefre
 modelEvent
 foreign_key944
 fieldname
 contentLA MURAILLE DE CHINE
 Descriptions
 0
 id5637
 localeeng
 modelEvent
 foreign_key944
 fielddescription
 contentThe Great Wall undulates across the Gobi Desert to the north and the hills of Beijing, the Mutianyu sections is the section closest to take bus 916 from Dongzhimen.
 1
 id5638
 localefre
 modelEvent
 foreign_key944
 fielddescription
 contentPrenez le bus 916 depuis Dongzhimen pour visiter la Grande Muraille de Chine au nord de Pékin.
 Links
 0
 id5639
 localeeng
 modelEvent
 foreign_key944
 fieldlink
 content
 1
 id5640
 localefre
 modelEvent
 foreign_key944
 fieldlink
 content
 Hotel(empty)
 Theme(empty)
- weather(false)
- meta_description_for_layoutA refreshing antidote to Beijing's high-rise hotels, Han's Royal Garden is a superb example of a traditional courtyard residence. Set in a quiet hutong, it is the former home of a Chinese noble family with five impressive courtyards, Cantonese and Western dining in exquisitely elegant surrounds, a soothing spa and a dedicated wine room, all within easy access to the Forbidden City. Han's Royal Garden is a charming enclave, away from the city bustle. With its characteristic grey slate roofs, intricately painted red, green and gold paintwork, elegant stone carvings and Chinese antiques, staying here is an authentic and unique experience that encompasses the best of traditional and modern Beijing. Take a pedicab through the winding alleys of the surrounding hutongs, past cafes, art shops and then on to the Bell and Drum Towers. From here, a short taxi ride takes you to Tiananmen Square and the Wangfujing shopping district. Han's Royal Garden is a Small Luxury Hotels of the World property.
- userData(null)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
 0paginator
 1simpleGraph
 2number
 3htmlToolbar
 4toolbar
 5tree
 6cleaner
 7commentWidget
 8javascript
 9imageCache
 10text
 11i18n
 12globesecret
 13arraySplitter
 14time
 15jqueryEngine
 16form
 17js
 18session
 19favorites
 20shareThis
 21breadcrumbs
 22html
 23assetCompress
====

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Han s Royal Garden Hotel Beijing

Beijing, Chine

0 commentaires

Réserver cet hôtel

Les expériences proches de l'hôtel

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

default

Query Explain:

Memory

Timers

warning

error

Rechercher une expérience

Se laisser guider

Rechercher un hôtel de charme

Rechercher par envie

Par pays

Han s Royal Garden Hotel Beijing

Beijing, Chine

0 commentaires

Réserver cet hôtel

Les expériences proches de l'hôtel

Autres hôtels selon vos critères

Beijing, Chine Courtyard 7

Beijing, Chine The Aman at Summer Palace, Beijing

Beijing, Chine Red Wall Garden Hotel Beijing

En savoir plus

Brèves

Les promesses Globe Secret

Des hôtels de charme a taille humaine

RESERVATION SANS FRAIS

DES CRITERES DE CHOIX UNIQUES

PLUS DE SERVICES A LA CARTE

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Query Explain:

Memory

Timers

Logs

warning

error

View Variables

Beijing, Chine
Courtyard 7

Beijing, Chine
The Aman at Summer Palace, Beijing

Beijing, Chine
Red Wall Garden Hotel Beijing