Links zur Wikipedialibrary

SQL

SELECT CONCAT('[[', replace(page_title, '_', ' '), ']]') AS Artikel,
       el_to AS Link,
       CASE WHEN el_to REGEXP '^.*/10\.*$'
            THEN CONCAT('[[doi:', REGEXP_REPLACE(REGEXP_REPLACE(el_to, '^.*/\(10\.*\)$', '\\1'), '(/pdf|/html|[?#].*)$', ''), ']]')
            # https://www-jstor-org.wikipedialibrary.idm.oclc.org/stable/10.5325/pennhistory.88.4.0548
            WHEN el_to REGEXP 'www-jstor-org.wikipedialibrary.*/stable/'
            THEN CONCAT('{{JSTOR|', REGEXP_REPLACE(REGEXP_REPLACE(el_to, '^.*/stable/\(.*\)$', '\\1'), '[?#].*$', ''), '}}')
            ELSE ''
            END AS DOI
  FROM externallinks, page
 WHERE el_to LIKE '%wikipedialibrary%'
   AND el_from = page_id
   AND page_namespace = 0
 ORDER BY el_to
SQL

Checking query status...
