Add in_wiki and in_wiki_en columns to tags and selected_tags table

1 files changed, 1 insertions, 1 deletions

diff --git a/sources/wiki/post.sql b/sources/wiki/post.sql
index 16d02ce..8d1fea3 100644
--- a/sources/wiki/post.sql
+++ b/sources/wiki/post.sql
@@ -23,7 +23,7 @@ CREATE INDEX relation_pages_rtype_idx ON relation_pages(rtype);
 CREATE INDEX wiki_images_image_idx ON wiki_images(image);
 
 INSERT INTO wikipages_keys (key,        langs, lang_count) SELECT key,        group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS     NULL GROUP BY key;
-INSERT INTO wikipages_tags (key, value, langs, lang_count) SELECT key, value, group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS NOT NULL GROUP BY key, value;
+INSERT INTO wikipages_tags (key, value, langs, lang_count) SELECT key, value, group_concat(lang || ' ' || status), count(*) FROM wikipages WHERE value IS NOT NULL AND value != '*' GROUP BY key, value;
 
 INSERT INTO wiki_languages (language, count_pages) SELECT lang, count(*) FROM wikipages GROUP BY lang;