Links to ODNB from enwiki - using template/DOI

SQL

use enwiki_p;
SELECT distinct
    externallinks.el_from, externallinks.el_to, page.page_title, page.page_namespace
FROM
    externallinks INNER JOIN page
    ON page.page_id = externallinks.el_from
WHERE
    externallinks.el_to LIKE '%doi.org/10.1093!%2Fref:odnb%' ESCAPE '!'
    AND page.page_namespace=0;
    
    # interestingly, DOIs in templates are partly URLencooded
    # and show up as, eg, https://dx.doi.org/10.1093%2Fref%3Aodnb%2F31543
    # so "LIKE '%dx.doi.org/10.1093/ref:odnb%'" only throws up <100 cases, where the DOI is linked directly
    # (see https://quarry.wmflabs.org/query/10098 for that)
    # therefore use the encoded version to find ones coming through the template
    # there *should* be ~4k of these, but the LIKE pattern keeps breaking
    #
    # original version used dx.doi.org, now switched to doi.org as of 2021
SQL

Checking query status...
