Warning (2): DOMDocument::loadXML() [domdocument.loadxml]: StartTag: invalid element name in Entity, line: 1 [APP/models/datasources/google_weather_source.php, line 92]
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
DOMDocument::loadXML() - [internal], line ??
GoogleWeatherSource::read() - APP/models/datasources/google_weather_source.php, line 92
Model::find() - CORE/cake/libs/model/model.php, line 2142
Event::view() - APP/models/event.php, line 127
EventsController::view() - APP/controllers/events_controller.php, line 113
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Warning (2): DOMDocument::loadXML() [domdocument.loadxml]: Extra content at the end of the document in Entity, line: 1 [APP/models/datasources/google_weather_source.php, line 92]
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
DOMDocument::loadXML() - [internal], line ??
GoogleWeatherSource::read() - APP/models/datasources/google_weather_source.php, line 92
Model::find() - CORE/cake/libs/model/model.php, line 2142
Event::view() - APP/models/event.php, line 127
EventsController::view() - APP/controllers/events_controller.php, line 113
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Odori Park in the center of the city of Sapporo, is transformed into a museum of snow on 1.5 km. Are pregnant in the Square presents the international competition of statues of snow where a dozen teams from around the world participate each year. The park is open continuously and you can come walk there whenever you want, especially to admire the magnificent spectacle of the illumination of statues from 22:00.
Globe Secretprovides transparencyof prices andbooking. By booking directly throughour secure system you pay exactlythe same price asif you hadbookedwith the hotel.
GlobeSecretalso offersits servicesfor bookingyour airline tickets.Andaccess tonegotiated ratesonover 500airlinestoover 1000 destinations.According to the sameprinciple,this service isfree of charge.Ifyou do not havetime toplan your next triporif you needadvicefrom a specialist,we build for youonyour journey, adapted toyour needsandyour budget.Tell usabout your projects!
Globe Secret has been created from professional travelers, hospitality and e-business. Globe Secret team guarantee our users a high selection of boutique hotels. Travel agent register n° IM075100403 - Financial guarantee : BPRP - Member of - RCP : Hiscox n° HA PRC0055186 - CNIL 1517931.
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` = 'eng') 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 `Event`.*, `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` = 'eng') 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` = 'eng') 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` = 'eng') LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) WHERE `Event`.`id` = 272 AND `Event`.`deleted` = 0 AND `Event`.`validate` = 1 AND `Event`.`published` = 1 LIMIT 1
1
1
1
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` = (272)
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` = 272 AND `EventsTheme`.`theme_id` = `Theme`.`id`)
4
4
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` = 'eng') 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` = 'eng') 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` = 'eng') WHERE `News`.`country_id` = 'JP' ORDER BY `News`.`created` DESC LIMIT 1
0
0
2
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` = 'eng') 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`.`longitude` BETWEEN 140.09486407996 AND 142.56033017043 AND `Hotel`.`latitude` BETWEEN 42.16933327766 AND 43.970409196501 ORDER BY ABS(`Hotel`.`longitude` - 141.327597125195) + ABS(`Hotel`.`latitude` - 43.0698712370804) ASC LIMIT 10
0
0
6
maybe slow
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` = 'eng') 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` = 'eng') 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` = 'eng') 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`.`id` != 272 AND `Event`.`longitude` BETWEEN 140.09486407996 AND 142.56033017043 AND `Event`.`latitude` BETWEEN 42.16933327766 AND 43.970409196501 ORDER BY ABS(`Event`.`longitude` - 141.327597125195) + ABS(`Event`.`latitude` - 43.0698712370804) ASC LIMIT 10
0
0
12
maybe slow
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` = 'eng') 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 `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` = 'eng') 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` = 'eng') 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 (19, 5, 6, 24, 8, 25, 4, 10, 12, 7, 9, 22, 30, 14, 26, 21, 3, 1, 13, 27, 18, 11, 28, 29, 16, 15, 23, 2, 17)
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` 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` = 'eng') 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` = 'eng') 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 `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) LEFT JOIN `events` AS `Event` ON (`Comment`.`foreign_key` = `Event`.`id`) WHERE `Comment`.`approved` = 1 AND `Event`.`id` = 272 AND `Comment`.`model` = 'Event' 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`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug`, `Event`.`id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) LEFT JOIN `events` AS `Event` ON (`Comment`.`foreign_key` = `Event`.`id`) WHERE `Comment`.`approved` = 1 AND `Event`.`id` = 272 AND `Comment`.`model` = 'Event' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5
0
0
0
Query Explain:
Click an "Explain" link above, to see the query explanation.
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-02-01 19:31:11
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]
title<p>
<span style="font-size:20px;">A SELECTION OF ONLY SMALL</span> <span style="font-size:14px;">BOUTIQUE-HOTEL</span></p>
content
localeeng
Titles
0
id10143
localeeng
modelPromise
foreign_key1
fieldtitle
content<p>
<span style="font-size:20px;">A SELECTION OF ONLY SMALL</span> <span style="font-size:14px;">BOUTIQUE-HOTEL</span></p>
1
id10144
localefre
modelPromise
foreign_key1
fieldtitle
content<p>
<span style="font-size:20px;">Des hôtels de charme </span><span style="font-size:14px;">a taille humaine</span></p>
Contents
0
id10145
localeeng
modelPromise
foreign_key1
fieldcontent
content
1
id10146
localefre
modelPromise
foreign_key1
fieldcontent
content<p>
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…</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
<meta charset="utf-8" />
</p>
1
Promise
id2
title<p>
BOOKING AT NO ADDITIONAL COST</p>
content<p>
<strong><span class="hps">Globe Secret</span> <span class="hps">provides transparency</span> <span class="hps">of prices and</span> <span class="hps">booking</span></strong><span>.</span> By booking <span class="hps">directly through</span> <span class="hps">our secure</span> system you <span class="hps">pay exactly</span> <span class="hps">the same price as</span> <span class="hps">if you had</span> <span class="hps">booked</span> <span class="hps">with the hotel</span><span>.</span></p>
localeeng
Titles
0
id10147
localeeng
modelPromise
foreign_key2
fieldtitle
content<p>
BOOKING AT NO ADDITIONAL COST</p>
1
id10148
localefre
modelPromise
foreign_key2
fieldtitle
content<p>
RESERVATION SANS FRAIS</p>
Contents
0
id10149
localeeng
modelPromise
foreign_key2
fieldcontent
content<p>
<strong><span class="hps">Globe Secret</span> <span class="hps">provides transparency</span> <span class="hps">of prices and</span> <span class="hps">booking</span></strong><span>.</span> By booking <span class="hps">directly through</span> <span class="hps">our secure</span> system you <span class="hps">pay exactly</span> <span class="hps">the same price as</span> <span class="hps">if you had</span> <span class="hps">booked</span> <span class="hps">with the hotel</span><span>.</span></p>
1
id10150
localefre
modelPromise
foreign_key2
fieldcontent
content<p>
<strong>Globe Secret garantie une transparence de prix et de réservation. </strong>En réservant directement sur notre site sécurisé vous payez éxactement le même prix que celui affiché par l'hôtel.</p>
content<p>
</p>
<p>
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,..</p>
3
Promise
id4
title<p>
MORE TAILORED SERVICES</p>
content<p>
</p>
<p>
<meta charset="utf-8" />
<span class="hps">Globe</span> <span class="hps">Secret</span> <span class="hps">also offers</span> <span class="hps">its services</span> <span class="hps">for <strong>booking</strong></span><strong> <span class="hps">your airline tickets</span></strong><span>.</span> <span class="hps">And</span> <span class="hps">access </span><span class="hps">to</span> <span class="hps">negotiated rates</span> <span class="hps">on</span> <span class="hps">over 500</span> <span class="hps">airlines</span> <span class="hps">to</span> <span class="hps">over 1000 destinations</span><span>.</span> <span class="hps">According to the same</span> <span class="hps">principle</span><span>,</span> <span class="hps">this service is</span> <span class="hps"><strong>free of charge</strong>.</span> <span class="hps">If</span> <span class="hps">you do not have</span> <span class="hps">time to</span> <span class="hps">plan your next trip</span> <span class="hps">or</span> <span class="hps">if you need</span> <span class="hps">advice</span> <span class="hps">from a specialist</span><span>,</span> <strong><span class="hps">we build for you</span> <span class="hps">on</span> <span class="hps">your journey</span></strong><span>, adapted to</span> <span class="hps">your needs</span> <span class="hps">and</span> <span class="hps">your budget</span><span>.</span> <span class="hps">Tell us</span> <span class="hps">about your projects!</span></p>
<p>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type" />
</p>
localeeng
Titles
0
id10155
localeeng
modelPromise
foreign_key4
fieldtitle
content<p>
MORE TAILORED SERVICES</p>
1
id10156
localefre
modelPromise
foreign_key4
fieldtitle
content<p>
PLUS DE SERVICES A LA CARTE</p>
Contents
0
id10157
localeeng
modelPromise
foreign_key4
fieldcontent
content<p>
</p>
<p>
<meta charset="utf-8" />
<span class="hps">Globe</span> <span class="hps">Secret</span> <span class="hps">also offers</span> <span class="hps">its services</span> <span class="hps">for <strong>booking</strong></span><strong> <span class="hps">your airline tickets</span></strong><span>.</span> <span class="hps">And</span> <span class="hps">access </span><span class="hps">to</span> <span class="hps">negotiated rates</span> <span class="hps">on</span> <span class="hps">over 500</span> <span class="hps">airlines</span> <span class="hps">to</span> <span class="hps">over 1000 destinations</span><span>.</span> <span class="hps">According to the same</span> <span class="hps">principle</span><span>,</span> <span class="hps">this service is</span> <span class="hps"><strong>free of charge</strong>.</span> <span class="hps">If</span> <span class="hps">you do not have</span> <span class="hps">time to</span> <span class="hps">plan your next trip</span> <span class="hps">or</span> <span class="hps">if you need</span> <span class="hps">advice</span> <span class="hps">from a specialist</span><span>,</span> <strong><span class="hps">we build for you</span> <span class="hps">on</span> <span class="hps">your journey</span></strong><span>, adapted to</span> <span class="hps">your needs</span> <span class="hps">and</span> <span class="hps">your budget</span><span>.</span> <span class="hps">Tell us</span> <span class="hps">about your projects!</span></p>
<p>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type" />
</p>
1
id10158
localefre
modelPromise
foreign_key4
fieldcontent
content<p>
</p>
<p>
<meta charset="utf-8" />
</p>
<div class="yiv1153918698MsoNormal" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font-family: verdana, helvetica, sans-serif; ">
<span style="font-family: Verdana; "><font>Globe Secret vous propose aussi ses services pour la <b>réservation de vos billets d’avion.</b> 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 <b>sans frais supplémentaires</b>. </font></span><span style="font-family: Verdana; ">Si vous n’avez pas le temps de préparer votre prochain voyage ou si vous avez besoin des conseils d’un spécialiste,<b> nous construisons pour vous votre voyage sur mesure, adapté à vos besoins et votre budget. </b></span><span style="font-family: Verdana; ">Faites-nous part de vos projets !</span></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
6Art & 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
19BABY SITTING
5BEACH
6BICYCLE RENTAL
24CIGAR LOUNGE
8CITY
25COUNTRYSIDE
4DESERT
10DIVING
12ECOLOGY
7FISHING
9GOLF
22HANDICAP ACCESS
30HELIPORT
14HORSEBACK RIDING
26HUNTING
21INTERNET ACCESS
3ISLAND
1JUNGLE
13LAKE
27POLO
18POOL
11SAFARI
28SAILING
29SHOPPING
16SKIING
15SPA
23TENNIS
2TREKKING
17WINERY
countries_for_layout
0
Country
idAL
nameAlbania
name_freAlbanie
1
Country
idAD
nameAndorra
name_freAndorre
2
Country
idAI
nameAnguilla
name_freAnguilla
3
Country
idAG
nameAntigua/Barbuda
name_freAntigua-Et-Barbuda
4
Country
idAR
nameArgentina
name_freArgentine
5
Country
idAM
nameArmenia
name_freArménie
6
Country
idAU
nameAustralia
name_freAustralie
7
Country
idAT
nameAustria
name_freAutriche
8
Country
idAZ
nameAzerbaijan
name_freAzerbaïdjan
9
Country
idBS
nameBahamas
name_freBahamas
10
Country
idBB
nameBarbados
name_freBarbade
11
Country
idBE
nameBelgium
name_freBelgique
12
Country
idBZ
nameBelize
name_freBelize
13
Country
idBM
nameBermuda
name_freBermudes
14
Country
idBT
nameBhutan
name_freBhoutan
15
Country
idBO
nameBolivia
name_freBolivie
16
Country
idBA
nameBosnia
name_freBosnie-Herzégovine
17
Country
idBR
nameBrazil
name_freBrésil
18
Country
idKH
nameCambodia
name_freCambodge
19
Country
idCA
nameCanada
name_freCanada
20
Country
idCL
nameChile
name_freChili
21
Country
idCN
nameChina
name_freChine
22
Country
idCO
nameColombia
name_freColombie
23
Country
idCK
nameCook Islands
name_freÎles Cook
24
Country
idCR
nameCosta Rica
name_freCosta Rica
25
Country
idHR
nameCroatia
name_freCroatie
26
Country
idCZ
nameCzech Republic
name_freRépublique Tchèque
27
Country
idDK
nameDenmark
name_freDanemark
28
Country
idDM
nameDominica
name_freDominique
29
Country
idDO
nameDominican Republic
name_freRépublique Dominicaine
30
Country
idEC
nameEcuador
name_freÉquateur
31
Country
idEG
nameEgypt
name_freÉgypte
32
Country
idEE
nameEstonia
name_freEstonie
33
Country
idFJ
nameFiji
name_freFidji
34
Country
idFI
nameFinland
name_freFinlande
35
Country
idFR
nameFrance
name_freFrance
36
Country
idPF
nameFrench Polynesia
name_frePolynésie Française
37
Country
idDE
nameGermany
name_freAllemagne
38
Country
idGR
nameGreece
name_freGrèce
39
Country
idGD
nameGrenada
name_freGrenade
40
Country
idGP
nameGuadeloupe
name_freGuadeloupe
41
Country
idGT
nameGuatemala
name_freGuatemala
42
Country
idHN
nameHonduras
name_freHonduras
43
Country
idHK
nameHong Kong
name_freHong-Kong
44
Country
idHU
nameHungary
name_freHongrie
45
Country
idIS
nameIceland
name_freIslande
46
Country
idIN
nameIndia
name_freInde
47
Country
idID
nameIndonesia
name_freIndonésie
48
Country
idIE
nameIreland
name_freIrlande
49
Country
idIL
nameIsrael
name_freIsraël
50
Country
idIT
nameItaly
name_freItalie
51
Country
idJM
nameJamaica
name_freJamaïque
52
Country
idJP
nameJapan
name_freJapon
53
Country
idJO
nameJordan
name_freJordanie
54
Country
idKE
nameKenya
name_freKenya
55
Country
idLA
nameLaos
name_freLaos
56
Country
idLV
nameLatvia
name_freLettonie
57
Country
idLB
nameLebanon
name_freLiban
58
Country
idLT
nameLithuania
name_freLituanie
59
Country
idMO
nameMacau
name_freMacao
60
Country
idMG
nameMadagascar
name_freMadagascar
61
Country
idMY
nameMalaysia
name_freMalaisie
62
Country
idMV
nameMaldives
name_freMaldives
63
Country
idMU
nameMauritius
name_freMaurice
64
Country
idMX
nameMexico
name_freMexique
65
Country
idMN
nameMongolia
name_freMongolie
66
Country
idME
nameMontenegro
name_freMonténégro
67
Country
idMA
nameMorocco
name_freMaroc
68
Country
idMZ
nameMozambique
name_freMozambique
69
Country
idMM
nameMyanmar
name_freMyanmar
70
Country
idNA
nameNamibia
name_freNamibie
71
Country
idNL
nameNetherlands
name_frePays-Bas
72
Country
idAN
nameNetherlands Antilles
name_freAntilles Néerlandaises
73
Country
idNZ
nameNew Zealand
name_freNouvelle-Zélande
74
Country
idNI
nameNicaragua
name_freNicaragua
75
Country
idNO
nameNorway
name_freNorvège
76
Country
idOM
nameOman
name_freOman
77
Country
idPK
namePakistan
name_frePakistan
78
Country
idPA
namePanama
name_frePanama
79
Country
idPE
namePeru
name_frePérou
80
Country
idPH
namePhilippines
name_frePhilippines
81
Country
idPL
namePoland
name_frePologne
82
Country
idPT
namePortugal
name_frePortugal
83
Country
idPR
namePuerto Rico
name_frePorto Rico
84
Country
idRE
nameReunion
name_freRéunion
85
Country
idRO
nameRomania
name_freRoumanie
86
Country
idRU
nameRussia
name_freRussie
87
Country
idLC
nameSaint Lucia
name_freSainte-Lucie
88
Country
idBL
nameSaint-Barthelemy
name_freSaint-Barthélemy
89
Country
idSA
nameSaudi Arabia
name_freArabie Saoudite
90
Country
idRS
nameSerbia
name_freSerbie
91
Country
idSC
nameSeychelles
name_freSeychelles
92
Country
idSG
nameSingapore
name_freSingapour
93
Country
idSK
nameSlovak Republic
name_freSlovaquie
94
Country
idSI
nameSlovenia
name_freSlovénie
95
Country
idZA
nameSouth Africa
name_freAfrique Du Sud
96
Country
idES
nameSpain
name_freEspagne
97
Country
idLK
nameSri Lanka
name_freSri Lanka
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
idSJ
nameSvalbard And Jan Mayen Islands
name_freSvalbard Et Île Jan Mayen
101
Country
idSE
nameSweden
name_freSuède
102
Country
idCH
nameSwitzerland
name_freSuisse
103
Country
idTW
nameTaiwan
name_freTaïwan
104
Country
idTZ
nameTanzania
name_freTanzanie
105
Country
idTH
nameThailand
name_freThaïlande
106
Country
idTN
nameTunisia
name_freTunisie
107
Country
idTR
nameTurkey
name_freTurquie
108
Country
idTC
nameTurks And Caicos Islands
name_freÎles Turks et Caïques
109
Country
idUG
nameUganda
name_freOuganda
110
Country
idUA
nameUkraine
name_freUkraine
111
Country
idAE
nameUnited Arab Emirates
name_freÉmirats Arabes Unis
112
Country
idGB
nameUnited Kingdom
name_freRoyaume-Uni
113
Country
idUS
nameUnited States
name_freÉtats-Unis
114
Country
idUY
nameUruguay
name_freUruguay
115
Country
idVU
nameVanuatu
name_freVanuatu
116
Country
idVN
nameVietnam
name_freViet Nam
117
Country
idVG
nameVirgin Islands (British)
name_freÎles Vierges Britanniques
118
Country
idVI
nameVirgin Islands (U.S.)
name_freÎles Vierges Des États-Unis
119
Country
idZW
nameZimbabwe
name_freZimbabwe
staticSlugs
0who-we-are
1sitemap
2terms-and-conditions
3news
4jobs
5legal
6credits
userFavorites
fav-event(empty)
fav-hotel(empty)
event
Event
id272
deleted0
validate1
published1
created_user_id1
begin2012-02-01
end2012-02-07
locationSoen-Hassamu Dori, 063-0802, Japon
latitude43.0698712370804
longitude141.327597125195
zoom13
state_id(null)
country_idJP
created2011-08-02 15:40:02
modified2011-08-02 15:40:02
url
comment_count0
former_business_id(null)
localeeng
nameINTERNATIONAL ICE FESTIVAL IN SAPPORO
descriptionOdori Park in the center of the city of Sapporo, is transformed into a museum of snow on 1.5 km. Are pregnant in the Square presents the international competition of statues of snow where a dozen teams from around the world participate each year. The park is open continuously and you can come walk there whenever you want, especially to admire the magnificent spectacle of the illumination of statues from 22:00.
link
Country
idJP
nameJapan
name_freJapon
State
id(null)
country_id(null)
name(null)
EventImage(empty)
Theme
0
id6
created2011-05-12 12:50:25
modified2011-05-12 14:02:42
uriart0.png
1
id7
created2011-05-12 12:50:31
modified2011-05-12 12:50:31
urifestival0.png
2
id11
created2011-05-12 12:50:53
modified2011-05-12 12:50:53
uriinsolite0.png
3
id8
created2011-05-12 12:50:35
modified2011-05-12 12:50:35
urinature0.png
Weather(false)
News(empty)
relatedHotels(empty)
relatedEvents(empty)
themes
6Art & Culture
10Famille & Enfant
7Festival & Tradition
12Gastronomie
11Insolite & Curieux
13Marché & Shopping
5Musique
8Nature
4Parc & Jardin
9Sport
themes_images
6art0.png
4parc1.png
5musique0.png
7festival0.png
8nature0.png
9sport0.png
10famille0.png
11insolite0.png
12gastronomie0.png
13shopping0.png
meta_description_for_layoutOdori Park in the center of the city of Sapporo, is transformed into a museum of snow on 1.5 km. Are pregnant in the Square presents the international competition of statues of snow where a dozen teams from around the world participate each year. The park is open continuously and you can come walk there whenever you want, especially to admire the magnificent spectacle of the illumination of statues from 22:00.
- RCP : Hiscox n° HA PRC0055186 - CNIL 1517931.
0 comment
Add your commentFor which desire?