]> git.wh0rd.org - tt-rss.git/commitdiff
feedbrowser_cache: add limit
authorAndrew Dolgov <fox@bah.spb.su>
Tue, 20 Jan 2009 10:03:35 +0000 (11:03 +0100)
committerAndrew Dolgov <fox@bah.spb.su>
Tue, 20 Jan 2009 10:03:35 +0000 (11:03 +0100)
functions.php

index 5d965eed117c65df1b4accccad11c603a3cbf98b..d80c6fb5e4b2014ca161b6bee28750bb40f16ee6 100644 (file)
                        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 feed_url LIKE '%:%@%/%')) 
-                               GROUP BY feed_url, title ORDER BY subscribers DESC");
+                               GROUP BY feed_url, title ORDER BY subscribers DESC LIMIT 1000");
        
                db_query($link, "BEGIN");