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 |
ISINSTOCK |
ISNEWUSED |
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] |
74.00 |
[empty string] |
[empty string] |
[empty string] |
M/Y Cloud 9 |
[empty string] |
242.78 ft |
[empty string] |
[empty string] |
13.50 m |
3.50 m |
[empty string] |
[empty string] |
250’000 lt |
40’000 lt |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
2xCATERPILLAR 3516C-Chd 2000 kW@1600 rpm |
[empty string] |
[empty string] |
16.5 knots |
15 knots |
6'000 nm / 4'000nm |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
CRN |
[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] |
0 |
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 |
0 |
[empty string] |
[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>MORE THAN A YACHT – BY THE VISION AND ENTHUSIASM OF A KNOWLEDGEABLE OWNER<br /></strong>With a length overall of 74 meters, CLOUD 9’s sleek profile is enhanced by subtle super structural design details which, together with the elegant aesthetics of her guest areas, have resulted in a <a href="../../../../superyachts">superyacht</a> of world-class caliber. </p>
<p>The design vision behind CLOUD 9, specified by the experienced owner, demonstrates an optimized balance between interior and exterior spaces, with impressive volume and a high degree of comfort, along with a free-flowing layout for a relaxed indoor-outdoor living environment.</p>
<p><strong>PRIVATE SHOWINGS</strong><br />Visit The Ferretti Group Showroom in Ft. Lauderdale, the largest covered, in-water marina in the US, featuring new and used Pershing, Riva, and Ferretti Yachts. Allied Marine is the exclusive dealer for these premier brands in the US, and an authorized dealer for CRN and Custom Line yachts.</p>
<p> </p> |
[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] |
CRN model Cloud 9, one of Ferretti Group's exclusive custom mega yachts. |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Exterior of the CRN M/Y Cloud 9 in the ocean. |
1770.jpg |
1770 |
[empty string] |
84E9A400-080D-CA22-75D38340B208665F |
MY-Cloud-9 |
Cloud 9 CRN Luxury Superyacht | Allied Marine |
[empty string] |
https://www.alliedmarine.com/new-yachts-for-sale/CRN-yachts/MY-Cloud-9 |
[empty string] |
[empty string] |
1 |
New Yacht Models |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
58 |
[empty string] |
|
SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
yacht_data.isFeatured,
yacht_data.isInStock,
yacht_data.isNewUsed,
yacht_data.ferrettiModelID,
yacht_data.brokerREF,
yacht_data.staffREF,
yacht_data.officeREF,
yacht_data.yatcoREF,
yacht_data.modelREF,
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 = 'MY-Cloud-9' ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |