| 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 |
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 |
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 |
OFFICEREF |
PHOTOCAPTION |
PHOTOID |
PRIORITY |
PRIORITY |
RANDOMSEED |
SEOPAGETITLE |
SEOPREVIEWTEXT |
SEOURL |
STAFFREF |
TEMPLATEDESC |
TEMPLATEID |
TEMPLATENAME |
TEMPLATEREF |
USERFIRSTNAME |
USERFULLNAME |
USERFULLNAME2 |
USERLASTNAME |
USERPHONE |
YACHTID |
YATCOREF |
| 1 |
11.28 |
[empty string] |
[empty string] |
[empty string] |
Pacific Seacraft |
37' |
1991 |
10' 10 |
4' 6 |
16,000lbs |
Fiberglass |
W.I.B. Crealock |
Yanmar |
44hp |
Sail |
Sweet Thing |
$104,900 |
Seabrooke Island, SC |
[empty string] |
[empty string] |
http://www.davidwaltersyachts.com/yacht-details.cfm?y=6255309 |
Stephen Reverand |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Cutter |
[empty string] |
[empty string] |
July 12, 2019 |
[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] |
LAB03INT,LAB28STR,LAB11STR,LAB12STR,LAB13STR,LAB14STR,LAB02STR,LAB03STR,LAB15STR,LAB01STR,LAB25STR,LAB01MEM,LAB03MEM,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB08STR,LAB19STR,LAB21STR,LAB20STR,LAB10STR,LAB18STR,LAB16STR,LAB22STR,LAB23STR,LAB24STR |
0 |
1 |
[empty string] |
1 |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
1 |
0 |
[empty string] |
[empty string] |
[empty string] |
Link to Virtual Tour |
Builder |
[empty string] |
[empty string] |
[empty string] |
Length |
[empty string] |
Sold Yacht |
Additional Info |
Year Built |
[empty string] |
[empty string] |
[empty string] |
Beam |
[empty string] |
[empty string] |
[empty string] |
Draft |
[empty string] |
[empty string] |
[empty string] |
Displacement |
[empty string] |
[empty string] |
[empty string] |
Hull |
[empty string] |
[empty string] |
[empty string] |
Designer |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
Power |
[empty string] |
Type (Sail or Power) |
[empty string] |
Yacht Name |
[empty string] |
Yacht Price |
[empty string] |
Location |
[empty string] |
Year Refit |
[empty string] |
Fuel Type |
[empty string] |
[empty string] |
[empty string] |
Engine Hours |
[empty string] |
Number of Engines |
[empty string] |
Engine Model |
Engine Manufacturer |
Holding Tank Capacity |
Fuel Tank Capacity |
Water Tank Capacity |
Model |
[empty string] |
[empty string] |
Selling Date |
[empty string] |
[empty string] |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
[empty string] |
[empty string] |
<p>"Sweet Thing" is a fine example of the exceptionally seaworthy W.I.B. Crealock designed Pacific Seacraft 37. Her double-furling cutter rig, canoe stern and her shoal draft keel make her ready to sail to the islands and beyond in comfort and style.</p>
<p>"The Crealock 37 is an attempt to provide the weekender and the cruising sailor with a boat which will travel fast between ports under complete control, and which will yet remind him that the passage itself should be one of the pleasures of the cruise." --W.I.B. Crealock, Designer</p>
<p>Step aboard "Sweet Thing" and you will immediately be struck by her solid construction and quality materials - from fine teak accents to heavy bronze opening port lights. Her many recent cruising upgrades include a linear auto helm, an offshore wind vane, a water maker, solar panels, heavy duty ground tackle and an electric windlass. She is not only stylish and comfortable, she is fully equipped and ready to go.</p>
<p><em><strong>April / May 2016 Additions & Services;</strong></em></p>
<ul>
<li>Kayden 80 E 3.5 GPH water maker</li>
<li>(2) 230 watt solar panels</li>
<li>Cape Horn Self Steering wind vane</li>
<li>Icom 802 SSB with Pactor modem</li>
<li>Xantrex Battery charger/inverter</li>
<li>4 new Lifelene 80 Amp hour AGM batteries.</li>
<li>Lofrans Tigress electric windless</li>
</ul>
<ul>
<li>Rocna 25 kg anchor, 140' 3/8 BBB chain 200' 5/8 braid rope rode.</li>
<li>Fortress FX 37 anchor W/25' 3/8' chain and 200' 5/8' 3 strand rope rod</li>
<li>Sanitation hoses replaced and head rebuilt.</li>
<li>Hauled, bottom painted, aft cut less bearing replaced, prop balanced., new zincs</li>
<li>Full engine service, including filters, fluids, impeller, etc</li>
</ul>
<p> <em> <strong>Other Notable Features;</strong></em></p>
<ul>
<li>
<p>Raymarine C120 Chartplotter w/Radar</p>
</li>
<li>Autopilot Autohelm ST6000 Linear Drive</li>
<li>Edson Teak Cockpit Table with Folding Leaves</li>
<li>Lewmar Folding Helmsman's Wheel</li>
<li>2012 Achilles Hard Bottom Dinghy w/Custom Cover, available</li>
<li>2012 Suzuki 4HP Four Stroke Outboard w/Custom Cover, available</li>
</ul>
<div class="two-col">
<dl>
<dt>Dimensions</dt>
<dd>LOA: 36 ft 11 in<br />Beam: 10 ft 10 in<br />LWL: 27 ft 9 in<br />Maximum Draft: 4 ft 10 in<br />Displacement: 16000 lbs Dry Load<br />Ballast: 6200 lbs<br />Bridge Clearance: 47 ft 10 in</dd>
</dl>
<dl>
<dt>Engines</dt>
<dd>Engine 1:<br />Engine Brand: Yanmar<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 2750<br />Propeller: 3 blade propeller<br />Engine Power: 44 HP</dd>
</dl>
<dl>
<dt>Tanks</dt>
<dd>Fresh Water Tanks: (95 Gallons)<br />Fuel Tanks: (40 Gallons)<br />Holding Tanks: (12 Gallons)</dd>
</dl>
<dl>
<dt>Accommodations</dt>
<dd>Number of single berths: 1<br />Number of double berths: 2<br />Number of cabins: 2<br />Number of heads: 1</dd>
</dl>
<dl>
<dt>Outside Equipment/Extras</dt>
<dd>Electric windlass</dd>
</dl>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Accommodations</strong><br />
<p>Although she is built to sail in even the most challenging conditions "Sweet Thing" is remarkably roomy and comfortable below decks. The welcoming companionway leads to a generous U-shaped galley to starboard. To port, there is a navigation station with upgraded electrical panels and an ample quarter berth. The main salon boasts stunning teak joinery work, six solid bronze opening port lights, a large Bomar hatch, a folding teak dinette table and plush Ultra leather upholstery. The starboard settee easily converts to a double berth. The head is forward to starboard with two large louvered hanging lockers to port. The master stateroom is forward, with a roomy offset double berth and a dressing seat which also serves as easy passage into and out of the berth. Three large opening ports and a Bomar hatch provide plenty of light and ventilation. The overall feel is that of comfortable quality which is enhanced by the lovely teak and holly sole throughout.</p>
<ul>
<li>Teak Joinery Throughout; Teak & Holly Cabinsole</li>
<li>Sleeps 6</li>
<li>UltraLeather Interior Cushions (New 2010)</li>
<li>Soft Vinyl Headliner with Zippers to Access Hardware and Wiring</li>
<li>Chelsea- Boston Series Barometer</li>
<li>6'4" Headroom<br /><br /></li>
</ul>
<p> </p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Galley</strong><br />
<p>The U-Shaped galley to starboard is set-up to please even the most discriminating onboard chef. There is a large double stainless sink, a gimballed stainless propane oven and stove, two cutting boards, and is is the case throughout this boat, there is ample storage in lockers accessed by louvered teak doors. 12v refrigeration cools the two-compartment ice box.</p>
<ul>
<li>Sea Frost 12V Refrigeration (New 2011)</li>
<li>Force 10 Stainless Steel 2-Burner Gimballed Propane Stove/Oven with 2 tanks</li>
<li>Hot/Cold Pressure Water</li>
<li>Deep 10" Double SStainless Steel Sinks</li>
<li>Manual Sea Water Foot Pump</li>
<li>Manual Fresh Water Foot Pump </li>
<li>Teak Spice Rack</li>
<li>Teak Serving Tray</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electronics and Navigation</strong><br />
<ul>
<li>Raymarine C120 Chartplotter w/Radar</li>
<li>Raymarine Radar Dome</li>
<li>Raymarine ST40 Depth</li>
<li>Icom 802 SSB with Pactor Modem (New 5/2016)</li>
<li>VHF ICOM-IC-M502</li>
<li>ICOM Commander Mic II</li>
<li>Autopilot Autohelm ST6000 Linear Drive</li>
<li>Comnav Wind Instruments</li>
<li>Clarion M/09 Radio and CD with 2 Bose Speakers</li>
<li>Toshiba Flatscreen TV</li>
<li>Compass Ritchie Globemaster SP-5<br /><br /></li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electrical</strong><br />
<p> </p>
<p> </p>
<ul>
<li>(2) 230 Watt Solar Panels (New 5/2016)</li>
<li>(4) Lifeline Group 31 AGM batteries (New 5/2016)</li>
<li>HR 1800 battery charger / inverter 1000W (New 5/2016)</li>
<li>500 Watt Inverter </li>
<li>Lightning Ground System</li>
<li>Hitachi 80 Amp Alternator</li>
<li>Second Battery Switch</li>
<li>(2) Marinco 50' Shore Power Cables</li>
<li>12V LED/110V Lighting and Receptacles</li>
<li>GFCI Protection</li>
<li>Hella Cabin Fans</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Mechanical</strong><br />
<p>"Sweet Thing"s 44 HP Yanmar diesel is smooth, quiet and has plenty of power. With the companionway ladder and cover removed the engine access is excellent. A removable hatch cover in the cockpit sole provides excellent access to the top of rear of the engine which is clean and has been consistently professionally maintained.</p>
<ul>
<li>Kayden 80E 3.5 GPH water maker (New 5/2016)</li>
<li>Crusair Reverse Cycle Heat/Air</li>
<li>Yanmar 44 HP Diesel (Full service 5/2016)</li>
<li>New Motor Mounts (2013)</li>
<li>New Oil Cooler (2013)</li>
<li>Fresh Water Cooling System</li>
<li>Racor Fuel Filter</li>
<li>Engine Fuel Shut Off Valve</li>
<li>Emergency Engine Stop/Alarm </li>
<li>Engine Room Sound Insulation</li>
<li>Gronco Manual Head, rebuilt and sanitation hoses replaced 4/2016</li>
<li>Y Valve</li>
<li>Automatic Electric Bilge Pump</li>
<li>Electric Shower Sump Pump</li>
<li>Fiberglass Fuel Tank Under Cabin Sole w/Fuel Gauge</li>
<li>Emergency Tiller</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Sails and Rigging</strong><br />
<ul>
<li>Full Battened Mainsail</li>
<li>110% Furling Headsail</li>
<li>Furling Staysail</li>
<li>Asymmetrical Spinnaker</li>
<li>Mack Pack w/Lazy Jacks for Main Sail</li>
<li>Profurl NC42 Roller Furling Headsail Stay</li>
<li>Profurl Roller Furling Staysail Stay</li>
<li>Running Backstays</li>
<li>Mainsail, staysail and headsail removed May 2016 and fully inspected / repaired by a sail loft.</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Construction and Deck</strong><br />
<p>"Sweet Thing" is a heavily built offshore cruiser, with an external solid lead, Scheel keel (shoal draft 4'6"), and skeg hung rudder, solid glass hand laid up hull, cast reinforced Bowmar hatches and solid bronze port lights. Her rudder has large skeg and bronze propeller is in a protected aperture. Hauled in April 2016, new bottom paint, cutlass bearing and prop balanced.</p>
<ul>
<li>Two Lewmar #46 ST Bronze Primary Winches</li>
<li>Three Lewmar #16 ST Bronze Winches on Cabintop</li>
<li>Two Lewmar #16 ; One-Lewmar #8 Bronze Winches</li>
</ul>
<ul>
<li>Lofrans Tigress electric windlass (New 5/2016)</li>
<li>Rocna 25 kg primary anchor w/ 140' 3/8 BBB chain and 200' 5/8 braid rope rode (New 5/2016)</li>
<li>Fortress FX 47 secondary anchor w/25' 3/8 chain and 200' 5/8 3 strand rope rode (New 5/2016)</li>
<li>Cape Horn Self Steering Wind Vane (New 5/2016)</li>
<li>Garhauer Solid Vang</li>
<li>Lewmar Folding Wheel</li>
<li>Bronze Opening Ports w/ Screens (10)</li>
<li>29" High Double Lifelines and Stainless Steel Stanchion</li>
<li>Life Sling Recovery System</li>
<li>Edson Teak Cockpit Table with Folding Leaves</li>
<li>Swim ladder</li>
<li>SS Mast Rails (Sissy Bars)</li>
<li>Dorade Vents</li>
<li>Forespar Whisker Pole Chocks</li>
<li>(2) Adjustable cockpit seats (New 2016)</li>
<li>(2) Propane #20 Aluminum Tank</li>
<li>Dodger/Bimini/Connector (New 2014)</li>
<li>Outland Hatch Covers</li>
<li>Rail Mounted Propane Grill</li>
<li>Outboard Motor Hoist </li>
<li>Navigation Lights</li>
<li>Vetus Cowls</li>
<li>Cockpit Canvas Cover</li>
<li>Teak Drop Boards for Companionway</li>
<li>Custom Saloon Doors for Companionway</li>
<li>Cockpit Cushions</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Comments</strong><br />
<p>"Sweet Thing" is a beautiful example of the Pacific Seacraft 37 that has been afforded excellent care and numerous upgrades. All original documents and manuals including original factory equipment and dealer installed options list have been maintained with the vessel. She is seriously for sale and is definitely one of the nicest 37's on the market in turn-key cruise ready condition awaiting her new owners.</p>
</td>
</tr>
</tbody>
</table>
</div> |
[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] |
9247 |
[empty string] |
[empty string] |
0DDF9B6D-0AD8-35D3-703274E9CD67D4E5 |
[empty string] |
[empty string] |
https://www.davidwaltersyachts.com/Sail/37-Pacific-Seacraft-1991/528 |
11 |
The default yacht template for David Walters Yachts |
1 |
Brokerage |
1 |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
528 |
[empty string] |
|
| SQL |
SELECT
yacht_data.templateREF,
yacht_data.isArchived,
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.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.userPhone,
users.userFirstName + ' ' + users.userLastName AS userFullName,
users.userLastName + ', ' + users.userFirstName AS userFullName2,
yacht_photos.photoID,
yacht_photos.photoCaption,
yacht_photos.priority,
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 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 ( yachtID = 528 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |
