summaryrefslogtreecommitdiff
path: root/functions.php
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2009-01-19 04:35:33 +0100
committerAndrew Dolgov <[email protected]>2009-01-19 04:35:33 +0100
commitd2b1c99be6b27b9bb079cc9843003235f04f2863 (patch)
treee1dd717cf655b620b66f5116e7473f0aae1b945b /functions.php
parent3584cb119e8f42a63034688b0ccfb2eb8242b227 (diff)
getLabelCounters: fix for read labels
Diffstat (limited to 'functions.php')
-rw-r--r--functions.php7
1 files changed, 3 insertions, 4 deletions
diff --git a/functions.php b/functions.php
index e1990d723..c43f71aae 100644
--- a/functions.php
+++ b/functions.php
@@ -2641,10 +2641,9 @@
LEFT JOIN ttrss_user_labels2 ON (label_id = ttrss_labels2.id)
LEFT JOIN ttrss_user_entries ON (ref_id = article_id AND
unread = true AND
- ttrss_user_entries.owner_uid = '$owner_uid'),ttrss_feeds
- WHERE ttrss_feeds.id = feed_id AND
- hidden = false AND
- ttrss_labels2.owner_uid = '$owner_uid'
+ ttrss_user_entries.owner_uid = '$owner_uid')
+ LEFT JOIN ttrss_feeds ON (ttrss_feeds.id = feed_id AND hidden = false)
+ WHERE ttrss_labels2.owner_uid = '$owner_uid'
GROUP BY ttrss_labels2.id, caption");
while ($line = db_fetch_assoc($result)) {