diff options
| author | Jochen Topf <jochen@topf.org> | 2010-11-06 21:46:16 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2010-11-06 21:46:16 +0100 |
| commit | a12227eb394955dfdff2a6032b75156754f8f804 (patch) | |
| tree | b4bbde64da694d60badfb416cceead5aed51237b /sources/master | |
| parent | 79f4ec1fa8238cce85ed2379544cb347fa965f57 (diff) | |
| download | taginfo-a12227eb394955dfdff2a6032b75156754f8f804.tar taginfo-a12227eb394955dfdff2a6032b75156754f8f804.tar.gz | |
Finished report: Frequently Used Keys Without Wiki Page
Diffstat (limited to 'sources/master')
| -rw-r--r-- | sources/master/master.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sources/master/master.sql b/sources/master/master.sql index 74fc146..331a464 100644 --- a/sources/master/master.sql +++ b/sources/master/master.sql @@ -46,8 +46,8 @@ INSERT INTO db.keys (key) SELECT DISTINCT k FROM josm.josm_style_rules WHERE k -- potlatch XXX -- INSERT INTO db.keys (key) SELECT DISTINCT key FROM merkaartor.keys WHERE key NOT IN (SELECT key FROM db.keys); -UPDATE db.keys SET in_wiki=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages); -UPDATE db.keys SET in_wiki_en=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE lang='en'); +UPDATE db.keys SET in_wiki=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE value IS NULL); +UPDATE db.keys SET in_wiki_en=1 WHERE key IN (SELECT distinct key FROM wiki.wikipages WHERE value IS NULL AND lang='en'); UPDATE db.keys SET in_josm=1 WHERE key IN (SELECT distinct k FROM josm.josm_style_rules); -- potlatch XXX UPDATE db.keys SET in_merkaartor=1 WHERE key IN (SELECT key FROM merkaartor.keys); |