RESULTSET |
query |
|
ASKINGPRICE |
ASKINGPRICEFORMATTED |
BOATNAME |
BUILDER |
CALC_1 |
CALC_2 |
CALC_3 |
CALC_4 |
CURRENCY |
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 |
FB_ADMINS |
FIELDORDER |
INCLUDEOFFICE |
INCLUDEUSER |
INCSECTIONS |
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 |
LOAFEET |
LOAMETERS |
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 |
OFFICENAME |
OFFICEREF |
OG_DESC |
OG_IMAGE |
OG_TITLE |
OG_TYPE |
OG_URL |
PHOTOCAPTION |
PHOTOID |
PRIORITY |
RANDOMSEED |
SALESPERSON |
SALESPERSONCELLPHONE |
SALESPERSONEMAIL |
SALESPERSONPHONE |
SCHEMA_DESC |
SCHEMA_IMAGE |
SCHEMA_NAME |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TEMPLATEDESC |
TEMPLATEID |
TEMPLATENAME |
TEMPLATEREF |
TWITTER_CARD |
TWITTER_DESC |
TWITTER_IMAGE |
TWITTER_IMAGE_ALT |
TWITTER_SITE |
TWITTER_TITLE |
USERFIRSTNAME |
USERFULLNAME |
USERFULLNAME2 |
USERLASTNAME |
VESSELID |
VESSELLOCATION |
YACHTID |
YATCOREF |
YCSEOURL |
YEARBUILT |
YPHOTOLARGE |
YPHOTOMEDIUM |
YPHOTOSMALL |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
29.87 |
3624320.00 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
98FT |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
CAT |
C32 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
371 |
[empty string] |
Aluminum |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
2014 |
[empty string] |
[empty string] |
S100 |
3,624,320 |
2 |
[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] |
LAB06INT,LAB05MEM,LAB06MEM,LAB03STR,LAB23STR,LAB26STR,LAB21STR,LAB28STR,LAB27STR,LAB05INT,LAB02STR,LAB01STR,LAB18STR,LAB10STR,LAB11STR,LAB15STR,LAB16STR,LAB17STR,LAB24STR,LAB29STR,LAB25STR,LAB04STR,LAB02INT,LAB03INT,LAB04INT,LAB01INT,LAB19STR,LAB20STR,LAB20MEM,LAB03MEM,LAB08MEM,LAB07MEM,LAB02MEM,LAB09MEM,LAB11MEM |
1 |
1 |
[empty string] |
[empty string] |
[empty string] |
0 |
0 |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
0 |
0 |
[empty string] |
[empty string] |
Motor Type |
[empty string] |
Hull Length |
[empty string] |
Fuel Type |
Trade-In Comments |
Length Overall |
[empty string] |
Number of Motor |
PDF Link |
Boat Name |
[empty string] |
Trailer Included |
[empty string] |
Colors |
[empty string] |
Currency |
Trade-In Manufacturer |
[empty string] |
[empty string] |
Vessel Category |
Trade-In Line |
[empty string] |
[empty string] |
[empty string] |
Specifications |
[empty string] |
[empty string] |
[empty string] |
VT / walk through link |
[empty string] |
[empty string] |
[empty string] |
Options |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Engine Manufacturer |
Standard Features |
Engine Model |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Draft |
[empty string] |
Hours |
[empty string] |
Engine Type |
[empty string] |
Hull Material |
[empty string] |
Horse Power |
Bridge Clearance |
Fuel Type |
Stock # |
[empty string] |
Year |
Hull Condition |
Interior Condition |
Model |
Asking Price |
Type |
Mechanical Condition |
[empty string] |
[empty string] |
[empty string] |
0 |
2 |
0 |
0 |
0 |
0 |
2 |
0 |
2 |
1 |
2 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
[empty string] |
<p>One of a kind Sport Fishing Yacht designed by the famous designer Paolo Scanu who has worked some of the most important shipyards in the world such as Benetti, CRN and Alloy Yachts.</p>
<p>This Aico S100 has been built by one of the best Turkish shipyards in 2014 and delivered to her owners in 2015. </p>
<p>The interior of the yacht is luxurious with satin, lacquer, and bamboo. The floors in the staterooms are carpeted.</p>
<p>Accommodations<strong>:</strong> Owner's cabin with double bed, separate wardrobe and bathroom with shower. Two double cabins with separate bathrooms. VIP cabin in the bow with separate wardrobe and bathroom with shower. Crew accommodation with independent access from outside. Laundry room storage, freezer, washer dryer and mini workshop.</p>
<p>Aft there is a large comfortable area with a sofa and table to accommodate 10 people.</p>
<p>Large living room with separate dining area for 8 people open to large kitchen with all the necessary amenities including induction stove top, electric oven, microwave, fridge, dishwasher and minibar.</p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong><em>offered by</em></strong><strong> <br /><span style="font-size: 14pt;">Inter</span></strong><span style="font-size: 14pt;"><em><strong>Marine Yacht </strong></em><strong>Group</strong><em><strong><br /></strong></em><span style="background-color: #ffff00;"><strong>Listing Broker: Mike Smalley, CPYB - Call 954.665.7138</strong></span></span><em><strong><br /></strong></em>email: mike@intermarineyachts.com / www.Intermarineyachts.com </span><br /><br /><span style="font-size: 10pt;"><em>Authorized Dealer:</em> Prestige Yachts - Monte Carlo Yachts (80', 86', 96' & 105')</span><br /><span style="font-size: 10pt;">Bayliner - Chaparral - Four Winns - Jeanneau (Power Boats)</span><br /><br /><span style="font-size: 10pt;"><em>Exclusive North America Distributor (United States & Canada):<br /></em>DL Yachts Dreamline - 26 to 49 meters - Fiberglass / Aluminum Construction</span><br /><span style="font-size: 10pt;">Nuova Jolly - Europe's Leading Brand of <em>High-End</em> Inflatable Boats 5 - 13 meters</span></p>
<p style="text-align: center;"><span style="font-size: 10pt;">Three Locations - Open 7 Days a Week</span><br /><span style="font-size: 10pt;">New – Trades – Brokerage - Consignment / Flexible Financing</span><br /><span style="font-size: 10pt;">Export Worldwide - We speak English, French, Spanish & Russian</span></p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong>FORT LAUDERDALE <br /></strong><em>Sales - Service - Parts - Storage / Corporate<br /></em>4550 Anglers Avenue Fort Lauderdale, FL 33312</span><br /><br /><span style="font-size: 10pt;"><strong>DANIA BEACH <br /></strong><em>In Water Yacht Display<br /></em>320 North Federal Hwy Dania Beach, FL 33004</span><br /><br /><span style="font-size: 10pt;"><strong><strong>JUPITER <br /></strong></strong><em>Sales - Service - Marina<br /></em>19157 SE Federal Highway (at County Line Road) Jupiter, FL 33469</span><br /><br /><span style="font-size: 10pt;"><em>Like us on Facebook at </em>www.facebook.com/intermarineboats</span><br /><span style="font-size: 10pt;">Big Enough to Perform ...Small Enough to Care</span></p> |
[empty string] |
[empty string] |
Custom |
Aico |
<h2>Additional Specs, Equipment and Information:</h2>
<div class="two-col">
<dl>
<dt>Specs</dt>
<dd>Flag of Registry: Gibraltar (UK)<br />Hull Shape: Deep Vee</dd>
</dl>
<dl>
<dt>Dimensions</dt>
<dd>LOA: 98 ft 0 in<br />Beam: 11 ft 1 in<br />Maximum Draft: 3 ft 5 in<br />Displacement: 327800 lbs</dd>
</dl>
<dl>
<dt>Engines</dt>
<dd>Engine 1:<br />Engine Brand: CAT<br />Year Built: 2014<br />Engine Model: C32<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Location: Port<br />Engine Hours: 371<br />Drive Type: Direct Drive<br />Engine Power: 1825 HP<br /><br />Engine 2:<br />Engine Brand: CAT <br />Year Built: 2014<br />Engine Model: C32<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Location: Starboard<br />Engine Hours: 371<br />Drive Type: Direct Drive<br />Engine Power: 1825 HP</dd>
</dl>
<dl>
<dt>Tanks</dt>
<dd>Fresh Water Tanks: 1 (792 Gallons)<br />Fuel Tanks: 1 (6604 Gallons)</dd>
</dl>
<dl>
<dt>Accommodations</dt>
<dd>Number of single berths: 4<br />Number of double berths: 2<br />Number of cabins: 4<br />Number of heads: 4<br />Seating Capacity: 12</dd>
</dl>
<dl>
<dt>Electrical Equipment</dt>
<dd>Electrical Circuit: 220V</dd>
</dl>
<dl>
<dt>Outside Equipment/Extras</dt>
<dd>Total Liferaft Capacity: 12</dd>
</dl>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Accommodation</strong><br />
<p><strong>Number of cabins:</strong></p>
<ul>
<li>1 Master Cabin – Separate Bathroom</li>
<li>1 Vip Cabin – Separate Bathroom</li>
<li>2 Guest Cabins – Separate Bathroom</li>
<li>1 Crew Cabin – Separate Bathroom – 2 Berths</li>
<li>1 Small Workshop</li>
<li>1 Day Head</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Galley and laundry</strong><br />
<ul>
<li>Service bathroom.</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electronics and Navigation Equipment</strong><br />
<p><strong>HELM STATION:</strong></p>
<ul>
<li>Two GPS Raymarine G series</li>
<li>Two Command Autopilot ST70</li>
<li>Autopilot ST70 with two repeater </li>
<li>Steering Gear Control</li>
<li>Bow and Stern thruster</li>
<li>Compass</li>
<li>VHF Raymarine 240 E</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Flystation</strong><br />
<ul>
<li>One GPS Raymarine G series</li>
<li>One Autopilot Raymarine ST70</li>
<li>Autopilot ST70</li>
<li>VHF Raymarine 240 E</li>
<li>Bow and Stern thruster</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Cockpit Station</strong><br />
<ul>
<li>Control Station</li>
<li>Autopilot Control</li>
<li>Bow and Stern thruster</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electrical System</strong><br />
<ul>
<li>Bow thruster</li>
<li>Stern thruster</li>
<li>Water makers model C1600 - 25 Gal/Hour</li>
<li>Air Conditioning</li>
<li>Inverter</li>
<li>Sewage treatment plant</li>
<li>Fuel waste oil tank</li>
<li>Compressor Fire-fighting system in the engine room</li>
<li>Generator Kohler 33 Kw – hours 943</li>
<li>Kohler 20 Kw – hours 450</li>
<li>4 Raymarine Cameras</li>
<li>Antenna Tv</li>
<li>Phone System</li>
<li>Washer & Dryer</li>
<li>Ice maker in crew area</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Deck Equipment</strong><br />
<ul>
<li>Interior equipment Electric bilge pump Electric toilet Battery charger Manual bilge pump Catwalk Opacmare 3800</li>
<li>Hydraulic davit Opacmare – 1500 kg Displacement</li>
<li>2 Anchors for 200 kg each in stainless steel</li>
<li>2 Winches hydraulic</li>
<li>2Winches warping</li>
<li>Waterproof doors</li>
<li>Watertight doors</li>
<li>Camera and sub lighthouse</li>
<li>Searchlight</li>
<li>Electronic instrumentation</li>
<li>Dinghy Gommonautica G48</li>
<li>Engine Dinghy Honda 90 Hp Vtec – year 2014</li>
<li>Beach umbrella</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Other Features</strong><br />
<ul>
<li>Cockpit shower</li>
<li>Teak cockpit</li>
<li>Cockpit table</li>
<li>Hydraulic gangway</li>
<li>Cushions</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<p style="text-align: center;"> </p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong><em>offered by</em></strong><strong> <br /><span style="font-size: 14pt;">Inter</span></strong><span style="font-size: 14pt;"><em><strong>Marine Yacht </strong></em><strong>Group</strong><em><strong><br /></strong></em><span style="background-color: #ffff00;"><strong>Listing Broker: Mike Smalley, CPYB - Call 954.665.7138</strong></span></span><em><strong><br /></strong></em>email: mike@intermarineyachts.com / www.Intermarineyachts.com </span><br /><br /><span style="font-size: 10pt;"><em>Authorized Dealer:</em> Prestige Yachts - Monte Carlo Yachts (80', 86', 96' & 105')</span><br /><span style="font-size: 10pt;">Bayliner - Chaparral - Four Winns - Jeanneau (Power Boats)</span><br /><br /><span style="font-size: 10pt;"><em>Exclusive North America Distributor (United States & Canada):<br /></em>DL Yachts Dreamline - 26 to 49 meters - Fiberglass / Aluminum Construction</span><br /><span style="font-size: 10pt;">Nuova Jolly - Europe's Leading Brand of <em>High-End</em> Inflatable Boats 5 - 13 meters</span></p>
<p style="text-align: center;"><span style="font-size: 10pt;">Three Locations - Open 7 Days a Week</span><br /><span style="font-size: 10pt;">New – Trades – Brokerage - Consignment / Flexible Financing</span><br /><span style="font-size: 10pt;">Export Worldwide - We speak English, French, Spanish & Russian</span></p>
<p style="text-align: center;"><span style="font-size: 10pt;"><strong>FORT LAUDERDALE <br /></strong><em>Sales - Service - Parts - Storage / Corporate<br /></em>4550 Anglers Avenue Fort Lauderdale, FL 33312</span><br /><br /><span style="font-size: 10pt;"><strong>DANIA BEACH <br /></strong><em>In Water Yacht Display<br /></em>320 North Federal Hwy Dania Beach, FL 33004</span><br /><br /><span style="font-size: 10pt;"><strong><strong>JUPITER <br /></strong></strong><em>Sales - Service - Marina<br /></em>19157 SE Federal Highway (at County Line Road) Jupiter, FL 33469</span><br /><br /><span style="font-size: 10pt;"><em>Like us on Facebook at </em>www.facebook.com/intermarineboats</span><br /><span style="font-size: 10pt;">Big Enough to Perform ...Small Enough to Care</span></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] |
0 |
Off-Site Location |
5 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
24867 |
[empty string] |
5C7178C8-E295-A097-B3E7FBF744160E7A |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
http://www.intermarineboats.com/yacht-consignment/2014-Custom-98FT-Aico/1264 |
24 |
Template to add In-House Featured and Trade-In yachts |
2 |
In-House Featured and Trade-In |
2 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Mike |
Mike Smalley |
Smalley, Mike |
Smalley |
[empty string] |
[empty string] |
1264 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
|
SQL |
SELECT
yacht_data.yachtID,
yacht_data.isArchived,
yacht_data.templateREF,
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.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_data.fb_admins,
yacht_data.og_title,
yacht_data.og_type,
yacht_data.og_image,
yacht_data.og_url,
yacht_data.og_desc,
yacht_data.twitter_card,
yacht_data.twitter_site,
yacht_data.twitter_title,
yacht_data.twitter_desc,
yacht_data.twitter_image,
yacht_data.twitter_image_alt,
yacht_data.schema_name,
yacht_data.schema_desc,
yacht_data.schema_image,
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,
yc_data.askingPrice,
yc_data.loaMeters,
yc_data.vesselID,
yc_data.vesselLocation,
yc_data.yearBuilt,
yc_data.askingPriceFormatted,
yc_data.boatName,
yc_data.builder,
yc_data.currency,
yc_data.loaFeet,
yc_data.salesPerson,
yc_data.SalesPersonCellPhone,
yc_data.SalesPersonEmail,
yc_data.SalesPersonPhone,
yc_data.incSections,
yc_data.yPhotoLarge,
yc_data.yPhotoMedium,
yc_data.yPhotoSmall,
yc_data.ycSeoUrl,
yacht_photos.photoID,
yacht_photos.photoCaption,
yacht_model.mfrRef,
yacht_model.modelName,
yacht_mfr.mfrName,
userOffices.officeName
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 yc_data ON yacht_data.yatcoREF = yc_data.vesselID
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
LEFT JOIN userOffices ON yacht_data.officeREF = userOffices.officeID
WHERE ( yachtID = 1264 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |