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 |
2023-02-06 00:00:00.0 |
2023-02-06 00:00:00.0 |
353 |
[empty string] |
<p><span style="color: #3598db;"><strong>SHOW LOCATION | ONE HERALD PLAZA, MIAMI FLORIDA 33132</strong></span><br />Allied Marine Brokerage Yachts - Ramp D | Ferretti Group New Yachts Display - Ramp C</p>
<p><span style="color: #34495e;"><a style="color: #34495e;" href="#yd1"><strong>SCROLL DOWN FOR BOATS</strong></a></span></p>
<p><span style="color: #3598db;"><strong>DATES & TIMES<br /></strong></span>Wed-Sat, February 15-18 (10am to 7pm) and Sun, February 19th (10am to 5pm)</p>
<p><em>Download our best-ever Guide Book for the Miami International Boat Show! </em></p>
<p><span style="color: #ec008c;"><strong><a style="color: #ec008c;" href="../../../../download/6A678092E5A554D0977A85546015318AB845915B08F3686C16DED8FEE6FEF611">CLICK TO DOWNLOAD OUR MIAMI INTERNATIONAL BOAT SHOW GUIDE PDF</a></strong></span></p>
<p><span style="color: #3598db;"><strong><a id="yd1"></a>BROKERAGE YACHTS ON DISPLAY</strong></span></p>
<p><a href="../../../../used-yachts-for-sale/2017-riva-domino-super-movin-day-yacht-for-sale/8107516_2"><img src="../../../../photos/articles/movin-day-2017-riva-88-post.jpg" alt="Image 2004: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2002-mangusta-80-nicky-ds-yacht-for-sale/8669375_2"><img src="../../../../photos/articles/nicky-d-2002-mangusta-80-post.jpg" alt="Image 2005: " width="40%" height="auto" /> </a></p>
<p> <a href="../../../../used-yachts-for-sale/2021-riva-76-bahamas-baby-pearl-yacht-for-sale/8372584_2"><img src="../../../../photos/articles/baby-pearl-2021-riva-76-bahamas-post.jpg" alt="Image 1999: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2021-riva-88-folgore-our-trade-yacht-for-sale/8409078_2"><img src="../../../../photos/articles/our-trade-2021-riva-88-folgore-post.jpg" alt="Image 2006: " width="40%" height="auto" /></a></p>
<p><span style="color: #3598db;"><strong>FERRETTI GROUP NEW YACHTS ON DISPLAY</strong></span></p>
<p><a href="../../../../new-yachts-for-sale/Custom-Line-yachts/Custom-Line-Navetta-33"><img src="../../../../photos/articles/custom-line-navetta-33-post.jpg" alt="Image 2000: " width="40%" height="auto" /></a> <a href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-9X"><img src="../../../../photos/articles/pershing-9x-post.jpg" alt="Image 2008: " width="40%" height="auto" /></a></p>
<p><a href="../../../../new-yachts-for-sale/Pershing-yachts/Pershing-8X"><img src="../../../../photos/articles/pershing-8x-post.jpg" alt="Image 2007: " width="40%" height="auto" /></a> <a href="../../../../new-yachts-for-sale/Riva-yachts/Riva-90-Argo"><img src="../../../../photos/articles/riva-90-argo-post.jpg" alt="Image 2009: " width="40%" height="auto" /></a></p>
<p><a href="../../../../new-yachts-for-sale/Riva-yachts/Riva-56-Rivale"><img src="../../../../photos/articles/56-rivale-post.jpg" alt="Image 1997: " width="40%" height="auto" /></a> <a href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-860-Project"><img src="../../../../photos/articles/ferretti-yachts-860-post.jpg" alt="Image 2002: " width="40%" height="auto" /></a></p>
<p><a href="../../../../new-yachts-for-sale/Ferretti-yachts/Ferretti-Yachts-780"><img src="../../../../photos/articles/ferretti-yachts-780-post1.jpg" alt="Image 2001: " width="40%" height="auto" /></a> <a href="https://www.wally.com/Fleet/Model/p/20-295-448-PUB-EXT/n/wallypower58%20New"><img src="../../../../photos/articles/58-wallypower-post.jpg" alt="Image 1998: " width="40%" height="auto" /></a></p>
<p><a href="https://www.wally.com/Fleet/Model/p/20-294-447-PUB-EXT/n/wallytender48X"><img src="../../../../photos/articles/wallytender-48x-post.jpg" alt="Image 2010: " width="40%" height="auto" /></a></p> |
ALLIED MARINE AT THE 2023 MIAMI INTERNATIONAL BOAT SHOW |
2023-02-09 17:37: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 |
The show will take place at the Miami Beach Convention Center, Pride Park, Herald Plaza, Venetian Marina, Museum Park Marina, and Superyacht Miami at Yacht Haven Grande Miami. |
ALLIED MARINE AT THE 2023 MIAMI INTERNATIONAL BOAT SHOW |
1.0 |
|
[empty string] |
ALLIED MARINE AT THE 2023 MIAMI INTERNATIONAL BOAT SHOW |
website |
https://www.alliedmarine.com |
[empty string] |
mibs-logo-post-another4.jpg |
mibs-logo-post-another4.jpg,baby-pearl-2021-riva-76-bahamas-post.jpg,our-trade-2021-riva-88-folgore-post.jpg,movin-day-2017-riva-88-post.jpg,nicky-d-2002-mangusta-80-post.jpg,custom-line-navetta-33-post.jpg,riva-90-argo-post.jpg,56-rivale-post.jpg,pershing-9x-post.jpg,pershing-8x-post.jpg,ferretti-yachts-860-post.jpg,ferretti-yachts-780-post1.jpg,58-wallypower-post.jpg,wallytender-48x-post.jpg |
2023-02-06 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
|
[empty string] |
ALLIED MARINE AT THE 2023 MIAMI INTERNATIONAL BOAT SHOW |
yachting-news |
allied-marine-at-the-2023-miami-international-boat-show |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/allied-marine-at-the-2023-miami-international-boat-show |
0 |
[empty string] |
[empty string] |
[empty string] |
|
[empty string] |
[empty string] |
[empty string] |
ALLIED MARINE AT THE 2023 MIAMI INTERNATIONAL BOAT SHOW |
[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 = 'allied-marine-at-the-2023-miami-international-boat-show'
ORDER BY postedDate desc |