aboutsummaryrefslogtreecommitdiff
path: root/src/main/java/com/juick/service
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-10-18 17:23:37 +0300
committerGravatar Vitaly Takmazov2022-10-18 17:23:53 +0300
commit8f8e3bafdbe22c9beb27afb593bbc5b57512c53d (patch)
treeeef49f03963568e98e67afe603ef720608c2cbbb /src/main/java/com/juick/service
parentcc921ccb6bc13e69c716a4eff95c0740745777c1 (diff)
Better trends query on `/api/tags` endpoint
Diffstat (limited to 'src/main/java/com/juick/service')
-rw-r--r--src/main/java/com/juick/service/TagServiceImpl.java4
1 files changed, 2 insertions, 2 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