| 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] |
43.59 |
[empty string] |
[empty string] |
[empty string] |
CHECKMATE |
143 |
2013 |
BENETTI |
[empty string] |
Ancona |
[empty string] |
[empty string] |
Other |
14kn |
Italy |
CLONE-480 |
[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] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
0.00 |
[empty string] |
[empty string] |
LAB01STR,LAB08STR,LAB03STR,LAB04STR,LAB02STR,LAB04INT,LAB05STR,LAB09STR,LAB10STR,LAB06STR,LAB07STR,LAB11STR,LAB01INT,LAB02INT,LAB03INT,LAB01MEM,LAB02MEM |
0 |
0 |
5 |
12 |
9 |
31 |
0 |
0 |
0 |
0 |
0 |
0 |
[empty string] |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Staterooms |
General Boat Description |
Boat Name |
[empty string] |
Guests |
Additional Detail Description |
Length |
[empty string] |
Crew |
[empty string] |
Year |
[empty string] |
Beam |
[empty string] |
Brand |
[empty string] |
[empty string] |
[empty string] |
Asking Price |
[empty string] |
[empty string] |
[empty string] |
City |
[empty string] |
[empty string] |
[empty string] |
State |
[empty string] |
[empty string] |
[empty string] |
Sold Date (Internal) |
[empty string] |
[empty string] |
[empty string] |
Boat Hull Material |
[empty string] |
[empty string] |
[empty string] |
Cruising Speed Measure |
[empty string] |
Country |
[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] |
[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] |
1 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
<p><strong>UNIQUE DESIGN BUILT TO BENETTI MEGAYACHT CALIBER<br /></strong>CHECKMATE was the second launched of the Benetti Vision series. She boats a unique design and features and was built to meet the highest Benetti standards.</p>
<p><strong>LUXURY YACHT FOR SALE - WALKTHROUGH</strong><br />Indubitably innovative, she offers great features such as 180-degree panoramic views on the master deck with spacious staterooms and an impressive upper deck dining area with slide-away doors that create a 270-degree alfresco dining experience. CHECKMATE was built to be “contemporary chic” and her custom interior is the rare and perfect blend between beautiful Cherry and Burr Madrona woods and many types of delicate Italian marble.</p>
<p>The CHECKMATE accommodations sleep up to 12 in the Owner's party in 5 staterooms, plus crew accommodations for up to 9 in 5 cabins.</p>
<p>The Main Salon offers Benetti’s Exclusive Sea Technology B.E.S.T. system entertainment controlled through Apple iPad. Enjoy a 40’’ Samsung HD LED TV with Nextworks DVD Player, Denon AVR with Apple Airplay. The main salon is wired with Promar PMS6, 6.5” speakers, and a B&W ASW608 subwoofer. Apple iPad remote control with charge dock, SAT Decoder, and Thomson TB30 VOIP Telephone. </p>
<p>Owner's Suite is equipped with a 40’’ Samsung HD LED TV, Nextworks DVD Player with Denon AVR with Apple Airplay(4) Promar PMS6, 6.5” speakers, and a B&W ASW608 subwoofer. There is also an Apple iPad remote control with a charging dock, SAT Decoder, and Thomson TB30 VOIP Telephone. The Owner's Study offers a 32’’ Samsung HD LED TV with Nextworks DVD Player, a Denon AVR with Apple Airplay, (4) Promar PMS6, 6.5” speakers, and a B&W ASW608 subwoofer. Apple iPad remote control with charge dock, SAT Decoder, and Thomson TB30 VOIP Telephone.</p>
<p>VIP Cabins offer 26’’ Samsung LED TV per Guest Cabin each with a Nextworks DVD Player per cabin, and a Denon AVR with Apple Airplay (1) per cabin. Apple iPad remote control with charge dock (1) per cabin. 2 Promar PMS6, 6.5” speakers per cabin, and a Grandstram GXP280 VOIP phone per cabin.</p>
<p>The 2 Guest Cabins each offer 26’’ Samsung LED TV, each with a Nextworks DVD Player and a Denon AVR with Apple Airplay per cabin. Apple iPad remote control with charge dock (1) per cabin with 2 Promar PMS6, 6.5” speakers per cabin. Each cabin has a Grandstram GXP280 VOIP phone, and a SAT Decoder.</p>
<p>The Upper Salon offers a 40’’ Samsung HD LED TV equipped with a Nextworks DVD Player, Denon AVR with Apple Airplay, Promar PMS6, 6.5” speakers, and a B&W ASW608 subwoofer. Apple iPad remote control with charging dock an SAT Decoder and Thomson TB30 VOIP Telephone </p>
<p>Crew Mess is equipped with a 26’’ Samsung LED TV, TEAC DV600 A/V Receiver/DVD Player + USB iPod Interface, Promar PMS6, 6.5” speakers a SAT Decoder, and Cisco SMB SPA 301 VOIP Telephone, and a CCTV Control Display.</p>
<p>Captain's Cabin offers a 26’’ Samsung LED TV equipped with a TEAC DV600 A/V Receiver/DVD Player + USB iPod Interface, Promar PMS6, 6.5” speakers, SAT Decoder, and a Cisco SMB SPA 301 VOIP Telephone.</p>
<p>The three crew cabins each have TEAC DV600 A/V Receiver/DVD Player + USB iPod Interface (1) per cabin and a Promar PMS5, 5” speakers (2) per cabin. Each also has a Cisco SMB SPA 301 VOIP Telephone.</p>
<p>Engineer Cabin is equipped with a TEAC DV600 A/V Receiver/DVD Player + USB iPod Interface, a Promar PMS5, 5” speakers, and a Cisco SMB SPA 301 VOIP Telephone. </p>
<p>The Wheelhouse offers a TEAC DV600 A/V Receiver/DVD Player + USB iPod Interface, two Promar PMS5, 5” speakers, and a Cisco SMB SPA 301 VOIP Telephone</p>
<p>The Sundeck offers a Nextworks Audio system with Denon AVR with Apple Airplay, Apple iPad remote control with charge dock, and Promar PMO8 8” Speakers</p>
<p>Main Galley offers Miele cooking top, a Gaggenau grill top, an exhaust hood, and a Miele oven and microwave. The Main Galley also offers a custom built-in freezer/fridge with Sub Zero Fridge Drawers and a Euro cave wine cellar for 75 bottles. Miele dishwasher, Broan garbage macerator, and a Broan trash compactor. The Galley also offers a custom dumb waiter and Gaggenau coffee system.</p>
<p>Mess Equipment in the Crew Galley includes a Miele Microwave and dishwasher, as well as, a Miele refrigerator in the Captain’s cabin.</p>
<p>Additional Galley Equipment includes a microwave in the Skylounge bar/pantry. Two BBQs on the Sun Deck, an ice maker in the main saloon bar. A Frigobar in each Main Saloon Bar, Owner’s Study, Guests Lobby, and Skylounge bar/pantry. The Skylounge bar/pantry and Sundeck each have an ice maker and a fridge on the sundeck and the Skylounge bar/pantry has a dishwasher.</p>
<p>Laundry Equipment includes three Miele Professional Washers and three Miele Professional Dryers.<br /><br />Tenders and Toys include a 2012 Williams 18’ Diesel Jet 565 and two SEA-DOO Spark Jet-skis</p>
<p>Deck Equipment includes two Anchor Windlass systems, two Aft Warping Capstans, two Anchors, and security equipment. Benetti Exclusive Sea Technology: B.E.S.T. CCTV System<br />Panasonic NW502SE Fixed IP Cameras, Panasonic NS202AE Panning IP Camera, and a FLIR Voyager II Night Vision Camera</p>
<p>Safety Equipment includes a Fire Fighting System throughout the vessel in accordance with MCA Autronica. Fire Alarm System, four Zodiac Life-Rafts, Sailor 406 EPIRBS, flares, and medical equipment.</p>
<p>Electrical Equipment includes (2) Kolher Generators and two Asea converters. The mechanical equipment includes (2) Idromar MC8S9 Duplex Watermakers, Naiad mod. #525 zero speed + underway trim tabs/stabilizers, Naiad #24 bow thruster, twin disc steering system and Condaria 180.000 Kcal/h, Model WM 150002 Air Conditioning. Communication systems include a Sailor SATcom, Radiotelephone SSB Sailor 5000, VHF: Sailor RT 6222/6210 for wheelhouse, (2) Remote control units for crew mess/galley, (4) Portable VHF Sailor SP, 3510, (2) VHF Sailor SP3520 GMDSS and a GSM Telular SX Series (Europe) Cell Phone System.</p>
<p>The CHECKMATE navigation systems include a Furuno FR BB 2117 Radar, Plath Navigator X MK2 Gyrocompass, Plath Jupiter Magnetic Compass, BB Navis AP 3000 Auto Pilot, Blackbox graphic DFF 1 Depth Sounder, Leica MX Marine GPS, Furuno Navnet Video Plotter, NMEA System Wind/Speed Log, and a Navtex NX700 </p>
<p><strong>Refit items in 2020-2019<br /></strong><strong>•</strong> Steering gear serviced<br /><strong>•</strong> Crane - serviced (new actuator)<br /><strong>•</strong> Garage - cosmetic maintenances<br /><strong>•</strong> Engine Room - cosmetic maintenance<br /><strong>•</strong> Sea Water Pumps<br /><strong>•</strong> Serviced air-conditioning<br /><strong>•</strong> New plants anchor lockers, chains, windlasses, and controllers<br /><strong>•</strong> Repaint and service galley floor<br /><strong>•</strong> Replace Williams Jet tender tubes, cushions, steering, actuator, and engine service<br /><strong>•</strong> Main salon and sky lounge electric doors, service bilges, serviced and painted<br /><strong>•</strong> Sewage Tank - stripped and recoated<br /><strong>•</strong> Sewage Treatment Plant - overhaul<br /><strong>•</strong> Generator Exhaust - replaced<br /><strong>•</strong> Crew Mattresses – replaced with new<br /><strong>•</strong> Sundeck Umbrella & Support - replaced with new<br /><strong>•</strong> Dumb waiter - serviced<br /><strong>•</strong> Exterior Windows - caulking resealed<br /><strong>•</strong> Anchor Locker Bilge Pumps - replaced<br /><strong>•</strong> Main Fire Pump & Bilge Pump - serviced<br /><strong>•</strong> Jacuzzi - upgraded heater system<br /><strong>•</strong> Service AV system serviced<br /><strong>•</strong> Crew heads - overhaul & service<br /><strong>•</strong> ABS annual – hull and machinery</p>
<p><strong>Refit items: 2019 – 2018<br />•</strong> 5-year Class Survey completed<br /><strong>•</strong> Full top to a bottom paint job<br /><strong>•</strong> Full rebuild of Starboard Generator and new electrical end<br /><strong>•</strong> Top end rebuild of Port Generator<br /><strong>•</strong> All steering, stabilizer, and bow thruster high-pressure hydraulic lines and hoses replaced<br /><strong>•</strong> New exhaust with insulated jackets for both Main Engines<br /><strong>•</strong> Full air-conditioning and refrigeration service<br /><strong>•</strong> Anchor Windlasses removed and replaced with new seals<br /><strong>•</strong> New port shaft<br /><strong>•</strong> Thru-Hulls removed and re-bed (Oct 2017 yard period)<br /><strong>•</strong> (2) New SEA-DOO Spark Jet-ski</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] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
|
[empty string] |
7625 |
0 |
CAB01007-B7E1-280D-6528C0C966C60823 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
[empty string] |
3 |
Recently Sold Superyachts |
3 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
480 |
0 |
|
| 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 ( photoID > 0 AND (templateREF = 3) AND (isArchived = 0 OR isArchived IS NULL) AND yachtID = 480 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY calc_1 desc |