From c49e78bef068f4c4607d6d572366661e40b404be Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Tue, 16 Oct 2012 17:31:27 +0700
Subject: blog title

---
 src/java/com/juick/http/www/Tags.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/java/com/juick/http/www/Tags.java')

diff --git a/src/java/com/juick/http/www/Tags.java b/src/java/com/juick/http/www/Tags.java
index 07cff582..534ca8ef 100644
--- a/src/java/com/juick/http/www/Tags.java
+++ b/src/java/com/juick/http/www/Tags.java
@@ -41,7 +41,7 @@ public class Tags {
             PreparedStatement stmt = null;
             ResultSet rs = null;
             try {
-                stmt = sql.prepareStatement("SELECT tags.name AS name,COUNT(DISTINCT messages.user_id) AS cnt FROM (messages INNER JOIN messages_tags ON (messages.ts>TIMESTAMPADD(DAY,-3,NOW()) AND messages.message_id=messages_tags.message_id)) INNER JOIN tags ON messages_tags.tag_id=tags.tag_id GROUP BY tags.tag_id ORDER BY cnt DESC LIMIT ?");
+                stmt = sql.prepareStatement("SELECT tags.name AS name,COUNT(DISTINCT messages.user_id) AS cnt FROM (messages INNER JOIN messages_tags ON (messages.ts>TIMESTAMPADD(DAY,-3,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 ?");
                 stmt.setInt(1, cnt);
                 rs = stmt.executeQuery();
                 rs.beforeFirst();
-- 
cgit v1.2.3