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] |
|
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 |