Replicas browser and optimizer
This query is marked as a draft
This query has been published
All pages linking to the ODNB (using an encoded DOI) in enwiki mainspace.
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
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in