How to Setup Feed Query

beautiheart

Member
Hi,
Do you have any idea about a feed query for not showing duplicate articles from differents feed modules but from the same website.
Example:
Category A contain article1 and CategoryB contains the article1 too.
So in the last 24hours articles, it will show article1 twice.
i want to get rid of the second one.
Thank you
 

BOCo23

New Member
IsDeleted = 0 AND FeedId IN (SELECT DISTINCT FeedId FROM Feed WHERE GUID IN ('***','***','***',...,'***'))

This is not the best way and it's not working. Maybe some other idea?
 
Last edited:

joseph raphael

Well-Known Member
IsDeleted = 0 AND FeedId IN (SELECT DISTINCT FeedId FROM Feed WHERE GUID IN ('***','***','***',...,'***'))

This is not the best way and it's not working. Maybe some other idea?

It's working fine for me, make sure you put the feed GUID not the module GUID.
 

Mayapur Voice

New Member
Tried this too....can't figure out how it works :-(

I am sure so many people have this problem especially those pulling feeds from the same website using different categories and not all people know sql queries. For the time being I am forced to remove the "last 24 hours" module along with one more that I had created for last 30 days...
 
I've tried it and doesn't work at all because the disctinct clause is on feed guid and not on post_id, so if the same post appears in two feeds, the disctinct clause won't work and won't dedup the post.
 
Top