diff options
author | Andrew Dolgov <[email protected]> | 2009-01-16 10:57:08 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-16 10:57:08 +0100 |
commit | 6c8feb8f1264469b30c7f57e2e98165ece5e5c3e (patch) | |
tree | f0ae37df0dbca0c759561a29c91326f80da91c10 | |
parent | 42fd0acfdc3023e6c05aef5994660d7331eaea14 (diff) |
top25 button uses feedbrowser cache
-rw-r--r-- | modules/pref-feeds.php | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/modules/pref-feeds.php b/modules/pref-feeds.php index 350d6d15d..790555421 100644 --- a/modules/pref-feeds.php +++ b/modules/pref-feeds.php @@ -68,11 +68,16 @@ $owner_uid = $_SESSION["uid"]; - $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers +/* $result = db_query($link, "SELECT feed_url,COUNT(id) AS subscribers FROM ttrss_feeds WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf WHERE tf.feed_url = ttrss_feeds.feed_url AND owner_uid = '$owner_uid') GROUP BY feed_url - ORDER BY subscribers DESC LIMIT 25"); + ORDER BY subscribers DESC LIMIT 25"); */ + + $result = db_query($link, "SELECT feed_url, subscribers FROM + ttrss_feedbrowser_cache WHERE (SELECT COUNT(id) = 0 FROM ttrss_feeds AS tf + WHERE tf.feed_url = ttrss_feedbrowser_cache.feed_url + AND owner_uid = '$owner_uid') ORDER BY subscribers DESC LIMIT 25"); print "<ul class='browseFeedList' id='browseFeedList'>"; |