| 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 |
Allan Leshchinsky |
News |
2019-09-30 00:00:00.0 |
2019-09-30 00:00:00.0 |
74 |
[empty string] |
<p>Riva, the legendary historical Italian shipyard has given us another new model. The <a href="../../../../new-yachts-for-sale/Riva-yachts/Riva-Dolceriva">Riva Dolceriva</a> was debuted at the <a href="../../../../yachting-news/cannes-yachting-festival-2019">2019 Cannes Yachting Festival</a>. She was designed by Officina Italiana Design, which is led by Mauro Micheli and Sergio Beretta, in collaboration with Ferretti Group’s engineering team. Officina Italiana Design has been responsible for designing the entire Riva fleet for the last quarter decade. The brand new Riva Dolceriva yacht for sale is an open yacht that lends from the brand's distinct design while adding in original touches.</p>
<p>Her interior details include:</p>
<p><strong>Salon:</strong></p>
<p><img class="img-fluid" src="../../../../photos/articles/riva-dolceriva-salon-details-yacht-for-sale.jpg" alt="Riva Dolceriva Salon Details - Yacht for Sale" width="1236" height="857" /></p>
<ul>
<li>Soft touch lacquering blue fenix</li>
<li>Mirrow Fume'</li>
<li>Wood sand oak</li>
<li>Dark lacquering blue majestic</li>
</ul>
<p><img class="img-fluid" title="Riva Dolceriva Salon Decor - Yacht for Sale" src="../../../../photos/articles/riva-dolceriva-salon-decor-yacht-for-sale.jpg" alt="Riva Dolceriva Salon Decor - Yacht for Sale" width="1236" height="857" /></p>
<ul>
<li>Soft leather cover mattone C12</li>
<li>Venetina blinds blue 5004 RAL</li>
<li>Sole leather cover blue majestic</li>
<li>Galleytop, sink, floor - Corian cameo white</li>
</ul>
<p><img class="img-fluid" title="Riva Dolceriva Salon Upholstery - Yacht for Sale" src="../../../../photos/articles/riva-dolceriva-salon-upholstery-yacht-for-sale.jpg" alt="Riva Dolceriva Salon Upholstery - Yacht for Sale" width="1236" height="857" /></p>
<ul>
<li>Soft and pouf leather - Penelopeoggi art, Dollaro Col 9010</li>
<li>2 decorative cushions 45x45 - Loro Piana Taragarh A3040RS Col 8 Dark Indigo</li>
<li>Carpeteros Col Neve 1404</li>
<li>Celling Italvipla Troical Col 6010</li>
</ul>
<p><strong>Cabin:</strong></p>
<p><img class="img-fluid" title="Riva Dolceriva Cabin Decor - Yacht for Sale" src="../../../../photos/articles/riva-dolceriva-cabin-decor-yacht-for-sale.jpg" alt="Riva Dolceriva Cabin Decor - Yacht for Sale" width="1236" height="857" /></p>
<ul>
<li>Soft touch lacquering blue fenix</li>
<li>Mirrow Fume'</li>
<li>Wood Sand Oak</li>
<li>Dark lacquering blue majesty</li>
</ul>
<p><img class="img-fluid" title="Riva Dolceriva Cabin Details- Yacht for Sale" src="../../../../photos/articles/riva-dolceriva-cabin-details-yacht-for-sale.jpg" alt="Riva Dolceriva Cabin Details- Yacht for Sale" width="1236" height="857" /></p>
<ul>
<li>Soft leather cover mattone C12</li>
<li>Venetina blinds blue 5004 RAL</li>
</ul>
<p><img class="img-fluid" title="Riva Dolceriva Cabin Upholstery- Yacht for Sale" src="../../../../photos/articles/riva-dolceriva-cabin-upholstery-yacht-for-sale.jpg" alt="Riva Dolceriva Cabin Upholstery- Yacht for Sale" width="1236" height="857" /></p>
<ul>
<li>Cover bed and pillow - Rubelli art, Twilly Twenty COVER BED AND PILLOW RUBELLI 30318-01 Bianco</li>
<li>Cushions 45x45 Loro Piana Dehors Twill AD9001 Col 7 Indigo-Ecru</li>
<li>Carpeteros Col Neve 1404</li>
<li>Celling Italvipla Troical Col 6010</li>
</ul>
<p> </p>
<p> </p> |
Interior Features of the Riva Dolceriva |
2020-12-07 14:31:00.0 |
|
[empty string] |
riva |
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] |
B004,B015,B016,B019,B020,B039,B029,B030,B035,B037,B002,B003,B027,B028,B024,B005,B026,B050,B041,B043,B052,B053,B011,B051,B046,B048,B014,B045,B049,B012,B018,B022,B021,B042,B031,B033,B034,B036 |
[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 |
Learn more about the Riva Dolceriva's interior features. This is one of the finest new yachts for sale. |
Interior Features of the Riva Dolceriva |
1.0 |
|
|
Interior Features of the Riva Dolceriva |
website |
https://www.alliedmarine.com |
[empty string] |
riva-dolceriva-running-in-sea.jpg |
riva-dolceriva-running-in-sea.jpg,riva-dolceriva-salon-upholstery-yacht-for-sale.jpg,riva-dolceriva-salon-details-yacht-for-sale.jpg,riva-dolceriva-salon-decor-yacht-for-sale.jpg,riva-dolceriva-cabin-upholstery-yacht-for-sale.jpg,riva-dolceriva-cabin-decor-yacht-for-sale.jpg,riva-dolceriva-cabin-details-yacht-for-sale.jpg |
2019-09-30 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
|
|
Interior Features of the Riva Dolceriva |
yachting-news |
interior-features-of-the-riva-dolceriva |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/interior-features-of-the-riva-dolceriva |
0 |
[empty string] |
[empty string] |
summary |
|
|
|
|
Interior Features of the Riva Dolceriva |
[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 = 'interior-features-of-the-riva-dolceriva'
ORDER BY postedDate desc |