Separate names with a comma.
Discussion in 'Frequently Asked Questions' started by appyet, Feb 13, 2015.
Refer to: http://forum.appyet.com/index.php?threads/feed-query-only-rss-site.25/
Do you have any idea about a feed query for not showing duplicate articles from differents feed modules but from the same website.
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.
if you know sql, there might be a way to SELECT DISTINCT.
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.
Now is working. Looks like I've had a mistake in query.
Good to know.. I hate SQL
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.