diff options
Diffstat (limited to 'src/main/java/com')
-rw-r--r-- | src/main/java/com/juick/service/TagServiceImpl.java | 4 | ||||
-rw-r--r-- | src/main/java/com/juick/www/api/Tags.java | 3 |
2 files changed, 2 insertions, 5 deletions
diff --git a/src/main/java/com/juick/service/TagServiceImpl.java b/src/main/java/com/juick/service/TagServiceImpl.java index a5f3241a..81c0c3ba 100644 --- a/src/main/java/com/juick/service/TagServiceImpl.java +++ b/src/main/java/com/juick/service/TagServiceImpl.java @@ -172,11 +172,11 @@ public class TagServiceImpl extends BaseJdbcService implements TagService { public List<TagStats> getTagStats() { return getJdbcTemplate().query( "SELECT tags.name,COUNT(DISTINCT messages.user_id) AS cnt " + - "FROM (messages INNER JOIN messages_tags ON (messages.ts>TIMESTAMPADD(DAY,-3,NOW()) " + + "FROM (messages INNER JOIN messages_tags ON (messages.ts>TIMESTAMPADD(DAY,-14,NOW()) " + "AND messages.message_id=messages_tags.message_id)) " + "INNER JOIN tags ON messages_tags.tag_id=tags.tag_id " + "WHERE tags.tag_id NOT IN (SELECT tag_id FROM tags_ignore) " + - "GROUP BY tags.tag_id ORDER BY cnt DESC LIMIT 20", new TagStatsMapper()); + "GROUP BY tags.tag_id HAVING cnt > 1 ORDER BY cnt DESC LIMIT 20", new TagStatsMapper()); } @Transactional diff --git a/src/main/java/com/juick/www/api/Tags.java b/src/main/java/com/juick/www/api/Tags.java index c7941925..7d934f38 100644 --- a/src/main/java/com/juick/www/api/Tags.java +++ b/src/main/java/com/juick/www/api/Tags.java @@ -43,9 +43,6 @@ public class Tags { @Visitor User visitor, @RequestParam(required = false, defaultValue = "0") int user_id ) { - if (user_id == 0) { - user_id = visitor.getUid(); - } if (user_id > 0) { return tagService.getUserTagStats(user_id); } |