diff options
author | Andrew Dolgov <[email protected]> | 2007-08-10 05:12:29 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-08-10 05:12:29 +0100 |
commit | ef1ac7c73aeaf34129f26d0bda39bea3fc55eeb3 (patch) | |
tree | fca22c7ad572c6fe3b1c983a31bc86607eb6a699 /functions.php | |
parent | 2bc2147f2e726b8db29f93e2a14da91b641ced7d (diff) |
limit tag browsing mode to top50 most popular
Diffstat (limited to 'functions.php')
-rw-r--r-- | functions.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/functions.php b/functions.php index 5fc20841a..336a6d4b9 100644 --- a/functions.php +++ b/functions.php @@ -1913,7 +1913,8 @@ $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id) FROM ttrss_user_entries WHERE int_id = post_int_id AND unread = true)) AS count FROM ttrss_tags - WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name ORDER BY tag_name"); + WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name + ORDER BY count DESC LIMIT 55"); $tags = array(); @@ -3474,7 +3475,8 @@ $result = db_query($link, "SELECT tag_name,SUM((SELECT COUNT(int_id) FROM ttrss_user_entries WHERE int_id = post_int_id AND unread = true)) AS count FROM ttrss_tags - WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name ORDER BY tag_name"); + WHERE owner_uid = ".$_SESSION['uid']." GROUP BY tag_name + ORDER BY count DESC LIMIT 50"); $tags = array(); |