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-02-07 00:00:00.0	2022-02-07 00:00:00.0	245	[empty string]	<p>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!</p> <p>Also be sure to <a title="MIBS Show Guide" href="../../../../documents/Miami_Boat_Show_Guide.pdf" target="_blank">download our best-ever Guide Book for the Miami International Boat Show</a>! </p> <p style="text-align: left;"><a title="MIBS Boat Show Guide Book" href="../../../../documents/Miami_Boat_Show_Guide.pdf" target="_blank"> <img src="../../../../photos/articles/guide-download-banner.jpg" alt="Image 0877: " width="800" height="293" /> </a> </p> <h2>LOCATION</h2> <p>The show covers many venues in Miami & Miami Beach, and you will find us at</p> <p style="padding-left: 30px;"><strong>One Herald Plaza, Miami, Florida 33132</strong></p> <p style="padding-left: 60px;"><strong>Allied Marine</strong> - Ramp C, HP C88<br /><strong>Ferretti Group</strong> - Ramp B, HP B131</p> <h2><br />DATES & TIMES</h2> <ul> <li>Wednesday, February 16 - 10 am to 6 pm</li> <li>Thursday, February 17 - 10 am to 6 pm</li> <li>Friday, February 18 - 10 am to 7 pm</li> <li>Saturday, February 19 - 10 am to 7 pm</li> <li>Sunday, February 20 - 10 am to 5 pm</li> </ul> <p> </p> <h2>ALLIED MARINE<br />BROKERAGE YACHTS</h2> <p>"INTERVENTION"<br />2010 Azimut 100'<br /><a title="Intervention page" href="../../../../used-yachts-for-sale/2010-Azimut-205-Leonardo-Intervention-yacht-for-sale/8049854_2">(see listing & broker info)</a><br /><a title="Intervention page" href="../../../../used-yachts-for-sale/2010-Azimut-205-Leonardo-Intervention-yacht-for-sale/8049854_2"><img src="../../../../photos/articles/intervention-brokerage-profile.jpg" alt="Image 0865: " width="500" height="333" /></a></p> <p>"MONARC"<br />2018 Pershing 82'<br /><a title="Monarc page" href="../../../../used-yachts-for-sale/2018-Pershing-83-82-Monarc-yacht-for-sale/8185497_2">(see listing & broker info)</a><br /><a title="Monarc page" href="../../../../used-yachts-for-sale/2018-Pershing-83-82-Monarc-yacht-for-sale/8185497_2"><img src="../../../../photos/articles/monarc-brokerage-profile.jpg" alt="Image 0868: " width="500" height="333" /></a></p> <p>"ANONYMOUS"<br />2019 Azimut 70'<br /><a title="Anonymous listing page" href="../../../../used-yachts-for-sale/2019-Azimut-83-S7-ANONYMOUS-yacht-for-sale/7998352_2">(see listing & broker info)</a><br /><a title="Anonymous listing page" href="../../../../used-yachts-for-sale/2019-Azimut-83-S7-ANONYMOUS-yacht-for-sale/7998352_2"><img src="../../../../photos/articles/anonymous-brokerage-profile.jpg" alt="Image 0866: " width="500" height="333" /></a></p> <p>"MACLEAN"<br />2020 Maori 54'<br /><a title="MACLEAN page" href="../../../../used-yachts-for-sale/2020-Maori-54-54-Maclean-yacht-for-sale/8211847_2">(see listing & broker info)</a><br /><a title="MACLEAN page" href="../../../../used-yachts-for-sale/2020-Maori-54-54-Maclean-yacht-for-sale/8211847_2"><img src="../../../../photos/articles/maclean-brokerage-profile.jpg" alt="Image 0864: " width="500" height="333" /></a></p> <p> </p> <h2>FERRETTI GROUP<br />NEW YACHTS<br /> </h2> <h4>FERRETTI YACHTS</h4> <p>Ferretti Yachts 500 <br /><a title="Ferretti Yachts 500 listing page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-500">(see listing info)</a><br /><a title="Ferretti Yachts 500 listing page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-500"><img src="../../../../photos/articles/ferrettiyachts-500-.jpg" alt="Image 0852: " width="500" height="333" /></a></p> <p>Ferretti Yachts 550<br /><a title="Ferretti Yachts 550 page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-550">(see listing info)</a><br /><a title="Ferretti Yachts 550 page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-550"><img src="../../../../photos/articles/ferrettiyachts-550.jpg" alt="Image 0853: " width="500" height="333" /></a></p> <p>Ferretti Yachts 670<br /><a title="Ferretti Yachts 670 page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-670">(see listing info)</a><br /><a title="Ferretti Yachts 670 page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-670"><img src="../../../../photos/articles/ferrettiyachts-670.jpg" alt="Image 0854: " width="500" height="333" /></a></p> <p>Ferretti Yachts 720<br /><a title="Ferretti Yachts 720 page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-720">(see listing info)</a><br /><a title="Ferretti Yachts 720 page" href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-720"><img src="../../../../photos/articles/ferrettiyachts-720.jpg" alt="Image 0855: " width="500" height="333" /></a></p> <p> </p> <h4>PERSHING</h4> <p>Pershing 7X<br /><a title="Pershing 7X page" href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-7X">(see listing info)</a><br /><a title="Pershing 7X page" href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-7X"><img src="../../../../photos/articles/pershing-7x.jpg" alt="Image 0856: " width="500" height="333" /></a></p> <p>Pershing 8X<br /><a title="Pershing 8X page" href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-8X">(see listing info)</a><br /><a title="Pershing 8X page" href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-8X"><img src="../../../../photos/articles/pershing8x-brokerage-profile.jpg" alt="Image 0863: " width="500" height="333" /></a></p> <p>Pershing 9X<br /><a title="Pershing 9X page" href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-9X">(see listing info)</a><br /><a title="Pershing 9X page" href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-9X"><img src="../../../../photos/articles/pershing-9x.jpg" alt="Image 0857: " width="500" height="333" /></a></p> <p> </p> <h4>RIVA</h4> <p>Aquariva Super<br /><a title="Aquariva Super page" href="../../../../new-yachts-for-sale/Riva-yachts/Aquariva-Super">(see listing info)</a><br /><a title="Aquariva Super page" href="../../../../new-yachts-for-sale/Riva-yachts/Aquariva-Super"><img src="../../../../photos/articles/rivaaqsuper33.jpg" alt="Image 0858: " width="500" height="333" /></a></p> <p>Rivamare<br /><a title="Rivamare page" href="../../../../new-yachts-for-sale/Riva-yachts/Rivamare">(see listing info)</a><br /><a title="Rivamare page" href="../../../../new-yachts-for-sale/Riva-yachts/Rivamare"><img src="../../../../photos/articles/rivamare38.jpg" alt="Image 0861: " width="500" height="333" /></a></p> <p>Dolceriva<br /><a title="Dolceriva page" href="../../../../new-yachts-for-sale/Riva-yachts/Dolceriva">(see listing info)</a><br /><a title="Dolceriva page" href="../../../../new-yachts-for-sale/Riva-yachts/Dolceriva"><img src="../../../../photos/articles/rivadolceriva-hardtop-profile-brokerage.jpg" alt="Image 0862: " width="500" height="333" /></a></p> <p>Riva 110' Dolcevita<br /><a title="Riva 110' Dolcevita page" href="../../../../new-yachts-for-sale/Riva-yachts/Riva-110-Dolcevita">(see listing info)</a><br /><a title="Riva 110' Dolcevita page" href="../../../../new-yachts-for-sale/Riva-yachts/Riva-110-Dolcevita"><img src="../../../../photos/articles/rivadolcevita110.jpg" alt="Image 0860: " width="500" height="333" /></a></p> <p> </p> <h4>WALLY</h4> <p>wallytender48X<br /><img src="../../../../photos/articles/wallytender48x-002.jpg" alt="Image 0869: " width="500" height="281" /></p> <h2> </h2>	See Us At The Miami International Boat Show 2022	2022-02-14 14:13:39.0		[empty string]	[empty string]	1	1	1	1	0	0	1	1	0	1	0	1	[empty string]	[empty string]	[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	See our boats and dock locations for this year's show.	See Us At The Miami International Boat Show 2022	1.0	See our boats and dock locations for this years show.	[empty string]	See Us At The Miami International Boat Show 2022	website	https://www.alliedmarine.com	[empty string]	mibs-city-boats-crop1-sm.jpg	mibs-city-boats-crop1-sm.jpg,guide-download-banner.jpg,mibs-logo-screencap-sm.jpg,ferrettiyachts-550.jpg,monarc-brokerage-profile.jpg,anonymous-brokerage-profile.jpg,intervention-brokerage-profile.jpg,maclean-brokerage-profile.jpg,pershing8x-brokerage-profile.jpg,rivadolceriva-hardtop-profile-brokerage.jpg,rivamare38.jpg,rivadolcevita110.jpg,wallytender48x-002.jpg,rivaaqsuper33.jpg,pershing-9x.jpg,pershing-7x.jpg,ferrettiyachts-720.jpg,ferrettiyachts-670.jpg,ferrettiyachts-550.jpg,ferrettiyachts-500-.jpg	2022-02-07 10:00:00.0	[empty string]	[empty string]	3	[empty string]	See our boats and dock locations for this years show.	[empty string]	See Us At The Miami International Boat Show 2022	yachting-news	see-us-at-the-miami-international-boat-show-2022	[empty string]	[empty string]	https://www.alliedmarine.com/yachting-news/see-us-at-the-miami-international-boat-show-2022	0	[empty string]	[empty string]	[empty string]	See our boats and dock locations for this years show.	[empty string]	[empty string]	[empty string]	See Us At The Miami International Boat Show 2022	[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 = 'see-us-at-the-miami-international-boat-show-2022' ORDER BY postedDate desc

See Us At The Miami International Boat Show 2022

Feb 07, 2022

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 be sure to download our best-ever Guide Book for the Miami International Boat Show!