Show Duplicate (Double) Articles

RatilalBhoye

New Member
Hey , Friends Help Me.

Show Duplicate (Double) Articles in Last 24 Hours RSS Feed Category.
 

Attachments

  • Screenshot_2015-06-25-20-04-19.png
    Screenshot_2015-06-25-20-04-19.png
    253.1 KB · Views: 39

dandisama

New Member
To fix the duplicate feed issue use Group by PubDate having COUNT(PubDate) >= 1 at the end . For eg in Last 24 hours use PubDate > [NOW] – 86400000 AND IsDeleted = 0 Group by PubDate having COUNT(PubDate) >= 1

amm.... its some confused... can you paste a screenshot? thanks for the help. greetings
 

RatilalBhoye

New Member
Step- 1 : Open Your Main Feed Module > Go To [Feed} Tab . Click On Update Button> and Copy Feed GUID: Ex. adXX9ba49XX4d82a159XXX681dXXXcc.

Step-1 Main Feed GUID.png



Step- 2 : Open Your FeedQuery [latest] Module Details > Click On [Query] Tab. Paste Below Code [Note First Update Feed GUID Address]:

Step-2 Feed Query.png

FeedId IN (SELECT FeedId FROM Feed WHERE GUID IN ('adXX9ba49XX4d82a159XXX681dXXXcc')) AND EnclosureLink is null AND PubDate > [NOW] - 86400000 AND IsDeleted = 0

Step- 3 : Open Your FeedQuery [unreads] Module Details > Click On [Query] Tab. Paste Below Code [Note First Update Feed GUID Address]:

IsRead=0 AND IsDeleted = 0 AND FeedId IN (SELECT FeedId FROM Feed WHERE GUID IN ('adXX9ba49XX4d82a159XXX681dXXXcc')) AND EnclosureLink is null

Paste Your Feed GUID In Bold Text
Save All Changes!
 
Last edited:
Top