@fox : sorry about the # using code quotes now i forgot.. (used to post in a forum that believe it or not is antique and does not have that )
Virgo i dont know what you are talking about. It returns the correct feeds. What SQL server are you using ? the query i used returns 11 unique feeds from the 28.
Your assumption is wrong else the query i suggested would not return 11 unique feeds. My feeds have NO auth, pwd or flag set (i can also give you a sqldump).
Bare a moment with me i just want to fix it, and if it happens on 4 different systems with different flavors out of the box then i can not be the only one unless nobody uses this feature. I know it seems you don't believe me (hence i can screenshot and provide you with the dumps)
your query returns absolutely nothing unless you change
and keep your entire query intact. I can give you screenshots (query + results ) in an email ,
In summary : your query no changes = no result on my machines (fresh untouched install)
your query with SELECT COUNT(id) != 0 results in 11 unique feeds (from the 28)
my little query (as a test no need to shame me for it it was just a test) = 11 unique feed as result.
I can only imagine somehow different sql flavors (postgress/mysql/mariadb are the cause ? ) or a setting wrong (doubt it) it is easy to run the query and show you the screenshots, as it would be nice to find out whats going on and why you have totally different results.
Second question why do you want to list 2 the same feeds one with auth and one without (if i understood you correctly as a user + password feed shouldn't be shared anyways normally, just my idea but i see the logic). Is there a reason for the second where clauses i left out?
True lol at the query as i said not that good in it however it does return the 11 unique feeds that are not private and not using a password which was i thought the point.
So Virgo maybe we can try to figure out what is happening as the original query in rssfunc form git does not work on my system yet the edited (yours with edit or my silly test) do return the unique feeds. i'll buy you good beer if you happen to travel to Belgium.
last dumb question (trying to find the differences here) are you using the latest git version ?
systems tested : Centos 6 - 7 - fedora server 21 - 22 (cant help it). latest mysql server and latest mariadb server on all flavors and combinations : the original query fails. (sorry am not good in postgres to take well care of it).
always only used latest git version in clean directory.
@ virgo :Can i have your config virgo on which you did the query test ? (mine and yours) i would like to build exactly your config also as its intriguing to me and i could learn tt-rss well, always usefull as its a great system in my opinion.