nlwiki Suspicious IMDb links

This query is marked as a draft This query has been published by Bdijkstra.

https://nl.wikipedia.org/wiki/Gebruiker:Bdijkstra/quarry/IMDb

Takes a few seconds with recentchanges and ~1 minute without.

SQL

SELECT
	CONCAT('[',el_to,' ',REGEXP_SUBSTR(el_to,'/[a-z]+/.*'),']') AS el_to,
    CONCAT('[[:',REPLACE(page_title,'_',' '),']]') AS page_title
FROM externallinks, page
WHERE
	page_namespace=0 AND
    el_from=page_id AND
	el_to REGEXP '^https?://www\.imdb\.com/[a-z]+/[a-z]{2}' AND
    el_to NOT REGEXP '^https?://www.imdb.com/(' 
    	'company/co[0-9]{7}|event/ev[0-9/]+|genre/[a-z]+|list/ls[0-9}{9}|media/[a-z/]+|name/nm[0-9]{6}|news/ni[0-9]{7}|title/tt[0-9]{7}' 
        ')'

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...