diff options
author | Andrew Dolgov <[email protected]> | 2020-01-25 12:53:10 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2020-01-25 12:53:10 +0300 |
commit | 0e9e1ad112bb114ab023e01a3c1e68adad1c788a (patch) | |
tree | bba8f6d6248fdf7c32c9ba533cdef6ac03e11f95 /classes | |
parent | cdd2b6fd22ad28d6f6cdbdb5d0d4a713ea8b51e3 (diff) |
getCategoryUnread: return correct unread count for labels category
Diffstat (limited to 'classes')
-rwxr-xr-x | classes/feeds.php | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/classes/feeds.php b/classes/feeds.php index 4b3d72c93..8ef4f1f1c 100755 --- a/classes/feeds.php +++ b/classes/feeds.php @@ -1313,10 +1313,9 @@ class Feeds extends Handler_Protected { return 0; } else if ($cat == -2) { - $sth = $pdo->prepare("SELECT SUM(CASE WHEN unread THEN 1 ELSE 0 END) AS unread FROM - ttrss_user_entries ue, ttrss_user_labels2 l - WHERE article_id = ref_id AND - ue.owner_uid = :uid"); + $sth = $pdo->prepare("SELECT COUNT(DISTINCT article_id) AS unread + FROM ttrss_user_entries ue, ttrss_user_labels2 l + WHERE article_id = ref_id AND unread IS true AND ue.owner_uid = :uid"); $sth->execute(["uid" => $owner_uid]); $row = $sth->fetch(); |