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

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 = 'allied-marine-at-the-2023-miami-international-boat-show' ORDER BY postedDate desc