From 67f02e2aa7b246ef7ca2b2aa4c62e2826327d219 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 29 Aug 2020 08:41:52 +0300 Subject: properly return counters for labels with zero assigned articles refs https://community.tt-rss.org/t/label-counter-doesnt-update-when-count-goes-down-to-zero/3766 --- classes/counters.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'classes/counters.php') diff --git a/classes/counters.php b/classes/counters.php index d8ed27621..4230fa4d4 100644 --- a/classes/counters.php +++ b/classes/counters.php @@ -234,8 +234,8 @@ class Counters { COUNT(u1.unread) AS total FROM ttrss_labels2 LEFT JOIN ttrss_user_labels2 ON (ttrss_labels2.id = label_id) - LEFT JOIN ttrss_user_entries AS u1 ON u1.ref_id = article_id - WHERE ttrss_labels2.owner_uid = :uid AND u1.owner_uid = :uid + LEFT JOIN ttrss_user_entries AS u1 ON u1.ref_id = article_id AND u1.owner_uid = :uid + WHERE ttrss_labels2.owner_uid = :uid GROUP BY ttrss_labels2.id, ttrss_labels2.caption"); $sth->execute([":uid" => $_SESSION['uid']]); -- cgit v1.2.3