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/2022-pursuit-os-385-offshore-pursuit-38-yacht-for-sale/9067779_2"><img src="../../../../photos/articles/1-pursuit38-2022-pursuit-38.jpg" alt="Image 1949: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2021-riva-dolceriva-epica-yacht-for-sale/8634818_2"><img src="../../../../photos/articles/1-epica-2021-riva-48-dolceriva.jpg" alt="Image 1951: " width="40%" height="auto" /></a></p>
<p><a href="../../../../used-yachts-for-sale/2023-ferretti-yachts-500-coalition-yacht-for-sale/8913732_2"><img src="../../../../photos/articles/1-coalition-2023-50-ferretti.jpg" alt="Image 1950: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2008-pershing-72-uptown-girl-yacht-for-sale/8739517_2"><img src="../../../../photos/articles/1-uptown-girl-2008-72-pershing.jpg" alt="Image 1948: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2008-huckins-linwood-marina-yacht-for-sale/7856284_2"><img src="../../../../photos/articles/1-marina-2008-huckins-linwood-60.jpg" alt="Image 2119: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2019-ferretti-yachts-850-crazy-yacht-for-sale/8316659_2"><img src="../../../../photos/articles/1-crazy-2019-ferretti-yachts-85.jpg" alt="Image 2117: " width="40%" height="auto" /></a> </p>
<p><a href="../../../../used-yachts-for-sale/2008-hampton-630-fun-seacalm-yacht-for-sale/9029684_2"><img src="../../../../photos/articles/1-funseacalm-2008-hampton-63.jpg" alt="Image 2164: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2011-intrepid-430-sport-yacht-islander-yacht-for-sale/8623556_2"><img src="../../../../photos/articles/1-islander-2011-intrepid-43.jpg" alt="Image 2444: " width="40%" height="auto" /></a></p>
<p><a href="../../../../used-yachts-for-sale/2022-princess-r35-princess-35-yacht-for-sale/9082207_2"><img src="../../../../photos/articles/1-princess-35-2022-princess-35.jpg" alt="Image 2447: " width="40%" height="auto" /></a> <a href="../../../../used-yachts-for-sale/2022-ferretti-yachts-550-time-2-fly-yacht-for-sale/8269495_2"><img src="../../../../photos/articles/1-time-2-fly-2022-ferretti-55.jpg" alt="Image 2450: " width="40%" height="auto" /></a></p>
<p><a href="../../../../used-yachts-for-sale/2020-pershing-70-liquid-yacht-for-sale/9000638_2"><img src="../../../../photos/articles/1-liquid-2020-70-pershing.jpg" alt="Image 2445: " width="40%" height="auto" /></a>. <a href="../../../../used-yachts-for-sale/2022-pershing-6x-bella-vita-yacht-for-sale/8867374_2"><img src="../../../../photos/articles/1-bella-vita-2022-6x-pershing.jpg" alt="Image 2438: " width="40%" height="auto" /></a></p>
<p><a href="../../../../used-yachts-for-sale/2023-riva-110-dolcevita-starfire-yacht-for-sale/8950131_2"><img src="../../../../photos/articles/1-starfire-2023-110-riva.jpg" alt="Image 2449: " width="40%" height="auto" /> </a><a href="../../../../used-yachts-for-sale/2021-riva-dolceriva-epica-yacht-for-sale/8634818_2"> <img src="../../../../photos/articles/riva-epica.jpg" alt="Image 2453: " width="40%" height="auto" /></a></p>
<p><a href="../../../../used-yachts-for-sale/2021-valhalla-boatworks-v-41-yacht-for-sale/9018519_2"><img src="../../../../photos/articles/pursuit341-2022-pursuit-41.jpg" alt="Image 2454: "Pursuit341_2022 PURSUIT 41"" width="40%" height="auto" /></a></p>
<p> </p> |
Just Reduced Used Yachts For Sale |
2023-11-14 12:39:22.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,pursuit341-2022-pursuit-41.jpg,riva-epica.jpg,1-bella-vita-2022-6x-pershing.jpg,1-uptown-girl-2008-72-pershing.jpg,1-time-2-fly-2022-ferretti-55.jpg,1-starfire-2023-110-riva.jpg,1-pursuit38-2022-pursuit-38.jpg,1-princess-35-2022-princess-35.jpg,1-marina-2008-huckins-linwood-60.jpg,1-liquid-2020-70-pershing.jpg,1-islander-2011-intrepid-43.jpg,1-funseacalm-2008-hampton-63.jpg,1-epica-2021-riva-48-dolceriva.jpg,1-crazy-2019-ferretti-yachts-85.jpg,1-coalition-2023-50-ferretti.jpg,1-beso-2023-ferretti-yachts-860.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 |