About Soldeu & El Tarter

Andorra's best all round skiing resort, offerring high quality accommodation, superb facilities, lively Apres Ski and excellent value for money. Soldeu & El Tarter are part of the GRANDVALIRA Ski area which boasts 210KM of ski area over 128 runs wtih something for everyone, 16 Green, 51 Blue, 42 Red and for the show offs, 19 Black oh and 3 freestyle parks and 2 world class runs. Soldeu is an enchanting, charming village that has been extensivley developed into a leading ski and summer tourist destination. 

Click image to start gallery

Your Holiday

El Clos Snack Bar

10AM - 10PM
You could almost ski onto our terrace from the bottom of the El Tarter chair lift. A great choice for lunch, varied menu from snacks to full a blown m

Borda del Rector

1PM - 5Pm & 8PM - Midnight
If you are looking to sample local cuisine and flavours of the highest order, then this is probably your best bet in the Soldeu area. A charming old r

La Caleta

Noon until Midnight
Soldeu's original Tapas restaurant. Come and visit Jose in this cosy little restaurant and enjoy some traditional Andaluz Tapas and tasty wine - every

La Cort De Popaire

1PM - 10:30PM
Set in old barn gives Cort de Popaire a rustic traditional feel, enhanced with the large open fire. This is one of Soldeu's favourite restaurants amon

Live Resort Chat

Add new comment

Say hello to jude, mad nortern irish woman. Tell her james said she had to buy you a shot!!
Sent from Soldeu » reply to this comment
helen Manchester
1 month ago
Fat Albert’s is closed today for a rafting event for the staff. But will give Barcode a go. Thanks.
Sent from Soldeu » reply to this comment
Andorra Travel Service

Resort contact

Andorra Travel Service

Email:

info@andorratravelservice.com

Phone:

00 376 351150

Twitter:

@andorraexperts

Website:

