summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-03-07 00:01:34 +0100
committerYorhel <git@yorhel.nl>2009-03-07 00:01:34 +0100
commit0680666a8659e75a90d581f8f3a0e3172c16bcd1 (patch)
treed04490b676c1831962e9f3955f8202a3bdaecf6c /util
parenteaa8088edb36565d5dd232a624003f3aaef9ee9e (diff)
Adding list of VNs to tag pages
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.3.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/updates/update_2.3.sql b/util/updates/update_2.3.sql
index da43c8e1..533a6581 100644
--- a/util/updates/update_2.3.sql
+++ b/util/updates/update_2.3.sql
@@ -105,7 +105,7 @@ DECLARE
i RECORD;
l RECORD;
BEGIN
- FOR l IN SElECT id FROM tags WHERE EXISTS(SELECT 1 FROM tags_parents WHERE parent = id) LOOP
+ FOR l IN SElECT id FROM tags WHERE meta = FALSE AND EXISTS(SELECT 1 FROM tags_parents WHERE parent = id) LOOP
FOR i IN SELECT tag FROM tag_tree(l.id, 0, true) LOOP
FOR r IN SELECT l.id, vid, uid, vote, spoiler FROM tags_vn WHERE tag = i.tag LOOP
RETURN NEXT r;