From 6dc2dccddbcd8a83a757e6131bf08590265d1bec Mon Sep 17 00:00:00 2001 From: Vitaly Takmazov Date: Tue, 17 Apr 2018 12:26:23 +0300 Subject: www: reduce tags cloud and its layout --- juick-server-jdbc/src/main/java/com/juick/service/TagServiceImpl.java | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'juick-server-jdbc/src') diff --git a/juick-server-jdbc/src/main/java/com/juick/service/TagServiceImpl.java b/juick-server-jdbc/src/main/java/com/juick/service/TagServiceImpl.java index 63e07bd2..0e371ab5 100644 --- a/juick-server-jdbc/src/main/java/com/juick/service/TagServiceImpl.java +++ b/juick-server-jdbc/src/main/java/com/juick/service/TagServiceImpl.java @@ -175,9 +175,7 @@ public class TagServiceImpl extends BaseJdbcService implements TagService { @Override public List getPopularTags() { return getJdbcTemplate().queryForList( - "SELECT name FROM tags WHERE top=1 ORDER BY name ASC", String.class) - .stream() - .collect(Collectors.toList()); + "select name from tags where noindex=0 order by stat_messages desc limit 20", String.class); } @Transactional(readOnly = true) -- cgit v1.2.3