| 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 |
9.45 |
[empty string] |
[empty string] |
[empty string] |
Pacific Seacraft |
31' |
2006 |
9' 10 |
4' |
11,000lbs |
Fiberglass |
W.I.B. Crealock |
Yanmar |
28hp |
Sail |
Bella Luna |
$109,000 |
Solomans Island, MD |
[empty string] |
[empty string] |
[empty string] |
Bernie & Kate |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
[empty string] |
March 22, 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] |
<div class="two-col">
<dl>
<dt>Specs</dt>
<dd>Designer: W.I.B. Crealock<br />Hull Shape: Monohull</dd>
</dl>
<dl>
<dt>Dimensions</dt>
<dd>LOA: 31 ft 0 in<br />Beam: 9 ft 10 in<br />LWL: 24 ft 2 in<br />Maximum Draft: 4 ft 0 in<br />Displacement: 11000 lbs<br />Ballast: 4400 lbs<br />Headroom: 6 ft 2 in<br />Dry Weight: 11000 lbs</dd>
</dl>
<dl>
<dt>Engines</dt>
<dd>Engine 1:<br />Engine Brand: Yanmar <br />Year Built: 2006<br />Engine Model: 3YM30F<br />Engine Type: Inboard<br />Engine/Fuel Type: Diesel<br />Engine Hours: 1400<br />Engine Power: 28 HP</dd>
</dl>
<dl>
<dt>Tanks</dt>
<dd>Fresh Water Tanks: (65 Gallons)<br />Fuel Tanks: (23 Gallons)<br />Holding Tanks: (15 Gallons)</dd>
</dl>
</div>
<div>
<table border="0">
<tbody>
<tr>
<td><br /><strong>Full Specifications</strong><br />
<p><strong>Accommodations</strong></p>
<p>This sought after Pacific Seacraft 31 is a perfect cruising yacht for a single hander, couple, or small family. The traditional interior features rich, hand-rubbed teak with light fiberglass accents. Ten large Hood opening port-lights and a deck hatch provide plenty of light and excellent ventilation.</p>
<p>The ambiance of this traditional cruiser is pleasing; and, for her size, she is spacious due to the innovative open layout. Starting forward is a 6'6” long V-berth complete with shelves and cabinets on the sides and forward, and drawers underneath. This is a large double berth with cabinetry on each side and stowage outboard. Just aft of the double berth is the main salon with two settees which double as sea berths 7' in length when the footwell is used. You often don’t have seven foot berths even on a much larger vessel. And that foot well is a secure place to put many things including your laptop while underway.</p>
<p>A large dining table slides out from beneath the V-berth to seat four comfortably. Because it disappears completely under the V-berth when not in use, the salon is open and spacious feeling with room to walk around. The grey-blue upholstery is in excellent condition, essentially new condition due to light usage and the slip covers. Further aft and to starboard is the nav station which features a large chart table cleverly built over the large refrigerator and freezer. It actually is larger than the refrigerator on many larger boats. The 12 volt refrigeration system works brilliantly. The chart table on top of the refrigerator has a small tilt-out drawer in addition to a large dedicated paper chart drawer. There is a gooseneck chart light that has a red as well as white light option over the chart table.</p>
<p>To port and aft of the galley is a huge double berth that provides accommodations for guests or incredible storage. You can use plastic bins and take all the ship’s stores you need for a winter deep in the Bahamas! The enclosed head is conveniently located immediately to starboard of the companionway stairs for easy access to remove wet gear when going off watch. The head is equipped with a faucet shower, sump pump, and wet locker. All available space has been ingeniously used for storage, which is impressive in capacity for a yacht of this size.</p>
<p>She is comfortable for four for a week and can sleep six if you use all the berths. For a cruising couple she is completely comfortable and easy to handle. She is a very nice little cruiser that will not cost you an arm and leg to maintain!</p>
<ul>
<li>Open plan interior provides loads of space with ample light and ventilation</li>
<li>Sleeps six! Vberth, double quarter berth and salon settee berths</li>
<li>Enclosed head with faucet type shower</li>
<li>Forward: V-berth, wider than a queen bed at the top, more than adequate storage beneath, on the side rail and in the deep teak lockers.</li>
<li>Salon has 7’ settees with storage below, behind, and above, including upgraded teak lockers</li>
<li>Each bookshelf contains 3 DC outlets for charging and for moveable fan</li>
<li>Galley: Two burner Force 10 propane stove with oven and broiler</li>
<li>Standing nav station houses chart storage</li>
<li>Large SeaFrost refrigerator with custom freezer compartment </li>
<li>Hanging locker adjoins nav table</li>
<li>Wet locker adjoining head</li>
<li>Head with ample storage and sink. Faucet pulls out to shower. Sump drains shower.</li>
<li>Aft port quarter has a double berth that sleeps two and has locker and outboard storage</li>
<li>Salon head room: 6’2”</li>
<li>Salon Seating for six</li>
<li>Dining table slides out from under the V-berth </li>
<li>Cushions are in excellent condition with upholstery protected by slip covers in salon and quarter berth</li>
<li>Interior is oiled teak in excellent condition</li>
<li>Reading lamps and overhead dome lights</li>
<li>Red and white light at the chart table</li>
<li>Teak and holly cabin sole in excellent condition</li>
<li>Stand up Nav Station is large, oiled teak with fold-out drawer and chart storage</li>
<li>Ten opening ports, two large opening deck hatches and two dorades</li>
</ul>
<p><strong>Galley</strong></p>
<ul>
<li>Perfect offshore galley at the bottom of the companionway to port</li>
<li>Great storage for dishes and provisions</li>
<li>Force 10 two-burner propane stove with oven and broiler</li>
<li>Double stainless steel sinks</li>
<li>Custom flip up additional counter space</li>
<li>Formica counter tops</li>
<li>Hot and cold pressurized water</li>
<li>Foot pump for fresh water</li>
<li>Foot pump for sea water</li>
<li>Abundant counter space with large butcher block cutting board</li>
<li>Abundant storage for provisions, pots & pans, and cooking utensils</li>
<li>SeaFrost BD3 12v refrigerator with custom freezer section</li>
<li>Water heater</li>
<li>BBQ grill</li>
<li>Propane storage locker with a ten pound propane tank, pressure, gauge and solenoid</li>
</ul>
<p>Plumbing</p>
<ul>
<li>Enclosed head aft to starboard</li>
<li>Toilet is Jabsco 29120-3000 Twist 'n' Lock</li>
<li>Hoses have been replaced as necessary</li>
<li>Y Valve for direct overboard flush</li>
<li>Holding tank</li>
<li>Deck pump out for holding tank</li>
<li>Overboard pump out with macerator</li>
<li>Shower type faucet with sump pump in head</li>
<li>Sink in head with mixing faucet & pressure hot/cold</li>
</ul>
<p><strong>Electronics</strong></p>
<ul>
<li>Nav pod at the helm low enough to easily see over</li>
<li>GPS 741C Chart plotter with a mount on the binnacle three years old </li>
<li>Raymarine ST60 masthead wind instrument with display in center pod</li>
<li>Raymarine Tridata ST60 knot meter and depth sounder with repeater at nav station</li>
<li>Ritchie binnacle compass SP5</li>
<li>ICOM 502 VHF fixed mounter</li>
<li>Handheld VHF</li>
<li>VHF Masthead antenna</li>
<li>DC outlet at the helm</li>
<li>Cantalupi Red and White light over nav station</li>
<li>Windex on the masthead</li>
<li>Wifi booster antenna</li>
<li>Clock</li>
<li>Temperature and Hygrometer</li>
</ul>
<p><strong>Electrical</strong></p>
<p>Electrical system is designed for comfort while cruising the Chesapeake with 12volt refrigeration. It is comprised of an upgraded 400 amp hour battery bank with brand new house batteries and is charged with an upgraded 80 amp alternator on the main engine. A Xantrex Freedom 15 inverter/charger provides shore power charging and inverting.</p>
<p>12 Volt System:</p>
<ul>
<li>House system upgraded with 400 amp hours of batteries new in 2017</li>
<li>Two 4D Lifeline AGM batteries for the house bank</li>
<li>Engine Start battery Group 27</li>
<li>Link 10 battery monitor</li>
<li>BlueSea battery switch</li>
<li>Upgraded 80 amp alternator</li>
<li>Upgraded Max Charge voltage regulator (“smartest” one on the market in 2011)</li>
<li>12 Volt Electrical Panel</li>
<li>Tricolor masthead light</li>
<li>Nav lights</li>
<li>Cabin lights</li>
<li>Bilge pumps (two)</li>
<li>Electronics</li>
<li>Sea Frost refrigeration</li>
<li>Four Hella fans installed, plus two portable Hella fans designed to mount in various places</li>
<li>Several 12v connections for various items needing charging and portable fans</li>
</ul>
<p>110 Volt Shore Power System:</p>
<ul>
<li>30 Amp Shore power connection</li>
<li>AC Breaker Panel</li>
<li>15 amp Xantrex smart battery charger/inverter</li>
<li>Shore power connection and shore power cord</li>
<li>GFCI 110 outlets in galley, and head</li>
<li>Additional 110 outlets in the VBerth, at the chart table, and aft to port</li>
<li>Inverter 1500 watts</li>
</ul>
<p><strong>Engine</strong></p>
<ul>
<li>Yanmar 3YM30 fresh water cooled 28hp diesel engine</li>
<li>Under 700 hours and solid maintenance history</li>
<li>Upgraded with 80 am alternator</li>
<li>Engine instruments with tachometer and Plexiglas cover</li>
<li>Single lever engine control</li>
<li>Electric fuel pump</li>
<li>17 gallon fiberglass fuel tank with gauge and inspection port</li>
<li>100 mile cruising range</li>
<li>6.0 knots under power</li>
<li>Oil and oil filter changed annually at end of season</li>
<li>Dual Racor fuel filter system</li>
<li>Secondary fuel filter</li>
<li>Cutlass bearing in excellent condition due to light usages</li>
<li>PSS Dripless stuffing box</li>
<li>Three-blade Campbell Sailor Prop, maintained annually</li>
<li>Wheel steering – Edson rack and pinion steering</li>
</ul>
<p><strong>Hull and Deck Details</strong></p>
<p>Being a 2006 Pacific Seacraft 31, this boat should not be confused with the old design of a 31 footer known as a Mariah. The new PSC 31 is a modern design inspired by the popularity of the PSC 37. They packed it all into 31 feet. The PSC 31 is a classic Bill Crealock design with a long cruising fin keel, skeg hung rudder, spoon bow, and vertical transom to increase the volume below. It is a very expensive boat for its size, and worth the money. There are no corners cut in this build quality, not to mention the extras these owners opted for.</p>
<p>Of course, the hull solid fiberglass is hand laid with water resisting vinylester resin on the outermost layer. Isophthalic polyester resin is used on the inner layers of glass matt and roving. The ballast is lead which is used for all high-quality boats. The shoal draft version draws four feet. The keel is the patented Scheel keel designed to minimize leeway and improve tracking. It works well and the boat is idyllic in the Bahamas! The rudder has an internal steel plate inside with fiberglass to form the rudder. It is skeg mounted for strength and good protection. The deck is built of marine plywood sandwiched between fiberglass. The non-skid is molded into the deck on top. The deck is attached to the hull with 3M 5200 glued, literally glued, and then it is through-bolted with 1/4 inch stainless bolts every four inches. This is an impressive build for any sized boat and at 31 feet it produces a monolithic, super strong boat!</p>
<ul>
<li>Solid fiberglass hand laid</li>
<li>Bronze through hulls</li>
<li>Shoal draft lead Scheel keel, draws four feet!</li>
<li>Factory epoxy barrier coat</li>
<li>New bottom paint spring of 2017</li>
<li>Teak rub rail with ss striker</li>
<li>Wheel steering with Edson rack-and-pinion system</li>
<li>Deck is marine ply sandwiched with fiberglass</li>
<li>Trunk cabin with ten Hood portlights with screens</li>
<li>Gelcoat on cabin house in excellent condition</li>
<li>Large forward two-way hatch with screen</li>
<li>Twin dorades with boxes</li>
<li>Bow pulpit</li>
<li>30” double lifelines</li>
<li>Boarding gates port and starboard</li>
<li>Stern rail</li>
<li>Teak cap rail finished in Cetol in excellent condition</li>
<li>Teak hand rails on the cabin house finished in Cetol</li>
<li>Proper propane locker on the starboard coaming</li>
</ul>
<p>Cockpit Details</p>
<ul>
<li>Dodger and Bimini with connector panel in blue matching the boot stripe</li>
<li>Sun shades that zip on</li>
<li>Long cockpit seat benches, 7 feet long with contoured backs</li>
<li>Seating for seven</li>
<li>Cockpit cushions</li>
<li>Three lockers</li>
<li>Contoured helm seat</li>
<li>Good winch placement for single hand sailing</li>
<li>Traveler in front of the binnacle</li>
<li>Wheel steering</li>
<li>Two cockpit drains</li>
<li>Manual bilge pump in the cockpit</li>
<li>Stern rail with transom boarding ladder</li>
</ul>
<p><strong>Ground Tackle:</strong></p>
<ul>
<li>Double bow roller at the stem head</li>
<li>Divided chain locker</li>
<li>Electric Maxwell HRC windlass with foot switches</li>
<li>Primary bow anchor 35# Delta anchor w/ 200' 5/16th chain</li>
<li>Secondary bow anchor Fortress FX23 w/ 25' 5/16th chain and 200' ½” nylon rode</li>
<li>Fortress FX37 stows in the cabin as storm anchor</li>
<li>Stern chain locker with anchor roller on port stern quarter</li>
<li>Fortress FX7 with 10ft 5/16th chain stowed on the stern</li>
</ul>
<p><strong>Cockpit</strong></p>
<p>Flat stern creates a surprisingly spacious cockpit for a yacht this size, but everything is still within easy reach for a singlehander. Cockpit seat benches are seven feet long, long enough to lie down on.</p>
<ul>
<li>Fitted cockpit cushions</li>
<li>Folding swim ladder</li>
<li>Dodger is in excellent due to light use and proper decommissioning each year</li>
<li>Bimini is also in excellent condition</li>
<li>Edson pedestal and steering wheel with cover</li>
<li>Ritchie compass</li>
<li>Raymarine ST60 Tridata in pod on pedestal</li>
<li>Ram Mounts and cable disconnects on pedestal allow chart plotter to be easily removed and stowed for safety</li>
</ul>
<p><strong>Sails & Rigging</strong></p>
<p>The Pacific Seacraft 31 is a joy under sail and perfect for a single hand sailor or a couple. The singlehanders package provides easy sail handling from the cockpit. The sloop rig has a Harken furler for the genoa headsail and the single line reefing system for the mainsail makes it easy to balance in all conditions. The Lazy Jacks system keeps the mainsail tidy when dropping or reefing the sail.</p>
<ul>
<li>Sloop rig with 1/19 wire rigging and</li>
<li>External chain-plates allow more space on side decks</li>
<li>Has the fittings on the deck and mast to be rigged as a cutter</li>
<li>Inspection in summer of 2017</li>
<li>Deck stepped mast with compression post</li>
<li>Aluminum mast painted white with winch pads and line stopper</li>
<li>Bridge clearance 47’</li>
<li>Mechanical four part vang system</li>
<li>Single handers package</li>
<li>Color coded running rigging</li>
<li>Main halyard, jib halyard, and topping lift</li>
<li>Two reef lines lead aft for single line reefing</li>
<li>Spinlock triple line clutch</li>
<li>Lazy jacks</li>
<li>Preventer system</li>
<li>Harken headsail furler</li>
<li>Ullman mainsail partial batten with two reef points and single line reefing in the cockpit</li>
<li>Spectra topping lift doubles as a spare main halyard</li>
<li>Ullman 130% genoa with foam padded luff for reefing with the furler</li>
<li>UV protection</li>
</ul>
<p>Winches:</p>
<ul>
<li>Harken #40 ST two-speed primary sheet winches on the coaming</li>
<li>Harken cabin house winches for main halyard and reefing</li>
<li>Mast winch for jib halyard</li>
</ul>
<p>Dinghy:</p>
<ul>
<li>Beautiful classic 7’11” Dyer sailing dinghy</li>
<li>Tows beautifully</li>
<li>Rows beautifully</li>
<li>Mast and sailing rig available if you pay the shipping from Kansas</li>
</ul>
<p><strong>Safety and Additional Inventory</strong></p>
<p><strong> </strong></p>
<ul>
<li>Emergency tiller</li>
<li>PFDs four</li>
<li>Rule electric bilge pump with float switch</li>
<li>High water Rule bilge pump with float switch</li>
<li>Whale gusher manual bilge pump</li>
<li>Docklines, fenders and boat-hook</li>
<li>30 amp AC power cable</li>
<li>Winch handles (2)</li>
<li>Fire extinguishers two</li>
<li>Flare kit</li>
<li>Horn</li>
<li>Masthead tricolor and anchor light </li>
</ul>
</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] |
6098 |
[empty string] |
[empty string] |
834FAB91-BF93-CF79-D1853B84134F7252 |
[empty string] |
[empty string] |
https://www.davidwaltersyachts.com/Sail/31-Pacific-Seacraft-2006/562 |
12 |
The default yacht template for David Walters Yachts |
1 |
Brokerage |
1 |
Bernie Jakits |
Bernie Jakits & Kate Christensen |
& Kate Christensen, Bernie Jakits |
& Kate Christensen |
(443) 742-1792 |
562 |
[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 = 562 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL )
ORDER BY yachtID |
