diff options
Diffstat (limited to 'sources/wiki')
| -rw-r--r-- | sources/wiki/post.sql | 2 |
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; |