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-11-22 00:00:00.0 |
2022-11-22 00:00:00.0 |
321 |
[empty string] |
<p><strong>RECENT PRICE REDUCTIONS ON USED YACHTS AND BOATS FOR SALE</strong>. <br />Below you will find used yachts and boats that have had a recent price reduction. Take this opportunity to find that yacht that best fits your needs at the price you want. For more information on these yachts for sale, click on the yacht you are interested in below or call us.</p>
<p><a href="../../../../used-yachts-for-sale/2020-pursuit-os-355-call-it-a-day-yacht-for-sale/8843068_2"><img src="../../../../photos/articles/2020-pursuit-35-call-it-a-day.jpg" alt="Image 1949: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2016-tiara-yachts-44-coupe-journey-yacht-for-sale/8535681_2"><img src="../../../../photos/articles/2016-tiara-yachts-45-journey.jpg" alt="Image 1951: " width="40%" height="auto" /></a></p>
<p><a href="../../../../used-yachts-for-sale/2021-riva-88-folgore-our-trade-yacht-for-sale/8409078_2"><img src="../../../../photos/articles/2021-riva-88-our-trade.jpg" alt="Image 1950: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2005-gamefisherman-custom-express-sportfish-slippery-slope-yacht-for-sale/8925514_2"><img src="../../../../photos/articles/2005-gamefisherman-45-slippery-slope.jpg" alt="Image 1948: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2023-ferretti-yachts-500-coalition-yacht-for-sale/8913732_2"><img src="../../../../photos/articles/2023-ferretti-yachts-50-coalition.jpg" alt="Image 2119: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2017-ferretti-yachts-750-sami-kay-iii-yacht-for-sale/8639664_2"><img src="../../../../photos/articles/2017-ferretti-yachts-75-sami-kay-iii.jpg" alt="Image 2117: " width="40%" height="auto" /></a> </p>
<p><a href="../../../../used-yachts-for-sale/2022-riva-rivamare-carpe-vita-yacht-for-sale/8733766_2"><img src="../../../../photos/articles/2022-riva-38-carpe-vita.jpg" alt="Image 2164: " width="40%" height="auto" /></a></p> |
Just Reduced Used Yachts For Sale |
2023-07-06 15:52:36.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 |
PRICE REDUCTIONS ON USED YACHTS |
Just Reduced Used Yachts For Sale |
1.0 |
Brokerage Price Reduced Yachts for Sale |
[empty string] |
Just Reduced Used Yachts For Sale |
website |
https://www.alliedmarine.com |
[empty string] |
business-linkedin-banner-2.jpg |
business-linkedin-banner-2.jpg,2022-riva-38-carpe-vita.jpg,2017-ferretti-yachts-75-sami-kay-iii.jpg,2023-ferretti-yachts-50-coalition.jpg,2005-gamefisherman-45-slippery-slope.jpg,2021-riva-88-our-trade.jpg,2016-tiara-yachts-45-journey.jpg,2020-pursuit-35-call-it-a-day.jpg,2022-pershing-9x-trade.jpg,2020-pardo-38.jpg,2020-maori-54.jpg,2017-ferretti-yachts-650.jpg,2016-tiara-yachts-45.jpg,2015-azimut-70.jpg,2013-midnight-express-37.jpg,2008-ocean-37.jpg |
2023-04-24 00:00:00.0 |
[empty string] |
[empty string] |
3 |
[empty string] |
Brokerage Price Reduced Yachts for Sale |
[empty string] |
Just Reduced Used Yachts For Sale |
yachting-news |
just-reduced-used-yachts-for-sale |
[empty string] |
[empty string] |
https://www.alliedmarine.com/yachting-news/just-reduced-used-yachts-for-sale |
0 |
[empty string] |
[empty string] |
[empty string] |
Brokerage Price Reduced Yachts for Sale |
[empty string] |
[empty string] |
[empty string] |
Just Reduced Used Yachts For Sale |
[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 = 'just-reduced-used-yachts-for-sale'
ORDER BY postedDate desc |