Links to ODNB from enwiki - using template/DOI

SQL

use enwiki_p;
SELECT
    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 '%dx.doi.org/10.1093[%]2Fref[%]3Aodnb[%]2F%'
    AND page.page_namespace=0;
    
    # interestingly, DOIs in CS1 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 someone *isn't* using the template correctly
    # therefore use the encoded version to find ones coming through the template

SQL

Checking query status...