query

RESULTSET

query
	ARTICLEAUTHOR	ARTICLECATNAME	ARTICLEDATE	ARTICLEDATE2	ARTICLEID	ARTICLEPLACEMENT	ARTICLETEXT	ARTICLETITLE	ARTICLEUPDATED	ARTICLEURL	ARTICLE_SECTION	ARTICLE_TAG	CATREF	ENABLEAUTHOR	ENABLEDESCRIPTION	ENABLEDOCUMENTSTAB	ENABLELINKSTAB	ENABLELOCATIONTAB	ENABLEPHOTOSTAB	ENABLESEOTAB	ENABLESTARTENDDATES	ENABLETAGSTAB	ENABLEWEBSITE	ENABLEYOUTUBETAB	EXTDATA01	EXTDATA02	EXTDATA03	EXTDATA04	EXTDATA05	EXTDATA06	EXTDATA07	EXTDATA08	EXTDATA09	EXTDATA10	EXTDATA11	EXTDATA12	EXTLABEL01	EXTLABEL02	EXTLABEL03	EXTLABEL04	EXTLABEL05	EXTLABEL06	EXTLABEL07	EXTLABEL08	EXTLABEL09	EXTLABEL10	EXTLABEL11	EXTLABEL12	FB_ADMINS	INTERLINKINGSETS	ISAPPROVED	ISARCHIVED	KEYWORDS	LATITUDE	LINKTITLEP	LINKTITLES	LOCADDRESS1	LOCADDRESS2	LOCCITY	LOCSTATEREF	LOCZIP	LONGITUDE	METADESCRIPTION	MYCHANGEFREQ	MYDESCRIPTION	MYPAGETITLE	MYPRIORITY	OG_DESC	OG_IMAGE	OG_TITLE	OG_TYPE	OG_URL	ONFRONTPAGE	PIC1	PICALL	POSTEDDATE	POSTSTATUSCOLOR	POSTSTATUSNAME	POSTSTATUSREF	PRIMARY_TAGREG	SCHEMA_DESC	SCHEMA_IMAGE	SCHEMA_NAME	SEODIR	SEOHANDCRAFTEDURL	SEOPAGETITLE	SEOPREVIEWTEXT	SEOURL	STAFFREF	TAGNAME	TAGURL	TWITTER_CARD	TWITTER_DESC	TWITTER_IMAGE	TWITTER_IMAGE_ALT	TWITTER_SITE	TWITTER_TITLE	USERFIRSTNAME	USERLASTNAME
