diff options
author | Andrew Dolgov <[email protected]> | 2007-06-02 03:42:27 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-06-02 03:42:27 +0100 |
commit | 1b1b8a7b848d726d944976f1bad26a616cfac049 (patch) | |
tree | 3b678e5bd903a986419d4d8f0c64b1cdeabccbe9 | |
parent | 1e7cbe16f3bd22b204e6213c3ad19035651229da (diff) |
getFeedCounters: use JOIN
-rw-r--r-- | functions.php | 17 |
1 files changed, 15 insertions, 2 deletions
diff --git a/functions.php b/functions.php index 841045bb7..253223acd 100644 --- a/functions.php +++ b/functions.php @@ -1983,7 +1983,7 @@ $old_counters = $_SESSION["fctr_last_value"]; - $result = db_query($link, "SELECT id,last_error,parent_feed, +/* $result = db_query($link, "SELECT id,last_error,parent_feed, SUBSTRING(last_updated,1,19) AS last_updated, (SELECT count(id) FROM ttrss_entries,ttrss_user_entries @@ -1991,7 +1991,20 @@ ttrss_user_entries.ref_id = ttrss_entries.id AND unread = true AND owner_uid = ".$_SESSION["uid"].") as count FROM ttrss_feeds WHERE owner_uid = ".$_SESSION["uid"] . " - AND parent_feed IS NULL"); + AND parent_feed IS NULL"); */ + + $result = db_query($link, "SELECT ttrss_feeds.id, + SUBSTRING(ttrss_feeds.last_updated,1,19) AS last_updated, + last_error, + COUNT(ttrss_entries.id) + FROM ttrss_feeds + LEFT JOIN ttrss_user_entries ON (ttrss_user_entries.feed_id = ttrss_feeds.id + AND ttrss_user_entries.owner_uid = ttrss_feeds.owner_uid + AND ttrss_user_entries.unread = true) + LEFT JOIN ttrss_entries ON (ttrss_user_entries.ref_id = ttrss_entries.id) + WHERE ttrss_feeds.owner_uid = ".$_SESSION["uid"]." + AND parent_feed IS NULL + GROUP BY ttrss_feeds.id, ttrss_feeds.title, ttrss_feeds.last_updated, last_error"); $fctrs_modified = false; |