diff options
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(); |