From a12227eb394955dfdff2a6032b75156754f8f804 Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Sat, 6 Nov 2010 21:46:16 +0100 Subject: Finished report: Frequently Used Keys Without Wiki Page --- sources/master/master.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sources/master') 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); -- cgit v1.2.3