1	Dave Kresge	News	2022-03-07 00:00:00.0	2022-03-07 00:00:00.0	247	[empty string]	<h2 style="text-align: center;"><a href="../../../../documents/Allied_Marine_Palm_Beach_2022_Boat_Show_Guide.pdf" target="_blank" rel="noopener">DOWNLOAD PDF GUIDE</a></h2> <p style="text-align: center;">See below for our lineup of brokerage yachts from Allied Marine and new yachts on display from Ferretti Group, including Pershing, Riva, Ferretti Yachts, and Wally! Also, <a href="../../../../documents/Allied_Marine_Palm_Beach_2022_Boat_Show_Guide.pdf" target="_blank" rel="noopener">click here to download our best-ever Guide Book for the Palm Beach International Boat Show!</a></p> <hr /> <h4 style="text-align: center;">SUPERYACHTS IN THE SHOW \| DOCK E2</h4> <table style="margin-left: auto; margin-right: auto;"> <tbody> <tr> <td style="width: 324.5px;"> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img src="../../../../photos/articles/eiv-rossinavi-2.jpg" alt="Image 0950: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">EIV<br />2020 Rossinavi 164'</h4> <p><a href="../../../../used-yachts-for-sale/2020-Rossinavi-205-Motor-Yacht-EIV-yacht-for-sale/8243781_2" target="_blank" rel="noopener">SEE LISTING</a></p> <p><a style="display: none;">MORE INFORMATION</a></p> </div> </div> </td> <td style="width: 323.5px;"> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../used-yachts-for-sale/2019-Custom-Line-205-NAVETTA-37-Ferretti-Motoryacht-MAREA-yacht-for-sale/7918580_2" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/marea-2.jpg" alt="Image 0924: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">MAREA<br />2019 Custom Line NAVETTA 37</h4> <p><a href="../../../../used-yachts-for-sale/2019-Custom-Line-205-NAVETTA-37-Ferretti-Motoryacht-MAREA-yacht-for-sale/7918580_2" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> </tr> </tbody> </table> <h4 style="text-align: center;"> </h4> <h4 style="text-align: center;">BROKERAGE YACHTS IN THE SHOW \| DOCK/RAMP 3</h4> <p> </p> <table> <tbody> <tr> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/bad-daddy-2.jpg" alt="Image 0959: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">BAD DADDY <br />2018 PERSHING 70'</h4> <p><a href="../../../../used-yachts-for-sale/2018-Pershing-83-70-BAD-DADDY-yacht-for-sale/7826347_2" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/diva-2.jpg" alt="Image 0961: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">DIVA <br />2013 RIVA 33'</h4> <p><a href="../../../../used-yachts-for-sale/2013-Riva-37-Aquariva-Super-DIVA-yacht-for-sale/7844641_2" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/canary-2.jpg" alt="Image 0960: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">CANARY <br />2002 CUSTOM CAROLINA 38'</h4> <p><a href="../../../../used-yachts-for-sale/2002-Custom-Carolina-42-Bobby-Sullivan-Express-CANARY-yacht-for-sale/8227172_2" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"> <div class="yacht card rounded-0"><a class="stretched-link" href="no-link" target="_blank" rel="noopener" data-template-id="v_card_url"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/double-or-nothing-crop1.jpg" alt="Image 1065: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title" data-template-id="v_card_name">DOUBLE OR NOTHING</h4> <p><a href="../../../../used-yachts-for-sale/2017-Pershing-83-82-Double-or-Nothing-yacht-for-sale/8244062_2" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/scout-2.jpg" alt="Image 0986: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title" style="text-align: center;">THE COOP<br />2021 SCOUT 53'</h4> <p><a href="../../../../used-yachts-for-sale/2021-Scout-54-530-LXF-THE-COOP-yacht-for-sale/8232033_2" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../used-yachts-for-sale/2016-Bonadeo-37-37-Bella-yacht-for-sale/8183337_2" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/bella.jpg" alt="Image 0972: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">BELLA<br />2016 BONADEO 37'</h4> <p><a href="../../../../used-yachts-for-sale/2016-Bonadeo-37-37-Bella-yacht-for-sale/8183337_2">SEE LISTING</a></p> </div> </div> </td> </tr> </tbody> </table> <p>  </p> <h4 style="text-align: center;">NEW YACHTS IN THE SHOW \| DOCK/RAMP 4</h4> <p> </p> <table> <tbody> <tr> <td> <div class="yacht card rounded-0"> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/custom-line-navetta-no-logo.jpg" alt="Image 0994: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">CUSTOM LINE NAVETTA 33</h4> <p><a href="../../../../new-yachts-for-sale/Custom-Line-yachts/Custom-Line-Navetta-33" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/670-2.jpg" alt="Image 0958: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">FERRETTI YACHTS 670</h4> <p><a href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-670" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"> <div class="yacht card rounded-0"><a class="stretched-link" href="https://{$VesselURrl}" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/pershing-9x1.jpg" alt="Image 1063: " width="100%" height="Auto" /></div> <div class="card-block"> <h4 class="card-title">Pershing 9X</h4> <p><a href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-9X" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/8x-2.jpg" alt="Image 0956: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">PERSHING 8X</h4> <p><a href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-8X" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/riva-48-dolceriva-3.jpg" alt="Image 0977: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">DOLCERIVA</h4> <p><a href="../../../../new-yachts-for-sale/Riva-yachts/Dolceriva" target="_blank" rel="noopener">SEE LISTING</a></p> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/wally-43x-3.jpg" alt="Image 0954: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">WALLYTENDER43X</h4> <p><span style="color: #ffffff;">MORE INFORMATION</span></p> </div> </div> </td> <td> <div class="yacht card rounded-0"><a class="stretched-link" href="../../../../" target="_blank" rel="noopener"> </a> <div class="card-img"><img class="card-img-top" src="../../../../photos/articles/wally-48x-2.jpg" alt="Image 0967: " width="100%" height="auto" /></div> <div class="card-block"> <h4 class="card-title">WALLYTENDER48X</h4> <p><span style="color: #ffffff;">MORE INFORMATION</span></p> </div> </div> </td> </tr> </tbody> </table> <p> </p>	2022 PALM BEACH INTERNATIONAL BOAT SHOW & VISITOR GUIDE	2022-06-15 16:30:38.0		[empty string]	allied marine,Boat Shows,superyacht,yacht news	1	1	1	1	0	0	1	1	0	1	0	1	1	1	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	Omit Sidebar	Omit Gallery	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.000000	Links/Quotes	Link/Quote	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	0.000000	[empty string]	weekly	2022 Palm Beach International Boat Show Guide, Allied Marine Superyachts, Brokerage Yachts, plus, new Ferretti, Riva, Pershing, and Wally yachts on display.	PALM BEACH INTERNATIONAL BOAT SHOW GUIDE	1.0	Palm Beach International Boat Show Guide and Yachts On Display		PALM BEACH INTERNATIONAL BOAT SHOW GUIDE	website	https://www.alliedmarine.com	[empty string]	guide-download-banner-copy.jpg	guide-download-banner-copy.jpg,guide-pages.jpg,banner-text.jpg,scout-2.jpg,riva-bahamas.jpg,custom-line-navetta-no-logo.jpg,scout.jpg,pershing-9x1.jpg,riva-56.jpg,double-or-nothing-crop1.jpg,riva-48-dolceriva-3.jpg,wally-43x-3.jpg,wally-48x-2.jpg,riva-48-dolceriva-2.jpg,marea-2.jpg,photo-coming-2.jpg,eiv-rossinavi-2.jpg,diva-2.jpg,canary-2.jpg,bella.jpg,bad-daddy-2.jpg,670-2.jpg,500-2.jpg,8x-2.jpg,eiv-rossinavi.jpg,marea.jpg,bad-daddy.jpg,diva.jpg,canary.jpg,670.jpg,8x.jpg,riva-48-dolceriva.jpg,riva-76-bahamas.jpg,wp-wally-43x.jpg,wp-wally-48x.jpg	2022-03-07 00:00:00.0	[empty string]	[empty string]	3	[empty string]	2022 Palm Beach International Boat Show Guide, Allied Marine Superyachts, Brokerage Yachts, plus, new Ferretti, Riva, Pershing, and Wally yachts on display.		2022 PALM BEACH INTERNATIONAL BOAT SHOW & VISITOR GUIDE	yachting-news	palm-beach-international-boat-show-guide	[empty string]	[empty string]	https://www.alliedmarine.com/yachting-news/palm-beach-international-boat-show-guide	0	[empty string]	[empty string]	summary	Palm Beach International Boat Show Guide and Yachts On Display				PALM BEACH INTERNATIONAL BOAT SHOW GUIDE	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT articles.articleID, articles.catREF, articles.staffREF, articles.postStatusREF, articles.articleTitle, articles.seoHandCraftedURL, articles.articleAuthor, articles.articleURL, articles.seoURL, articles.articleDate, articles.articleDate2, articles.postedDate, articles.articleUpdated, articles.latitude, articles.longitude, articles.articleText, articles.isArchived, articles.metaDescription, articles.seoPreviewText, articles.primary_tagREG, articles.myPageTitle, articles.myDescription, articles.fb_admins, articles.og_title, articles.og_type, articles.og_image, articles.og_url, articles.og_desc, articles.twitter_card, articles.twitter_site, articles.twitter_title, articles.twitter_desc, articles.twitter_image, articles.twitter_image_alt, articles.article_section, articles.article_tag, articles.myChangeFreq, articles.myPriority, articles.schema_name, articles.schema_desc, articles.schema_image, articles.seoPageTitle, articles.keywords, articles.isApproved, articles.articlePlacement, articles.onFrontPage, articles.locAddress1, articles.locAddress2, articles.locCity, articles.locStateREF, articles.locZip, articles.extData01, articles.extData02, articles.extData03, articles.extData04, articles.extData05, articles.extData06, articles.extData07, articles.extData08, articles.extData09, articles.extData10, articles.extData11, articles.extData12, articles.pic1, articles.picAll, articles.interlinkingSets, articleCats.articleCatName, articleCats.extLabel01, articleCats.extLabel02, articleCats.extLabel03, articleCats.extLabel04, articleCats.extLabel05, articleCats.extLabel06, articleCats.extLabel07, articleCats.extLabel08, articleCats.extLabel09, articleCats.extLabel10, articleCats.extLabel11, articleCats.extLabel12, articleCats.enableStartEndDates, articleCats.enableLocationTab, articleCats.enableLinksTab, articleCats.linkTitleS, articleCats.linkTitleP, articleCats.enablePhotosTab, articleCats.enableDocumentsTab, articleCats.enableYouTubeTab, articleCats.enableTagsTab, articleCats.enableSeoTab, articleCats.enableAuthor, articleCats.enableDescription, articleCats.enableWebsite, articleCats.seoDir, article_status.postStatusName, article_status.postStatusColor, article_tag.tagName, article_tag.tagURL, users.userLastName, users.userFirstName FROM articles LEFT JOIN articleCats ON articles.catREF = articleCats.articleCatID LEFT JOIN article_status ON articles.postStatusREF = article_status.postStatusID LEFT JOIN article_tag ON articles.primary_tagREG = article_tag.tagID LEFT JOIN users ON articles.staffREF = users.userID WHERE seoHandCraftedURL = 'palm-beach-international-boat-show-guide' ORDER BY postedDate desc

2022 PALM BEACH INTERNATIONAL BOAT SHOW & VISITOR GUIDE

Mar 07, 2022

DOWNLOAD PDF GUIDE

See below for our lineup of brokerage yachts from Allied Marine and new yachts on display from Ferretti Group, including Pershing, Riva, Ferretti Yachts, and Wally! Also, click here to download our best-ever Guide Book for the Palm Beach International Boat Show!