From 7e454e815dd67f0ac3804e213599be9bbbc2755e Mon Sep 17 00:00:00 2001 From: fluffy Date: Thu, 21 Jun 2012 08:52:50 -0700 Subject: [PATCH] Fix category count query for mysql --- classes/pref_feeds.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/classes/pref_feeds.php b/classes/pref_feeds.php index bf9f18a9..1f875ba1 100644 --- a/classes/pref_feeds.php +++ b/classes/pref_feeds.php @@ -1192,7 +1192,7 @@ class Pref_Feeds extends Protected_Handler { print ""; - $result = db_query($this->link, "SELECT c.title, c.id,COUNT(f.*) AS count + $result = db_query($this->link, "SELECT c.title, c.id,COUNT(f.id) AS count FROM ttrss_feed_categories AS c LEFT JOIN ttrss_feeds AS f ON (f.cat_id = c.id) WHERE c.owner_uid = ".$_SESSION["uid"]." -- 2.39.5