diff options
| author | Andrew Dolgov <[email protected]> | 2020-01-27 15:45:04 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2020-01-27 15:45:04 +0300 |
| commit | 47135160d1fd84e88ebfeb9400ca7ac8c965c39c (patch) | |
| tree | 7d7c083ff796fe60a839289077c83c4ee0469bdb /classes/counters.php | |
| parent | 076c5382fafcaf5ffd2bd41752e8e3c3b20e6af0 (diff) | |
getCategoryCounters: properly handle categories which don't have any stored feeds/articles
Diffstat (limited to 'classes/counters.php')
| -rw-r--r-- | classes/counters.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/classes/counters.php b/classes/counters.php index b65f0adeb..534dfe380 100644 --- a/classes/counters.php +++ b/classes/counters.php @@ -29,10 +29,10 @@ class Counters { SUM(CASE WHEN marked THEN 1 ELSE 0 END) AS count_marked, (SELECT COUNT(id) FROM ttrss_feed_categories fcc WHERE fcc.parent_cat = fc.id) AS num_children - FROM ttrss_feed_categories fc, ttrss_feeds f, ttrss_user_entries ue - WHERE f.cat_id = fc.id AND - ue.feed_id = f.id AND - ue.owner_uid = :uid + FROM ttrss_feed_categories fc + LEFT JOIN ttrss_feeds f ON (f.cat_id = fc.id) + LEFT JOIN ttrss_user_entries ue ON (ue.feed_id = f.id) + WHERE fc.owner_uid = :uid GROUP BY fc.id UNION SELECT 0, |