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