From ef1ac7c73aeaf34129f26d0bda39bea3fc55eeb3 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 10 Aug 2007 05:12:29 +0100 Subject: limit tag browsing mode to top50 most popular --- functions.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'functions.php') 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(); -- cgit v1.2.3