| 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 |
14.33 |
[empty string] |
[empty string] |
[empty string] |
Moody |
47' |
1985 |
14'6 |
4'9 |
29,000lbs |
Fiberglass |
Bill Dixon |
Perkins |
85hp |
Sail |
Sirius |
$168,000 |
Fort Lauderdale |
[empty string] |
[empty string] |
http://www.davidwaltersyachts.com/yacht-details.cfm?y=6156004 |
George Eberhard |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
December 22, 2017 |
$160,000 |
George Eberhard |
[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] |
0 |
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>Sirius is one of those boats that has been improved well beyond any competitor. She is ready to go cruising with incredible upgrades all within the last couple years. She has an impressive list of equipment leaving you nothing to add before you head off on your next adventure. Sirius is a must see for any couple wishing to go cruising on a fast well designed, Bill Dixon cruiser.</p>
<p>Her incredible custom dinghy lift enables easy access on and off with scuba gear as well as dinghy launching. Before buying a cruising boat in this category you must see SIRIUS! </p>
<p> </p>
<div class="two-col">
<dl>
<dt>Specs</dt>
<dd>Builder: Moody<br />Designer: Bill Dixon<br />Flag of Registry: United States</dd>
</dl>
<dl>
<dt>Dimensions</dt>
<dd>LOA: 46 ft 6 in<br />Beam: 14 ft 6 in<br />LWL: 38 ft 9 in<br />Minimum Draft: 4 ft 9 in<br />Displacement: 29000 lbs<br />Ballast: 13000 lbs</dd>
</dl>
<dl>
<dt>Engines</dt>
<dd>Engine 1:<br />Engine Brand: Perkins<br />Year Built: 1985<br />Engine Model: 4.236 FWC<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 3779<br />Engine Power: 85 HP</dd>
</dl>
<dl>
<dt>Tanks</dt>
<dd>Fresh Water Tanks: Stainless steel (140 Gallons)<br />Fuel Tanks: Stainless steel (84 Gallons)<br />Holding Tanks: Plastic (30 Gallons)</dd>
</dl>
<dl>
<dt>Accommodations</dt>
<dd>Number of twin berths: 1<br />Number of double berths: 2<br />Number of cabins: 2<br />Number of heads: 2</dd>
</dl>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Interior Accommodations</strong><br />
<p>Starting forward the guest head is finished in white Formica with teak trim, stainless steel sink, hot and cold pressure water, telephone type shower and Jabsco Quiet Flush electric head. The opening hatch overhead includes a Nicro-Fico solar vent. A teak door leads aft to the forward cabin. This very comfortable forward cabin has teak access doors both forward and aft. There’s a large offset double berth to starboard and a single berth to port with significant storage below both bunks. There are two overhead opening hatches that afford great ventilation and natural light. To starboard and forward of the double berth is a large hanging locker with double doors. To port a cedar lined locker with shelves at the forward end of the single berth. Both lockers have storage above. In addition there are three large storage lockers outboard on the port and starboard sides.</p>
<p>Aft from the forward stateroom through the varnished teak door is the main salon with a huge dinette with extendable table that seats 8 or more. The main bulkhead has beautiful stainless lamps, a stainless clock and barometer. The off white Ultra-suede fabric-covered dinette cushions make for a neutral appearance. Outboard starboard are teak bookshelves, a storage locker and liquor locker. </p>
<p>The large walk-through galley is aft to starboard with white laminate counter tops. To port aft of the settee is a forward facing navigation station with a swivel arm seat, full instrumentation, and a large chart table.</p>
<p>Moving aft on the port side of the vessel and through a door is the head for the aft cabin finished in white Formica, outboard of the vanity and above the head are storage lockers. There is a Jabsco Quiet Flush Electric head with Electrosan waste treatment system. The separate stall shower with seat includes storage locker under and outboard of the seat. </p>
<p>The main entrance to the full-width master stateroom is aft of the galley. There is a large centerline double berth with a custom Ultimate memory foam/latex mattress. Storage lockers with bookshelves are port and starboard. The cabin sides and cabinetry are all gloss varnish. Outboard and to starboard are two large hanging lockers. The aft bulkhead has a beveled mirror. On the starboard side of the berth is an L-shaped seat and behind and below is more storage.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Galley</strong><br />
<ul>
<li>Double stainless steel sinks with hot and cold pressure water</li>
<li>Fresh hand pump at sink</li>
<li>Electric salt water pump at sink</li>
<li>Gimbaled Shipmate 3-burner stainless steel stove and oven with broiler</li>
<li>Seafrost 12V refrigerator and freezer, refurbished 2015</li>
<li>Seafrost compressor / control panel, 2014</li>
<li>Solenoid switch for propane</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Navigation Equipment and Electronics</strong><br />
<p>Great navigation station for a cruising sailboat. The electrical panel is located here as well.</p>
<ul>
<li>Simrad autopilot with cockpit remote (new 2005/2013 update)</li>
<li>Raymarine C series HD Color Radar/Chart plotter system dual display 9” at chart table and 12” on deck (new 2013)</li>
<li>Garmin Nema 2000 (4) GMI 20 navigation screens, 2015</li>
<li>Triducer- depth, water temperature, water speed, 2015</li>
<li>ICOM M802 marine SSB, 2015</li>
<li>Raymarine AIS transmit/ receiver, 2015</li>
<li>Raymarine HD radar, 2013</li>
<li>All GPS are wired to feed computer navigation</li>
<li>West Marine VHF radio [2007] with wireless remote mic with antenna on top of mast</li>
<li>West Marine hand held VHF</li>
<li>Alpine AM/FM/Sirius radio with CD player with 12-disc changer, with individual speaker controls</li>
<li>ProSine 2.0 inverter/charger (2002) ACR 406MHZ GPS EPIRB global 6 pro, (2015)</li>
<li>SEA SSB radio with automatic tuner</li>
<li>Plath recording barometer</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Electrical</strong><br />
<ul>
<li>Engine panel, engine gauges & wiring, 2014</li>
<li>Engine Starter 2015</li>
<li>Three Kyracera 140 watt solar panels, 2014-15</li>
<li>Fresh water tank gauge and meter, 2016</li>
<li>Fuel sending unit and gauge, 2014</li>
</ul>
<p>12 volt and 110 volt electrical systems and electrical panel with circuit breakers:</p>
<p><em>12 volt DC electrical system includes –</em></p>
<ul>
<li>(3x) AGM 600 watt house batteries, 2017</li>
<li>(2x) AGM engine start batteries (2015)</li>
<li>AGM generator battery (2015)</li>
<li>Two high power alternators (245 amp /135 amp) on engine set up to separately charge house/start bank with individual external smart regulators (new 2014).</li>
<li>Victron amp hour meter/battery monitor</li>
</ul>
<p><em>110 volt AC electrical system includes:</em></p>
<ul>
<li>(1x) 50’ X 30-amp 125V dockside electrical cables (new 2017)</li>
<li>Fail Safe galvanic isolator (2013)</li>
<li>Multiple adaptors for shore power cable</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Engine and Mechanical</strong><br />
<p>Perkins 4.236 FWC 85 hp diesel engine with approximately 3779 engine hours, Dual Racor fuel filters with electric priming/bleed/fuel polishing pump, 1½” stainless steel shaft with new PSS dripless shaft seal and shaft log rebuilt in 2016), new motor mounts (2013), all realigned in 2016. MaxProp 3-blade (serviced 2016). Easy access to engine is through a large door to the engine room from the galley and moveable engine cover in galley (redisgned 2014). A hydraulic centerboard lift is operated by an electric motor or a back up hand pump.</p>
<ul>
<li>Phasor 4.5 KW generator (29 hours), 2015</li>
<li>Marine Air 16,000 BTU Dometic air handler, 2013</li>
<li>Marine Air 10,00 BTU, 2014 </li>
<li>A/C & generator seacocks, 2014</li>
<li>Spectra Ventura 200T watermaker, 2014</li>
<li>Watermaker seacock, 2014</li>
<li>Raritan water heater, 2015</li>
<li>Raritan Electro Scan Treatment, 2013</li>
<li>Fresh water multi fixture pump, 2017</li>
<li>Superwind feathering prop wind generator, 2015</li>
<li>(2) Jabsco quiet flush electric toilets, 2013</li>
<li>12V hydraulic wireless dinghy lift, 2017</li>
<li>Edson Wheel, steering cable replaced in 2014</li>
<li>Shaft log, dripless shaft seal, flex coupler, 2016</li>
<li>Cutlessbearing, 2016</li>
<li>Max prop serviced in 2016</li>
<li>Electronic fuel pump, 2015</li>
<li>Engine Impeller, raw water pump, fresh water pump, 2016</li>
<li>Two alternators, 245amp & 135amp & belts, 2014</li>
<li>Perko engine strainer & seacock, 2014</li>
<li>Engine & running gear alignment, 2016</li>
<li>Fuel shut-off valves</li>
<li>Manual bilge pumps</li>
<li>Redesigned front engine box with access doors, 2014</li>
<li>Automatic fire extinguisher system in engine room</li>
<li>Engine room bilge blower</li>
<li>Electric bilge pumps with alarm, 2014</li>
<li>(5) Portable fire extinguishers, 2016</li>
<li>Brownie's Third Lung rebuilt in 2014</li>
<li>A very extensive spare parts inventory is included</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Hull and Deck</strong><br />
<p>CONSTRUCTION</p>
<p>Sirius is a British built center cockpit ocean cruising sloop with shoal draft keel, hydraulic retractable keel/centerboard and a skeg hung rudder. Whisper Grey Interlux hull(2002), Interlux white decks (2015) and house. Three coats of Black Trinidad SR bottom paint 2016, red shear stripes. Hull has stiffeners per Lloyds recommendations. Fiberglass hull, decks, and low profile coach roofs have core in places for extra strength where needed. Stainless exterior grab rails.</p>
<p>DECK EQUIPMENT</p>
<p>Fiberglass nonskid deck repainted with Awlgrip 2015. Anodized aluminum toe rail. Stainless handrails. Aft of the double stainless bow roller is the below deck windlass with chain locker. Tigress manual/electric windlass with up and down switches on both the foredeck and the cockpit, new 2014. Aft of the windlass is a very large sail/storage accessed by a large Lewmar deck hatch. Two large aft lazarette hatches one for Propane the other contains the Phasor 4.5 KW generator, 29 hours, 2015. Large center cockpit with teak seats and teak cockpit sole replaced in 2001.</p>
<p>Pedestal steering with stainless wheel, Weems & Plath compass, single engine controls, and autopilot with remote. SIRIUS has a Superwind feathering prop wind generator (2015) and three Kyracera 140 watt solar panels (2014/2015)</p>
<ul>
<li>Trinidad SR bottom paint, 3 coats in 2016</li>
<li>Refurbished decks, 2015-2016</li>
<li>Lofrans tigress windlass with new heavy wiring to nav station, foot controls forward & wireless control from cockpit, 2014</li>
<li>Dual bow roller with mechanical lock for anchor and a removable bowsprit.</li>
<li> ATN Tacker and sleeve for spinnaker, 2014 </li>
<li>Mantus 85lbs anchor with 300' of 5/16 galvanized anchor chain (2017)</li>
<li>Fortress FX 37 20' chain, 250' of rode on deck in custom roller</li>
<li>Centerboard System refurbished 2014</li>
<li>Stainless steel 85 gallon diesel fuel tank</li>
<li>Two 70 gallon stainless steel water tanks </li>
<li>Fuel tank polishing in 2014</li>
<li>Dock lines and spring lines</li>
<li>Fenders</li>
<li>Fender board</li>
<li>6 hatch covers, 2014</li>
<li>Solid Acrylic hatch board</li>
<li>Stainless stern and bow pulpits</li>
<li>Stainless steel stanchions with port and starboard double lifelines and gates</li>
<li>Wireless LED spotlights forward and aft, 2014</li>
<li>Snubber Harness, 2014</li>
<li>Flag, ensign pole and socket</li>
<li>BBQ Magma with cover</li>
<li> (4) Dorade vents </li>
<li>Lewmar hatches with newer Lexan and gaskets</li>
<li>Oversized aluminum cleats</li>
<li>Oversize midship cleats</li>
<li>Custom Mystic stainless folding midships boarding ladder can be mounted either side</li>
<li>Shroud Shooter – powered rigging cutters</li>
<li>Varnished teak cockpit table</li>
<li>Stereo speakers</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Sails and Rigging</strong><br />
<p>Great equipment for running short handed with control lines led aft. Selden mast stepped on deck. Double spreader rig with mechanical vang and separate preventer. Stainless steel 1 x 19 standing rigging with Norseman mechanical fittings all replaced 2001 (deck toggles replaced 2013). Furlex head stay furling. Harken Battcar mainsail with Stack Pac and lazy jacks replaced in 2014. Separate staysail track. Mast is rigged with 2 jib halyards, 2 main halyards (primary led aft), spinnaker halyard (led aft), staysail halyard. There is also a custom stainless bowsprit for the asymmetrical cruising spinnaker. A hydraulic tensioned inner forestay is fitted for use with staysail or storm sail. Running backstays are fitted. Sirius has a custom tall rig, which provides excellent sailing performance even in light air.</p>
<ul>
<li>Standing & Running Rigging, 2014</li>
<li>Redesigned cockpit reefing system, preventer New England Dyneema line, 2016</li>
<li>Mack sails- mainsail, 135 genoa & spinnaker, 2014</li>
<li>Inner forestry storm sail refurbished in 2014</li>
<li>Harken mainsheet traveler control aft of cockpit </li>
<li>Stack pack & lazy jacks, 2014</li>
<li>Harken Genoa tracks with adjustable cars </li>
<li>(8) Spinlock line clutches for all aft lead control lines</li>
<li>All deck blocks except genoa turning blocks replaced with Harken Black Magic blocks </li>
<li>Primary halyards and all running rigging replaced in 2014</li>
<li>Main halyard</li>
<li>Stainless steel mast pulpit</li>
</ul>
<p>Winches include:</p>
<ul>
<li>All winches serviced in 2014</li>
<li>(2) Lewmar 65 primary winches</li>
<li>(2) Lewmar 44 secondary winches</li>
<li>(2) Lewmar 40 mainsheet winches (2001)</li>
<li>(1) Harken 40 electric utility winch (use for halyards etc.)</li>
<li>(3) Lewmar winches on mast for secondary halyards</li>
<li>Winch Rite cordless winch handle</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Canvas</strong><br />
<ul>
<li>Wave Stopper hard dodger</li>
<li>New full cockpit enclosure, 2014, fully redesigned</li>
<li>Canvas awnings, 2014</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Safety</strong><br />
<ul>
<li>Achilles 10'4" dinghy with Yamaha 20hp four stroke, 2014</li>
<li>Dinghy Canvas Cover, 2014</li>
<li>ACR 406 MHz gps EPIRB, 2016</li>
<li>Life sling</li>
<li>Galerider drogue</li>
<li>(6) Life jackets (Type 2)</li>
<li>Flare kit</li>
<li>Emergency tiller</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Closing Remarks</strong><br />
<p>Sirius is a remarkable boat with more upgrades than any other boat in this category. She’s fully equipped and cruise ready. With her recent electronic upgrades, 200 gallon per day water maker, wireless 12V dinghy lift, Phasor 4.5Kw generator, Superwind wind generator, new house batteries, updated cockpit enclosure and Bimini she’s ready for blue water. Owner is done cruising and motivated. Bring all offers!</p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Exclusions</strong><br />
<p>Portable microwave, ice maker, toaster oven, all bedding, pillows and fishing rods ALONG WITH ALL PERSONAL BELONGINGS.</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] |
5237 |
[empty string] |
[empty string] |
B8B9239E-B37B-3EAD-10A445057849F995 |
[empty string] |
[empty string] |
https://www.davidwaltersyachts.com/Sail/47-Moody-1985/501 |
1 |
The default yacht template for David Walters Yachts |
1 |
Brokerage |
1 |
Michael |
Michael Cummins |
Cummins, Michael |
Cummins |
954 527 0457 |
501 |
[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 = 501 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |
