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 |
2021-10-06 00:00:00.0 |
2021-10-06 00:00:00.0 |
233 |
[empty string] |
<p>Presented at the 2021 Cannes Yachting Festival, Riva's new open yacht with built-in hard top is a blend of elegance, sportiness and livability.</p>
<p>A sleek profile and stylish details infuse this trendsetting yacht with a fashion-driven spirit. Riva 68’ Diable sets the bar as the must-have open yacht, an incredible boat that tempts and beguiles, asking “what is it that you truly desire?”</p>
<figure class="image"><img src="../../../../photos/articles/riva68diablenewcruising-0013-52809.jpg" alt="Image 0551: " width="1000" height="667" />
<figcaption><em>The bright, airy, and open deck of the Riva 68' Diable</em></figcaption>
</figure>
<p> </p>
<p>At 20.67m in length (almost 68 feet) and with a beam of 5.29m (over 17 feet), Riva 68’ Diable made her debut at the Cannes Yachting Festival and is now set like the purest of diamonds in the range of open yachts under 70 feet, a segment in which the storied Sarnico-based shipyard has long been a recognised leader.</p>
<p>The brainchild of Mauro Micheli, founder with Sergio Beretta of Officina Italiana Design, the firm that has designed all Riva’s yachts for the last 27 years, working in partnership with the Product Strategy Committee led by Mr. Piero Ferrari and the Ferretti Group Engineering Department, Riva 68’ Diable represents a spectacular layering of ingenuity, styles and techniques.</p>
<figure class="image"><img src="../../../../photos/articles/riva68diablenewstandard-0000-52787.jpg" alt="Image 0553: " width="1000" height="667" />
<figcaption><em>Spacious lounging area below deck on the Riva 68' Diable</em></figcaption>
</figure>
<p> </p>
<p>The project is a virtuoso combination of innovative technology and design on the one hand, and of passion for tradition and attention to detail on the other: the unique secret formula behind every Riva success story.</p>
<p>The 68’ Diable is available in all Riva range colors.</p>
<figure class="image"><img src="../../../../photos/articles/riva68diablenewstandard-0002-52789.jpg" alt="Image 0554: " width="1000" height="658" />
<figcaption><em>Master stateroom aboard the Riva 68' Diable</em></figcaption>
</figure>
<p> </p>
<p> </p> |
New Riva 68' Diable - The Devil Is In The Details |
2021-10-06 18:04:51.0 |
|
[empty string] |
[empty string] |
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 |
Riva's new open yacht with built-in hard top is a blend of elegance, sportiness, and livability. |
New Riva 68' Diablo The Devil Is In The Details |
1.0 |
Riva's new open yacht with built-in hard top is a blend of elegance, sportiness, and livability. |
[empty string] |
New Riva 68' Diablo The Devil Is In The Details |
website |
https://www.alliedmarine.com |
[empty string] |
riva68diablenewcruising-0006-52802.jpg |
riva68diablenewcruising-0006-52802.jpg,riva68diablenewcruising-0013-52809.jpg,riva68diablenewstandard-0000-52787.jpg,riva68diablenewstandard-0002-52789.jpg |
2021-10-06 10:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Riva's new open yacht with built-in hard top is a blend of elegance, sportiness, and livability. |
[empty string] |
New Riva 68' Diablo The Devil Is In The Details |
yachting-news |
new-riva-68-diablo-the-devil-is-in-the-details |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/new-riva-68-diablo-the-devil-is-in-the-details |
0 |
[empty string] |
[empty string] |
[empty string] |
Riva's new open yacht with built-in hard top is a blend of elegance, sportiness, and livability. |
[empty string] |
[empty string] |
[empty string] |
New Riva 68' Diablo The Devil Is In The Details |
[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 = 'new-riva-68-diablo-the-devil-is-in-the-details'
ORDER BY postedDate desc |