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://www.tandfonline.com%'

                OR el_to LIKE 'https://www.tandfonline.com%'

                OR el_to LIKE 'http://www.sciencedirect.com/%'

                OR el_to LIKE 'https://www.sciencedirect.com/%'

                OR el_to LIKE 'http://link.springer.com/%'

                OR el_to LIKE 'https://link.springer.com/%'

                OR el_to LIKE 'http://journals.sagepub.com/%'

                OR el_to LIKE 'https://journals.sagepub.com/%'

                OR el_to LIKE 'http://pubs.acs.org/%'

                OR el_to LIKE 'https://pubs.acs.org/%'

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

                OR el_to LIKE 'https://www.sciencemag.org/%'

                OR el_to LIKE 'http://science.sciencemag.org/%'

                OR el_to LIKE 'https://science.sciencemag.org/%'

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

                OR el_to LIKE 'https://www.bmj.com/%'

                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%' )

                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%'

                OR el_index LIKE 'http://com.wiley.doi%'

                OR el_index LIKE 'https://com.els-cdn.%'

                OR el_index LIKE 'http://com.serialssolutions.%'

               );