SQL
AخA
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/%' */
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.
All SQL code is licensed under CC0 License.