www.andorratravelservice.com/

  • CakePHP
  • History
  • Session
    +

    Session

    • Config
      • userAgent29e8e2091e3e9dfa2b291ecad977d67c
      • time1537682767
      • countdown10
    • is_mobile(false)
    • UserAuth(empty)
    • _Token
      • key32f791bfdd0d389e2e55277305bb9e74084838e7
      • allowedControllers(empty)
      • allowedActions(empty)
      • unlockedFields(empty)
      • csrfTokens
        • 32f791bfdd0d389e2e55277305bb9e74084838e71524724567
    ====
  • Request
    +

    Request

    Cake Params

    • plugin(null)
    • controllerPages
    • actionresort
    • named(empty)
    • pass
      • 0Andorra
      • 1RestOfAndorra
      • 2soldeu--el-tarter
    • isAjax(false)
    • _Token
      • key32f791bfdd0d389e2e55277305bb9e74084838e7
      • unlockedFields(empty)

    Post data

    No post data.

    Query string

    No querystring data.

    Cookie

    • ChatMessages3

    Current Route

    • keys(empty)
    • options(empty)
    • defaults
      • controllerPages
      • actionresort
      • plugin(null)
    • template/resort/*
    ====
  • Sqllog
    +

    Sql Logs

    default

    Total Time: 35 ms
    Total Queries: 36 queries
    Query Affected Num. rows Took (ms) Actions
    SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `hooh_live`.`cake_sessions` AS `Session` WHERE `id` = '3hm2q4qm4pk0655ndeo31inmm3' LIMIT 1 0 0 1 maybe slow
    SELECT `UserSetting`.`id`, `UserSetting`.`name`, `UserSetting`.`name_public`, `UserSetting`.`value`, `UserSetting`.`type`, `UserSetting`.`category` FROM `hooh_live`.`user_settings` AS `UserSetting` WHERE 1 = 1 56 56 0
    SELECT `UserActivity`.`id`, `UserActivity`.`useragent`, `UserActivity`.`user_id`, `UserActivity`.`last_action`, `UserActivity`.`last_url`, `UserActivity`.`logout_time`, `UserActivity`.`user_browser`, `UserActivity`.`ip_address`, `UserActivity`.`logout`, `UserActivity`.`deleted`, `UserActivity`.`status`, `UserActivity`.`created`, `UserActivity`.`modified`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name` FROM `hooh_live`.`user_activities` AS `UserActivity` LEFT JOIN `hooh_live`.`users` AS `User` ON (`UserActivity`.`user_id` = `User`.`id`) WHERE `UserActivity`.`useragent` = '29e8e2091e3e9dfa2b291ecad977d67c3hm2q4qm4pk0655ndeo31inmm3' LIMIT 1 0 0 0
    SELECT `Country`.`id`, `Country`.`name` FROM `hooh_live`.`countries` AS `Country` WHERE 1 = 1 269 269 0
    SELECT `Region`.`id`, `Region`.`name` FROM `hooh_live`.`regions` AS `Region` WHERE 1 = 1 249 249 0
    SELECT `Resort`.`id`, `Resort`.`radio_id`, `Resort`.`name`, `Resort`.`slug`, `Resort`.`user_id`, `Resort`.`region_based_resort`, `Resort`.`region_id`, `Resort`.`country_id`, `Resort`.`description`, `Resort`.`background`, `Resort`.`background_type`, `Resort`.`email`, `Resort`.`phone`, `Resort`.`uploadfile`, `Resort`.`facebook`, `Resort`.`twitter`, `Resort`.`google`, `Resort`.`website`, `Resort`.`location`, `Resort`.`location_weather`, `Resort`.`location_weather_WEOID`, `Resort`.`lat`, `Resort`.`lng`, `Resort`.`active`, `Resort`.`is_imported`, `Resort`.`featured`, `Resort`.`views`, `Resort`.`seo_title`, `Resort`.`seo_description`, `Resort`.`seo_keywords`, `Resort`.`modified`, `Resort`.`created`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`short_description`, `Region`.`active`, `Region`.`featured`, `Region`.`order`, `Region`.`picture`, `Region`.`modified`, `Region`.`created`, `Country`.`id`, `Country`.`cc_fips`, `Country`.`cc_iso`, `Country`.`tld`, `Country`.`name`, `Country`.`featured`, `Country`.`background`, `Country`.`order` FROM `hooh_live`.`resorts` AS `Resort` LEFT JOIN `hooh_live`.`users` AS `User` ON (`Resort`.`user_id` = `User`.`id`) LEFT JOIN `hooh_live`.`regions` AS `Region` ON (`Resort`.`region_id` = `Region`.`id`) LEFT JOIN `hooh_live`.`countries` AS `Country` ON (`Resort`.`country_id` = `Country`.`id`) WHERE `Resort`.`active` = '1' AND ((`Resort`.`slug` = 'soldeu--el-tarter') OR (`Resort`.`slug` = 'RestOfAndorra') OR (`Resort`.`slug` = 'Andorra')) LIMIT 1 1 1 1
    SELECT `UserDetail`.`id`, `UserDetail`.`user_id`, `UserDetail`.`resort_id`, `UserDetail`.`gender`, `UserDetail`.`photo`, `UserDetail`.`cover_image`, `UserDetail`.`bday`, `UserDetail`.`location`, `UserDetail`.`marital_status`, `UserDetail`.`cellphone`, `UserDetail`.`facebook`, `UserDetail`.`twitter`, `UserDetail`.`google`, `UserDetail`.`web_page`, `UserDetail`.`works_at`, `UserDetail`.`about`, `UserDetail`.`interests`, `UserDetail`.`newsletter`, `UserDetail`.`has_holiday`, `UserDetail`.`created`, `UserDetail`.`modified` FROM `hooh_live`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = 4186 1 1 0
    SELECT `ResortPicture`.`id`, `ResortPicture`.`resort_id`, `ResortPicture`.`user_id`, `ResortPicture`.`title`, `ResortPicture`.`picture`, `ResortPicture`.`primary_picture`, `ResortPicture`.`active`, `ResortPicture`.`sort_order`, `ResortPicture`.`created`, `ResortPicture`.`modified` FROM `hooh_live`.`resort_pictures` AS `ResortPicture` WHERE `ResortPicture`.`resort_id` = (484) LIMIT 4 4 4 0
    SELECT `Place`.`id`, `Place`.`name`, `Place`.`contact_name`, `Place`.`slug`, `Place`.`user_id`, `Place`.`resort_id`, `Place`.`place_category_id`, `Place`.`region_based_place`, `Place`.`region_id`, `Place`.`description`, `Place`.`background`, `Place`.`background_type`, `Place`.`email`, `Place`.`phone`, `Place`.`oh_from`, `Place`.`oh_to`, `Place`.`opening_hours`, `Place`.`facebook`, `Place`.`twitter`, `Place`.`google`, `Place`.`website`, `Place`.`location`, `Place`.`lat`, `Place`.`lng`, `Place`.`active`, `Place`.`vip`, `Place`.`status`, `Place`.`paid`, `Place`.`voucher_id`, `Place`.`views`, `Place`.`seo_title`, `Place`.`seo_description`, `Place`.`seo_keywords`, `Place`.`modified`, `Place`.`created`, `Place`.`averageRating` FROM `hooh_live`.`places` AS `Place` WHERE `Place`.`active` = '1' AND `Place`.`status` IS NULL AND `Place`.`resort_id` = 484 AND `Place`.`paid` > 0 GROUP BY `Place`.`id` ORDER BY rand() ASC 26 26 3 maybe slow
    SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`resort_id`, `Review`.`place_id`, `Review`.`event_id`, `Review`.`review`, `Review`.`stars`, `Review`.`active`, `Review`.`modified`, `Review`.`created` FROM `hooh_live`.`reviews` AS `Review` WHERE `Review`.`place_id` IN (1394, 1511, 1445, 1475, 1387, 1471, 1388, 1384, 1383, 1385, 1382, 1380, 1391, 1393, 1381, 1465, 1468, 1510, 1390, 1395, 1386, 1379, 1378, 1508, 1377, 1376) 12 12 0
    SELECT `UserNotification`.`id`, `UserNotification`.`user_id`, `UserNotification`.`holiday_id`, `UserNotification`.`resort_id`, `UserNotification`.`place_id`, `UserNotification`.`event_id`, `UserNotification`.`offer_id`, `UserNotification`.`excursion_id`, `UserNotification`.`model_name`, `UserNotification`.`type`, `UserNotification`.`status`, `UserNotification`.`read`, `UserNotification`.`modified`, `UserNotification`.`created` FROM `hooh_live`.`user_notifications` AS `UserNotification` WHERE `UserNotification`.`type` = 'checkin' AND `UserNotification`.`place_id` IN (1394, 1511, 1445, 1475, 1387, 1471, 1388, 1384, 1383, 1385, 1382, 1380, 1391, 1393, 1381, 1465, 1468, 1510, 1390, 1395, 1386, 1379, 1378, 1508, 1377, 1376) 15 15 4 maybe slow
    SELECT `Place`.`id`, `Place`.`name`, `Place`.`contact_name`, `Place`.`slug`, `Place`.`user_id`, `Place`.`resort_id`, `Place`.`place_category_id`, `Place`.`region_based_place`, `Place`.`region_id`, `Place`.`description`, `Place`.`background`, `Place`.`background_type`, `Place`.`email`, `Place`.`phone`, `Place`.`oh_from`, `Place`.`oh_to`, `Place`.`opening_hours`, `Place`.`facebook`, `Place`.`twitter`, `Place`.`google`, `Place`.`website`, `Place`.`location`, `Place`.`lat`, `Place`.`lng`, `Place`.`active`, `Place`.`vip`, `Place`.`status`, `Place`.`paid`, `Place`.`voucher_id`, `Place`.`views`, `Place`.`seo_title`, `Place`.`seo_description`, `Place`.`seo_keywords`, `Place`.`modified`, `Place`.`created`, `Place`.`averageRating` FROM `hooh_live`.`places` AS `Place` WHERE `Place`.`active` = '1' AND `Place`.`status` IS NULL AND `Place`.`resort_id` = 484 AND `Place`.`paid` > 0 GROUP BY `Place`.`id` ORDER BY rand() ASC LIMIT 4 4 4 3 maybe slow
    SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`resort_id`, `Review`.`place_id`, `Review`.`event_id`, `Review`.`review`, `Review`.`stars`, `Review`.`active`, `Review`.`modified`, `Review`.`created` FROM `hooh_live`.`reviews` AS `Review` WHERE `Review`.`place_id` IN (1391, 1394, 1393, 1384) 2 2 0
    SELECT `UserNotification`.`id`, `UserNotification`.`user_id`, `UserNotification`.`holiday_id`, `UserNotification`.`resort_id`, `UserNotification`.`place_id`, `UserNotification`.`event_id`, `UserNotification`.`offer_id`, `UserNotification`.`excursion_id`, `UserNotification`.`model_name`, `UserNotification`.`type`, `UserNotification`.`status`, `UserNotification`.`read`, `UserNotification`.`modified`, `UserNotification`.`created` FROM `hooh_live`.`user_notifications` AS `UserNotification` WHERE `UserNotification`.`type` = 'checkin' AND `UserNotification`.`place_id` IN (1391, 1394, 1393, 1384) 2 2 4 maybe slow
    SELECT `Event`.`id`, `Event`.`name`, `Event`.`subtitle`, `Event`.`slug`, `Event`.`user_id`, `Event`.`place_id`, `Event`.`resort_id`, `Event`.`event_category_id`, `Event`.`region_based_event`, `Event`.`region_id`, `Event`.`description`, `Event`.`background`, `Event`.`background_type`, `Event`.`event_start`, `Event`.`event_end`, `Event`.`recurring_event`, `Event`.`recurring_event_type`, `Event`.`recurring_event_times`, `Event`.`recurring_event_dates`, `Event`.`entrance_price`, `Event`.`email`, `Event`.`phone`, `Event`.`facebook`, `Event`.`twitter`, `Event`.`google`, `Event`.`website`, `Event`.`location`, `Event`.`lat`, `Event`.`lng`, `Event`.`active`, `Event`.`vip`, `Event`.`status`, `Event`.`views`, `Event`.`seo_title`, `Event`.`seo_description`, `Event`.`seo_keywords`, `Event`.`modified`, `Event`.`created`, `Place`.`id`, `Place`.`name`, `Place`.`contact_name`, `Place`.`slug`, `Place`.`user_id`, `Place`.`resort_id`, `Place`.`place_category_id`, `Place`.`region_based_place`, `Place`.`region_id`, `Place`.`description`, `Place`.`background`, `Place`.`background_type`, `Place`.`email`, `Place`.`phone`, `Place`.`oh_from`, `Place`.`oh_to`, `Place`.`opening_hours`, `Place`.`facebook`, `Place`.`twitter`, `Place`.`google`, `Place`.`website`, `Place`.`location`, `Place`.`lat`, `Place`.`lng`, `Place`.`active`, `Place`.`vip`, `Place`.`status`, `Place`.`paid`, `Place`.`voucher_id`, `Place`.`views`, `Place`.`seo_title`, `Place`.`seo_description`, `Place`.`seo_keywords`, `Place`.`modified`, `Place`.`created`, `Place`.`averageRating` FROM `hooh_live`.`events` AS `Event` LEFT JOIN `hooh_live`.`places` AS `Place` ON (`Event`.`place_id` = `Place`.`id`) WHERE `Event`.`active` = '1' AND `Event`.`status` IS NULL AND `Event`.`resort_id` = 484 AND MONTH(`Event`.`event_start`) >= '4' GROUP BY `Event`.`id` ORDER BY rand() ASC LIMIT 4 4 4 1 maybe slow
    SELECT `EventPicture`.`id`, `EventPicture`.`event_id`, `EventPicture`.`user_id`, `EventPicture`.`title`, `EventPicture`.`picture`, `EventPicture`.`primary_picture`, `EventPicture`.`active`, `EventPicture`.`sort_order`, `EventPicture`.`created`, `EventPicture`.`modified` FROM `hooh_live`.`event_pictures` AS `EventPicture` WHERE `EventPicture`.`active` = '1' AND `EventPicture`.`primary_picture` = '1' AND `EventPicture`.`event_id` IN (247, 249, 252, 248) 4 4 0
    SELECT `UserNotification`.`id`, `UserNotification`.`user_id`, `UserNotification`.`holiday_id`, `UserNotification`.`resort_id`, `UserNotification`.`place_id`, `UserNotification`.`event_id`, `UserNotification`.`offer_id`, `UserNotification`.`excursion_id`, `UserNotification`.`model_name`, `UserNotification`.`type`, `UserNotification`.`status`, `UserNotification`.`read`, `UserNotification`.`modified`, `UserNotification`.`created` FROM `hooh_live`.`user_notifications` AS `UserNotification` WHERE `UserNotification`.`type` = 'checkin' AND `UserNotification`.`event_id` IN (247, 249, 252, 248) 0 0 4 maybe slow
    SELECT `Event`.`id`, `Event`.`name`, `Event`.`subtitle`, `Event`.`slug`, `Event`.`user_id`, `Event`.`place_id`, `Event`.`resort_id`, `Event`.`event_category_id`, `Event`.`region_based_event`, `Event`.`region_id`, `Event`.`description`, `Event`.`background`, `Event`.`background_type`, `Event`.`event_start`, `Event`.`event_end`, `Event`.`recurring_event`, `Event`.`recurring_event_type`, `Event`.`recurring_event_times`, `Event`.`recurring_event_dates`, `Event`.`entrance_price`, `Event`.`email`, `Event`.`phone`, `Event`.`facebook`, `Event`.`twitter`, `Event`.`google`, `Event`.`website`, `Event`.`location`, `Event`.`lat`, `Event`.`lng`, `Event`.`active`, `Event`.`vip`, `Event`.`status`, `Event`.`views`, `Event`.`seo_title`, `Event`.`seo_description`, `Event`.`seo_keywords`, `Event`.`modified`, `Event`.`created`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name`, `Place`.`id`, `Place`.`name`, `Place`.`contact_name`, `Place`.`slug`, `Place`.`user_id`, `Place`.`resort_id`, `Place`.`place_category_id`, `Place`.`region_based_place`, `Place`.`region_id`, `Place`.`description`, `Place`.`background`, `Place`.`background_type`, `Place`.`email`, `Place`.`phone`, `Place`.`oh_from`, `Place`.`oh_to`, `Place`.`opening_hours`, `Place`.`facebook`, `Place`.`twitter`, `Place`.`google`, `Place`.`website`, `Place`.`location`, `Place`.`lat`, `Place`.`lng`, `Place`.`active`, `Place`.`vip`, `Place`.`status`, `Place`.`paid`, `Place`.`voucher_id`, `Place`.`views`, `Place`.`seo_title`, `Place`.`seo_description`, `Place`.`seo_keywords`, `Place`.`modified`, `Place`.`created`, `Place`.`averageRating`, `Resort`.`id`, `Resort`.`radio_id`, `Resort`.`name`, `Resort`.`slug`, `Resort`.`user_id`, `Resort`.`region_based_resort`, `Resort`.`region_id`, `Resort`.`country_id`, `Resort`.`description`, `Resort`.`background`, `Resort`.`background_type`, `Resort`.`email`, `Resort`.`phone`, `Resort`.`uploadfile`, `Resort`.`facebook`, `Resort`.`twitter`, `Resort`.`google`, `Resort`.`website`, `Resort`.`location`, `Resort`.`location_weather`, `Resort`.`location_weather_WEOID`, `Resort`.`lat`, `Resort`.`lng`, `Resort`.`active`, `Resort`.`is_imported`, `Resort`.`featured`, `Resort`.`views`, `Resort`.`seo_title`, `Resort`.`seo_description`, `Resort`.`seo_keywords`, `Resort`.`modified`, `Resort`.`created`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`short_description`, `Region`.`active`, `Region`.`featured`, `Region`.`order`, `Region`.`picture`, `Region`.`modified`, `Region`.`created`, `EventCategory`.`id`, `EventCategory`.`parent_id`, `EventCategory`.`category_icon_id`, `EventCategory`.`sort_order`, `EventCategory`.`lft`, `EventCategory`.`rght`, `EventCategory`.`name`, `EventCategory`.`slug`, `EventCategory`.`icon`, `EventCategory`.`active`, `EventCategory`.`modified`, `EventCategory`.`created` FROM `hooh_live`.`events` AS `Event` LEFT JOIN `hooh_live`.`users` AS `User` ON (`Event`.`user_id` = `User`.`id`) LEFT JOIN `hooh_live`.`places` AS `Place` ON (`Event`.`place_id` = `Place`.`id`) LEFT JOIN `hooh_live`.`resorts` AS `Resort` ON (`Event`.`resort_id` = `Resort`.`id`) LEFT JOIN `hooh_live`.`regions` AS `Region` ON (`Event`.`region_id` = `Region`.`id`) LEFT JOIN `hooh_live`.`event_categories` AS `EventCategory` ON (`Event`.`event_category_id` = `EventCategory`.`id`) WHERE `Event`.`resort_id` = 484 AND `Event`.`active` = '1' AND `Event`.`status` IS NULL AND MONTH(`Event`.`event_start`) = '4' 0 0 1 maybe slow
    SELECT `Place`.`id`, `Place`.`place_category_id` FROM `hooh_live`.`places` AS `Place` WHERE `Place`.`active` = '1' AND `Place`.`resort_id` = 484 AND `Place`.`status` IS NULL GROUP BY `Place`.`place_category_id` 10 10 1 maybe slow
    SELECT `PlaceCategory`.`id`, `PlaceCategory`.`parent_id`, `PlaceCategory`.`category_icon_id`, `PlaceCategory`.`sort_order`, `PlaceCategory`.`lft`, `PlaceCategory`.`rght`, `PlaceCategory`.`name`, `PlaceCategory`.`slug`, `PlaceCategory`.`icon`, `PlaceCategory`.`active`, `PlaceCategory`.`modified`, `PlaceCategory`.`created`, `ParentCategory`.`id`, `ParentCategory`.`parent_id`, `ParentCategory`.`category_icon_id`, `ParentCategory`.`sort_order`, `ParentCategory`.`lft`, `ParentCategory`.`rght`, `ParentCategory`.`name`, `ParentCategory`.`slug`, `ParentCategory`.`icon`, `ParentCategory`.`active`, `ParentCategory`.`modified`, `ParentCategory`.`created`, `CategoryPicture`.`id`, `CategoryPicture`.`user_id`, `CategoryPicture`.`title`, `CategoryPicture`.`url`, `CategoryPicture`.`picture`, `CategoryPicture`.`active`, `CategoryPicture`.`sort_order`, `CategoryPicture`.`created`, `CategoryPicture`.`modified` FROM `hooh_live`.`place_categories` AS `PlaceCategory` LEFT JOIN `hooh_live`.`place_categories` AS `ParentCategory` ON (`PlaceCategory`.`parent_id` = `ParentCategory`.`id`) LEFT JOIN `hooh_live`.`category_pictures` AS `CategoryPicture` ON (`PlaceCategory`.`category_icon_id` = `CategoryPicture`.`id`) WHERE `PlaceCategory`.`id` IN (3, 6, 8, 10, 13, 14, 20, 22, 24, 29) AND `PlaceCategory`.`active` = '1' 10 10 0
    SELECT `Event`.`id`, `Event`.`event_category_id` FROM `hooh_live`.`events` AS `Event` WHERE `Event`.`active` = '1' AND `Event`.`resort_id` = 484 AND `Event`.`status` IS NULL GROUP BY `Event`.`event_category_id` 3 3 0
    SELECT `EventCategory`.`id`, `EventCategory`.`parent_id`, `EventCategory`.`category_icon_id`, `EventCategory`.`sort_order`, `EventCategory`.`lft`, `EventCategory`.`rght`, `EventCategory`.`name`, `EventCategory`.`slug`, `EventCategory`.`icon`, `EventCategory`.`active`, `EventCategory`.`modified`, `EventCategory`.`created` FROM `hooh_live`.`event_categories` AS `EventCategory` WHERE `EventCategory`.`id` IN (1, 6, 7) AND `EventCategory`.`active` = '1' 3 3 0
    SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`user_id`, `Article`.`place_id`, `Article`.`resort_id`, `Article`.`event_id`, `Article`.`description`, `Article`.`background`, `Article`.`active`, `Article`.`status`, `Article`.`featured`, `Article`.`modified`, `Article`.`created`, `Article`.`views`, `Article`.`seo_title`, `Article`.`seo_description`, `Article`.`seo_keywords` FROM `hooh_live`.`articles` AS `Article` WHERE `Article`.`resort_id` = 484 AND `Article`.`active` = '1' ORDER BY `Article`.`views` ASC LIMIT 3 0 0 0
    SELECT `UserPhoto`.`id`, `UserPhoto`.`album_id`, `UserPhoto`.`user_id`, `UserPhoto`.`holiday_id`, `UserPhoto`.`resort_id`, `UserPhoto`.`model`, `UserPhoto`.`modelId`, `UserPhoto`.`picture`, `UserPhoto`.`status`, `UserPhoto`.`reports_count`, `UserPhoto`.`likes_count`, `UserPhoto`.`created`, `UserPhoto`.`modified`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name`, `UserPhotoAlbum`.`id`, `UserPhotoAlbum`.`user_id`, `UserPhotoAlbum`.`holiday_id`, `UserPhotoAlbum`.`name`, `UserPhotoAlbum`.`slug`, `UserPhotoAlbum`.`status`, `UserPhotoAlbum`.`created`, `UserPhotoAlbum`.`modified` FROM `hooh_live`.`user_photos` AS `UserPhoto` LEFT JOIN `hooh_live`.`users` AS `User` ON (`UserPhoto`.`user_id` = `User`.`id`) LEFT JOIN `hooh_live`.`user_photo_albums` AS `UserPhotoAlbum` ON (`UserPhoto`.`id` = `UserPhotoAlbum`.`id`) WHERE `UserPhoto`.`resort_id` = 484 ORDER BY rand() ASC LIMIT 4 0 0 2 maybe slow
    SELECT `ArrowchatChatroomRoom`.`id`, `ArrowchatChatroomRoom`.`model_id`, `ArrowchatChatroomRoom`.`model`, `ArrowchatChatroomRoom`.`author_id`, `ArrowchatChatroomRoom`.`name`, `ArrowchatChatroomRoom`.`description`, `ArrowchatChatroomRoom`.`welcome_message`, `ArrowchatChatroomRoom`.`image`, `ArrowchatChatroomRoom`.`type`, `ArrowchatChatroomRoom`.`password`, `ArrowchatChatroomRoom`.`length`, `ArrowchatChatroomRoom`.`max_users`, `ArrowchatChatroomRoom`.`limit_message_num`, `ArrowchatChatroomRoom`.`limit_seconds_num`, `ArrowchatChatroomRoom`.`session_time` FROM `hooh_live`.`arrowchat_chatroom_rooms` AS `ArrowchatChatroomRoom` WHERE `ArrowchatChatroomRoom`.`model` = 'Resort' AND `ArrowchatChatroomRoom`.`model_id` = 484 LIMIT 1 1 1 1
    SELECT `ArrowchatChatroomMessage`.`id`, `ArrowchatChatroomMessage`.`reply_id`, `ArrowchatChatroomMessage`.`chatroom_id`, `ArrowchatChatroomMessage`.`user_id`, `ArrowchatChatroomMessage`.`notify_user`, `ArrowchatChatroomMessage`.`username`, `ArrowchatChatroomMessage`.`message`, `ArrowchatChatroomMessage`.`type`, `ArrowchatChatroomMessage`.`global_message`, `ArrowchatChatroomMessage`.`is_mod`, `ArrowchatChatroomMessage`.`is_admin`, `ArrowchatChatroomMessage`.`read_by`, `ArrowchatChatroomMessage`.`sent`, `ArrowchatChatroomMessage`.`action`, `ArrowchatChatroomMessage`.`version`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name`, `ArrowchatChatroomRoom`.`id`, `ArrowchatChatroomRoom`.`model_id`, `ArrowchatChatroomRoom`.`model`, `ArrowchatChatroomRoom`.`author_id`, `ArrowchatChatroomRoom`.`name`, `ArrowchatChatroomRoom`.`description`, `ArrowchatChatroomRoom`.`welcome_message`, `ArrowchatChatroomRoom`.`image`, `ArrowchatChatroomRoom`.`type`, `ArrowchatChatroomRoom`.`password`, `ArrowchatChatroomRoom`.`length`, `ArrowchatChatroomRoom`.`max_users`, `ArrowchatChatroomRoom`.`limit_message_num`, `ArrowchatChatroomRoom`.`limit_seconds_num`, `ArrowchatChatroomRoom`.`session_time` FROM `hooh_live`.`arrowchat_chatroom_messages` AS `ArrowchatChatroomMessage` LEFT JOIN `hooh_live`.`users` AS `User` ON (`ArrowchatChatroomMessage`.`user_id` = `User`.`id`) LEFT JOIN `hooh_live`.`arrowchat_chatroom_rooms` AS `ArrowchatChatroomRoom` ON (`ArrowchatChatroomMessage`.`chatroom_id` = `ArrowchatChatroomRoom`.`id`) WHERE `ArrowchatChatroomMessage`.`chatroom_id` = 673 AND `ArrowchatChatroomMessage`.`reply_id` IS NULL ORDER BY `ArrowchatChatroomMessage`.`sent` DESC LIMIT 3 3 3 1 maybe slow
    SELECT `UserDetail`.`id`, `UserDetail`.`user_id`, `UserDetail`.`resort_id`, `UserDetail`.`gender`, `UserDetail`.`photo`, `UserDetail`.`cover_image`, `UserDetail`.`bday`, `UserDetail`.`location`, `UserDetail`.`marital_status`, `UserDetail`.`cellphone`, `UserDetail`.`facebook`, `UserDetail`.`twitter`, `UserDetail`.`google`, `UserDetail`.`web_page`, `UserDetail`.`works_at`, `UserDetail`.`about`, `UserDetail`.`interests`, `UserDetail`.`newsletter`, `UserDetail`.`has_holiday`, `UserDetail`.`created`, `UserDetail`.`modified` FROM `hooh_live`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = 7066 1 1 0
    SELECT `UserRight`.`id`, `UserRight`.`user_id`, `UserRight`.`first_name`, `UserRight`.`last_name`, `UserRight`.`email`, `UserRight`.`gender`, `UserRight`.`photo`, `UserRight`.`bday`, `UserRight`.`location`, `UserRight`.`marital_status`, `UserRight`.`cellphone`, `UserRight`.`notifications`, `UserRight`.`facebook`, `UserRight`.`twitter`, `UserRight`.`google`, `UserRight`.`web_page`, `UserRight`.`works_at`, `UserRight`.`about`, `UserRight`.`interests`, `UserRight`.`profile`, `UserRight`.`created`, `UserRight`.`modified` FROM `hooh_live`.`user_rights` AS `UserRight` WHERE `UserRight`.`user_id` = 7066 1 1 0
    SELECT `UserDetail`.`id`, `UserDetail`.`user_id`, `UserDetail`.`resort_id`, `UserDetail`.`gender`, `UserDetail`.`photo`, `UserDetail`.`cover_image`, `UserDetail`.`bday`, `UserDetail`.`location`, `UserDetail`.`marital_status`, `UserDetail`.`cellphone`, `UserDetail`.`facebook`, `UserDetail`.`twitter`, `UserDetail`.`google`, `UserDetail`.`web_page`, `UserDetail`.`works_at`, `UserDetail`.`about`, `UserDetail`.`interests`, `UserDetail`.`newsletter`, `UserDetail`.`has_holiday`, `UserDetail`.`created`, `UserDetail`.`modified` FROM `hooh_live`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = 4186 1 1 0
    SELECT `UserRight`.`id`, `UserRight`.`user_id`, `UserRight`.`first_name`, `UserRight`.`last_name`, `UserRight`.`email`, `UserRight`.`gender`, `UserRight`.`photo`, `UserRight`.`bday`, `UserRight`.`location`, `UserRight`.`marital_status`, `UserRight`.`cellphone`, `UserRight`.`notifications`, `UserRight`.`facebook`, `UserRight`.`twitter`, `UserRight`.`google`, `UserRight`.`web_page`, `UserRight`.`works_at`, `UserRight`.`about`, `UserRight`.`interests`, `UserRight`.`profile`, `UserRight`.`created`, `UserRight`.`modified` FROM `hooh_live`.`user_rights` AS `UserRight` WHERE `UserRight`.`user_id` = 4186 0 0 0
    SELECT `UserDetail`.`id`, `UserDetail`.`user_id`, `UserDetail`.`resort_id`, `UserDetail`.`gender`, `UserDetail`.`photo`, `UserDetail`.`cover_image`, `UserDetail`.`bday`, `UserDetail`.`location`, `UserDetail`.`marital_status`, `UserDetail`.`cellphone`, `UserDetail`.`facebook`, `UserDetail`.`twitter`, `UserDetail`.`google`, `UserDetail`.`web_page`, `UserDetail`.`works_at`, `UserDetail`.`about`, `UserDetail`.`interests`, `UserDetail`.`newsletter`, `UserDetail`.`has_holiday`, `UserDetail`.`created`, `UserDetail`.`modified` FROM `hooh_live`.`user_details` AS `UserDetail` WHERE `UserDetail`.`user_id` = 7066 1 1 0
    SELECT `UserRight`.`id`, `UserRight`.`user_id`, `UserRight`.`first_name`, `UserRight`.`last_name`, `UserRight`.`email`, `UserRight`.`gender`, `UserRight`.`photo`, `UserRight`.`bday`, `UserRight`.`location`, `UserRight`.`marital_status`, `UserRight`.`cellphone`, `UserRight`.`notifications`, `UserRight`.`facebook`, `UserRight`.`twitter`, `UserRight`.`google`, `UserRight`.`web_page`, `UserRight`.`works_at`, `UserRight`.`about`, `UserRight`.`interests`, `UserRight`.`profile`, `UserRight`.`created`, `UserRight`.`modified` FROM `hooh_live`.`user_rights` AS `UserRight` WHERE `UserRight`.`user_id` = 7066 1 1 0
    SELECT `ArrowchatChatroomMessageReply`.`id`, `ArrowchatChatroomMessageReply`.`reply_id`, `ArrowchatChatroomMessageReply`.`chatroom_id`, `ArrowchatChatroomMessageReply`.`user_id`, `ArrowchatChatroomMessageReply`.`notify_user`, `ArrowchatChatroomMessageReply`.`username`, `ArrowchatChatroomMessageReply`.`message`, `ArrowchatChatroomMessageReply`.`type`, `ArrowchatChatroomMessageReply`.`global_message`, `ArrowchatChatroomMessageReply`.`is_mod`, `ArrowchatChatroomMessageReply`.`is_admin`, `ArrowchatChatroomMessageReply`.`read_by`, `ArrowchatChatroomMessageReply`.`sent`, `ArrowchatChatroomMessageReply`.`action`, `ArrowchatChatroomMessageReply`.`version` FROM `hooh_live`.`arrowchat_chatroom_messages` AS `ArrowchatChatroomMessageReply` WHERE `ArrowchatChatroomMessageReply`.`reply_id` IN (5277, 5276, 5275) ORDER BY `ArrowchatChatroomMessageReply`.`sent` DESC 0 0 2 maybe slow
    UPDATE resorts SET views=views+1, modified=NOW() WHERE id=484 1 1 2 maybe slow
    SELECT `UserGroup`.`id`, `UserGroup`.`parent_id`, `UserGroup`.`name`, `UserGroup`.`alias_name`, `UserGroup`.`description`, `UserGroup`.`allowRegistration`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `hooh_live`.`user_groups` AS `UserGroup` WHERE `allowRegistration` = 1 ORDER BY `name` ASC 3 3 0
    SELECT `Resort`.`id`, `Resort`.`radio_id`, `Resort`.`name`, `Resort`.`slug`, `Resort`.`user_id`, `Resort`.`region_based_resort`, `Resort`.`region_id`, `Resort`.`country_id`, `Resort`.`description`, `Resort`.`background`, `Resort`.`background_type`, `Resort`.`email`, `Resort`.`phone`, `Resort`.`uploadfile`, `Resort`.`facebook`, `Resort`.`twitter`, `Resort`.`google`, `Resort`.`website`, `Resort`.`location`, `Resort`.`location_weather`, `Resort`.`location_weather_WEOID`, `Resort`.`lat`, `Resort`.`lng`, `Resort`.`active`, `Resort`.`is_imported`, `Resort`.`featured`, `Resort`.`views`, `Resort`.`seo_title`, `Resort`.`seo_description`, `Resort`.`seo_keywords`, `Resort`.`modified`, `Resort`.`created`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`short_description`, `Region`.`active`, `Region`.`featured`, `Region`.`order`, `Region`.`picture`, `Region`.`modified`, `Region`.`created`, `Country`.`id`, `Country`.`cc_fips`, `Country`.`cc_iso`, `Country`.`tld`, `Country`.`name`, `Country`.`featured`, `Country`.`background`, `Country`.`order` FROM `hooh_live`.`resorts` AS `Resort` LEFT JOIN `hooh_live`.`regions` AS `Region` ON (`Resort`.`region_id` = `Region`.`id`) LEFT JOIN `hooh_live`.`countries` AS `Country` ON (`Resort`.`country_id` = `Country`.`id`) WHERE `Resort`.`active` = '1' AND NOT (`Resort`.`background` IS NULL) GROUP BY `Resort`.`id` ORDER BY rand() ASC LIMIT 16 16 16 4 maybe slow

    Query Explain:

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

    ====
  • Timer
    +

    Memory

    Peak Memory Use 15.81 MB

    Message Memory use
    Component initialization 2.10 MB
    Controller action start 7.20 MB
    Controller render start 9.54 MB
    View render complete 11.15 MB

    Timers

    Total Request Time: 284 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 15.02
    Event: Controller.initialize 35.59
    Event: Controller.startup 0.57
    Controller action 80.53
    Event: Controller.beforeRender 28.11
    » Processing toolbar data 18.82
    Rendering View 51.81
    » Event: View.beforeRender 0.05
    » Rendering APP/View/Pages/resort.ctp 32.49
    » » Rendering APP/View/Elements/header-background.ctp 0.16
    » » Rendering APP/View/Elements/resort_header_links.ctp 1.25
    » » Rendering APP/View/Elements/breadcrums.ctp 0.75
    » » Rendering APP/View/Elements/resort-links.ctp 0.78
    » » » Rendering APP/View/Elements/follow.ctp 0.20
    » » Rendering APP/View/Elements/map_resort.ctp 0.37
    » » Rendering APP/View/Elements/dropdown_place_categories.ctp 6.73
    » » Rendering APP/View/Elements/chat/add_comment.ctp 2.86
    » » » Rendering APP/View/Elements/ajax_validation_comments.ctp 0.18
    » » Rendering APP/View/Elements/chat/comment_list.ctp 1.47
    » » Rendering APP/View/Elements/ajax_validation.ctp 0.16
    » Event: View.afterRender 0.04
    » Event: View.beforeLayout 0.04
    » Rendering APP/View/Layouts/default.ctp 17.84
    » » Rendering APP/View/Elements/meta.ctp 0.18
    » » Rendering APP/View/Elements/facebook-connect.ctp 0.15
    » » Rendering APP/View/Elements/cookie-bar.ctp 0.44
    » » Rendering APP/View/Elements/header.ctp 1.99
    » » Rendering APP/View/Elements/footer.ctp 3.50
    » » Rendering APP/View/Elements/modals.ctp 8.80
    » » » Rendering APP/Plugin/Admin/View/Elements/provider.ctp 0.57
    » » » Rendering APP/View/Elements/ajax_validation.ctp #2 0.14
    » » » Rendering APP/Plugin/Admin/View/Elements/provider.ctp #2 0.27
    » » » Rendering APP/View/Elements/ajax_validation.ctp #3 0.14
    » » » Rendering APP/Plugin/Admin/View/Elements/provider.ctp #3 0.27
    » » » Rendering APP/View/Elements/ajax_validation.ctp #4 0.14
    » » Rendering APP/View/Elements/ga.ctp 0.15
    » » Rendering APP/View/Elements/uservoice.ctp 0.16
    Event: View.afterLayout 0.00
    ====
  • Log
    +

    Logs

    There were no log entries made this request

    ====
  • Variables
    +

    View Variables

    • title_for_layoutVisit Soldeu, things to do - Hang out on Holiday
    • description_for_layoutcheck out all that's happening in Soldeu, who's going, news of events, best places to go, discounts and live resort chat - chat with locals
    • keywords_for_layoutSoldeu & El Tarter, resort, Hang out on Holiday,Dating on Holiday,Holiday Romance,Clubbing,Holidays,friends,social networking,clubs,parties,free entrance,VIP vouchers,Resorts,Advertising
    • image_for_layouthttp://hangoutonholiday.com/img/imagecache/950x600_0118959724_drinks stop.jpg
    • secure_image_for_layouthttps://hangoutonholiday.com/img/imagecache/950x600_0118959724_drinks stop.jpg
    • og_typehangoutonholiday:resort
    • og_geo_lat42.577789
    • og_geo_lng1.666049
    • chatroom_messages
      • 0
        • ArrowchatChatroomMessage
          • id5277
          • reply_id(null)
          • chatroom_id673
          • user_id7066
          • notify_user0
          • usernamehelen Manchester
          • message\ud83e\udd1c\ud83c\udffb\ud83d\udca5
          • typetext
          • global_message(false)
          • is_mod(false)
          • is_admin(false)
          • read_by["6682","473","4186","4186","7066","6583","6748","6445","6243","6528"]
          • sent1521646936
          • action(false)
          • version2
        • User
          • id7066
          • parent_id(null)
          • resort_id(null)
          • fb_id(null)
          • fb_access_token(null)
          • twt_id(null)
          • twt_access_token(null)
          • twt_access_secret(null)
          • ldn_id(null)
          • mobile_udid06038927-130D-4B72-A97E-E58C188D92F2
          • mobile_token133e19eb37ea9d2b7016c4b6234619a39ee034a5dcb384927798c98bb5a8d8ec
          • is_android(false)
          • onsignal_token4c584c08-c441-49df-b7f0-8e3abe095dd9
          • user_group_id2
          • usernamehelenmanchester
          • slughelenmanchester
          • password4ca6553555aa85d98fa9f571e3346f88f397c43c3f5f930ebc83a8064745e500
          • salt/pdxcFkDWY4/sm/UElUygOhFUtLKLp0kNwRRHqzGn6teERy4FXVGVSi1KToLW7r0
          • change_password_code(null)
          • emailhelen_farrington@hotmail.co.uk
          • namehelen Manchester
          • first_namehelen
          • last_nameManchester
          • active1
          • email_verified1
          • last_login(null)
          • pending_agent0
          • pending_vendor0
          • by_admin0
          • ip_address85.255.235.121
          • profile_views0
          • is_imported(false)
          • referalwebsite
          • created2018-03-18 16:35:24
          • modified2018-03-22 08:32:12
          • complete_namehelen Manchester
          • UserDetail
            • id6544
            • user_id7066
            • resort_id(null)
            • genderFemale
            • photo(null)
            • cover_image(null)
            • bday(null)
            • location(null)
            • marital_status(null)
            • cellphone(null)
            • facebook(null)
            • twitter(null)
            • google(null)
            • web_page(null)
            • works_at(null)
            • about(null)
            • interests(null)
            • newsletter(true)
            • has_holiday(true)
            • created2018-03-18 16:35:24
            • modified2018-03-18 16:35:56
          • UserRight
            • id5051
            • user_id7066
            • first_name(true)
            • last_name(true)
            • email(false)
            • gender(true)
            • photo(true)
            • bday(true)
            • location(true)
            • marital_status(true)
            • cellphone(true)
            • notifications(true)
            • facebook1
            • twitter1
            • google1
            • web_page(true)
            • works_at(true)
            • about(true)
            • interests(true)
            • profile(true)
            • created2018-03-18 16:35:24
            • modified2018-03-18 16:35:24
        • ArrowchatChatroomRoom
          • id673
          • model_id484
          • modelResort
          • author_id1
          • nameSoldeu
          • descriptionSoldeu
          • welcome_message
          • imagechatroom_play.png
          • type(true)
          • password(null)
          • length0
          • max_users0
          • limit_message_num3
          • limit_seconds_num10
          • session_time1468937757
        • ArrowchatChatroomMessageReply(empty)
      • 1
        • ArrowchatChatroomMessage
          • id5276
          • reply_id(null)
          • chatroom_id673
          • user_id4186
          • notify_user0
          • usernameAndorra Travel Service
          • messageSay hello to jude, mad nortern irish woman. Tell her james said she had to buy you a shot!!
          • typetext
          • global_message(false)
          • is_mod(false)
          • is_admin(false)
          • read_by(null)
          • sent1521646895
          • action(false)
          • version2
        • User
          • id4186
          • parent_id(null)
          • resort_id(null)
          • fb_id(null)
          • fb_access_token(null)
          • twt_id(null)
          • twt_access_token(null)
          • twt_access_secret(null)
          • ldn_id(null)
          • mobile_udidEA7B32CD-CE18-4ACB-AF50-0CF7425D895B
          • mobile_token8cfc95dd54e625652bf22af281b863bda6de05d9334ce79fe3b60423e2a8932a
          • is_android(false)
          • onsignal_token4c2f786f-56f4-4fed-ab0e-711405de9e8e
          • user_group_id5
          • usernameandorraski
          • slugandorraski
          • passwordb804605da74e02a956f9af31c06c9f14814edc138cd5b5e238520ebba66ec61f
          • saltyJuafiajr5OSWBGZDr6t3Hd5RISmATeedHyhqwICvcqdWEjE/PhXjlFpKF8o1Tyf
          • change_password_code(null)
          • emailinfo@andorratravelservices.com
          • nameAndorra Travel Service
          • first_nameAndorra
          • last_nameTravel Service
          • active1
          • email_verified1
          • last_login2018-01-20 14:44:26
          • pending_agent0
          • pending_vendor0
          • by_admin1
          • ip_address(null)
          • profile_views0
          • is_imported(false)
          • referalwebsite
          • created2016-11-15 18:10:30
          • modified2018-04-25 17:03:48
          • complete_nameAndorra Travel Service
          • UserDetail
            • id4261
            • user_id4186
            • resort_id(null)
            • gender
            • photo15130080071531706205.jpg
            • cover_image15130079882023357292.jpg
            • bday(null)
            • location
            • marital_status
            • cellphone
            • facebook(null)
            • twitter(null)
            • google(null)
            • web_page
            • works_at(null)
            • about(null)
            • interests(null)
            • newsletter(true)
            • has_holiday(true)
            • created2016-11-15 18:10:30
            • modified2017-12-11 16:00:07
          • UserRight(empty)
        • ArrowchatChatroomRoom
          • id673
          • model_id484
          • modelResort
          • author_id1
          • nameSoldeu
          • descriptionSoldeu
          • welcome_message
          • imagechatroom_play.png
          • type(true)
          • password(null)
          • length0
          • max_users0
          • limit_message_num3
          • limit_seconds_num10
          • session_time1468937757
        • ArrowchatChatroomMessageReply(empty)
      • 2
        • ArrowchatChatroomMessage
          • id5275
          • reply_id(null)
          • chatroom_id673
          • user_id7066
          • notify_user0
          • usernamehelen Manchester
          • messageFat Albert\u2019s is closed today for a rafting event for the staff. But will give Barcode a go. Thanks.
          • typetext
          • global_message(false)
          • is_mod(false)
          • is_admin(false)
          • read_by(null)
          • sent1521646750
          • action(false)
          • version2
        • User
          • id7066
          • parent_id(null)
          • resort_id(null)
          • fb_id(null)
          • fb_access_token(null)
          • twt_id(null)
          • twt_access_token(null)
          • twt_access_secret(null)
          • ldn_id(null)
          • mobile_udid06038927-130D-4B72-A97E-E58C188D92F2
          • mobile_token133e19eb37ea9d2b7016c4b6234619a39ee034a5dcb384927798c98bb5a8d8ec
          • is_android(false)
          • onsignal_token4c584c08-c441-49df-b7f0-8e3abe095dd9
          • user_group_id2
          • usernamehelenmanchester
          • slughelenmanchester
          • password4ca6553555aa85d98fa9f571e3346f88f397c43c3f5f930ebc83a8064745e500
          • salt/pdxcFkDWY4/sm/UElUygOhFUtLKLp0kNwRRHqzGn6teERy4FXVGVSi1KToLW7r0
          • change_password_code(null)
          • emailhelen_farrington@hotmail.co.uk
          • namehelen Manchester
          • first_namehelen
          • last_nameManchester
          • active1
          • email_verified1
          • last_login(null)
          • pending_agent0
          • pending_vendor0
          • by_admin0
          • ip_address85.255.235.121
          • profile_views0
          • is_imported(false)
          • referalwebsite
          • created2018-03-18 16:35:24
          • modified2018-03-22 08:32:12
          • complete_namehelen Manchester
          • UserDetail
            • id6544
            • user_id7066
            • resort_id(null)
            • genderFemale
            • photo(null)
            • cover_image(null)
            • bday(null)
            • location(null)
            • marital_status(null)
            • cellphone(null)
            • facebook(null)
            • twitter(null)
            • google(null)
            • web_page(null)
            • works_at(null)
            • about(null)
            • interests(null)
            • newsletter(true)
            • has_holiday(true)
            • created2018-03-18 16:35:24
            • modified2018-03-18 16:35:56
          • UserRight
            • id5051
            • user_id7066
            • first_name(true)
            • last_name(true)
            • email(false)
            • gender(true)
            • photo(true)
            • bday(true)
            • location(true)
            • marital_status(true)
            • cellphone(true)
            • notifications(true)
            • facebook1
            • twitter1
            • google1
            • web_page(true)
            • works_at(true)
            • about(true)
            • interests(true)
            • profile(true)
            • created2018-03-18 16:35:24
            • modified2018-03-18 16:35:24
        • ArrowchatChatroomRoom
          • id673
          • model_id484
          • modelResort
          • author_id1
          • nameSoldeu
          • descriptionSoldeu
          • welcome_message
          • imagechatroom_play.png
          • type(true)
          • password(null)
          • length0
          • max_users0
          • limit_message_num3
          • limit_seconds_num10
          • session_time1468937757
        • ArrowchatChatroomMessageReply(empty)
    • guest1
    • chatroom
      • ArrowchatChatroomRoom
        • id673
        • model_id484
        • modelResort
        • author_id1
        • nameSoldeu
        • descriptionSoldeu
        • welcome_message
        • imagechatroom_play.png
        • type(true)
        • password(null)
        • length0
        • max_users0
        • limit_message_num3
        • limit_seconds_num10
        • session_time1468937757
    • resort
      • Resort
        • id484
        • radio_id(null)
        • nameSoldeu & El Tarter
        • slugsoldeu--el-tarter
        • user_id4186
        • region_based_resort(true)
        • region_id274
        • country_id9
        • description<p>Andorra's best all round skiing resort, offerring high quality accommodation, superb facilities, lively Apres Ski and excellent value for money. Soldeu & El Tarter are part of the GRANDVALIRA Ski area which boasts 210KM of ski area over 128 runs wtih something for everyone, 16 Green, 51 Blue, 42 Red and for the show offs, 19 Black oh and 3 freestyle parks and 2 world class runs. Soldeu is an enchanting, charming village that has been extensivley developed into a leading ski and summer tourist destination. </p>
        • background1513192126626958032.jpg
        • background_type(false)
        • emailinfo@andorratravelservice.com
        • phone00 376 351150
        • uploadfile
        • facebook(null)
        • twitter@andorraexperts
        • google(null)
        • websitehttps://www.andorratravelservice.com/
        • locationAD100 Soldeu, Andorra
        • location_weatherSoldeu, Canillo, Andorra
        • location_weather_WEOID472603
        • lat42.577789
        • lng1.666049
        • active(true)
        • is_imported(true)
        • featured(true)
        • views1458
        • seo_titleVisit Soldeu, things to do
        • seo_descriptioncheck out all that's happening in Soldeu, who's going, news of events, best places to go, discounts and live resort chat - chat with locals
        • seo_keywords
        • modified2018-04-25 09:35:22
        • created2014-04-18 15:14:25
      • User
        • id4186
        • parent_id(null)
        • resort_id(null)
        • fb_id(null)
        • fb_access_token(null)
        • twt_id(null)
        • twt_access_token(null)
        • twt_access_secret(null)
        • ldn_id(null)
        • mobile_udidEA7B32CD-CE18-4ACB-AF50-0CF7425D895B
        • mobile_token8cfc95dd54e625652bf22af281b863bda6de05d9334ce79fe3b60423e2a8932a
        • is_android(false)
        • onsignal_token4c2f786f-56f4-4fed-ab0e-711405de9e8e
        • user_group_id5
        • usernameandorraski
        • slugandorraski
        • passwordb804605da74e02a956f9af31c06c9f14814edc138cd5b5e238520ebba66ec61f
        • saltyJuafiajr5OSWBGZDr6t3Hd5RISmATeedHyhqwICvcqdWEjE/PhXjlFpKF8o1Tyf
        • change_password_code(null)
        • emailinfo@andorratravelservices.com
        • nameAndorra Travel Service
        • first_nameAndorra
        • last_nameTravel Service
        • active1
        • email_verified1
        • last_login2018-01-20 14:44:26
        • pending_agent0
        • pending_vendor0
        • by_admin1
        • ip_address(null)
        • profile_views0
        • is_imported(false)
        • referalwebsite
        • created2016-11-15 18:10:30
        • modified2018-04-25 17:03:48
        • complete_nameAndorra Travel Service
        • UserDetail
          • id4261
          • user_id4186
          • resort_id(null)
          • gender
          • photo15130080071531706205.jpg
          • cover_image15130079882023357292.jpg
          • bday(null)
          • location
          • marital_status
          • cellphone
          • facebook(null)
          • twitter(null)
          • google(null)
          • web_page
          • works_at(null)
          • about(null)
          • interests(null)
          • newsletter(true)
          • has_holiday(true)
          • created2016-11-15 18:10:30
          • modified2017-12-11 16:00:07
      • Region
        • id274
        • country_id9
        • nameAndorra
        • short_description(null)
        • active(true)
        • featured(true)
        • order9999
        • picture15131794722096055614.jpg
        • modified2017-12-13 15:37:52
        • created2017-12-13 15:32:19
      • Country
        • id9
        • cc_fipsAN
        • cc_isoAD
        • tld.ad
        • nameAndorra
        • featured(true)
        • background15131793781318528115.jpg
        • order9999
      • ResortPicture
        • 0
          • id1578
          • resort_id484
          • user_id2
          • titledrinks stop.jpg
          • picturedrinks stop.jpg
          • primary_picture(true)
          • active(true)
          • sort_order0
          • created2017-11-20 13:37:28
          • modified2017-11-20 13:37:28
        • 1
          • id1596
          • resort_id484
          • user_id2
          • titleTrineu _ Joves _ Alta _ 04.jpg
          • pictureTrineu _ Joves _ Alta _ 04.jpg
          • primary_picture(false)
          • active(true)
          • sort_order0
          • created2017-12-01 16:00:13
          • modified2017-12-01 16:00:13
        • 2
          • id1597
          • resort_id484
          • user_id2
          • titleAE.jpg
          • pictureAE.jpg
          • primary_picture(false)
          • active(true)
          • sort_order0
          • created2017-12-01 16:00:39
          • modified2017-12-01 16:00:39
        • 3
          • id1598
          • resort_id484
          • user_id2
          • titlegranvalira_5.jpg
          • picturegranvalira_5.jpg
          • primary_picture(false)
          • active(true)
          • sort_order0
          • created2017-12-01 16:00:58
          • modified2017-12-01 16:00:58
    • places_maps
      • 0
        • Place
          • id1394
          • nameBorda del Rector
          • contact_name
          • slugborda-del-rector-1394
          • user_id6459
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionIf you are looking to sample local cuisine and flavours of the highest order, then this is probably your best bet in the Soldeu area. A charming old restaurant brought up to date with modern touches and a classic menu. The owners are always on hand to help and they have one of the finest wine menus in the entire country. It enjoys a warm cost atmosphere and the staff are excellent.
          • background151277396083964126.jpg
          • background_type(null)
          • emailtresataula@gmail.com
          • phone+ 376 852 606
          • oh_from
          • oh_to
          • opening_hours1PM - 5Pm & 8PM - Midnight
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCarretera General 2, La Pleta de Soldeu. Passatge de l'Asó, AD100 Soldeu, Andorra
          • lat42.578281
          • lng1.661409
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views142
          • seo_titleBorda del Rector Restaurant in Soldeu, Andorra
          • seo_descriptionA charming traditional restaurant in Soldeu
          • seo_keywords
          • modified2018-04-24 11:44:41
          • created2017-12-08 22:57:10
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 1
        • Place
          • id1511
          • nameL'Abarset Restaurant
          • contact_name
          • slugl-abarset-restaurant-1511
          • user_id6806
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionL'Abarset is more than just an exceptional restaurant. Situated at the foot of the El Tartar ski slope - next to the main lift this place is busy all day, serves great food but really comes alive from 4PM onwards when the music is cranked up for the daily Apres Ski party. Live DJ's get the party going thru until 8PM. There is a VIP area but you need to book.
          • background15179416291108233383.jpg
          • background_type(null)
          • emailinfo@grandvalira.com
          • phone+376 890 704
          • oh_from
          • oh_to
          • opening_hours8AM - 8PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 El Tarter, Andorra
          • lat42.580151
          • lng1.651174
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views72
          • seo_titleL'Abarset Restaurant El Tartar
          • seo_descriptionOne of the best restaurants and Apres ski places in El Tartar
          • seo_keywords
          • modified2018-04-25 05:48:03
          • created2018-02-06 18:26:04
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 2
        • Place
          • id1445
          • nameAndorra Travel Service
          • contact_name
          • slugandorra-travel-service-1445
          • user_id6411
          • resort_id484
          • place_category_id14
          • region_based_place(false)
          • region_id0
          • descriptionWe've been around for 30 years and as such are renowned as the local specialists in Soldeu and all over Andorra for all your travel needs. Accommodation, Transfers, Excursions, Ski Rental, Ski School, we have it all covered. Message us in APP for any requirements you have on or off the slopes.
          • background15133009671355284967.jpg
          • background_type(null)
          • emailinfo@andorratravelservices.com
          • phone0330 043 2134 (local rate)
          • oh_from
          • oh_to
          • opening_hoursDaily until 8PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views138
          • seo_titleAndorra Travel Service
          • seo_descriptionOne of the oldest and most established agencies in Andorra for all your travel needs
          • seo_keywords
          • modified2018-04-25 03:40:48
          • created2017-12-15 01:20:49
          • averageRating5.00
        • Review
          • 0
            • id170
            • user_id6243
            • resort_id(null)
            • place_id1445
            • event_id(null)
            • reviewTravelled to Andorra a few times and these guys have helped us arrange the hotel and all our ski stuff - excellent service. Cathy knows everything about Andorra ??
            • stars5
            • active(true)
            • modified2017-12-15 01:29:06
            • created2017-12-15 01:29:06
        • UserNotification(empty)
      • 3
        • Place
          • id1475
          • nameNeilson Soldeu
          • contact_name
          • slugneilson-soldeu-1475
          • user_id6583
          • resort_id484
          • place_category_id29
          • region_based_place(false)
          • region_id0
          • descriptionPlease message for any assistance required during your stay - we hope you have a great holiday.
          • background15152397651792222289.png
          • background_type(null)
          • emailinfo@andorratravelservices.com
          • phone0330 043 2134 (local Rate)
          • oh_from
          • oh_to
          • opening_hours8am - 8pm
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(true)
          • status(null)
          • paid3
          • voucher_id(null)
          • views123
          • seo_titleNeilson Soldeu assistance
          • seo_description
          • seo_keywords
          • modified2018-04-23 19:03:03
          • created2018-01-06 11:55:44
          • averageRating5.00
        • Review
          • 0
            • id178
            • user_id4186
            • resort_id(null)
            • place_id1475
            • event_id(null)
            • reviewGreat times!
            • stars5
            • active(true)
            • modified2018-01-06 12:57:46
            • created2018-01-06 12:57:46
          • 1
            • id179
            • user_id4186
            • resort_id(null)
            • place_id1475
            • event_id(null)
            • reviewType your review...
            • stars5
            • active(true)
            • modified2018-01-06 13:15:42
            • created2018-01-06 13:15:42
        • UserNotification
          • 0
            • id6695
            • user_id4136
            • holiday_id(null)
            • resort_id484
            • place_id1475
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-02-06 22:58:19
            • created2018-02-06 22:58:19
          • 1
            • id6716
            • user_id6779
            • holiday_id(null)
            • resort_id484
            • place_id1475
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-02-08 08:49:36
            • created2018-02-08 08:49:36
      • 4
        • Place
          • id1387
          • nameSkiz Ski & Board Rentals
          • contact_name
          • slugskiz-ski-board-rentals-1387
          • user_id6452
          • resort_id484
          • place_category_id22
          • region_based_place(false)
          • region_id0
          • descriptionThink Better! If you normally drag your skis across airports and pay heavily for the privilege.. Or wait for hours in a queue to pick up sub-standard, badly adjusted skis that last saw wax and an edge when they were made. We have an alternative... YOUR choice of high quality, high end skis & boots, waxed and edged to perfection, fitted by professionals. No queuing, no waiting & genuine service. What does this cost? You might be pleasantly surprised..
          • background1513529692650740939.jpg
          • background_type(null)
          • emailinfo@llopgris.com
          • phone+376 830013
          • oh_from
          • oh_to
          • opening_hours0830-1900
          • facebook
          • twitter
          • google
          • websitewww.skiz1700.com
          • locationCamí Pont del Tarter, AD100 El Tarter, Andorra
          • lat42.577869
          • lng1.648531
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views147
          • seo_titleSkiz Rental equipment in El Tarter, Andorra
          • seo_descriptionSkiz is a fully equipped ski and snowboard rental shop in the centre of El tarter
          • seo_keywords
          • modified2018-04-26 00:12:46
          • created2017-12-08 16:59:37
          • averageRating5.00
        • Review
          • 0
            • id182
            • user_id4186
            • resort_id(null)
            • place_id1387
            • event_id(null)
            • reviewBest ski service for race and good price
            • stars5
            • active(true)
            • modified2018-01-23 12:41:13
            • created2018-01-23 12:41:13
        • UserNotification(empty)
      • 5
        • Place
          • id1471
          • name3 Estanys Restaurant
          • contact_name
          • slug3-estanys-restaurant-1471
          • user_id6559
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionIn the heart of Grau Roig, next to the chair lift in Cubil, the 3 Estanys restaurant offers its customers a full-service restaurant based on Mediterranean cuisine. Salads, pasta, home-made pizzas and cold cut platters. In the evenings, the restaurant also serves three types of special menus: escudella menu, fondue menu or chuletón menú. Opening hours: From 9 am to 3.30 pm. Evening opening hours: From 7.30 pm. Dinners by request before 48 hours. Evening access: On foot from the car park at Cubil.
          • background1514486029538548876.jpg
          • background_type(null)
          • email3estanys@hotansa.ad
          • phone+376 875 500
          • oh_from
          • oh_to
          • opening_hours9AM-3:30PM & 7:30PM-11PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 Canillo, Andorra
          • lat42.565857
          • lng1.601507
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views108
          • seo_title3 Estanys Restaurant Andorra
          • seo_descriptionIn the heart of Grau Roig, next to the chair lift in Cubil, the 3 Estanys restaurant offers its customers a full-service restaurant based on Mediterranean cuisine
          • seo_keywords
          • modified2018-04-25 02:12:05
          • created2017-12-28 18:26:48
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 6
        • Place
          • id1388
          • nameNordic Esports
          • contact_name
          • slugnordic-esports-1388
          • user_id6453
          • resort_id484
          • place_category_id22
          • region_based_place(false)
          • region_id0
          • descriptionNordic Esports can help with anything ski or board related, buy a new board, rent skis, boots, helmet, equipment repairs and expert advice.
          • background15127532891297686252.jpg
          • background_type(null)
          • emailinfo@andorratravelservice.com
          • phone0330 043 2134
          • oh_from
          • oh_to
          • opening_hoursMon Sat 0830-1800 - Sun 0900-2000
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationRc. General S/N, AD100 El Tarter, Andorra
          • lat42.580349
          • lng1.648920
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views216
          • seo_titleNordic esports in El Tarter
          • seo_descriptionFor all your ski and snowboard rental requirements and repair service
          • seo_keywords
          • modified2018-04-25 12:32:43
          • created2017-12-08 17:11:29
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 7
        • Place
          • id1384
          • nameLa Cort De Popaire
          • contact_name
          • slugla-cort-de-popaire-1384
          • user_id6449
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionSet in old barn gives Cort de Popaire a rustic traditional feel, enhanced with the large open fire. This is one of Soldeu's favourite restaurants amongst locals and tourists - Specialising in Local Fare and heaven for meat eaters, the service and cuisine are excellent. A great choice for special occasions. There is also an A la Carte menu.
          • background1515431135562676239.jpg
          • background_type(null)
          • emaillacortdepopaire@hotmail.com
          • phone+ 376 851 211
          • oh_from
          • oh_to
          • opening_hours1PM - 10:30PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 Soldeu, Andorra
          • lat42.577400
          • lng1.666640
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views168
          • seo_titleLa Cort de Polaire restaurant, Soldeu, Andorra
          • seo_descriptionOne of the smartest restaurants in Soldeu - meat and a la carte
          • seo_keywords
          • modified2018-04-25 08:28:22
          • created2017-12-08 15:04:12
          • averageRating5.00
        • Review
          • 0
            • id171
            • user_id6396
            • resort_id(null)
            • place_id1384
            • event_id(null)
            • reviewExcellent meal the other night. Highly recommend the stuffed squid and fillet steak
            • stars5
            • active(true)
            • modified2017-12-16 15:10:12
            • created2017-12-16 15:10:12
          • 1
            • id172
            • user_id473
            • resort_id(null)
            • place_id1384
            • event_id(null)
            • reviewAmazing high quality food - meat cooked indoors on the huge grill. Surf and turf option is mouthwatering and surprisingly inexpensive for a top ski resort!
            • stars5
            • active(true)
            • modified2017-12-17 16:42:53
            • created2017-12-17 16:42:53
        • UserNotification
          • 0
            • id6531
            • user_id6155
            • holiday_id(null)
            • resort_id484
            • place_id1384
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-01-19 18:15:57
            • created2018-01-19 18:15:57
          • 1
            • id6806
            • user_id6927
            • holiday_id(null)
            • resort_id484
            • place_id1384
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-02-20 15:14:38
            • created2018-02-20 15:14:38
      • 8
        • Place
          • id1383
          • nameThe Villager
          • contact_name
          • slugthe-villager-1383
          • user_id6448
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionThis couldn't be more handy if you are getting the Gondola back down as its the same building - A perfect stop for a bit of Apres, live music and live sports. Everything you'd expect to find in an Irish bar.
          • background15135283401189172511.jpg
          • background_type(null)
          • emaildirmarketing@sporthotels.ad
          • phone+376 870550
          • oh_from
          • oh_to
          • opening_hoursNoon - 1AM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCarretera General, s/n, AD100 Soldeu, Andorra
          • lat42.577957
          • lng1.663853
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views193
          • seo_titleThe Villager Irish Pub Soldeu
          • seo_descriptionRight next to the gondola the Villager is a great Irish bar with live music and live sports, great for Apres
          • seo_keywords
          • modified2018-04-23 19:06:26
          • created2017-12-08 11:55:38
          • averageRating0.00
        • Review(empty)
        • UserNotification
          • 0
            • id6775
            • user_id473
            • holiday_id(null)
            • resort_id484
            • place_id1383
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-02-16 16:51:10
            • created2018-02-16 16:51:10
          • 1
            • id6807
            • user_id6927
            • holiday_id(null)
            • resort_id484
            • place_id1383
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-02-20 16:27:52
            • created2018-02-20 16:27:52
      • 9
        • Place
          • id1385
          • nameHotel Bruxelles
          • contact_name
          • slughotel-bruxelles-1385
          • user_id6450
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionSet right in the centre of soldeu with a huge sun terrace, a huge range of sandwiches and snacks As well as a full service restaurant open lunchtime and evenings. Come here for excellent food and Something on the menu to please everyone.
          • background1513004734619643023.jpg
          • background_type(null)
          • emailhotelbruxelles@hotmail.com
          • phone+ 376 851 010
          • oh_from
          • oh_to
          • opening_hours10AM - 10:30PM
          • facebook
          • twitter
          • google
          • websitewww.andorrahotelbruxelles.com
          • locationCarretera General 2, La Pleta de Soldeu. Passatge de l'Asó, AD100 Soldeu, Andorra
          • lat42.578281
          • lng1.661409
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views191
          • seo_titleHotel Bruxelles A La Carte Restaurant
          • seo_descriptionA wide selection of food from Burgers to A La Carte
          • seo_keywords
          • modified2018-04-25 20:42:41
          • created2017-12-08 15:25:27
          • averageRating5.00
        • Review
          • 0
            • id181
            • user_id6544
            • resort_id(null)
            • place_id1385
            • event_id(null)
            • reviewType your review...
            • stars5
            • active(true)
            • modified2018-01-11 18:56:26
            • created2018-01-11 18:56:26
        • UserNotification
          • 0
            • id6388
            • user_id6396
            • holiday_id(null)
            • resort_id484
            • place_id1385
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2017-12-22 14:44:14
            • created2017-12-22 14:44:14
          • 1
            • id6391
            • user_id6450
            • holiday_id(null)
            • resort_id484
            • place_id1385
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2017-12-22 19:32:30
            • created2017-12-22 19:32:30
          • 2
            • id6571
            • user_id6243
            • holiday_id(null)
            • resort_id484
            • place_id1385
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-01-22 21:40:48
            • created2018-01-22 21:40:48
      • 10
        • Place
          • id1382
          • namePussycat Disco
          • contact_name
          • slugpussycat-disco-1382
          • user_id6447
          • resort_id484
          • place_category_id6
          • region_based_place(false)
          • region_id0
          • descriptionSet in a 200 year old farmhouse, now converted into a club and is legendary in Soldeu. After a recent revamp the Pussycat is back and bigger than ever. Apres ski hut on a Thursday is super popular with free apres food with every beer! Late night is when this place erupts with theme nights and DJ sets! Monthly theme nights include: Full Moon Party / Winter Zoo & Club Brand nights. Music policy depends on the night but usually goes like this: Thursday: Latino / Friday: House & Hip Hop / Saturday: Techno and Tech -house.
          • background151352806028989624.jpg
          • background_type(null)
          • emailisudafox@hotmail.com
          • phone+ 376 851 211
          • oh_from
          • oh_to
          • opening_hours3PM - 3AM, 4AM & 5AM (fri/sat)
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577621
          • lng1.665614
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views154
          • seo_titlePussycat Disco Soldeu Andorra
          • seo_descriptionThe legend that is the pussycat still going strong, apes ski, live music, free snacks, beers and cocktails
          • seo_keywords
          • modified2018-04-25 11:34:19
          • created2017-12-08 11:37:11
          • averageRating5.00
        • Review
          • 0
            • id176
            • user_id6528
            • resort_id(null)
            • place_id1382
            • event_id(null)
            • reviewType your review...
            • stars5
            • active(true)
            • modified2018-01-03 13:57:26
            • created2018-01-03 13:57:26
        • UserNotification(empty)
      • 11
        • Place
          • id1380
          • nameFat Alberts
          • contact_name
          • slugfat-alberts-1380
          • user_id6445
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionCome and enjoy the famous hospitality at Fat Alberts, one of the oldest and most established bars in Soldeu. Just off the main street we enjoy the stunning setting of a 300 year old converted barn. Live music and great DJ's throughout the week, this is a place where locals also like to enjoy a night of music and great food in the restaurant. It's also the only place where you will see the local ski instructor band The Shambles, every Tuesday & Thursday.
          • background15138608231540616893.jpeg
          • background_type(null)
          • emailfattysandslims@gmail.com
          • phone+ 376 366 475
          • oh_from
          • oh_to
          • opening_hours3PM - 3AM (4AM weekends)
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttp://www.fat-albertssoldeu.com
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views278
          • seo_titleFat Alberts Bar & Restaurant in Soldeu Andorra
          • seo_descriptionFat Alberts is one of the oldest bars in Soldeu, great music, great food - perfect Apres and evening bar
          • seo_keywords
          • modified2018-04-25 07:19:35
          • created2017-12-08 11:10:31
          • averageRating5.00
        • Review
          • 0
            • id173
            • user_id6508
            • resort_id(null)
            • place_id1380
            • event_id(null)
            • reviewType your review...
            • stars5
            • active(true)
            • modified2017-12-21 20:21:38
            • created2017-12-21 20:21:38
        • UserNotification
          • 0
            • id6358
            • user_id6506
            • holiday_id(null)
            • resort_id484
            • place_id1380
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2017-12-18 16:47:21
            • created2017-12-18 16:47:21
          • 1
            • id6375
            • user_id6508
            • holiday_id(null)
            • resort_id484
            • place_id1380
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2017-12-21 20:18:02
            • created2017-12-21 20:18:02
          • 2
            • id6376
            • user_id6508
            • holiday_id(null)
            • resort_id484
            • place_id1380
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2017-12-21 20:20:18
            • created2017-12-21 20:20:18
      • 12
        • Place
          • id1391
          • nameEl Clos Snack Bar
          • contact_name
          • slugel-clos-snack-bar-1391
          • user_id6456
          • resort_id484
          • place_category_id8
          • region_based_place(false)
          • region_id0
          • descriptionYou could almost ski onto our terrace from the bottom of the El Tarter chair lift. A great choice for lunch, varied menu from snacks to full a blown meal but get in early, its gets busy.
          • background15173134591288926880.jpg
          • background_type(null)
          • emaileclos@hangoutonholiday.com
          • phone+ 376 753 500
          • oh_from
          • oh_to
          • opening_hours10AM - 10PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCtra. del Tarter, AD100 El Tarter, Andorra
          • lat42.579884
          • lng1.649463
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views142
          • seo_titleEl Clos Snack Bar El Tartar, Andorra
          • seo_descriptionGreat choice for lunch from snacks to full blown meals - gets busy though so get in early
          • seo_keywords
          • modified2018-04-24 16:34:26
          • created2017-12-08 22:11:16
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 13
        • Place
          • id1393
          • nameLa Caleta
          • contact_name
          • slugla-caleta-1393
          • user_id6458
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionSoldeu's original Tapas restaurant. Come and visit Jose in this cosy little restaurant and enjoy some traditional Andaluz Tapas and tasty wine - everyone loves tapas right, we do.
          • background15127727041620703750.jpg
          • background_type(null)
          • emailgatillin@hotmail.es
          • phone+ 376 366 221
          • oh_from
          • oh_to
          • opening_hoursNoon until Midnight
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCG-2, Soldeu, Andorra
          • lat42.577160
          • lng1.665768
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views134
          • seo_titleLa Caleta Tapas Restaurant Soldeu
          • seo_descriptionThe best and original Tapas restaurant in Soldeu, Andorra
          • seo_keywords
          • modified2018-04-25 21:32:53
          • created2017-12-08 22:37:18
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 14
        • Place
          • id1381
          • nameBarcode
          • contact_name
          • slugbarcode-1381
          • user_id6446
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionHow many 'Barcodes' are there in the world - quite a few we reckon - welcome to the Andorra branch. Come and join us for Apres ski parties on the best terrace in Soldeu enjoying a burger and live music. You got to try one of our famous Gin & Tonics
          • background15135276091775939862.jpg
          • background_type(null)
          • emailbarcode@hangoutonholiday.com
          • phone+376
          • oh_from
          • oh_to
          • opening_hours3PM - 3AM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCarretera General, s/n, AD100 Soldeu, Andorra
          • lat42.577957
          • lng1.663853
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views145
          • seo_titleBar Code Soldeu Andorra
          • seo_descriptionBar Code in Soldeu specialises in great food, live music and world famous gin and tonic
          • seo_keywords
          • modified2018-04-23 18:59:24
          • created2017-12-08 11:23:47
          • averageRating5.00
        • Review
          • 0
            • id175
            • user_id4186
            • resort_id(null)
            • place_id1381
            • event_id(null)
            • reviewThe drunken irish lady made our night!! Thanks
            • stars5
            • active(true)
            • modified2017-12-28 11:33:02
            • created2017-12-28 11:33:02
          • 1
            • id183
            • user_id6243
            • resort_id(null)
            • place_id1381
            • event_id(null)
            • reviewA great night - top bar - thanks Jude
            • stars5
            • active(true)
            • modified2018-01-24 19:26:39
            • created2018-01-24 19:26:39
        • UserNotification(empty)
      • 15
        • Place
          • id1465
          • nameSlideawayz Ski Rental
          • contact_name
          • slugslideawayz-ski-rental-1465
          • user_id6524
          • resort_id484
          • place_category_id22
          • region_based_place(false)
          • region_id0
          • descriptionSlidewayz snowboard shop & rental
          • background1513940835680577536.jpg
          • background_type(null)
          • emailinfo@llopgris.com
          • phone+376 853595
          • oh_from
          • oh_to
          • opening_hours8AM - 7PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitewww.slidewayz.com
          • locationCamí Vell de Soldeu, AD100, Andorra
          • lat42.577717
          • lng1.660591
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views103
          • seo_titleSlideaway Ski Rental in Soldeu
          • seo_descriptionsildeaway ski rental for all your rental requirements
          • seo_keywords
          • modified2018-04-23 22:59:03
          • created2017-12-22 11:06:44
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 16
        • Place
          • id1468
          • nameAndorra Direct
          • contact_name
          • slugandorra-direct-1468
          • user_id6411
          • resort_id484
          • place_category_id14
          • region_based_place(false)
          • region_id0
          • descriptionAndorra Direct - For all your transfer and ski extra needs. Transfers from Barcelona, Gerona and Toulouse airports - shuttle and private transfers, ski passes, activities, ski hire, everything you need when you come to Andorra, And the best bit.. The more you book the more you save!!
          • background15144620401966239916.jpg
          • background_type(null)
          • emailinfo@andorratravelservices.com
          • phone020 3026 9670
          • oh_from
          • oh_to
          • opening_hours9AM - 8PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationBordes D'envalira, AD100 Soldeu, Andorra
          • lat42.560417
          • lng1.682180
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views127
          • seo_titleAndorra Direct Transfers
          • seo_descriptionTransfers direct from Barcelona, Gerona and Toulouse airports to all Andorra Resorts
          • seo_keywords
          • modified2018-04-25 02:54:11
          • created2017-12-26 16:55:00
          • averageRating0.00
        • Review(empty)
        • UserNotification
          • 0
            • id6534
            • user_id6583
            • holiday_id(null)
            • resort_id484
            • place_id1468
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-01-19 23:37:43
            • created2018-01-19 23:37:43
      • 17
        • Place
          • id1510
          • nameFoto Servei
          • contact_name
          • slugfoto-servei-1510
          • user_id6753
          • resort_id484
          • place_category_id20
          • region_based_place(false)
          • region_id0
          • descriptionFoto Servei of Soldeu & El Tarter - for all your photo requirements, we are on the mountain every day snapping away.
          • background151716005869666197.jpg
          • background_type(null)
          • emailfotosoldeu@gmail.com
          • phone00 376 351150
          • oh_from
          • oh_to
          • opening_hoursall day every day
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views137
          • seo_titleFoto Servi Soldeu Andorra
          • seo_descriptionFor all you photograph and video needs on the mountains
          • seo_keywords
          • modified2018-04-25 15:28:38
          • created2018-01-28 17:20:07
          • averageRating0.00
        • Review(empty)
        • UserNotification
          • 0
            • id6634
            • user_id6753
            • holiday_id(null)
            • resort_id484
            • place_id1510
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-01-29 14:56:54
            • created2018-01-29 14:56:54
          • 1
            • id6640
            • user_id6753
            • holiday_id(null)
            • resort_id484
            • place_id1510
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-01-30 09:58:28
            • created2018-01-30 09:58:28
      • 18
        • Place
          • id1390
          • nameL'avet Pizzeria
          • contact_name
          • slugl-avet-pizzeria-1390
          • user_id6455
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionAn original Pizzeria serving up amazing thin crusted based Pizzas, salads, pastas and the best garlic bread in Soldeu. Situated right in the centre of town its the perfect choice for snacks, a full blown meal or take away.
          • background15130029841039151463.jpg
          • background_type(null)
          • emaillavet@hangoutonholiday.com
          • phone+ 376 739 325
          • oh_from
          • oh_to
          • opening_hours1PM - 11PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views134
          • seo_titleL'avet Pizzeria, Soldeu, Andorra
          • seo_descriptionThe best Pizzeria in town, thin crust pizza to eat in or take away
          • seo_keywords
          • modified2018-04-25 20:54:11
          • created2017-12-08 22:02:33
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 19
        • Place
          • id1395
          • nameFontanella Restaurant
          • contact_name
          • slugfontanella-restaurant-1395
          • user_id6460
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionSpecialising in Italian cuisine - Pizzas & Pastas, The Fontanella is the finest Italian restaurant in the area with one of the most reasonably priced menus in town.
          • background15171540381151948024.jpg
          • background_type(null)
          • emailrecepcio@hotelpiolets.com
          • phone+ 376 872 787
          • oh_from
          • oh_to
          • opening_hours1PM-11PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCarretera General 2, La Pleta de Soldeu. Passatge de l'Asó, AD100 Soldeu, Andorra
          • lat42.578281
          • lng1.661409
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views142
          • seo_titleFontanella Restaurant in Soldeu, Andorra
          • seo_descriptionA classic Italian restaurant in the village of Soledu
          • seo_keywords
          • modified2018-04-23 19:00:56
          • created2017-12-08 23:08:01
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 20
        • Place
          • id1386
          • nameDelbosc Coffee Shop
          • contact_name
          • slugdelbosc-coffee-shop-1386
          • user_id6451
          • resort_id484
          • place_category_id24
          • region_based_place(false)
          • region_id0
          • descriptionWe are a friendly little Coffee Shop & Tea Room in Soldeu Village. Get your day off to the perfect start with a fresh coffee, homemade pastries, a toastie maybe or perhaps a burger for lunch. There is something great about the smell of fresh coffee and freshly baked bread in the morning. We also do take away coffee if you can hold your ski's poles and coffee all at once - cash only though. We serve - Chai Lattes. - Fresh croissants/pastries - Home-made cakes - Bio soups, bio teas - Veggie food - Sandwiches – Burgers - Chocolates - Oat /soy/ almond milk. - Cakes to order - Next to supermarket font - WIFI - Coffee to go
          • background1514553085985539561.jpg
          • background_type(null)
          • emailadrianaspag2@hotmail.com
          • phone+ 376 728223
          • oh_from
          • oh_to
          • opening_hoursDaily 0900-1900
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views150
          • seo_titleDelbosco Coffee shop in Soldeu
          • seo_descriptionMorning coffee and pastries, take away service, toasties, and burgers
          • seo_keywords
          • modified2018-04-25 15:33:00
          • created2017-12-08 16:41:21
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 21
        • Place
          • id1379
          • nameThe Harp
          • contact_name
          • slugthe-harp-1379
          • user_id6444
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionThe Harp Soldeu where everyone is invited to the party. The party starts early December and ends mid April - this is one of the liveliest bars in town - live music every night at Apres Ski time with some of the best musicians in town. Probably the most fun you can have in a bar.
          • background1513522480182470692.jpg
          • background_type(null)
          • emailtheharpsoldeu@hotmail.com
          • phone+376
          • oh_from
          • oh_to
          • opening_hours3PM - 3AM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCG-2, AD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views154
          • seo_titleThe Harp Irish Bar, Soldeu
          • seo_descriptionGreat Apres ski bar with live music every night
          • seo_keywords
          • modified2018-04-23 19:06:19
          • created2017-12-08 10:57:27
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 22
        • Place
          • id1378
          • nameSports Calbo
          • contact_name
          • slugsports-calbo-1378
          • user_id6411
          • resort_id484
          • place_category_id22
          • region_based_place(false)
          • region_id0
          • descriptionFor the best start to your holiday in the Soldeu resort, make sure you have the best skiing equipment. For rentals, put your trust in our sports pros and let them help you get kitted out at the Esports Calbo store. Ideally located in the gondola station. The latest equipment and great service.
          • background15130027411139051114.jpg
          • background_type(null)
          • emailinfo@andorratravelservices.com
          • phone3300432134
          • oh_from
          • oh_to
          • opening_hours8AM - 6PM (Weekends 7PM)
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCarretera General 2 s/n Edifici Telecabina Grandvalira Soldeu, AD100 Soldeu, Andorra
          • lat42.576054
          • lng1.669175
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views153
          • seo_titleEsports Calbo, ski rental in Soldeu, Andorra
          • seo_descriptionThe most established ski rental shop in Soldeu - let our professional technicians help you get kitted out
          • seo_keywords
          • modified2018-04-25 06:21:32
          • created2017-12-08 10:34:14
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 23
        • Place
          • id1508
          • nameNeilson Chalets
          • contact_name
          • slugneilson-chalets-1508
          • user_id6684
          • resort_id484
          • place_category_id10
          • region_based_place(false)
          • region_id0
          • descriptionNeilson Chalets in El Tarter - please send us a message if you require any assistance
          • background15164605662005529963.jpg
          • background_type(null)
          • emailinfo@andorratravelservices.com
          • phone0330 043 2134 local rate
          • oh_from
          • oh_to
          • opening_hours8AM - 8PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 El Tarter, Andorra
          • lat42.580151
          • lng1.651174
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views76
          • seo_title
          • seo_description
          • seo_keywords
          • modified2018-04-25 08:50:07
          • created2018-01-20 15:01:50
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 24
        • Place
          • id1377
          • namePic Negre
          • contact_name
          • slugpic-negre-1377
          • user_id6411
          • resort_id484
          • place_category_id22
          • region_based_place(false)
          • region_id0
          • descriptionPic Negre in Soldeu sells and rents the finest ski brands for skiing and boarding. (Oh and Bike rental in the summer). Our stores are ideally placed on the main street and our staff will ensure the best service so your equipment is the best fit for your ability.
          • background1513002549894408906.jpg
          • background_type(null)
          • emailinfo@andorratravelservice.com
          • phone0330 043 2134
          • oh_from
          • oh_to
          • opening_hours8AM - 8PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views163
          • seo_titlePic Negre Ski and Board Rental in Soldeu
          • seo_descriptionPic Negre is a leading ski, board and bike rental shop in the centre of Soldeu, Andorra
          • seo_keywords
          • modified2018-04-25 15:54:27
          • created2017-12-08 10:21:35
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 25
        • Place
          • id1376
          • nameThe Aspen Bar
          • contact_name
          • slugthe-aspen-bar-1376
          • user_id6443
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionThe Aspen is one of Soldeu's legendary bars with locals & tourists alike. As you'd expect we have all the ingredients to make this place rock, live music, huge screens showing all the sports, table football, pool tables, great bar food and top music. And right bang in the centre of town. Come here on the Aprés for drinks, snacks and to catch up with your instructors or later for the great atmsophere, friendly staff & live music. Not to be missed!!
          • background15130019041261744282.jpg
          • background_type(null)
          • emailaspen@hangoutonholiday.com
          • phone+376 851 974
          • oh_from
          • oh_to
          • opening_hours2PM - 3AM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCG-2, AD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views175
          • seo_titleThe Aspen Bar, Soldeu Andorra
          • seo_descriptionA proper old fashioned English pub in the centre of Soldeu, live music, open late
          • seo_keywords
          • modified2018-04-23 19:06:02
          • created2017-12-08 10:13:47
          • averageRating5.00
        • Review
          • 0
            • id180
            • user_id6612
            • resort_id(null)
            • place_id1376
            • event_id(null)
            • reviewChilled out sports bar with live music, party place on Thursdays and Saturdays! Pool tables, table football and snack and bar food! Always something on to watch and do!!
            • stars5
            • active(true)
            • modified2018-01-10 19:16:32
            • created2018-01-10 19:16:32
        • UserNotification(empty)
    • places
      • 0
        • Place
          • id1391
          • nameEl Clos Snack Bar
          • contact_name
          • slugel-clos-snack-bar-1391
          • user_id6456
          • resort_id484
          • place_category_id8
          • region_based_place(false)
          • region_id0
          • descriptionYou could almost ski onto our terrace from the bottom of the El Tarter chair lift. A great choice for lunch, varied menu from snacks to full a blown meal but get in early, its gets busy.
          • background15173134591288926880.jpg
          • background_type(null)
          • emaileclos@hangoutonholiday.com
          • phone+ 376 753 500
          • oh_from
          • oh_to
          • opening_hours10AM - 10PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCtra. del Tarter, AD100 El Tarter, Andorra
          • lat42.579884
          • lng1.649463
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views142
          • seo_titleEl Clos Snack Bar El Tartar, Andorra
          • seo_descriptionGreat choice for lunch from snacks to full blown meals - gets busy though so get in early
          • seo_keywords
          • modified2018-04-24 16:34:26
          • created2017-12-08 22:11:16
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 1
        • Place
          • id1394
          • nameBorda del Rector
          • contact_name
          • slugborda-del-rector-1394
          • user_id6459
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionIf you are looking to sample local cuisine and flavours of the highest order, then this is probably your best bet in the Soldeu area. A charming old restaurant brought up to date with modern touches and a classic menu. The owners are always on hand to help and they have one of the finest wine menus in the entire country. It enjoys a warm cost atmosphere and the staff are excellent.
          • background151277396083964126.jpg
          • background_type(null)
          • emailtresataula@gmail.com
          • phone+ 376 852 606
          • oh_from
          • oh_to
          • opening_hours1PM - 5Pm & 8PM - Midnight
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCarretera General 2, La Pleta de Soldeu. Passatge de l'Asó, AD100 Soldeu, Andorra
          • lat42.578281
          • lng1.661409
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views142
          • seo_titleBorda del Rector Restaurant in Soldeu, Andorra
          • seo_descriptionA charming traditional restaurant in Soldeu
          • seo_keywords
          • modified2018-04-24 11:44:41
          • created2017-12-08 22:57:10
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 2
        • Place
          • id1393
          • nameLa Caleta
          • contact_name
          • slugla-caleta-1393
          • user_id6458
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionSoldeu's original Tapas restaurant. Come and visit Jose in this cosy little restaurant and enjoy some traditional Andaluz Tapas and tasty wine - everyone loves tapas right, we do.
          • background15127727041620703750.jpg
          • background_type(null)
          • emailgatillin@hotmail.es
          • phone+ 376 366 221
          • oh_from
          • oh_to
          • opening_hoursNoon until Midnight
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCG-2, Soldeu, Andorra
          • lat42.577160
          • lng1.665768
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views134
          • seo_titleLa Caleta Tapas Restaurant Soldeu
          • seo_descriptionThe best and original Tapas restaurant in Soldeu, Andorra
          • seo_keywords
          • modified2018-04-25 21:32:53
          • created2017-12-08 22:37:18
          • averageRating0.00
        • Review(empty)
        • UserNotification(empty)
      • 3
        • Place
          • id1384
          • nameLa Cort De Popaire
          • contact_name
          • slugla-cort-de-popaire-1384
          • user_id6449
          • resort_id484
          • place_category_id13
          • region_based_place(false)
          • region_id0
          • descriptionSet in old barn gives Cort de Popaire a rustic traditional feel, enhanced with the large open fire. This is one of Soldeu's favourite restaurants amongst locals and tourists - Specialising in Local Fare and heaven for meat eaters, the service and cuisine are excellent. A great choice for special occasions. There is also an A la Carte menu.
          • background1515431135562676239.jpg
          • background_type(null)
          • emaillacortdepopaire@hotmail.com
          • phone+ 376 851 211
          • oh_from
          • oh_to
          • opening_hours1PM - 10:30PM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationAD100 Soldeu, Andorra
          • lat42.577400
          • lng1.666640
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views168
          • seo_titleLa Cort de Polaire restaurant, Soldeu, Andorra
          • seo_descriptionOne of the smartest restaurants in Soldeu - meat and a la carte
          • seo_keywords
          • modified2018-04-25 08:28:22
          • created2017-12-08 15:04:12
          • averageRating5.00
        • Review
          • 0
            • id171
            • user_id6396
            • resort_id(null)
            • place_id1384
            • event_id(null)
            • reviewExcellent meal the other night. Highly recommend the stuffed squid and fillet steak
            • stars5
            • active(true)
            • modified2017-12-16 15:10:12
            • created2017-12-16 15:10:12
          • 1
            • id172
            • user_id473
            • resort_id(null)
            • place_id1384
            • event_id(null)
            • reviewAmazing high quality food - meat cooked indoors on the huge grill. Surf and turf option is mouthwatering and surprisingly inexpensive for a top ski resort!
            • stars5
            • active(true)
            • modified2017-12-17 16:42:53
            • created2017-12-17 16:42:53
        • UserNotification
          • 0
            • id6531
            • user_id6155
            • holiday_id(null)
            • resort_id484
            • place_id1384
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-01-19 18:15:57
            • created2018-01-19 18:15:57
          • 1
            • id6806
            • user_id6927
            • holiday_id(null)
            • resort_id484
            • place_id1384
            • event_id(null)
            • offer_id(null)
            • excursion_id(null)
            • model_namePlace
            • typecheckin
            • statusactive
            • read(false)
            • modified2018-02-20 15:14:38
            • created2018-02-20 15:14:38
    • events
      • 0
        • Event
          • id247
          • nameThe Shambles of Soldeu
          • subtitle(null)
          • slugthe-shambles-of-soldeu
          • user_id2
          • place_id1380
          • resort_id484
          • event_category_id7
          • region_based_event(false)
          • region_id0
          • description<p>Presenting the famous ski instructor band - The Shambles of Soldeu for great sing along Apres live music</p>
          • background151386115477800050.jpeg
          • background_type0
          • event_start2017-12-21 17:00:00
          • event_end0000-00-00 00:00:00
          • recurring_event(true)
          • recurring_event_typeweekly
          • recurring_event_times16
          • recurring_event_datess:209:"["2017-12-21","2017-12-28","2018-01-04","2018-01-11","2018-01-18","2018-01-25","2018-02-01","2018-02-08","2018-02-15","2018-02-22","2018-03-01","2018-03-08","2018-03-15","2018-03-22","2018-03-29","2018-04-05"]";
          • entrance_priceFree
          • emailfattysandslims@gmail.com
          • phone+ 376 366 475
          • facebook
          • twitter
          • google
          • website
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • views0
          • seo_titleThe Shambles
          • seo_descriptionThe only place to see the only ski instructor band in town
          • seo_keywords
          • modified2018-01-16 11:17:58
          • created2017-12-08 23:44:42
        • Place
          • id1380
          • nameFat Alberts
          • contact_name
          • slugfat-alberts-1380
          • user_id6445
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionCome and enjoy the famous hospitality at Fat Alberts, one of the oldest and most established bars in Soldeu. Just off the main street we enjoy the stunning setting of a 300 year old converted barn. Live music and great DJ's throughout the week, this is a place where locals also like to enjoy a night of music and great food in the restaurant. It's also the only place where you will see the local ski instructor band The Shambles, every Tuesday & Thursday.
          • background15138608231540616893.jpeg
          • background_type(null)
          • emailfattysandslims@gmail.com
          • phone+ 376 366 475
          • oh_from
          • oh_to
          • opening_hours3PM - 3AM (4AM weekends)
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttp://www.fat-albertssoldeu.com
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views278
          • seo_titleFat Alberts Bar & Restaurant in Soldeu Andorra
          • seo_descriptionFat Alberts is one of the oldest bars in Soldeu, great music, great food - perfect Apres and evening bar
          • seo_keywords
          • modified2018-04-25 07:19:35
          • created2017-12-08 11:10:31
          • averageRating5.00
        • EventPicture
          • 0
            • id542
            • event_id247
            • user_id2
            • titlefat als 4.jpeg
            • picturefat als 4.jpeg
            • primary_picture(true)
            • active(true)
            • sort_order0
            • created2017-12-21 12:59:08
            • modified2017-12-21 12:59:08
        • UserNotification(empty)
      • 1
        • Event
          • id249
          • nameRib Shack Tuesday
          • subtitle(null)
          • slugrib-shack-tuesday-249
          • user_id2
          • place_id1380
          • resort_id484
          • event_category_id6
          • region_based_event(false)
          • region_id0
          • description<p>Tuesday is Rib Shack night - eat as much as you can for only €16 for adults and €10 for kids - You need to book in advance - Message us in app or call - 2 sittings 6:30pm - 7pm & 9pm - 9:30pm</p>
          • background15154252761858444351.jpeg
          • background_type0
          • event_start2017-12-26 18:30:00
          • event_end0000-00-00 00:00:00
          • recurring_event(true)
          • recurring_event_typeweekly
          • recurring_event_times16
          • recurring_event_datess:209:"["2017-12-26","2018-01-02","2018-01-09","2018-01-16","2018-01-23","2018-01-30","2018-02-06","2018-02-13","2018-02-20","2018-02-27","2018-03-06","2018-03-13","2018-03-20","2018-03-27","2018-04-03","2018-04-10"]";
          • entrance_priceAdults €16 - Kids €10
          • emailfattysandslims@gmail.com
          • phone+ 376 366 475
          • facebook
          • twitter
          • google
          • website
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • views0
          • seo_titleRib Shack Tuesday
          • seo_descriptionEat as much as you can for one price - Ribs are our speciality
          • seo_keywords
          • modified2018-01-16 11:17:55
          • created2017-12-08 23:50:02
        • Place
          • id1380
          • nameFat Alberts
          • contact_name
          • slugfat-alberts-1380
          • user_id6445
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionCome and enjoy the famous hospitality at Fat Alberts, one of the oldest and most established bars in Soldeu. Just off the main street we enjoy the stunning setting of a 300 year old converted barn. Live music and great DJ's throughout the week, this is a place where locals also like to enjoy a night of music and great food in the restaurant. It's also the only place where you will see the local ski instructor band The Shambles, every Tuesday & Thursday.
          • background15138608231540616893.jpeg
          • background_type(null)
          • emailfattysandslims@gmail.com
          • phone+ 376 366 475
          • oh_from
          • oh_to
          • opening_hours3PM - 3AM (4AM weekends)
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttp://www.fat-albertssoldeu.com
          • locationPlaça del Piol, AD100 Soldeu, Andorra
          • lat42.577217
          • lng1.666934
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views278
          • seo_titleFat Alberts Bar & Restaurant in Soldeu Andorra
          • seo_descriptionFat Alberts is one of the oldest bars in Soldeu, great music, great food - perfect Apres and evening bar
          • seo_keywords
          • modified2018-04-25 07:19:35
          • created2017-12-08 11:10:31
          • averageRating5.00
        • EventPicture
          • 0
            • id548
            • event_id249
            • user_id2
            • titlefat als 6.jpeg
            • picturefat als 6.jpeg
            • primary_picture(true)
            • active(true)
            • sort_order0
            • created2017-12-21 14:40:47
            • modified2017-12-21 14:40:47
        • UserNotification(empty)
      • 2
        • Event
          • id252
          • nameThe Dogs Bollocks
          • subtitle(null)
          • slugthe-dogs-bollocks
          • user_id4186
          • place_id1376
          • resort_id484
          • event_category_id1
          • region_based_event(false)
          • region_id0
          • description<p>The Famous.. Or Infamous original ski-instructor band, live on stage</p>
          • background15131831061724446258.jpg
          • background_type0
          • event_start2017-12-14 16:00:00
          • event_end0000-00-00 00:00:00
          • recurring_event(true)
          • recurring_event_typeweekly
          • recurring_event_times16
          • recurring_event_datess:209:"["2017-12-14","2017-12-21","2017-12-28","2018-01-04","2018-01-11","2018-01-18","2018-01-25","2018-02-01","2018-02-08","2018-02-15","2018-02-22","2018-03-01","2018-03-08","2018-03-15","2018-03-22","2018-03-29"]";
          • entrance_pricefree
          • emailaspen@hangoutonholiday.com
          • phone+376 851 974
          • facebook
          • twitter@andorraexperts
          • google
          • website
          • locationCG-2, AD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • views0
          • seo_titleDogs Bollocks at the Aspen
          • seo_descriptionOne of the higlighst of the week, the Elvis night at The Aspen Soldeu
          • seo_keywords
          • modified2018-01-17 16:02:23
          • created2017-12-09 00:06:38
        • Place
          • id1376
          • nameThe Aspen Bar
          • contact_name
          • slugthe-aspen-bar-1376
          • user_id6443
          • resort_id484
          • place_category_id3
          • region_based_place(false)
          • region_id0
          • descriptionThe Aspen is one of Soldeu's legendary bars with locals & tourists alike. As you'd expect we have all the ingredients to make this place rock, live music, huge screens showing all the sports, table football, pool tables, great bar food and top music. And right bang in the centre of town. Come here on the Aprés for drinks, snacks and to catch up with your instructors or later for the great atmsophere, friendly staff & live music. Not to be missed!!
          • background15130019041261744282.jpg
          • background_type(null)
          • emailaspen@hangoutonholiday.com
          • phone+376 851 974
          • oh_from
          • oh_to
          • opening_hours2PM - 3AM
          • facebook
          • twitter@andorraexperts
          • google
          • websitehttps://www.andorratravelservice.com/
          • locationCG-2, AD100 Soldeu, Andorra
          • lat42.577789
          • lng1.666049
          • active(true)
          • vip(false)
          • status(null)
          • paid3
          • voucher_id(null)
          • views175
          • seo_titleThe Aspen Bar, Soldeu Andorra
          • seo_descriptionA proper old fashioned English pub in the centre of Soldeu, live music, open late
          • seo_keywords
          • modified2018-04-23 19:06:02
          • created2017-12-08 10:13:47
          • averageRating5.00
        • EventPicture
          • 0
            • id521
            • event_id252
            • user_id4186
            • titlePhoto 13-12-2017, 10 32 37.jpg
            • picturePhoto 13-12-2017, 10 32 37.jpg
            • primary_picture(true)
            • active(true)
            • sort_order0
            • created2017-12-13 16:38:17
            • modified2017-12-13 16:38:17
        • UserNotification(empty)
    • place_categories
      • 0
        • PlaceCategory
          • id3
          • parent_id(null)
          • category_icon_id4
          • sort_order2
          • lft3
          • rght8
          • nameBars
          • slugbars
          • icon
          • active(true)
          • modified2016-01-15 10:58:00
          • created0000-00-00 00:00:00
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id4
          • user_id2
          • titleBars
          • url(null)
          • picturebars.png
          • active(true)
          • sort_order3
          • created2013-11-04 10:17:58
          • modified2016-09-28 10:53:22
      • 1
        • PlaceCategory
          • id6
          • parent_id(null)
          • category_icon_id11
          • sort_order9
          • lft9
          • rght14
          • nameClubs
          • slugclubs
          • icon
          • active(true)
          • modified2016-01-15 10:58:00
          • created0000-00-00 00:00:00
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id11
          • user_id2
          • titleclubs
          • url(null)
          • pictureclubs.png
          • active(true)
          • sort_order9
          • created2013-11-04 10:18:00
          • modified2016-01-15 11:59:42
      • 2
        • PlaceCategory
          • id8
          • parent_id(null)
          • category_icon_id8
          • sort_order7
          • lft12
          • rght13
          • nameFast Food
          • slugfast-food
          • icon
          • active(true)
          • modified2016-01-15 10:58:00
          • created0000-00-00 00:00:00
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id8
          • user_id2
          • titlefastfood
          • url(null)
          • picturefastfood.png
          • active(true)
          • sort_order6
          • created2013-11-04 10:17:59
          • modified2013-11-06 14:32:22
      • 3
        • PlaceCategory
          • id10
          • parent_id(null)
          • category_icon_id10
          • sort_order4
          • lft17
          • rght22
          • nameHotels, Villas & Self catering
          • slughotels-villas--self-catering
          • icon
          • active(true)
          • modified2016-01-15 10:58:00
          • created0000-00-00 00:00:00
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id10
          • user_id2
          • titlehotels
          • url(null)
          • picturehotels.png
          • active(true)
          • sort_order8
          • created2013-11-04 10:17:59
          • modified2013-11-06 14:32:22
      • 4
        • PlaceCategory
          • id13
          • parent_id(null)
          • category_icon_id15
          • sort_order11
          • lft23
          • rght28
          • nameRestaurants
          • slugrestaurants
          • icon
          • active(true)
          • modified2016-01-26 18:30:34
          • created0000-00-00 00:00:00
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id15
          • user_id2
          • titlerestaurant
          • url(null)
          • picturerestaurant.png
          • active(true)
          • sort_order13
          • created2013-11-04 10:18:00
          • modified2013-11-06 14:32:22
      • 5
        • PlaceCategory
          • id14
          • parent_id(null)
          • category_icon_id17
          • sort_order15
          • lft24
          • rght25
          • nameTravel & Transport
          • slugtravel-transport
          • icon
          • active(true)
          • modified2016-01-15 10:58:00
          • created0000-00-00 00:00:00
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id17
          • user_id2
          • titletransportation
          • url(null)
          • picturetransportation.png
          • active(true)
          • sort_order15
          • created2013-11-04 10:18:01
          • modified2013-11-06 14:32:22
      • 6
        • PlaceCategory
          • id20
          • parent_id(null)
          • category_icon_id48
          • sort_order0
          • lft39
          • rght40
          • nameSports
          • slugsports
          • icon
          • active(true)
          • modified2016-09-30 13:00:09
          • created2016-09-30 13:00:09
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id48
          • user_id2
          • titleSports
          • url(null)
          • picturetennis.png
          • active(true)
          • sort_order0
          • created2016-09-30 12:59:34
          • modified2016-09-30 12:59:51
      • 7
        • PlaceCategory
          • id22
          • parent_id(null)
          • category_icon_id49
          • sort_order0
          • lft43
          • rght44
          • nameSki & Board Rental
          • slugski--board-rental
          • icon
          • active(true)
          • modified2017-12-01 10:14:21
          • created2016-11-01 16:54:45
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id49
          • user_id2
          • titleSki & Board Rental
          • url(null)
          • pictureski rental.jpg
          • active(true)
          • sort_order0
          • created2016-11-01 16:53:13
          • modified2016-11-01 16:54:10
      • 8
        • PlaceCategory
          • id24
          • parent_id(null)
          • category_icon_id51
          • sort_order0
          • lft47
          • rght48
          • nameCafe
          • slugcafe
          • icon
          • active(true)
          • modified2016-11-02 16:48:13
          • created2016-11-02 16:48:13
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id51
          • user_id2
          • titlecoffee shop
          • url(null)
          • picturecoffee shop.png
          • active(true)
          • sort_order0
          • created2016-11-02 16:41:33
          • modified2016-11-02 16:41:33
      • 9
        • PlaceCategory
          • id29
          • parent_id(null)
          • category_icon_id57
          • sort_order0
          • lft57
          • rght58
          • nameResort Rep
          • slugresort-rep
          • icon
          • active(true)
          • modified2018-01-20 14:47:40
          • created2018-01-20 14:47:40
        • ParentCategory
          • id(null)
          • parent_id(null)
          • category_icon_id(null)
          • sort_order(null)
          • lft(null)
          • rght(null)
          • name(null)
          • slug(null)
          • icon(null)
          • active(null)
          • modified(null)
          • created(null)
        • CategoryPicture
          • id57
          • user_id2
          • titleRep
          • url(null)
          • pictureRep.png
          • active(true)
          • sort_order0
          • created2018-01-20 14:46:22
          • modified2018-01-20 14:46:22
    • event_categories
      • 0
        • EventCategory
          • id1
          • parent_id(null)
          • category_icon_id24
          • sort_order4
          • lft(null)
          • rght(null)
          • nameAdventure & Sports
          • slugadventure-sports
          • icon
          • active(true)
          • modified2015-06-15 10:56:11
          • created0000-00-00 00:00:00
      • 1
        • EventCategory
          • id6
          • parent_id(null)
          • category_icon_id8
          • sort_order5
          • lft(null)
          • rght(null)
          • nameFood
          • slugfood
          • icon
          • active(true)
          • modified2015-06-15 10:56:14
          • created0000-00-00 00:00:00
      • 2
        • EventCategory
          • id7
          • parent_id(null)
          • category_icon_id31
          • sort_order3
          • lft(null)
          • rght(null)
          • nameLive Music
          • sluglive-music
          • icon
          • active(true)
          • modified2015-06-15 10:56:05
          • created0000-00-00 00:00:00
    • top_articles(empty)
    • from(null)
    • to(null)
    • user_uploaded_pictures(empty)
    • all_events(empty)
    • countries
      • 1Aruba
      • 2Antigua and Barbuda
      • 3United Arab Emirates
      • 4Afghanistan
      • 5Algeria
      • 6Azerbaijan
      • 7Albania
      • 8Armenia
      • 9Andorra
      • 10Angola
      • 11American Samoa
      • 12Argentina
      • 13Australia
      • 14Ashmore and Cartier Islands
      • 15Austria
      • 16Anguilla
      • 17Åland Islands
      • 18Antarctica
      • 19Bahrain
      • 20Barbados
      • 21Botswana
      • 22Bermuda
      • 23Belgium
      • 24Bahamas, The
      • 25Bangladesh
      • 26Belize
      • 27Bosnia and Herzegovina
      • 28Bolivia
      • 29Myanmar
      • 30Benin
      • 31Belarus
      • 32Solomon Islands
      • 33Navassa Island
      • 34Brazil
      • 35Bassas da India
      • 36Bhutan
      • 37Bulgaria
      • 38Bouvet Island
      • 39Brunei
      • 40Burundi
      • 41Canada
      • 42Cambodia
      • 43Chad
      • 44Sri Lanka
      • 45Congo, Republic of the
      • 46Congo, Democratic Republic of the
      • 47China
      • 48Chile
      • 49Cayman Islands
      • 50Cocos (Keeling) Islands
      • 51Cameroon
      • 52Comoros
      • 53Colombia
      • 54Northern Mariana Islands
      • 55Coral Sea Islands
      • 56Costa Rica
      • 57Central African Republic
      • 58Cuba
      • 59Cape Verde
      • 60Cook Islands
      • 61Cyprus
      • 62Denmark
      • 63Djibouti
      • 64Dominica
      • 65Jarvis Island
      • 66Dominican Republic
      • 67Dhekelia Sovereign Base Area
      • 68Ecuador
      • 69Egypt
      • 70Ireland
      • 71Equatorial Guinea
      • 72Estonia
      • 73Eritrea
      • 74El Salvador
      • 75Ethiopia
      • 76Europa Island
      • 77Czech Republic
      • 78French Guiana
      • 79Finland
      • 80Fiji
      • 81Falkland Islands (Islas Malvinas)
      • 82Micronesia, Federated States of
      • 83Faroe Islands
      • 84French Polynesia
      • 85Baker Island
      • 86France
      • 87French Southern and Antarctic Lands
      • 88Gambia, The
      • 89Gabon
      • 90Georgia
      • 91Ghana
      • 92Gibraltar
      • 93Grenada
      • 94Guernsey
      • 95Greenland
      • 96Germany
      • 97Glorioso Islands
      • 98Guadeloupe
      • 99Guam
      • 100Greece
      • 101Guatemala
      • 102Guinea
      • 103Guyana
      • 104Gaza Strip
      • 105Haiti
      • 106Hong Kong
      • 107Heard Island and McDonald Islands
      • 108Honduras
      • 109Howland Island
      • 110Croatia
      • 111Hungary
      • 112Iceland
      • 113Indonesia
      • 114Isle of Man
      • 115India
      • 116British Indian Ocean Territory
      • 117Clipperton Island
      • 118Iran
      • 119Israel
      • 120Italy
      • 121Cote d'Ivoire
      • 122Iraq
      • 123Japan
      • 124Jersey
      • 125Jamaica
      • 126Jan Mayen
      • 127Jordan
      • 128Johnston Atoll
      • 129Juan de Nova Island
      • 130Kenya
      • 131Kyrgyzstan
      • 132Korea, North
      • 133Kingman Reef
      • 134Kiribati
      • 135Korea, South
      • 136Christmas Island
      • 137Kuwait
      • 138Kosovo
      • 139Kazakhstan
      • 140Laos
      • 141Lebanon
      • 142Latvia
      • 143Lithuania
      • 144Liberia
      • 145Slovakia
      • 146Palmyra Atoll
      • 147Liechtenstein
      • 148Lesotho
      • 149Luxembourg
      • 150Libyan Arab
      • 151Madagascar
      • 152Martinique
      • 153Macau
      • 154Moldova, Republic of
      • 155Mayotte
      • 156Mongolia
      • 157Montserrat
      • 158Malawi
      • 159Montenegro
      • 160The Former Yugoslav Republic of Macedonia
      • 161Mali
      • 162Monaco
      • 163Morocco
      • 164Mauritius
      • 165Midway Islands
      • 166Mauritania
      • 167Malta
      • 168Oman
      • 169Maldives
      • 170Mexico
      • 171Malaysia
      • 172Mozambique
      • 173New Caledonia
      • 174Niue
      • 175Norfolk Island
      • 176Niger
      • 177Vanuatu
      • 178Nigeria
      • 179Netherlands
      • 180No Man's Land
      • 181Norway
      • 182Nepal
      • 183Nauru
      • 184Suriname
      • 185Netherlands Antilles
      • 186Nicaragua
      • 187New Zealand
      • 188Paraguay
      • 189Pitcairn Islands
      • 190Peru
      • 191Paracel Islands
      • 192Spratly Islands
      • 193Pakistan
      • 194Poland
      • 195Panama
      • 196Portugal
      • 197Papua New Guinea
      • 198Palau
      • 199Guinea-Bissau
      • 200Qatar
      • 201Reunion
      • 202Serbia
      • 203Marshall Islands
      • 204Saint Martin
      • 205Romania
      • 206Philippines
      • 207Puerto Rico
      • 208Russia
      • 209Rwanda
      • 210Saudi Arabia
      • 211Saint Pierre and Miquelon
      • 212Saint Kitts and Nevis
      • 213Seychelles
      • 214South Africa
      • 215Senegal
      • 216Saint Helena
      • 217Slovenia
      • 218Sierra Leone
      • 219San Marino
      • 220Singapore
      • 221Somalia
      • 222Spain
      • 223Saint Lucia
      • 224Sudan
      • 225Svalbard
      • 226Sweden
      • 227South Georgia and the Islands
      • 228Syrian Arab Republic
      • 229Switzerland
      • 230Trinidad and Tobago
      • 231Tromelin Island
      • 232Thailand
      • 233Tajikistan
      • 234Turks and Caicos Islands
      • 235Tokelau
      • 236Tonga
      • 237Togo
      • 238Sao Tome and Principe
      • 239Tunisia
      • 240East Timor
      • 241Turkey
      • 242Tuvalu
      • 243Taiwan
      • 244Turkmenistan
      • 245Tanzania, United Republic of
      • 246Uganda
      • 247United Kingdom
      • 248Ukraine
      • 249United States
      • 250Burkina Faso
      • 251Uruguay
      • 252Uzbekistan
      • 253Saint Vincent and the Grenadines
      • 254Venezuela
      • 255British Virgin Islands
      • 256Vietnam
      • 257Virgin Islands (US)
      • 258Holy See (Vatican City)
      • 259Namibia
      • 260West Bank
      • 261Wallis and Futuna
      • 262Western Sahara
      • 263Wake Island
      • 264Samoa
      • 265Swaziland
      • 266Serbia and Montenegro
      • 267Yemen
      • 268Zambia
      • 269Zimbabwe
    • regions
      • 2Corfu
      • 3Zante
      • 4The Alps
      • 5Kefalonia
      • 6Parga
      • 7Lefkas
      • 8Kos
      • 9Rhodes
      • 10Lesbos
      • 11Crete
      • 12Athens
      • 13Mykonos
      • 14Skiathos
      • 15Santorini
      • 16Majorca
      • 17Ibiza
      • 18Menorca
      • 19Costa Brava
      • 20Costa Blanca
      • 21Costa del Sol
      • 22Costa Dorada
      • 23Tenerife
      • 24Gran Canaria
      • 25Lanzarote
      • 26Fuerteventura
      • 27Algarve
      • 28Madeira
      • 29Italian Alps
      • 30Brittany
      • 31Belfast
      • 32Birmingham
      • 33Bradford
      • 34Bristol
      • 35Cardiff
      • 36Edinburgh
      • 37Exeter
      • 38Glasgow
      • 39Inverness
      • 40Leeds
      • 41Liverpool
      • 42London
      • 43Manchester
      • 44Middlesborough
      • 45Newcastle
      • 46Sunderland
      • 47Swansea
      • 48Cork
      • 49Dublin
      • 50Kerry
      • 51Shannon
      • 52Cannes
      • 53Dijon
      • 54Lyon
      • 55Marseille
      • 56Monaco
      • 57Nantes
      • 58Nice
      • 59Paris
      • 60Perpigan
      • 61Toulon
      • 62Toulouse
      • 63Berlin
      • 64Bremen
      • 65Cologne
      • 66Dusseldorf
      • 67Frankfurt
      • 68Hamburg
      • 69Munich
      • 70Nuremberg
      • 71Stuttgart
      • 72Graz
      • 73Innsbruck
      • 74Klagenfurt
      • 75Linz
      • 76Salzburg
      • 77Vienna
      • 78Brussels
      • 79Leige
      • 80Plovdiv
      • 81Sofia
      • 82Varna
      • 83Saranda
      • 84Tirana
      • 85Prague
      • 86Copenhagen
      • 87Dubai
      • 88Sharjah
      • 89Tallin
      • 90Helsinki
      • 91Gibraltor
      • 92Amsterdam
      • 93Eindhoven
      • 94Rotterdam
      • 95Budapest
      • 96Reykjavik
      • 97Eilat
      • 98Jerusalem
      • 99Tel Aviv
      • 100Bari
      • 101Bergamo
      • 102Brindisi
      • 103Cagliari
      • 104Catania
      • 105Florence
      • 106Genoa
      • 107Lido de Jeslo
      • 108Milan
      • 109Naples
      • 110Olbia
      • 111Palermo
      • 112Pisa
      • 113Rome
      • 114Trieste
      • 115Venice
      • 116Verona
      • 117Amman
      • 118Astana
      • 119Riga
      • 120Beirut
      • 121Palanga
      • 122Vilnius
      • 123Dubrovnik
      • 124Podgorica
      • 125Tivat
      • 126Bergen
      • 127Oslo
      • 128Trondheim
      • 129Muscat
      • 130Salalah
      • 131Gdansk
      • 132Katowice
      • 133Krakow
      • 134Lodz
      • 135Poznan
      • 136Rzeszow
      • 137Warsaw
      • 138Doha
      • 139Bucharest
      • 140Moscow
      • 141St Petersbirg
      • 142Bratislava
      • 143Gothenburg
      • 144Stockholm
      • 145Basel
      • 146Berne
      • 147Geneva
      • 148Zurich
      • 149Damascus
      • 150Kiev
      • 177Adelaide
      • 178Brisbane
      • 179Canberra
      • 180Perth
      • 181Sydney
      • 182Tasmania
      • 183Auckland
      • 184Christchurch
      • 185Wellington
      • 186Bloomfontein
      • 187Cape Town
      • 188Durban
      • 189Johanesburg
      • 190Port Elizabeth
      • 191Dalaman
      • 192Izmir
      • 193Antalya Area
      • 194Istanbul
      • 195Bodrum Area
      • 196Singapore
      • 197Alabama
      • 198Alaska
      • 199Arizona
      • 200Arkansas
      • 201California
      • 202Colorado
      • 203Connecticut
      • 204Delaware
      • 205Florida
      • 206Georgia
      • 207Hawaii
      • 208Idaho
      • 209Illinois
      • 210Indiana
      • 211Iowa
      • 212Kansas
      • 213Kentucky
      • 214Louisiana
      • 215Maine
      • 216Maryland
      • 217Massachusetts
      • 218Michigan
      • 219Minnesota
      • 220Mississippi
      • 221Missouri
      • 222Montana
      • 223Nebraska
      • 224Nevada
      • 225New Hampshire
      • 226New Jersey
      • 227New Mexico
      • 228New York
      • 229North Dakota
      • 230Ohio
      • 231Oklahoma
      • 232Oregon
      • 233Pennsylvania
      • 234Rhode Island
      • 235South Carolina
      • 236South Dakota
      • 237Tennessee
      • 238Texas
      • 239Utah
      • 240Vermont
      • 241Virginia
      • 242Washington
      • 243West Virginia
      • 244Wisconsin
      • 245Wyoming
      • 246Lisbon
      • 247Caribbean
      • 248Bordeaux
      • 249Lake Maggiore
      • 250Transylvania
      • 251Preveza
      • 252Kalamata
      • 253Dolomites
      • 254Malta
      • 255Gozo
      • 256Tbilisi
      • 257Istria
      • 258Zadar
      • 259Split
      • 260Dubrovnik
      • 261Zagreb
      • 262Morocco
      • 263Cornwall
      • 264Sicily
      • 265Kusadasi
      • 266Didim
      • 267Marmaris Area
      • 268Fethiye Area
      • 269Antigua
      • 270Barbuda
      • 271Cyclades
      • 272Surrey
      • 273Azores
      • 274Andorra
      • 275Livigno
      • 276Goa
    • authUser(empty)
    • emojifier(object)Emoji
    • is_mobile(false)
    • $request->data(empty)
    • $this->validationErrors
      • Session(empty)
      • UserSetting(empty)
      • User(empty)
      • UserGroup(empty)
      • UserActivity(empty)
      • Country(empty)
      • Region(empty)
      • Resort(empty)
      • ResortPicture(empty)
      • UserDetail(empty)
      • UserRight(empty)
      • Place(empty)
      • UserNotification(empty)
      • Review(empty)
      • Event(empty)
      • EventPicture(empty)
      • EventCategory(empty)
      • Article(empty)
      • Offer(empty)
      • PlaceCategory(empty)
      • ParentCategory(empty)
      • CategoryPicture(empty)
      • UserPhoto(empty)
      • UserPhotoAlbum(empty)
      • ArrowchatChatroomRoom(empty)
      • ArrowchatChatroomMessage(empty)
      • ArrowchatChatroomMessageReply(empty)
      • Holiday(empty)
      • UserContact(empty)
    • Loaded Helpers
      • 0Form
      • 1Html
      • 2Session
      • 3Js
      • 4UserAuth
      • 5Image
      • 6Text
      • 7Custom
      • 8Cache
      • 9Number
      • 10SimpleGraph
      • 11DebugTimer
      • 12Toolbar
      • 13HtmlToolbar
    ====
  • Environment
    +

    App Constants

    Constant Value
    APPNAME Hang out on Holiday
    BASEURL_TEMP //hangoutonholiday.com
    CHATBASEURL_TEMP //hangoutonholiday.com/chat
    BASEURL http://hangoutonholiday.com
    APIURL http://hangoutonholiday.com/api
    APICODE 9832114
    CHATBASEURL http://hangoutonholiday.com/chat
    SBASEURL https://hangoutonholiday.com
    DEFAULT_KEYWORDS hang out, holiday, resorts, party
    DEFAULT_DESCRIPTION Hang out on Holiday is designed to be fun, informative and there to help members help each other by sharing tips and information on how to get the best out of your holiday. We aim to bring you up to date news on events in your resort, what's hot and what's not.
    DEFAULT_IMAGE http://hangoutonholiday.com/img/main_photo.jpg
    DEFAULT_SECURED_IMAGE https://hangoutonholiday.com/img/main_photo.jpg
    FB_APPID 222576787815516
    FB_APPSECRET eb4fb91f29e6083707cb8336a90ab45b
    FB_NS hangoutonholiday
    FB_CANVAS_TEMP //apps.facebook.com/hangoutonholiday
    FB_APPURL_TEMP //www.facebook.com/HangOutOnHolidayFB/app_222576787815516
    FB_PAGE https://www.facebook.com/HangOutOnHolidayFB
    PAGEURL //apps.facebook.com/hangoutonholiday/app_222576787815516
    VERSION_1 1
    VERSION_2 2
    PARSE_CHAT_REGEX /\[{2}.*?\]{2}/
    FB_APP_URL http://fb.hangoutonholiday.com
    FB_CANVAS http://apps.facebook.com/hangoutonholiday
    FB_APPURL http://www.facebook.com/HangOutOnHolidayFB/app_222576787815516
    TW_KEY Zwf1IEtkZOmHxzC0VxbIYw
    TW_SECRET LWAY4rNBA8CDlSokjIHcJ4oftbqYFDj47jHKEDN0
    LI_KEY 8dzql0nb7kks
    LI_SECRET QHSB7AtBSEnMJsOK
    FS_ID NKE5LE40HUTQCSGTFZFPSP54MPJ3SDW3TPIT1L2YG55XVYYU
    FS_SECRET PSHVYJQNHOZID5KRZGTPNN55SUMJJNYOFRRSRUWJIRCET2KP
    DISQUS_SECRET_KEY NMcmNqTFig2suEudp6Mvm5wHEVyeDBkaYkL9scSGEpQPYoD6GHKpvFLmiaIIp7wA
    DISQUS_PUBLIC_KEY XV4WMWNIA0puuDx0T1ww1W3SNdAgkaC3bbvLvB57r1KgsXTmCxOlWgDLmFaoNu6Z
    DISQUS_GENERAL 2885309
    DISQUS_RESORTS 2885341
    DISQUS_PLACES 2885347
    DISQUS_EVENTS 2885349
    DISQUS_BLOG 2885351
    DISQUS_NEWS 2885354
    OPEN_WEATHER_KEY 7551b9c13a15e40bd7ec91b9c516e9be
    FIREBASE_API_KEY AAAAMFN4Ft0:APA91bH3a2Ppd6DnWVzwlqEI1CLC95vOAHB3NqOlGa8_DTDcHVadVQP6BYB1-sVe056qFoyHjdlz6-UFzqtWuIu6a84Httr4R8ai3trGAfGLT7opeehC3T5n43JR5H127Lw2spLcAZMUsbNWTfugR6BlcE2pvEatcw
    HOME_ACTIVITIES_COUNTER 10
    ONESIGNAL_APPID e10b09ee-3ce0-4954-84fa-50f5ebbfca1f
    ONESIGNAL_AUTH MDI4YjUxMDktNTRlYy00MTQ4LWE5NjktNWU0YmNlYzRlNGNk
    ONESIGNAL_RESTKEY YTk5ZGRkNmUtNGNhZi00YWFhLWE4OGMtMDlkMGJlOWIwYzFk
    SITE_URL http://agent.hang-out.com/
    USERMGMT_PATH /var/www/vhosts/hangoutonholiday.com/httpdocs/app/Plugin/Admin
    SITE_NAME Hang out on Holiday
    SITE_REGISTRATION 1
    ALLOW_DELETE_ACCOUNT 0
    SEND_REGISTRATION_MAIL 1
    SEND_PASSWORD_CHANGE_MAIL 1
    EMAIL_VERIFICATION 0
    EMAIL_FROM_ADDRESS contact@hangoutonholiday.com
    EMAIL_FROM_NAME Hang out on Holiday Team
    ALLOW_CHANGE_USERNAME 1
    BANNED_USERNAMES Administrator, SuperAdmin
    USE_RECAPTCHA 0
    PRIVATE_KEY_FROM_RECAPTCHA
    PUBLIC_KEY_FROM_RECAPTCHA
    LOGIN_REDIRECT_URL /
    LOGOUT_REDIRECT_URL /
    PERMISSIONS 1
    ADMIN_PERMISSIONS 0
    DEFAULT_GROUP_ID 2
    ADMIN_GROUP_ID 1
    GUEST_GROUP_ID 3
    USE_FB_LOGIN 1
    FB_APP_ID 222576787815516
    FB_SECRET eb4fb91f29e6083707cb8336a90ab45b
    FB_SCOPE email
    USE_TWT_LOGIN 1
    TWT_APP_ID Zwf1IEtkZOmHxzC0VxbIYw
    TWT_SECRET LWAY4rNBA8CDlSokjIHcJ4oftbqYFDj47jHKEDN0
    USE_GMAIL_LOGIN 1
    GMAIL_API_KEY AIzaSyBbIxsytOSvQqs04-FNNjhtctwueG01SiA
    GMAIL_CLIENT_ID 492566004772-6celudpqtgoc1fcg7lapvc30po8aagt0.apps.googleusercontent.com
    GMAIL_CLIENT_SECRET A2nW-p3d_mkma-FPMJYyS7Ji
    USE_YAHOO_LOGIN 1
    USE_LDN_LOGIN 1
    LDN_API_KEY 8dzql0nb7kks
    LDN_SECRET_KEY QHSB7AtBSEnMJsOK
    USE_FS_LOGIN 1
    FS_CLIENT_ID HLURXAQV44E34PPPPS0P2GPXST1S0GRMHG5LVQ0VJKRZH5MH
    FS_CLIENT_SECRET QQ0VAXGWO2BC5HNGTTG4FCTJPES1WLNWAIROX4PQADIUFG4C
    VIEW_ONLINE_USER_TIME 60
    USE_HTTPS 1
    HTTPS_URLS
    IMG_DIR profiles
    QRDN 12345678
    LOGIN_COOKIE_NAME HOOH
    DEFAULT_IMAGE_PATH /var/www/vhosts/hangoutonholiday.com/httpdocs/app/Plugin/Admin/webroot/img/default.jpg
    DEFAULT_IMAGE_URL http://agent.hang-out.com/admin/img/default.jpg
    ADMIN_EMAIL_ADDRESS dani@behappydigital.com
    USE_RECAPTCHA_ON_LOGIN 1
    BAD_LOGIN_ALLOW_COUNT 5
    USE_RECAPTCHA_ON_REGISTRATION 1
    USE_RECAPTCHA_ON_FORGOT_PASSWORD 1
    USE_RECAPTCHA_ON_EMAIL_VERIFICATION 1
    USE_REMEMBER_ME 1
    ALLOW_USER_MULTIPLE_LOGIN 1
    ALLOW_ADMIN_MULTIPLE_LOGIN 1
    LOGIN_IDLE_TIME 44640
    ELFINDER_DIR /var/www/vhosts/hangoutonholiday.com/httpdocs/app/webroot/files
    ELFINDER_URL http://hangoutonholiday.com/files

    CakePHP Constants

    Constant Value
    APP /var/www/vhosts/hangoutonholiday.com/httpdocs/app/
    APP_DIR app
    APPLIBS /var/www/vhosts/hangoutonholiday.com/httpdocs/app/Lib/
    CACHE /var/www/vhosts/hangoutonholiday.com/httpdocs/app/tmp/cache/
    CAKE /var/www/vhosts/hangoutonholiday.com/httpdocs/lib/Cake/
    CAKE_CORE_INCLUDE_PATH /var/www/vhosts/hangoutonholiday.com/httpdocs/lib
    CORE_PATH /var/www/vhosts/hangoutonholiday.com/httpdocs/lib/
    CAKE_VERSION 2.6.13
    CSS /var/www/vhosts/hangoutonholiday.com/httpdocs/app/webroot/css/
    CSS_URL css/
    DS /
    FULL_BASE_URL http://agent.hang-out.com
    IMAGES /var/www/vhosts/hangoutonholiday.com/httpdocs/app/webroot/img/
    IMAGES_URL img/
    JS /var/www/vhosts/hangoutonholiday.com/httpdocs/app/webroot/js/
    JS_URL js/
    LOGS /var/www/vhosts/hangoutonholiday.com/httpdocs/app/tmp/logs/
    ROOT /var/www/vhosts/hangoutonholiday.com/httpdocs
    TESTS /var/www/vhosts/hangoutonholiday.com/httpdocs/app/Test/
    TMP /var/www/vhosts/hangoutonholiday.com/httpdocs/app/tmp/
    VENDORS /var/www/vhosts/hangoutonholiday.com/httpdocs/vendors/
    WEBROOT_DIR webroot
    WWW_ROOT /var/www/vhosts/hangoutonholiday.com/httpdocs/app/webroot/

    PHP Environment

    Environment Variable Value
    Php Version 5.4.45
    Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
    Pp Custom Php Ini /var/www/vhosts/system/hangoutonholiday.com/etc/php.ini
    Pp Custom Php Cgi Index plesk-php54-fastcgi
    Script Name /app/webroot/index.php
    Request Uri /resort/Andorra/RestOfAndorra/soldeu--el-tarter
    Query String
    Request Method GET
    Server Protocol HTTP/1.0
    Gateway Interface CGI/1.1
    Redirect Url /app/webroot/resort/Andorra/RestOfAndorra/soldeu--el-tarter
    Remote Port 47814
    Script Filename /var/www/vhosts/hangoutonholiday.com/httpdocs/app/webroot/index.php
    Server Admin oliver@itsyourcloud.uk
    Context Document Root /var/www/vhosts/hangoutonholiday.com/httpdocs
    Context Prefix
    Request Scheme http
    Document Root /var/www/vhosts/hangoutonholiday.com/httpdocs
    Remote Addr 54.162.121.80
    Server Port 80
    Server Addr 178.62.30.208
    Server Name agent.hang-out.com
    Server Software Apache
    Server Signature
    Apache Server at agent.hang-out.com Port 80
    Http If Modified Since Tue, 23 Jan 2018 03:48:18 GMT
    Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Http User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
    Http Accept Encoding x-gzip, gzip, deflate
    Http Connection close
    Http X Accel Internal /internal-nginx-static-location
    Http X Real Ip 54.162.121.80
    Http Host agent.hang-out.com
    Redirect Status 200
    Redirect Redirect Status 200
    Fcgi Role RESPONDER
    Php Self /app/webroot/index.php
    Request Time Float 1524722767.28
    Request Time 1524722767
    ====
  • Include
    +

    Included Files

    Include Paths

    • 0/var/www/vhosts/hangoutonholiday.com/httpdocs/lib
    • 2/opt/plesk/php/5.4/share/pear
    • 3-> /var/www/vhosts/hangoutonholiday.com/httpdocs/lib/Cake/

    Included Files

    • core
      • Behavior
        • 0CORE/Model/Behavior/ContainableBehavior.php
        • 1CORE/Model/Behavior/TreeBehavior.php
      • Cache
        • 0CORE/Cache/Cache.php
        • 1CORE/Cache/Engine/FileEngine.php
        • 2CORE/Cache/CacheEngine.php
      • Component
        • 0CORE/Controller/Component/SessionComponent.php
        • 1CORE/Controller/Component/RequestHandlerComponent.php
        • 2CORE/Controller/Component/SecurityComponent.php
        • 3CORE/Controller/Component/CookieComponent.php
      • Config
        • 0CORE/Config/routes.php
        • 1CORE/Config/config.php
      • Controller
        • 0CORE/Controller/Controller.php
        • 1CORE/Controller/ComponentCollection.php
        • 2CORE/Controller/Component.php
      • Datasource
        • 0CORE/Model/Datasource/CakeSession.php
        • 1CORE/Model/Datasource/Session/DatabaseSession.php
        • 2CORE/Model/Datasource/Session/CakeSessionHandlerInterface.php
        • 3CORE/Model/Datasource/Database/Mysql.php
        • 4CORE/Model/Datasource/DboSource.php
        • 5CORE/Model/Datasource/DataSource.php
      • Error
        • 0CORE/Error/exceptions.php
        • 1CORE/Error/ErrorHandler.php
      • I18n
        • 0CORE/I18n/I18n.php
        • 1CORE/I18n/L10n.php
      • Log
        • 0CORE/Log/CakeLog.php
        • 1CORE/Log/LogEngineCollection.php
        • 2CORE/Log/Engine/FileLog.php
        • 3CORE/Log/Engine/BaseLog.php
        • 4CORE/Log/CakeLogInterface.php
      • Model
        • 0CORE/Model/Model.php
        • 1CORE/Model/BehaviorCollection.php
        • 2CORE/Model/ConnectionManager.php
        • 3CORE/Model/ModelBehavior.php
      • Network
        • 0CORE/Network/CakeRequest.php
        • 1CORE/Network/CakeResponse.php
      • Other
        • 0CORE/bootstrap.php
        • 1CORE/basics.php
        • 2CORE/Core/App.php
        • 3CORE/Core/Configure.php
        • 4CORE/Core/CakePlugin.php
        • 5CORE/Event/CakeEventListener.php
        • 6CORE/Event/CakeEvent.php
        • 7CORE/Event/CakeEventManager.php
        • 8CORE/Core/Object.php
      • Routing
        • 0CORE/Routing/Dispatcher.php
        • 1CORE/Routing/Filter/AssetDispatcher.php
        • 2CORE/Routing/DispatcherFilter.php
        • 3CORE/Routing/Filter/CacheDispatcher.php
        • 4CORE/Routing/Router.php
        • 5CORE/Routing/Route/CakeRoute.php
        • 6CORE/Routing/Route/PluginShortRoute.php
      • Utility
        • 0CORE/Utility/Hash.php
        • 1CORE/Utility/Inflector.php
        • 2CORE/Utility/ObjectCollection.php
        • 3CORE/Utility/Debugger.php
        • 4CORE/Utility/String.php
        • 5CORE/Utility/ClassRegistry.php
        • 6CORE/Utility/Security.php
      • View
        • 0CORE/View/HelperCollection.php
    • app
      • Component
        • 0APP/Controller/Component/ImageCacheComponent.php
      • Config
        • 0APP/Config/core.php
        • 1APP/Config/bootstrap.php
        • 2APP/Config/routes.php
        • 3APP/Config/database.php
      • Controller
        • 0APP/Controller/PagesController.php
        • 1APP/Controller/AppController.php
        • 2APP/Controller/AjaxController.php
        • 3APP/Controller/ApiController.php
        • 4APP/Controller/MaintenanceController.php
        • 5APP/Controller/PaymentsController.php
        • 6APP/Controller/WebserviceController.php
        • 7APP/Controller/WidgetController.php
      • Model
        • 0APP/Model/AppModel.php
        • 1APP/Model/ArrowchatChatroomMessageReply.php
      • Other
        • 0APP/webroot/index.php
        • 1APP/Vendor/Emoji.php
        • 2APP/Vendor/Mobile_Detect.php
        • 3APP/Lib/Elfinder/elFinderConnector.class.php
        • 4APP/Lib/Elfinder/elFinder.class.php
        • 5APP/Lib/Elfinder/elFinderVolumeDriver.class.php
        • 6APP/Lib/Elfinder/elFinderVolumeLocalFileSystem.class.php
    • plugins
      • Admin
        • Config
          • 0Admin/Config/bootstrap.php
          • 1Admin/Config/routes.php
        • Plugin
          • 0Admin/Lib/routes/SlugRoute.php
        • Component
          • 0Admin/Controller/Component/UserAuthComponent.php
          • 1Admin/Controller/Component/ImageToolComponent.php
          • 2Admin/Controller/Component/ImageHelperComponent.php
          • 3Admin/Controller/Component/ControllerListComponent.php
        • Model
          • 0Admin/Model/UserSetting.php
          • 1Admin/Model/AdminAppModel.php
          • 2Admin/Model/User.php
          • 3Admin/Model/UserGroup.php
          • 4Admin/Model/UserActivity.php
          • 5Admin/Model/Country.php
          • 6Admin/Model/Region.php
          • 7Admin/Model/Resort.php
          • 8Admin/Model/UserDetail.php
          • 9Admin/Model/Place.php
          • 10Admin/Model/Event.php
          • 11Admin/Model/PlaceCategory.php
          • 12Admin/Model/UserPhoto.php
          • 13Admin/Model/ArrowchatChatroomRoom.php
          • 14Admin/Model/ArrowchatChatroomMessage.php
        • Controller
          • 0Admin/Controller/AdminAppController.php
          • 1Admin/Controller/AbusesController.php
          • 2Admin/Controller/AdminsController.php
          • 3Admin/Controller/AgentsController.php
          • 4Admin/Controller/ArticlePicturesController.php
          • 5Admin/Controller/ArticlesController.php
          • 6Admin/Controller/AutocompleteController.php
          • 7Admin/Controller/BackgroundPicturesController.php
          • 8Admin/Controller/BlogCategoriesController.php
          • 9Admin/Controller/BlogPicturesController.php
          • 10Admin/Controller/BlogsController.php
          • 11Admin/Controller/CategoryPicturesController.php
          • 12Admin/Controller/ContentsController.php
          • 13Admin/Controller/CountriesController.php
          • 14Admin/Controller/DropzoneController.php
          • 15Admin/Controller/EventCategoriesController.php
          • 16Admin/Controller/EventPicturesController.php
          • 17Admin/Controller/EventsController.php
          • 18Admin/Controller/ExcursionCategoriesController.php
          • 19Admin/Controller/ExcursionsController.php
          • 20Admin/Controller/FeaturedStoriesController.php
          • 21Admin/Controller/FilesController.php
          • 22Admin/Controller/HangoutsController.php
          • 23Admin/Controller/HolidaysController.php
          • 24Admin/Controller/HomepageSlidersController.php
          • 25Admin/Controller/MessagesController.php
          • 26Admin/Controller/NotificationsController.php
          • 27Admin/Controller/OfferPicturesController.php
          • 28Admin/Controller/OffersController.php
          • 29Admin/Controller/PartiesController.php
          • 30Admin/Controller/PaypalController.php
          • 31Admin/Controller/PlaceCategoriesController.php
          • 32Admin/Controller/PlacePicturesController.php
          • 33Admin/Controller/PlacesController.php
          • 34Admin/Controller/RadiosController.php
          • 35Admin/Controller/RegionsController.php
          • 36Admin/Controller/ResortPicturesController.php
          • 37Admin/Controller/ResortsController.php
          • 38Admin/Controller/ReviewsController.php
          • 39Admin/Controller/StaticBannersController.php
          • 40Admin/Controller/TabsController.php
          • 41Admin/Controller/UserContactsController.php
          • 42Admin/Controller/UserEmailSignaturesController.php
          • 43Admin/Controller/UserEmailTemplatesController.php
          • 44Admin/Controller/UserEmailsController.php
          • 45Admin/Controller/UserGroupPermissionsController.php
          • 46Admin/Controller/UserGroupsController.php
          • 47Admin/Controller/UserSettingsController.php
          • 48Admin/Controller/UserStoriesController.php
          • 49Admin/Controller/UsersController.php
          • 50Admin/Controller/VendorsController.php
          • 51Admin/Controller/VouchersController.php
      • DebugKit
        • Component
          • 0DebugKit/Controller/Component/ToolbarComponent.php
        • Plugin
          • 0DebugKit/Lib/DebugMemory.php
          • 1DebugKit/Lib/Panel/HistoryPanel.php
          • 2DebugKit/Lib/DebugPanel.php
          • 3DebugKit/Lib/Panel/SessionPanel.php
          • 4DebugKit/Lib/Panel/RequestPanel.php
          • 5DebugKit/Lib/Panel/SqlLogPanel.php
          • 6DebugKit/Lib/Panel/TimerPanel.php
          • 7DebugKit/Lib/Panel/LogPanel.php
          • 8DebugKit/Lib/Log/Engine/DebugKitLog.php
          • 9DebugKit/Lib/Panel/VariablesPanel.php
          • 10DebugKit/Lib/Panel/EnvironmentPanel.php
          • 11DebugKit/Lib/Panel/IncludePanel.php
          • 12DebugKit/Lib/DebugTimer.php
        • Controller
          • 0DebugKit/Controller/DebugKitAppController.php
          • 1DebugKit/Controller/ToolbarAccessController.php
      • Mpdf
        • Component
          • 0Mpdf/Controller/Component/MpdfComponent.php
    ====