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 |
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] |
49.99 |
[empty string] |
[empty string] |
[empty string] |
M/Y Latona |
[empty string] |
164.0 ft |
[empty string] |
[empty string] |
[empty string] |
2.65 m |
[empty string] |
[empty string] |
50'000 litres / 13'208 US gallons |
14'000 litres / 3'698 US gallons |
Steel/Aluminium |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
16.0 knots |
14.0 knots |
3'800 nm |
[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] |
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 |
[empty string] |
[empty string] |
[empty string] |
Length Of Hull |
[empty string] |
[empty string] |
[empty string] |
Load Waterline Length |
[empty string] |
[empty string] |
[empty string] |
Max Beam |
[empty string] |
[empty string] |
[empty string] |
Draft |
[empty string] |
[empty string] |
[empty string] |
Unladen Displacement |
[empty string] |
[empty string] |
[empty string] |
Laden Displacement |
[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>Endless Beauty And Timeless Elegance</strong></p>
<p>At 50 meters in length, Latona stands out for her classical, timeless profile that enhances the style and elegance of outdoor areas. Working hand-in-hand with experienced owners, the yacht’s reflect a refined Liberty-style mood, a stylish fil rouge that unravels through all guest areas. </p>
<p>The streamlined bow and the spacious interior and exterior volumes include breathtaking areas almost ‘hanging’ over the sea, that let the Latona shine in all her endless beauty. The yacht is a peaceful, luxurious haven.</p>
<p>A large, exclusive open-air living area is integrated with the beach club and the floodable tender garage – over 70 square meters – allowing space to enjoy moments of pure wellness, fitness and relaxation for the entire family.</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 Latona, 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] |
CRN M/Y Latona Exterior - New Yacht for Sale |
1728.jpg |
1728 |
[empty string] |
013A4731-974F-D5BF-D8C4F5B88D563D49 |
MY-Latona |
Latona CRN Luxury Super Yacht | Allied Marine |
[empty string] |
https://www.alliedmarine.com/new-yachts-for-sale/CRN-yachts/MY-Latona |
[empty string] |
[empty string] |
1 |
New Yacht Models |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
57 |
[empty string] |
|
SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
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 = 'MY-Latona' ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |