diff options
author | Andrew Dolgov <[email protected]> | 2020-08-29 08:41:52 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2020-08-29 08:41:52 +0300 |
commit | 67f02e2aa7b246ef7ca2b2aa4c62e2826327d219 (patch) | |
tree | 8716821def8c9aff6df96ac57cd592eebfa630ae /classes | |
parent | 5497a137de85d2412b1381c457127e38ed1f8768 (diff) |
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
Diffstat (limited to 'classes')
-rw-r--r-- | classes/counters.php | 4 |
1 files changed, 2 insertions, 2 deletions
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']]); |