Fork of
Citations with redundant publisher links
by Nemo bis
This query is marked as a draft
This query has been published
by Nemo bis.
SQL
AخA
USE enwiki_p;
SELECT CONCAT("https://en.wikipedia.org/?curid=", el_from) AS page, el_to
FROM page
JOIN externallinks
ON el_from = page_id
AND page_namespace = 0
WHERE 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://dx.doi.org/%'
OR el_to LIKE 'https://dx.doi.org/%'
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 'http://iopscience.iop.org/%'
OR el_to LIKE 'https://iopscience.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_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/.*' ) */
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.%'
;
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.