diff options
author | Théophile Helleboid - chtitux <[email protected]> | 2018-12-08 22:36:03 +0100 |
---|---|---|
committer | Théophile Helleboid - chtitux <[email protected]> | 2018-12-08 22:36:03 +0100 |
commit | c70dc852a19e5725dec9311a2257ded2be1cc061 (patch) | |
tree | f7934956f2bcaf6e5cba5231b5f2b009cb0db153 /classes/counters.php | |
parent | a0d332326c8ff511b8dd05008a4c368fef623434 (diff) |
Be explicit when id column is ambiguous
Diffstat (limited to 'classes/counters.php')
-rw-r--r-- | classes/counters.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/classes/counters.php b/classes/counters.php index 2de7d5a3a..cee901304 100644 --- a/classes/counters.php +++ b/classes/counters.php @@ -24,11 +24,11 @@ class Counters { $pdo = DB::pdo(); - $sth = $pdo->prepare("SELECT id AS cat_id, value AS unread, + $sth = $pdo->prepare("SELECT ttrss_feed_categories.id AS cat_id, value AS unread, (SELECT COUNT(id) FROM ttrss_feed_categories AS c2 WHERE c2.parent_cat = ttrss_feed_categories.id) AS num_children FROM ttrss_feed_categories, ttrss_cat_counters_cache - WHERE ttrss_cat_counters_cache.feed_id = id AND + WHERE ttrss_cat_counters_cache.feed_id = ttrss_feed_categories.id AND ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid AND ttrss_feed_categories.owner_uid = ?"); $sth->execute([$_SESSION['uid']]); @@ -172,7 +172,7 @@ class Counters { FROM ttrss_feeds, ttrss_counters_cache WHERE ttrss_feeds.owner_uid = ? AND ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid - AND ttrss_counters_cache.feed_id = id"); + AND ttrss_counters_cache.feed_id = ttrss_feeds.id"); $sth->execute([$_SESSION['uid']]); while ($line = $sth->fetch()) { |