Fleming Virtual Tours

Fleming 55

query
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 RANDOMSEED SEOPAGETITLE SEOPREVIEWTEXT SEOURL STAFFREF TEMPLATEDESC TEMPLATEID TEMPLATENAME TEMPLATEREF USERFIRSTNAME USERFULLNAME USERFULLNAME2 USERLASTNAME YACHTID YATCOREF
1 40.06 [empty string] [empty string] [empty string] Fleming 55 55' 9 (16.99m) 60' 9' (18.50 m) 50' 10' (15.5 m) 16' (4.88 m) 5' (1.52 m) 16' (4.88 m) 80,178 lbs (36,368 kg) 1,000 US gal (3,785 l) 300 US gal (1,135 l) https://vrcloud.com/?pv=ma980 https://vrcloud.com/?pv=ma979 https://vrcloud.com/ma1749 https://vrcloud.com/?pv=1586552209 https://vrcloud.com/?pv=1663239477 Hull 55-213 Hull 55-217 Hull 55-232 Hull 55-247 55-260 (Two Cabin) [empty string] [empty string] 67,801 lbs (30,754 kg) [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] LAB01STR,LAB02STR,LAB03STR,LAB04STR,LAB05STR,LAB06STR,LAB07STR,LAB23STR,LAB08STR,LAB09STR,LAB10STR,LAB01MEM,LAB03MEM,LAB02MEM,LAB04MEM,LAB16STR,LAB11STR,LAB17STR,LAB12STR,LAB18STR,LAB13STR,LAB19STR,LAB14STR,LAB20STR,LAB15STR,LAB21STR,LAB22STR,LAB24STR,LAB25STR 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 0 0 [empty string] [empty string] [empty string] Description Block 01 Model Name [empty string] [empty string] Welcome Tour Full LOA [empty string] [empty string] Welcome Tour Preview LOA (w/swim and anchor platforms) [empty string] [empty string] Full Specifications LWL [empty string] [empty string] [empty string] Beam [empty string] [empty string] [empty string] Draft [empty string] [empty string] [empty string] Air Draft (to top of arch) [empty string] [empty string] [empty string] Displacement Full [empty string] [empty string] [empty string] Fuel [empty string] [empty string] [empty string] Water [empty string] Virtual Tour 1 [empty string] Virtual Tour 2 [empty string] Virtual Tour 3 [empty string] Virtual Tour 4 [empty string] Virtual Tour 5 [empty string] Virtual Tour Title 1 [empty string] Virtual Tour Title 2 [empty string] Virtual Tour Title 3 [empty string] Virtual Tour Title 4 [empty string] Virtual Tour Title 5 Virtual Tour 6 Virtual Tour Title 6 Displacement Light Virtual Tour 7 Virtual Tour Title 7 [empty string] [empty string] [empty string] [empty string] [empty string] 2 2 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <p>The Fleming 55 is a well-proven raised pilothouse motoryacht designed for serious cruising. Her semi-displacement hull gives her great flexibility in performance. The Fleming 55 has a range of 2,000 nautical miles at 8 knots yet, with her standard Twin Cummins QSC 500 hp common rail engines, she can attain a top speed of approximately 18 knots. Maximum sustained cruising speed is around 17 knots where her moderate deadrise provides a very comfortable ride. On longer passages, Fleming owners&nbsp;typically cruise at a very&nbsp;economical speed of 10 knots, where the typical fuel burn is slightly more than 10 gph.</p> <p>The Fleming's deep keel provides protection for the running gear and stability in following seas. Because noise and vibration contribute to fatigue, Fleming has paid special attention to producing a yacht which has become the standard in the industry for its whisper quiet, ultra smooth ride. Fundamental to this achievement is the use of&nbsp;Aquadrive anti-vibration drive systems.&nbsp;</p> <p>The Fleming 55 was first introduced in 1986, and since that time it has benefited from a rigorous program of evolution. There have been literally hundreds of improvements made, both big and small. While its legendary hull design remains essentially the same, today's Fleming 55 is a thoroughly modern yacht utilizing advanced technology, materials and construction methods. In 2019 construction of hull number 250 is well underway,&nbsp;making it one of the most successful production yachts in history.</p> <p><strong>Foredeck and Forepeak</strong></p> <p>Special attention has been paid to the ability to set and retrieve heavy ground tackle on the Fleming 55. The fiberglass anchor platform is equipped with twin Maxwell RC12 vertical windlasses with capstans&nbsp;for both rope and 3/8" (10mm) Grade-60 stainless steel chain. The windlass has a plug-in remote control as well as controls in the pilothouse and on the flybridge. Double sets of grooved rollers make it possible to self-launch and stow two 77 lb (35 Kg) Ultra anchors. Hose bibs for salt and fresh water are located next to the anchor platform, and there are deck lockers to port and stbd.</p> <p>A lock-down hatch on the foredeck provides convenient access to the forepeak, which is separated from the rest of the yacht by a collision bulkhead. It has an area for storage of chain and a separate ventilated rope locker. Each features a bitter end fitting. The forepeak drains directly overboard and can be hosed down without concerns that water will contaminate the bilges.</p> <p>The flared bow turns aside green water and provides a forward deck of unusually generous proportions. The oval stainless steel handrail has been brought inboard of the sloping bulwarks for convenience and security. To prevent streaking of the hull, the deck scuppers are piped down to the boot stripe, rather than being allowed to drain directly overboard.</p> <p>Further protection against heavy weather is provided by the design of the Portuguese bridge. There is comfortable seating on its forward side, which is also the location for the forward shorepower inlet. There is ample storage for fenders and lines inside ventilated lockers accessed from the aft side of the Portuguese Bridge, and double doors close off the forward deck areas from the side and bridge decks creating a safe area for small children. There are sturdy, stainless steel handrails around the forward face of the pilothouse and down both side decks.</p> <p>Easy stairs with handrails designed for both adults and children lead down to the wide and well-protected side-decks, which run down both sides of the boat. Here you will find cleats and chocks for forward and aft spring lines. The inward-opening bulwark doors make for easy and safe boarding.</p> <p><strong>Aft Deck and Swim Platform</strong></p> <p>With an area of approximately 250 sq ft. the Fleming 55 aft deck is unusually large. Being all at one level, it becomes an extension of the salon and provides ample space for chairs, donning scuba gear, or fishing. The fiberglass skirt around the edge of the wide teak&nbsp;cap rail conceals mood lighting and hides the engine-room air intakes which are well-protected from salt-laden spray.</p> <p>Shower fittings for hot and cold water, located next to the inward-opening transom door, are conveniently placed for use while standing on the swim platform. Stainless steel handrails on the transom and a swim ladder, which can be deployed by a person in the water, provide safety and convenience.</p> <p>Access to the upper boat deck is via a stainless steel ladder and a sliding hatch in the overhead. Access into the lazarette is through lockable hatches, with safe and stylish curved corners. Available as options are a console for cockpit engine controls and a locker, which can be equipped with a basin and faucet, insulated chest or icemaker.</p> <p><strong>Flying Bridge</strong></p> <p>The Fleming 55 low-profile flying bridge is spacious and packed with practical amenities. Its double helmseat, with folding stainless steel footrest, folds forward to access storage beneath it. The control console has full engine instrumentation and ample room for electronics. Access to and from the pilothouse is by a protected internal companionway directly from the pilothouse, avoiding the need to navigate perilous steps or ladders where a slip could result in a fall over the side. A wrap-around venturi windshield with stainless steel handrail provides protection from wind and weather.</p> <p>There is seating for eight guests close to, but out of the way of, the helm station. A fiberglass table is standard and an ingenious pass-thru "dumbwaiter" eliminates the need to carry refreshments up from the galley. Aft of the seating area is the separate boat deck for the tender and a fully hydraulic davit, with remote control. From here, a ladder provides direct access to the lower aft deck.</p> <p>A popular option is the aft facing&nbsp;boat deck control station that provides the captain with excellent visibility aft. Complete with bow thruster,&nbsp;and engine controls, backing into a tight slip is easier than ever.</p> <p>The radar arch provides ample room for the full range of antennae required by modern electronic equipment, and an optional fibreglass hardtop is a popular choice.</p> <p><strong>Main Salon and Galley</strong></p> <p>The salon in the Fleming 55 features a comfortable L-settee with cushions upholstered over wood frames instead of the usual foam cushions on plywood. The sole is hand-laid teak and holly strips, and all built-in furniture is of superior quality joinerwork with rounded corners. There is a hi-lo table of unique design making it suitable for dining and as a coffee table. To starboard is a cabinet with powered TV lift and space for entertainment system components. To port is a bar with icemaker. The salon opens directly onto the aft deck through double sliding doors.&nbsp;</p> <p>The galley is conveniently located on the same level as the salon and is properly designed to be used while underway. Either Corian or granite counter tops can be ordered. There are ample storage lockers and drawers, and appliances include a 21 cu. ft. side-by-side fridge/freezer with teak-panel doors and chilled water &amp; ice dispenser;&nbsp;Miele induction cooktop with practical custom stainless steel pot-holders; convection microwave; and&nbsp;an undermount double stainless steel sink with waste disposer. Space has been provided for an optional dishwasher. A 20-gallon water heater is conveniently located close to the sinks for instant hot water. A pass-through dumbwaiter makes it safe and easy to serve food and drinks to guests on the flying bridge.</p> <p>Fleming's signature low-profile design is evident even in the interior, as just a few steps lead up to pilothouse and down to the accommodations.&nbsp;</p> <p><strong>Accommodations</strong></p> <p>The perfect close to a day of cruising is to retire to a comfortable cabin. The Fleming 55 offers easy access to all the accommodations via a central passageway. A separate washer and drier are conveniently located behind a sliding door in this passage.</p> <p>The master cabin is forward for maximum light and ventilation. It features a tapered queen berth with headboard. The bed lifts at the press of a button to access storage for bulky items. The bed also slides aft to make it easier to make the bed. There are two hanging lockers with shelves, teak louvered doors and&nbsp;space for a TV.</p> <p>The master cabin has an en suite head with Corian, marble or granite countertops and a molded fiberglass shower stall. Hans-Grohe faucets are used throughout and feature a thermostatically controlled shower.&nbsp;</p> <p>The port guest cabin is offered with either two single or one double bed with headboards. An additional slide-out upper berth with either layout is optional. The aft bulkhead has generous bookshelves. The starboard guest cabin has one lower and one upper, slide-out, upper berth. This cabin can also be offered as an optional office with desk, lockers, bookshelves and space for a computer &amp; printer.</p> <p>The guest head features a one-piece fiberglass molding and shower stall with bi-fold stainless steel doors. The attractive ceramic basin is set in a Corian, marble or granite countertop. Faucets are Hans-Grohe with a thermostatically controlled shower.</p> <p>Throughout the yacht all lighting is LED type with polished stainless steel fittings. Teak and holly soles are standard in all interior areas.</p> <p><strong>Engine Room</strong></p> <p>The Fleming 55 engine room is meticulously well thought out and provides easy accessibility to every piece of equipment.</p> <p>A signature feature of the Fleming 55 is its quietness and freedom from vibration. Much of the credit for this lies with the Aquadrive system, which isolates the engine and transmission from the propeller thrust, permitting the use of much softer engine mounts.&nbsp;Aquadrive is fitted as standard on every Fleming 55 and their rotating couplings are concealed beneath fiberglass covers for safety.</p> <p>Another reason for the quietness of the Fleming is the careful attention paid to sound insulation. Lead/foam insulation is used extensively throughout and all hatches are dogged down on rubber gaskets. There are even double hatches separated by an air space over each engine.</p> <p>Fuel tanks are made of fiberglass with integrally molded sumps to allow maximum useage of fuel. Vinylester resin is used in their construction on the interior and fire-retardant resin in the outer layers. The fuel system has been designed to make the transfer of fuel foolproof. It is impossible to inadvertently overfill one tank by incorrectly switching a fuel return valve.</p> <p>Access to the engine room is via two hatches in the salon sole and from the lazarette through a uniquely shaped oval door designed for easy access. Engine room intake air enters from the lazarette to ensure it is free of salt before reaching the engines and generators.</p> <p>For safety and convenience each Cummins QSC 500HP engine has a start and a stop button located in the engine room, and a PTO (power take-off) on the gearbox provides hydraulic power for the stabilizers which are standard equipment on all Flemings.</p> <p><strong>Lazarette</strong></p> <p>Inside the large lazarette are four polyethylene water tanks totaling 300 gallons (1,135 liters), battery master switches, and a 3,500 watt inverter. Four air conditioning compressors provide heating and cooling for the entire yacht. Against the transom is the steering system with its connection point for the autopilot. The tops for the rudder stocks terminate above the waterline. Despite all this equipment there remains 95 cu. ft. of storage for fenders and other cruising gear. Access to the engine room is through the oval-shaped door.</p> <p><strong>Pilothouse</strong></p> <p>In many modern designs it has become fashionable to eliminate the inside steering station, but the Fleming 55 features a pilothouse which closely resembles the bridge of a much larger vessel. We created a dedicated place from which the boat is piloted and controlled without any distractions from other on-board activities but which is still only three steps from the salon and galley. Four interior steps safely lead to the upper flying bridge station.</p> <p>Specially designed removable consoles provide ample room for a full range of modern electronic equipment without intruding on the engine instrumentation. Overhead consoles provide additional space. There is also a proper chart area with drawers and a chart light. Electrical panels swing out to provide easy access to wiring connections and the inside of the flying bridge console is accessed through a swing-out bookcase. The watch-keeper has their own Stidd helm seat and an adjacent, raised L-shaped settee and table provide a comfortable social area with excellent visibility through the side and forward windows.</p> <p>This is truly the nerve center of the boat where all the systems and crew come together in complete harmony.</p> <p>&nbsp;</p> <p><strong>CONSTRUCTION STANDARDS</strong></p> <p>All Fleming Yachts are built to comply with the appropriate marine and environmental regulations for the area in which the yacht is delivered</p> <p>&nbsp;</p> <p>&nbsp; &nbsp; USA - NMMA Certified Manufacturer fully complying with: ABYC, USCG and EPA regulations.</p> <p>&nbsp; &nbsp; European - Built to CE-RCD Category "A" Ocean Standard using the relevant ISO standards.</p> <p>&nbsp; &nbsp; Australia - Australian Standard 1799.1-2009</p> <p>&nbsp; &nbsp; Canada - Transport Canada TP1332E 04/2010</p> <p>&nbsp;</p> <p><strong>MANAGEMENT &amp; ENVIRONMENT</strong></p> <p>Fleming Yachts Construction (HK) Ltd management and environmental systems have met and been approved by ISO 9001:2008 Quality Management Systems and ISO 14001:2004 Environmental Management Standards.</p> <p><strong>AFTERWORD</strong></p> <p>The question most manufacturers ask themselves when considering a new feature is whether it is necessary to include it in order to sell the boat. In the case of the Fleming, we ask only whether its inclusion will make the boat safer, better or more convenient. That is why we have introduced literally hundreds of refinements since we started construction in 1985 and why we continue the process today.</p> <p>For that reason, Fleming Yachts reserves the right to make changes to specifications and equipment without notice.&nbsp;</p> [empty string] <ul> <li><strong>LOA (hull):</strong> 55' 9" (16.99m)</li> <li><strong>LOA (including swim step and anchor platform):</strong> 60' 9" (18.50m)</li> <li><strong>LWL:</strong> 50' 10" (15.5m)</li> <li><strong>Beam:</strong> 16' (4.88m)</li> <li><strong>Draft:</strong> 5' (1.52m)</li> <li><strong>Air draft (to top of radar arch):</strong> 16' (4.88m)</li> <li><strong>Displacements:</strong> <ul> <li><strong>Minimum Operating Condition:</strong> 67,801 Lbs. (30,754kg)</li> <li><strong>Loaded Condition:</strong> 80,178 Lbs. (36,368kg)</li> </ul> </li> <li><strong>Main Engines:</strong> Twin Cummins QSC 8.3 500 hp with common rail fuel system</li> <li><strong>Transmission:</strong> Twin Disc MG5075A</li> <li><strong>Reduction Ratio:</strong> 2.53:1</li> <li><strong>Engine Controls:</strong> Glendinning EEC3 (with back-up system)</li> <li><strong>Generator:</strong> 17Kw, 60Hz Onan eQD (European model 13.5Kw, 50Hz)</li> <li><strong>Stabilizers:</strong> ABT TRAC 7.5 Sq. Ft fins with winglets, 220RMB model actuators</li> <li><strong>Fuel Tanks:</strong> 1,000 USG (3,785 Liters) in four tanks</li> <li><strong>Bowthruster: </strong>Sidepower SE250 15.5 hp (11.4Kw)</li> <li><strong>Water Tanks:</strong> 300 USG (1,135 Liters) in four tanks</li> <li><strong>Black Water Tank:</strong> 100 USG (378 Liters)</li> <li><strong>Monitoring System:</strong>&nbsp;Fleming First Mate (FFM) - Boning</li> </ul> [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] The Fleming 55 is an incredibly well-designed raised pilothouse cruising yacht. The 55 has a semi-displacement hull which results in excellent performance. [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 835 [empty string] 947C2CAB-FBA0-68A2-9D0B870C80722CDD Fleming Yachts 55 - The Ultimate Cruising Yacht [empty string] https://www.flemingyachts.com.au/model/Fleming-55 [empty string] [empty string] 1 Yacht Models 1 [empty string] [empty string] [empty string] [empty string] 2 [empty string]
CACHED false
EXECUTIONTIME 19
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.userFirstName + ' ' + users.userLastName AS userFullName, users.userLastName + ', ' + users.userFirstName AS userFullName2, yacht_photos.photoID, yacht_photos.photoCaption, yacht_model.mfrRef, yacht_model.modelName, yacht_mfr.mfrName FROM yacht_data LEFT JOIN yacht_templates ON yacht_data.templateREF = yacht_templates.templateID LEFT JOIN users ON yacht_data.staffREF = users.userID LEFT JOIN 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 = 2 ) AND ( yacht_photos.priority = 1 OR yacht_photos.priority IS NULL ) ORDER BY yachtID

Fleming 58

Fleming 65

Fleming 78