RESULTSET |
query |
|
BROKERREF |
CALC_1 |
CALC_2 |
CALC_3 |
CALC_4 |
DATA01 |
DATA02 |
DATA03 |
DATA04 |
DATA05 |
DATA06 |
DATA07 |
DATA08 |
DATA09 |
DATA10 |
DATA11 |
DATA12 |
DATA13 |
DATA14 |
DATA15 |
DATA16 |
DATA17 |
DATA18 |
DATA19 |
DATA20 |
DATA21 |
DATA22 |
DATA23 |
DATA24 |
DATA25 |
DATA26 |
DATA27 |
DATA28 |
DATA29 |
DATA30 |
DATA31 |
DATA32 |
DATA33 |
DATA34 |
DATA35 |
DATA36 |
DATA37 |
DATA38 |
DATA39 |
DATA40 |
DATA41 |
DATA42 |
DATA43 |
DATA44 |
DATA45 |
DEC01 |
DEC02 |
DEC03 |
DEC04 |
DEC05 |
DEC06 |
DEC07 |
DEC08 |
DEC09 |
DEC10 |
DEFAULTSORT |
FERRETTIMODELID |
FIELDORDER |
INCLUDEOFFICE |
INCLUDEUSER |
INT01 |
INT02 |
INT03 |
INT04 |
INT05 |
INT06 |
INT07 |
INT08 |
INT09 |
INT10 |
ISARCHIVED |
ISFEATURED |
KEYWORDS |
LAB01DEC |
LAB01INT |
LAB01MEM |
LAB01STR |
LAB02DEC |
LAB02INT |
LAB02MEM |
LAB02STR |
LAB03DEC |
LAB03INT |
LAB03MEM |
LAB03STR |
LAB04DEC |
LAB04INT |
LAB04MEM |
LAB04STR |
LAB05DEC |
LAB05INT |
LAB05MEM |
LAB05STR |
LAB06DEC |
LAB06INT |
LAB06MEM |
LAB06STR |
LAB07DEC |
LAB07INT |
LAB07MEM |
LAB07STR |
LAB08DEC |
LAB08INT |
LAB08MEM |
LAB08STR |
LAB09DEC |
LAB09INT |
LAB09MEM |
LAB09STR |
LAB10DEC |
LAB10INT |
LAB10MEM |
LAB10STR |
LAB11MEM |
LAB11STR |
LAB12MEM |
LAB12STR |
LAB13MEM |
LAB13STR |
LAB14MEM |
LAB14STR |
LAB15MEM |
LAB15STR |
LAB16MEM |
LAB16STR |
LAB17MEM |
LAB17STR |
LAB18MEM |
LAB18STR |
LAB19MEM |
LAB19STR |
LAB20MEM |
LAB20STR |
LAB21STR |
LAB22STR |
LAB23STR |
LAB24STR |
LAB25STR |
LAB26STR |
LAB27STR |
LAB28STR |
LAB29STR |
LAB30STR |
LAB31STR |
LAB32STR |
LAB33STR |
LAB34STR |
LAB35STR |
LAB36STR |
LAB37STR |
LAB38STR |
LAB39STR |
LAB40STR |
LAB41STR |
LAB42STR |
LAB43STR |
LAB44STR |
LAB45STR |
MEM01STATE |
MEM02STATE |
MEM03STATE |
MEM04STATE |
MEM05STATE |
MEM06STATE |
MEM07STATE |
MEM08STATE |
MEM09STATE |
MEM10STATE |
MEM11STATE |
MEM12STATE |
MEM13STATE |
MEM14STATE |
MEM15STATE |
MEM16STATE |
MEM17STATE |
MEM18STATE |
MEM19STATE |
MEM20STATE |
MEMO01 |
MEMO02 |
MEMO03 |
MEMO04 |
MEMO05 |
MEMO06 |
MEMO07 |
MEMO08 |
MEMO09 |
MEMO10 |
MEMO11 |
MEMO12 |
MEMO13 |
MEMO14 |
MEMO15 |
MEMO16 |
MEMO17 |
MEMO18 |
MEMO19 |
MEMO20 |
METADESCRIPTION |
MFRNAME |
MFRREF |
MODELNAME |
MODELREF |
NAME_FIRST |
NAME_FULL1 |
NAME_FULL2 |
NAME_FULL3 |
NAME_LAST |
OFFICEREF |
PHOTOCAPTION |
PHOTOFILENAME |
PHOTOID |
PRIORITY |
RANDOMSEED |
SEOHANDCRAFTEDURL |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TEMPLATEDESC |
TEMPLATEID |
TEMPLATENAME |
TEMPLATEREF |
USERFIRSTNAME |
USERFULLNAME |
USERFULLNAME2 |
USERLASTNAME |
YACHTID |
YATCOREF |
1 |
[empty string] |
8.23 |
36.00 |
[empty string] |
[empty string] |
Iseo |
[empty string] |
27 ft 0 in |
8.21 m - 26 ft 11 in |
7.08 m - 23 ft 3 in |
2.50 m - 8 ft 2 in |
0.96 m - 3 ft 2 in |
2.940 kg - 6,482 lbs |
3.850 kg - 8,488 lbs |
330 l - 87 US gal |
84 l - 22 US gal |
GRP |
6 |
[empty string] |
[empty string] |
[empty string] |
Volvo Penta D4 - 300A |
300 |
Stern Drives |
41 kn |
36 kn |
250 nm |
Volvo Penta V8 300 CE |
305 |
Stern Drives |
41 kn |
36 kn |
250 nm |
[empty string] |
Riva |
[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] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
21 |
LAB01STR,LAB30STR,LAB03STR,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB09STR,LAB10STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB15STR,LAB16STR,LAB17STR,LAB18STR,LAB19STR,LAB20STR,LAB21STR,LAB22STR,LAB23STR,LAB24STR,LAB25STR,LAB26STR,LAB27STR,LAB28STR,LAB29STR,LAB31STR,LAB32STR,LAB33STR,LAB34STR,LAB35STR,LAB36STR,LAB37STR,LAB38STR,LAB39STR,LAB41STR,LAB40STR,LAB42STR,LAB01MEM,LAB02MEM,LAB03MEM |
0 |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
[empty string] |
[empty string] |
[empty string] |
Description Block |
Page Title |
[empty string] |
[empty string] |
Virtual Tour URL |
[empty string] |
[empty string] |
[empty string] |
Video Embed Code |
Length Overall (NN ft N in) |
[empty string] |
[empty string] |
[empty string] |
Length Of Hull (String) |
[empty string] |
[empty string] |
[empty string] |
Load Waterline Length (String) |
[empty string] |
[empty string] |
[empty string] |
Max Beam (String) |
[empty string] |
[empty string] |
[empty string] |
Draft (String) |
[empty string] |
[empty string] |
[empty string] |
Unladen Displacement (String) |
[empty string] |
[empty string] |
[empty string] |
Laden Displacement (String) |
[empty string] |
[empty string] |
[empty string] |
Fuel |
[empty string] |
Water |
[empty string] |
Material |
[empty string] |
People on Board |
[empty string] |
Cabins |
[empty string] |
Bathrooms |
[empty string] |
Bathrooms in crew quarter |
[empty string] |
Engine 1 |
[empty string] |
Engine 1 HP |
[empty string] |
Engine 1 Transmission |
[empty string] |
Engine 1 Max Speed (kn) |
Engine 1 Cruise Speed (kn) |
Engine 1 Range |
Engine 2 |
Engine 2 HP |
Engine 2 Transmission |
Engine 2 Max Speed (kn) |
Engine 2 Cruise Speed (kn) |
Engine 2 Range |
Engine 3 |
Brand |
Engine 3 HP |
Engine 3 Transmission |
Engine 3 Max Speed (kn) |
Engine 3 Cruise Speed (kn) |
Engine 3 Range |
Engine 4 |
Engine 4 HP |
Engine 4 Max Speed (kn) |
Engine 4 Cruise Speed (kn) |
Engine 4 Range |
Engine 4 Transmission |
VRCloud Link |
[empty string] |
[empty string] |
[empty string] |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<p><strong>A Gem Tailor-Made For Your Every Need</strong></p>
<p>Iseo is the lake on which the history of Riva started way back in 1842. The origin of the Riva legend echoes in her name, but this sophisticated 27-foot runabout is more modern and contemporary than ever. </p>
<p>For while her lines and her design are as smooth and seductive as always, in emblematic Riva style, Iseo can also boast some of the very latest technology. The result is a marriage of tradition and innovation that cannot fail to beguile all who experience her. </p>
<p>The defining virtue of this marvelous creation is her remarkable versatility. Whether as your vessel of choice for excursions on the lake or the exclusive tender for your yacht, Iseo rises magnificently to any challenge. And she is so easy to transport, so you can enjoy her wherever and however you please – in great company and total comfort.<br /><br /></p>
<p><strong style="color: #0000ff;"><a style="color: #0000ff;" title="Riva Yachts in stock" href="../../../../used-yachts-for-sale?allyachts_length_desc%5Btoggle%5D%5B_tags%5D=true&allyachts_length_desc%5Bmenu%5D%5BBuilder%5D=RIVA&allyachts_length_desc%5Brange%5D%5Bcalc_FT%5D=10:600&%5BsortBy%5D=allyachts_length_desc">See the New Riva Yachts In Stock and Available Now.</a></strong></p> |
[empty string] |
<a href="https://www.riva-yacht.com/en-us/Models/Video-Gallery/2-21-36-PUB/Riva-Iseo">Watch video!<InvalidTag>var w=window,d=document,e;w._fpes||(w._fpes=[],w.addEventListener("load",function(){var s=d.createElement("script");s.src="//embed.flowplayer.org/6.0.4/embed.min.js",d.body.appendChild(s)})),e=[].slice.call(d.getElementsByTagName("script"),-1)[0].parentNode,w._fpes.push({e:e,l:"",c:{"ratio":0.5625,"rtmp":0,"live":false,"origin":"https://www.riva-yacht.com/en-us/Models/Video-Gallery/2-21-36-PUB/Riva-Iseo","swf":"//releases.flowplayer.org/6.0.4/flowplayer.swf","swfHls":"//releases.flowplayer.org/6.0.4/flowplayerhls.swf","adaptiveRatio":false,"clip":{"title":"","subtitles":[],"sources":[{"src":"https://www.riva-yacht.com/UploadB2B/videos/Iseo-1200p.mp4","suffix":"mp4","type":"video/mp4"}]}}});</script></a> |
[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] |
[empty string] |
[empty string] |
The Riva Iseo is a 27-foot runabout as the perfect vessel or yacht tender. Allied Marine is the exclusive U.S. dealer of Riva motor yachts. |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
895.jpg |
895 |
[empty string] |
A9F5AC81-094D-032B-DC1F2B7AF894E5E1 |
Iseo |
New Riva Iseo Yacht for Sale | Allied Marine |
[empty string] |
https://www.alliedmarine.com/new-yachts-for-sale/Riva-yachts/Iseo |
[empty string] |
[empty string] |
1 |
New Yacht Models |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
26 |
[empty string] |
|
SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
yacht_data.ferrettiModelID,
yacht_data.brokerREF,
yacht_data.staffREF,
yacht_data.officeREF,
yacht_data.yatcoREF,
yacht_data.modelREF,
yacht_data.isFeatured,
yacht_data.calc_1,
yacht_data.calc_2,
yacht_data.calc_3,
yacht_data.calc_4,
yacht_data.yachtID,
yacht_data.priority,
yacht_data.data01,
yacht_data.data02,
yacht_data.data03,
yacht_data.data04,
yacht_data.data05,
yacht_data.data06,
yacht_data.data07,
yacht_data.data08,
yacht_data.data09,
yacht_data.data10,
yacht_data.data11,
yacht_data.data12,
yacht_data.data13,
yacht_data.data14,
yacht_data.data15,
yacht_data.data16,
yacht_data.data17,
yacht_data.data18,
yacht_data.data19,
yacht_data.data20,
yacht_data.data21,
yacht_data.data22,
yacht_data.data23,
yacht_data.data24,
yacht_data.data25,
yacht_data.data26,
yacht_data.data27,
yacht_data.data28,
yacht_data.data29,
yacht_data.data30,
yacht_data.data31,
yacht_data.data32,
yacht_data.data33,
yacht_data.data34,
yacht_data.data35,
yacht_data.data36,
yacht_data.data37,
yacht_data.data38,
yacht_data.data39,
yacht_data.data40,
yacht_data.data41,
yacht_data.data42,
yacht_data.data43,
yacht_data.data44,
yacht_data.data45,
yacht_data.int01,
yacht_data.int02,
yacht_data.int03,
yacht_data.int04,
yacht_data.int05,
yacht_data.int06,
yacht_data.int07,
yacht_data.int08,
yacht_data.int09,
yacht_data.int10,
yacht_data.dec01,
yacht_data.dec02,
yacht_data.dec03,
yacht_data.dec04,
yacht_data.dec05,
yacht_data.dec06,
yacht_data.dec07,
yacht_data.dec08,
yacht_data.dec09,
yacht_data.dec10,
yacht_data.memo01,
yacht_data.memo02,
yacht_data.memo03,
yacht_data.memo04,
yacht_data.memo05,
yacht_data.memo06,
yacht_data.memo07,
yacht_data.memo08,
yacht_data.memo09,
yacht_data.memo10,
yacht_data.memo11,
yacht_data.memo12,
yacht_data.memo13,
yacht_data.memo14,
yacht_data.memo15,
yacht_data.memo16,
yacht_data.memo17,
yacht_data.memo18,
yacht_data.memo19,
yacht_data.memo20,
yacht_data.randomSeed,
yacht_data.metaDescription,
yacht_data.keywords,
yacht_data.seoPreviewText,
yacht_data.seoPageTitle,
yacht_data.seoURL,
yacht_data.seoHandCraftedURL,
yacht_templates.templateID,
yacht_templates.fieldOrder,
yacht_templates.mem01state,
yacht_templates.mem02state,
yacht_templates.mem03state,
yacht_templates.mem04state,
yacht_templates.mem05state,
yacht_templates.mem06state,
yacht_templates.mem07state,
yacht_templates.mem08state,
yacht_templates.mem09state,
yacht_templates.mem10state,
yacht_templates.mem11state,
yacht_templates.mem12state,
yacht_templates.mem13state,
yacht_templates.mem14state,
yacht_templates.mem15state,
yacht_templates.mem16state,
yacht_templates.mem17state,
yacht_templates.mem18state,
yacht_templates.mem19state,
yacht_templates.mem20state,
yacht_templates.templateDesc,
yacht_templates.templateName,
yacht_templates.lab01str,
yacht_templates.lab02str,
yacht_templates.lab03str,
yacht_templates.lab04str,
yacht_templates.lab05str,
yacht_templates.lab06str,
yacht_templates.lab07str,
yacht_templates.lab08str,
yacht_templates.lab09str,
yacht_templates.lab10str,
yacht_templates.lab11str,
yacht_templates.lab12str,
yacht_templates.lab13str,
yacht_templates.lab14str,
yacht_templates.lab15str,
yacht_templates.lab16str,
yacht_templates.lab17str,
yacht_templates.lab18str,
yacht_templates.lab19str,
yacht_templates.lab20str,
yacht_templates.lab21str,
yacht_templates.lab22str,
yacht_templates.lab23str,
yacht_templates.lab24str,
yacht_templates.lab25str,
yacht_templates.lab26str,
yacht_templates.lab27str,
yacht_templates.lab28str,
yacht_templates.lab29str,
yacht_templates.lab30str,
yacht_templates.lab31str,
yacht_templates.lab32str,
yacht_templates.lab33str,
yacht_templates.lab34str,
yacht_templates.lab35str,
yacht_templates.lab36str,
yacht_templates.lab37str,
yacht_templates.lab38str,
yacht_templates.lab39str,
yacht_templates.lab40str,
yacht_templates.lab41str,
yacht_templates.lab42str,
yacht_templates.lab43str,
yacht_templates.lab44str,
yacht_templates.lab45str,
yacht_templates.lab01int,
yacht_templates.lab02int,
yacht_templates.lab03int,
yacht_templates.lab04int,
yacht_templates.lab05int,
yacht_templates.lab06int,
yacht_templates.lab07int,
yacht_templates.lab08int,
yacht_templates.lab09int,
yacht_templates.lab10int,
yacht_templates.lab01dec,
yacht_templates.lab02dec,
yacht_templates.lab03dec,
yacht_templates.lab04dec,
yacht_templates.lab05dec,
yacht_templates.lab06dec,
yacht_templates.lab07dec,
yacht_templates.lab08dec,
yacht_templates.lab09dec,
yacht_templates.lab10dec,
yacht_templates.lab01mem,
yacht_templates.lab02mem,
yacht_templates.lab03mem,
yacht_templates.lab04mem,
yacht_templates.lab05mem,
yacht_templates.lab06mem,
yacht_templates.lab07mem,
yacht_templates.lab08mem,
yacht_templates.lab09mem,
yacht_templates.lab10mem,
yacht_templates.lab11mem,
yacht_templates.lab12mem,
yacht_templates.lab13mem,
yacht_templates.lab14mem,
yacht_templates.lab15mem,
yacht_templates.lab16mem,
yacht_templates.lab17mem,
yacht_templates.lab18mem,
yacht_templates.lab19mem,
yacht_templates.lab20mem,
yacht_templates.defaultSort,
yacht_templates.includeUser,
yacht_templates.includeOffice,
users.userLastName,
users.userFirstName,
users.userFirstName + ' ' + users.userLastName AS userFullName,
users.userLastName + ', ' + users.userFirstName AS userFullName2,
brokers.name_last,
brokers.name_first,
brokers.name_first + ' ' + brokers.name_last AS name_full1,
brokers.name_last + ', ' + brokers.name_first AS name_full2,
brokers.name_last + ', ' + brokers.name_first + ' (' + brokers.email + ')' AS name_full3,
yacht_photos.photoID,
yacht_photos.photoFileName,
yacht_photos.photoCaption,
yacht_model.mfrRef,
yacht_model.modelName,
yacht_mfr.mfrName
FROM
yacht_data
LEFT JOIN yacht_templates ON yacht_data.templateREF = yacht_templates.templateID
LEFT JOIN users ON yacht_data.staffREF = users.userID
LEFT JOIN brokers ON yacht_data.brokerREF = brokers.brokerID
LEFT JOIN yacht_photos ON yacht_data.yachtID = yacht_photos.yachtREF
LEFT JOIN yacht_model ON yacht_data.modelREF = yacht_model.modelID
LEFT JOIN yacht_mfr ON yacht_model.mfrREF = yacht_mfr.mfrID
WHERE ( templateREF = 1 AND ( isArchived != 1 OR isArchived IS NULL ) AND seoHandCraftedURL = 'Iseo' ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |