RESULTSET |
query |
|
ARTICLEAUTHOR |
ARTICLECATNAME |
ARTICLEDATE |
ARTICLEDATE2 |
ARTICLEID |
ARTICLEPLACEMENT |
ARTICLETEXT |
ARTICLETITLE |
ARTICLEUPDATED |
ARTICLEURL |
ARTICLE_SECTION |
ARTICLE_TAG |
CATREF |
ENABLEAUTHOR |
ENABLEDESCRIPTION |
ENABLEDOCUMENTSTAB |
ENABLELINKSTAB |
ENABLELOCATIONTAB |
ENABLEPHOTOSTAB |
ENABLESEOTAB |
ENABLESTARTENDDATES |
ENABLETAGSTAB |
ENABLEWEBSITE |
ENABLEYOUTUBETAB |
EXTDATA01 |
EXTDATA02 |
EXTDATA03 |
EXTDATA04 |
EXTDATA05 |
EXTDATA06 |
EXTDATA07 |
EXTDATA08 |
EXTDATA09 |
EXTDATA10 |
EXTDATA11 |
EXTDATA12 |
EXTLABEL01 |
EXTLABEL02 |
EXTLABEL03 |
EXTLABEL04 |
EXTLABEL05 |
EXTLABEL06 |
EXTLABEL07 |
EXTLABEL08 |
EXTLABEL09 |
EXTLABEL10 |
EXTLABEL11 |
EXTLABEL12 |
FB_ADMINS |
INTERLINKINGSETS |
ISAPPROVED |
ISARCHIVED |
KEYWORDS |
LATITUDE |
LINKTITLEP |
LINKTITLES |
LOCADDRESS1 |
LOCADDRESS2 |
LOCCITY |
LOCSTATEREF |
LOCZIP |
LONGITUDE |
METADESCRIPTION |
MYCHANGEFREQ |
MYDESCRIPTION |
MYPAGETITLE |
MYPRIORITY |
OG_DESC |
OG_IMAGE |
OG_TITLE |
OG_TYPE |
OG_URL |
ONFRONTPAGE |
PIC1 |
PICALL |
POSTEDDATE |
POSTSTATUSCOLOR |
POSTSTATUSNAME |
POSTSTATUSREF |
PRIMARY_TAGREG |
SCHEMA_DESC |
SCHEMA_IMAGE |
SCHEMA_NAME |
SEODIR |
SEOHANDCRAFTEDURL |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TAGNAME |
TAGURL |
TWITTER_CARD |
TWITTER_DESC |
TWITTER_IMAGE |
TWITTER_IMAGE_ALT |
TWITTER_SITE |
TWITTER_TITLE |
USERFIRSTNAME |
USERLASTNAME |
1 |
Holly Buisson |
News |
2022-05-24 00:00:00.0 |
2022-05-24 00:00:00.0 |
273 |
[empty string] |
<p>The CRN 142, a bespoke yacht to be delivered as M/Y CIAO, was launched May 21, 2022 at the Ferretti Group Superyacht Yard in Ancona, Italy. This new work of art in true <a title="CRN Page" href="../../../../new-yachts-for-sale/crn-yachts-for-sale">CRN</a> style entered the water for the first time in an exciting private ceremony attended by the owner, the senior management, and the employees with their families.<br /><br />Made entirely of aluminium, M/Y CIAO was designed and built by CRN in close collaboration with architecture and design studio Omega Architects, who conceived the external lines, and architects Massari Design, who created the outdoor guest areas and interiors.<br /><br />Measuring in at 52 meters in length, 9 meters in the beam and with a gross tonnage of 499, this new true custom yacht spans 4 decks. She accommodates up to 10 guests in the comfort of the main-deck owner suite and the 4 VIP cabins below.<br /><br />CRN M/Y CIAO is a tailor-made creation with a strong artisanal stamp. Her distinctive taut, svelte exterior lines and near-vertical bow exude a decidedly sporty, dynamic personality. The expanse of full-height tinted glazing on the main and upper decks blends into a visual continuum, offering uninterrupted sea views in the utmost on-board privacy. Even the wheelhouse has 3 generous windows that set off the external lines in an unbroken spatial and visual whole.<br /><br />The yacht reflects the vision of a knowledgeable owner who specifically wanted comfortable spaces in the open air, setting great store by the design of the social zones. The result is a pleasure vessel with a sublime harmony and a strong connection among the large, luminous indoor and outdoor spaces, for a perceptual and functional unity between inside and out.<br /><br />A wealth of features will enable the owner and guests to enjoy a peerless shared cruising experience. The sizeable al fresco dining area on the upper deck, the comfortable, versatile lounge areas with sun zone and spa pool on the sun deck and main deck, and the bright, roomy saloons on the main and upper decks are all smoothly designed with conviviality in mind.<br /><br />CRN M/Y CIAO is a masterpiece of nautical art that marries the finest Italian craftsmanship and savoir-faire with unrivalled in-depth design and build quality and know-how.</p> |
CRN Launches 142' Bespoke Yacht M/Y CIAO |
2022-06-22 10:37:10.0 |
|
[empty string] |
superyacht |
1 |
1 |
1 |
1 |
0 |
0 |
1 |
1 |
0 |
1 |
0 |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Omit Sidebar |
Omit Gallery |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0.000000 |
Links/Quotes |
Link/Quote |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0.000000 |
[empty string] |
weekly |
A new work of art in true CRN style. |
CRN Launches 142 Bespoke Yacht MY CIAO |
1.0 |
A new work of art in true CRN style. |
[empty string] |
CRN Launches 142 Bespoke Yacht MY CIAO |
website |
https://www.alliedmarine.com |
[empty string] |
crn-my-ciao.jpg |
crn-my-ciao.jpg |
2022-05-23 10:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
A new work of art in true CRN style. |
[empty string] |
CRN Launches 142 Bespoke Yacht MY CIAO |
yachting-news |
crn-launches-142-bespoke-yacht-my-ciao |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/crn-launches-142-bespoke-yacht-my-ciao |
0 |
[empty string] |
[empty string] |
[empty string] |
A new work of art in true CRN style. |
[empty string] |
[empty string] |
[empty string] |
CRN Launches 142 Bespoke Yacht MY CIAO |
[empty string] |
[empty string] |
|
SQL |
SELECT
articles.articleID,
articles.catREF,
articles.staffREF,
articles.postStatusREF,
articles.articleTitle,
articles.seoHandCraftedURL,
articles.articleAuthor,
articles.articleURL,
articles.seoURL,
articles.articleDate,
articles.articleDate2,
articles.postedDate,
articles.articleUpdated,
articles.latitude,
articles.longitude,
articles.articleText,
articles.isArchived,
articles.metaDescription,
articles.seoPreviewText,
articles.primary_tagREG,
articles.myPageTitle,
articles.myDescription,
articles.fb_admins,
articles.og_title,
articles.og_type,
articles.og_image,
articles.og_url,
articles.og_desc,
articles.twitter_card,
articles.twitter_site,
articles.twitter_title,
articles.twitter_desc,
articles.twitter_image,
articles.twitter_image_alt,
articles.article_section,
articles.article_tag,
articles.myChangeFreq,
articles.myPriority,
articles.schema_name,
articles.schema_desc,
articles.schema_image,
articles.seoPageTitle,
articles.keywords,
articles.isApproved,
articles.articlePlacement,
articles.onFrontPage,
articles.locAddress1,
articles.locAddress2,
articles.locCity,
articles.locStateREF,
articles.locZip,
articles.extData01,
articles.extData02,
articles.extData03,
articles.extData04,
articles.extData05,
articles.extData06,
articles.extData07,
articles.extData08,
articles.extData09,
articles.extData10,
articles.extData11,
articles.extData12,
articles.pic1,
articles.picAll,
articles.interlinkingSets,
articleCats.articleCatName,
articleCats.extLabel01,
articleCats.extLabel02,
articleCats.extLabel03,
articleCats.extLabel04,
articleCats.extLabel05,
articleCats.extLabel06,
articleCats.extLabel07,
articleCats.extLabel08,
articleCats.extLabel09,
articleCats.extLabel10,
articleCats.extLabel11,
articleCats.extLabel12,
articleCats.enableStartEndDates,
articleCats.enableLocationTab,
articleCats.enableLinksTab,
articleCats.linkTitleS,
articleCats.linkTitleP,
articleCats.enablePhotosTab,
articleCats.enableDocumentsTab,
articleCats.enableYouTubeTab,
articleCats.enableTagsTab,
articleCats.enableSeoTab,
articleCats.enableAuthor,
articleCats.enableDescription,
articleCats.enableWebsite,
articleCats.seoDir,
article_status.postStatusName,
article_status.postStatusColor,
article_tag.tagName,
article_tag.tagURL,
users.userLastName,
users.userFirstName
FROM
articles
LEFT JOIN articleCats ON articles.catREF = articleCats.articleCatID
LEFT JOIN article_status ON articles.postStatusREF = article_status.postStatusID
LEFT JOIN article_tag ON articles.primary_tagREG = article_tag.tagID
LEFT JOIN users ON articles.staffREF = users.userID
WHERE seoHandCraftedURL = 'crn-launches-142-bespoke-yacht-my-ciao'
ORDER BY postedDate desc |