From f59a072aa6805bfce9ca4cc097c550af0f64879e Mon Sep 17 00:00:00 2001 From: Marc Tobias Date: Fri, 7 Jul 2023 17:36:11 +0200 Subject: [PATCH] These days the OSM wikipedia tab no longer contains URLs --- lib-sql/functions/importance.sql | 4 ---- 1 file changed, 4 deletions(-) diff --git a/lib-sql/functions/importance.sql b/lib-sql/functions/importance.sql index 44e8bc8b..6c089d82 100644 --- a/lib-sql/functions/importance.sql +++ b/lib-sql/functions/importance.sql @@ -62,10 +62,6 @@ BEGIN WHILE langs[i] IS NOT NULL LOOP wiki_article := extratags->(case when langs[i] in ('english','country') THEN 'wikipedia' ELSE 'wikipedia:'||langs[i] END); IF wiki_article is not null THEN - wiki_article := regexp_replace(wiki_article,E'^(.*?)([a-z]{2,3}).wikipedia.org/wiki/',E'\\2:'); - wiki_article := regexp_replace(wiki_article,E'^(.*?)([a-z]{2,3}).wikipedia.org/w/index.php\\?title=',E'\\2:'); - wiki_article := regexp_replace(wiki_article,E'^(.*?)/([a-z]{2,3})/wiki/',E'\\2:'); - --wiki_article := regexp_replace(wiki_article,E'^(.*?)([a-z]{2,3})[=:]',E'\\2:'); wiki_article := replace(wiki_article,' ','_'); IF strpos(wiki_article, ':') IN (3,4) THEN wiki_article_language := lower(trim(split_part(wiki_article, ':', 1))); -- 2.39.5