USE enwiki_p;

SELECT CONCAT("https://en.wikipedia.org/?curid=", el_from) AS page, el_to

                from externallinks 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/%'

                OR ( el_to LIKE 'https://dl.acm.org/%'

                    AND el_to NOT LIKE 'https://dl.acm.org/author_page.cfm%'

                   AND el_to NOT LIKE 'http://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.%'

               ;