Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Nemo bis
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT page_title FROM page WHERE page_namespace = 0 AND page_id IN (select distinct(el_from) from externallinks where /* el_to LIKE 'http://dx.doi.org/%' OR el_to LIKE 'https://dx.doi.org/%' OR */ el_to LIKE 'http://www.tandfonline.com/doi/%' OR el_to LIKE 'https://www.tandfonline.com/doi/%' OR el_to LIKE 'http://www.sciencedirect.com/science/article/%' OR el_to LIKE 'https://www.sciencedirect.com/science/article/%' OR el_to LIKE 'http://linkinghub.elsevier.com/retrieve/pii/%' OR el_to LIKE 'https://linkinghub.elsevier.com/retrieve/pii/%' OR el_to LIKE 'http://www.journals.elsevierhealth.com/%' OR el_to LIKE 'https://www.journals.elsevierhealth.com/%' OR el_to LIKE 'http://link.springer.com/%' OR ( el_to LIKE 'https://link.springer.com/%' AND NOT el_to LIKE 'link.springer.com/journal/%' ) OR el_to LIKE 'http://journals.sagepub.com/doi/%' OR el_to LIKE 'https://journals.sagepub.com/doi/%' OR el_to LIKE 'http://pubs.acs.org/doi/%' OR el_to LIKE 'https://pubs.acs.org/doi/%' OR el_to LIKE 'http://ieeexplore.ieee.org/%' OR el_to LIKE 'https://ieeexplore.ieee.org/%' OR ( el_to LIKE 'http://www.nature.com/%' AND el_to NOT LIKE 'http://www.nature.com/news/%' ) OR ( el_to LIKE 'https://www.nature.com/%' AND el_to NOT LIKE 'https://www.nature.com/news/%' ) OR el_to LIKE 'http://www.sciencemag.org/c%' OR el_to LIKE 'https://www.sciencemag.org/c%' OR el_to LIKE 'http://science.sciencemag.org/c%' OR el_to LIKE 'https://science.sciencemag.org/c%' OR el_to LIKE 'http://academic.oup.com/%' OR el_to LIKE 'https://academic.oup.com/%' OR el_to LIKE 'http://journals.cambridge.org/%' OR el_to LIKE 'https://journals.cambridge.org/%' OR el_to LIKE 'https://www.cambridge.org/core/journals/%' OR el_to LIKE 'http://iopscience.iop.org/%' OR el_to LIKE 'https://iopscience.iop.org/%' OR el_to LIKE 'http://stacks.iop.org/%' OR el_to LIKE 'http://www.cell.com/%' OR el_to LIKE 'https://www.cell.com/%' OR el_to LIKE 'http://www.thelancet.com/%' OR el_to LIKE 'https://www.thelancet.com/%' OR el_to LIKE 'http://www.bmj.com/content/%' OR el_to LIKE 'https://www.bmj.com/content/%' OR el_to LIKE 'http://www.ingentaconnect.com/%' OR el_to LIKE 'https://www.ingentaconnect.com/%' OR ( el_to LIKE 'http://dl.acm.org/%' AND el_to NOT LIKE 'http://dl.acm.org/author_page.cfm%' ) OR ( el_to LIKE 'https://dl.acm.org/%' AND el_to NOT LIKE 'https://dl.acm.org/author_page.cfm%' ) OR el_to LIKE 'http://doi.acm.org/%' OR el_to LIKE 'http://meta.wkhealth.com/%' OR el_to LIKE 'https://meta.wkhealth.com/%' OR el_to LIKE 'http://journals.lww.com/%' OR el_to LIKE 'https://journals.lww.com/%' OR el_to LIKE 'http://www.nejm.org/%' OR el_to LIKE 'https://www.nejm.org/%' OR el_to LIKE 'http://psycnet.apa.org/%' OR el_to LIKE 'https://psycnet.apa.org/%' OR el_to LIKE 'http://jama.ama-assn.org/%' OR el_to LIKE 'http://jama.jamanetwork.com/%' OR el_to LIKE 'https://jama.ama-assn.org/%' OR el_to LIKE 'https://jama.jamanetwork.com/%' OR el_to LIKE 'http://www.informaworld.com/%' OR el_index LIKE 'http://org.royalsocietypublishing.%' OR ( ( el_index LIKE 'http://com.wiley.onlinelibrary%' OR el_index LIKE 'https://com.wiley.onlinelibrary%' ) AND NOT el_to LIKE '%/journal/%' ) OR el_index LIKE 'http://com.wiley.doi%' OR el_index LIKE 'https://com.els-cdn.%' OR el_index LIKE 'http://com.serialssolutions.%' OR el_index LIKE 'https://org.oclc.idm.%' /* OR ( el_to LIKE 'http://journals.%' AND el_to NOT RLIKE 'https?://journals.fcla.edu/.*' AND el_to NOT RLIKE 'https?://journals.lib.unb.ca/.*' AND el_to NOT RLIKE 'https?://journals.plos.org/.*' ) */ );
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...