diff options
author | Luc Didry <[email protected]> | 2017-02-16 12:05:32 +0100 |
---|---|---|
committer | Luc Didry <[email protected]> | 2017-02-16 12:05:32 +0100 |
commit | 453787526ad7a115f0f321f6a4a810c6ebe5e089 (patch) | |
tree | e1bd95e9f66530b9d08e76a280337f5b75d6b200 /include/rssfuncs.php | |
parent | ad7cea62e19aab1815fa7fb4fd5e9a31fcc1314a (diff) |
Improve update_feedbrowser_cache SQL query
Diffstat (limited to 'include/rssfuncs.php')
-rw-r--r-- | include/rssfuncs.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/include/rssfuncs.php b/include/rssfuncs.php index 1f38091b6..e26fc38be 100644 --- a/include/rssfuncs.php +++ b/include/rssfuncs.php @@ -23,9 +23,8 @@ function update_feedbrowser_cache() { $result = db_query("SELECT feed_url, site_url, title, 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 (private IS true OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%')) + FROM ttrss_feeds WHERE feed_url NOT IN (SELECT feed_url FROM ttrss_feeds + WHERE private IS true OR auth_login != '' OR auth_pass != '' OR feed_url LIKE '%:%@%/%') GROUP BY feed_url, site_url, title ORDER BY subscribers DESC LIMIT 1000"); db_query("BEGIN"); |