Citations with redundant publisher links

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://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 NOT LIKE 'http://www.nature.com/news/%' )
                OR ( el_to LIKE 'https://www.nature.com/%'
                    AND 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/%'
                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.%'
               );
SQL

Checking query status...
