RESULTSET |
query |
|
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 |
DEC01 |
DEC02 |
DEC03 |
DEC04 |
DEC05 |
DEC06 |
DEC07 |
DEC08 |
DEC09 |
DEC10 |
DEFAULTSORT |
FIELDORDER |
INCLUDEOFFICE |
INCLUDEUSER |
INT01 |
INT02 |
INT03 |
INT04 |
INT05 |
INT06 |
INT07 |
INT08 |
INT09 |
INT10 |
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 |
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 |
OFFICEREF |
PHOTOCAPTION |
PHOTOID |
PRIORITY |
RANDOMSEED |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TEMPLATEDESC |
TEMPLATEID |
TEMPLATENAME |
TEMPLATEREF |
USERFIRSTNAME |
USERFULLNAME |
USERFULLNAME2 |
USERLASTNAME |
YACHTID |
YATCOREF |
1 |
30.49 |
28.47 |
7.16 |
24.94 |
CC110 |
100' 0.25" |
93’ 5" |
23’ 6" |
4’ 9 3/4” |
121 tons |
266,760 lbs |
4,000 gallons |
15,140 liters |
500 gallons |
1,900 liters |
Twin MTU16V2000 M96L 2600HP |
Twin Onan 50kW (50Hz) |
[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] |
CC |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
LAB30STR,LAB01STR,LAB23STR,LAB02STR,LAB03STR,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB09STR,LAB10STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB15STR,LAB16STR,LAB17STR,LAB18STR,LAB19STR,LAB20STR,LAB21STR,LAB22STR,LAB24STR,LAB25STR,LAB26STR,LAB27STR,LAB01MEM |
0 |
0 |
[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] |
Overview |
Model |
[empty string] |
[empty string] |
[empty string] |
L.O.A. |
[empty string] |
[empty string] |
[empty string] |
L.W.L. |
[empty string] |
[empty string] |
[empty string] |
Beam |
[empty string] |
[empty string] |
[empty string] |
Draft |
[empty string] |
[empty string] |
[empty string] |
Displacement (t) |
[empty string] |
[empty string] |
[empty string] |
Displacement (lbs) |
[empty string] |
[empty string] |
[empty string] |
Fuel Tank (gal) |
[empty string] |
[empty string] |
[empty string] |
Fuel Tank (ltrs) |
[empty string] |
[empty string] |
[empty string] |
Water Tank (gal) |
[empty string] |
Water Tank (ltrs) |
[empty string] |
Engines |
[empty string] |
Generators |
[empty string] |
Recommended Capacity |
[empty string] |
Virtual Tour 1 URL |
[empty string] |
Virtual Tour 1 Title |
[empty string] |
Virtual Tour 2 URL |
[empty string] |
Virtual Tour 2 Title |
[empty string] |
Virtual Tour 3 URL |
[empty string] |
Virtual Tour 3 Title |
Virtual Tour 4 URL |
Virtual Tour 4 Title |
Name |
Virtual Tour 5 URL |
Virtual Tour 5 Title |
Virtual Tour 6 URL |
Virtual Tour 6 Title |
[empty string] |
[empty string] |
Series |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<p>The Horizon CC110 luxury superyacht “ABACO” features innovative spatial concepts on both her interior and exterior; Horizon worked with the owner’s selected design team Beiderbeck to create an independent raised pilothouse as well as provide near 360-degree visibility on all levels. The voluminous main salon opens with curved wood cabinetry to port and starboard seating that will accommodate 20 guests. Formal dining is in close proximity to both the main salon and the port-side galley, allowing for the owner to entertain guests easily between the three areas. Three large en suite guest staterooms are offered on “ABACO”: a full-beam, on-deck master and two guest staterooms below deck.</p>
<p> </p>
<p>For the ultimate outdoor experience, the flybridge is appointed with aft sun loungers for soaking up rays as well as center-line dinette seating that allows maximum ocean views. On the aft deck, a large settee and dining table will play host for many family gatherings at sea, and for watersports, the aft tender garage can, at the touch of a button, lower the swim platform to launch a 16.5 foot tender; the area can also be used as a beach club for guests while swimming, diving, or simply relaxing.</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] |
The Horizon CC110 luxury superyacht “ABACO” features innovative spatial concepts on both her interior and exterior. |
[empty string] |
[empty string] |
3965 |
[empty string] |
7AF02F18-0B73-15BA-7EECB7988C19D4C5 |
Horizon CC110 Superyacht |
[empty string] |
https://www.horizonyachtusa.com/new-yachts/horizon-cc110/40 |
[empty string] |
Use this to add new models to the website |
1 |
Models |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
40 |
[empty string] |
|
SQL |
SELECT
yacht_data.templateREF,
yacht_data.staffREF,
yacht_data.officeREF,
yacht_data.yatcoREF,
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.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_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.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,
yacht_photos.photoID,
yacht_photos.photoCaption
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 yacht_photos ON yacht_data.yachtID = yacht_photos.yachtREF
WHERE ( yachtID = 40 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |