|
Отели » St. Kitts Marriott Resort & The Royal Beach Casino
|
|
- user warning: Got error 28 from storage engine
query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 27880 ORDER BY v.weight, t.weight, t.name in /home/u4183/domains/rsbtravel.com/modules/taxonomy/taxonomy.module on line 633.
- user warning: Got error 28 from storage engine
query: SELECT COUNT(*) FROM (SELECT node.nid AS nid,
node.uid AS node_uid,
node.type AS node_type,
node_revisions.format AS node_revisions_format,
node.title AS node_title,
node_data_field_action_finish_date.field_action_dates_value AS node_data_field_action_finish_date_field_action_dates_value,
node_data_field_action_finish_date.field_action_dates_value2 AS node_data_field_action_finish_date_field_action_dates_value2,
node.vid AS node_vid,
node_revisions.body AS node_revisions_body
FROM node node
LEFT JOIN content_type_action node_data_field_action_finish_date ON node.vid = node_data_field_action_finish_date.vid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE ((node.type in ('action')) AND (node_data_field_action_finish_date.field_action_hotel_nid = 27879 ))
AND (DATE_FORMAT(node_data_field_action_finish_date.field_action_finish_date_value, '%Y-%m-%d') >= '2026-05-15')
) count_alias in /home/u4183/domains/rsbtravel.com/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
- user warning: Got error 28 from storage engine
query: SELECT COUNT(*) FROM (SELECT node_data_field_article_image.field_article_image_fid AS node_data_field_article_image_field_article_image_fid,
node_data_field_article_image.field_article_image_list AS node_data_field_article_image_field_article_image_list,
node_data_field_article_image.field_article_image_data AS node_data_field_article_image_field_article_image_data,
node.type AS node_type,
node.nid AS nid,
node.vid AS node_vid,
node.title AS node_title,
node.language AS node_language,
node_data_field_article_image.field_article_teaser_value AS node_data_field_article_image_field_article_teaser_value
FROM node node
LEFT JOIN content_field_article_hotels node_data_field_article_hotels ON node.vid = node_data_field_article_hotels.vid
INNER JOIN node node_node_data_field_article_hotels ON node_data_field_article_hotels.field_article_hotels_nid = node_node_data_field_article_hotels.nid
LEFT JOIN content_type_article node_data_field_article_image ON node.vid = node_data_field_article_image.vid
WHERE (node.type in ('article')) AND (node.status = 1) AND (node_node_data_field_article_hotels.nid = 27879 )
) count_alias in /home/u4183/domains/rsbtravel.com/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
- user warning: Got error 28 from storage engine
query: SELECT COUNT(*) FROM (SELECT node_data_field_gpro_image.field_gpro_image_fid AS node_data_field_gpro_image_field_gpro_image_fid,
node_data_field_gpro_image.field_gpro_image_list AS node_data_field_gpro_image_field_gpro_image_list,
node_data_field_gpro_image.field_gpro_image_data AS node_data_field_gpro_image_field_gpro_image_data,
node.type AS node_type,
node.nid AS nid,
node.vid AS node_vid,
node.title AS node_title,
node.language AS node_language,
node_data_field_pro_teaser.field_pro_teaser_value AS node_data_field_pro_teaser_field_pro_teaser_value
FROM node node
LEFT JOIN content_field_pro_hotel node_data_field_pro_hotel ON node.vid = node_data_field_pro_hotel.vid
LEFT JOIN node node_node_data_field_pro_hotel ON node_data_field_pro_hotel.field_pro_hotel_nid = node_node_data_field_pro_hotel.nid
LEFT JOIN content_type_group_program node_data_field_gpro_image ON node.vid = node_data_field_gpro_image.vid
LEFT JOIN content_type_program node_data_field_pro_teaser ON node.vid = node_data_field_pro_teaser.vid
WHERE (node.type in ('program')) AND (node.status = 1) AND (node_node_data_field_pro_hotel.nid = 27879 )
) count_alias in /home/u4183/domains/rsbtravel.com/sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.
- user warning: Got error 28 from storage engine
query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'rsbtravel' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /home/u4183/domains/rsbtravel.com/modules/block/block.module on line 433.
St. Kitts Marriott Resort & The Royal Beach Casino
Marriott Hotels & Resorts
Официальный сайт
858 Frigate Bay Road
Frigate Bay, St. Kitts,
West Indies
Tel.: +1-866-847-1139
Check in: 16:00
Check out: 12:00
|
|
|
Прекрасный отель в бухте Фригейт-Бей с просторными номерами и живописными видами. На территории курорта есть поле для гольфа, казино и спа-центр с полным спектром услуг, 3 бассейна и 8 ресторанов.
Большой оборудованный пляж с удобным входом в воду.
Отель подходит как для отдыха, так и для проведения всевозможных мероприятий.
|
|
|
|
|
|
