diff options
| author | fluffy <[email protected]> | 2012-06-21 08:52:50 -0700 |
|---|---|---|
| committer | fluffy <[email protected]> | 2012-06-21 08:52:50 -0700 |
| commit | 7e454e815dd67f0ac3804e213599be9bbbc2755e (patch) | |
| tree | 5e72cdc0d441887ff3e26717fb022fb9011617c7 /classes | |
| parent | ece7871113892e324c46a83f9628bdb74a0d92ca (diff) | |
Fix category count query for mysql
Diffstat (limited to 'classes')
| -rw-r--r-- | classes/pref_feeds.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/classes/pref_feeds.php b/classes/pref_feeds.php index bf9f18a94..1f875ba12 100644 --- a/classes/pref_feeds.php +++ b/classes/pref_feeds.php @@ -1192,7 +1192,7 @@ class Pref_Feeds extends Protected_Handler { print "</div>"; - $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"]." |