nlwiki Suspicious IMDb links

SQL

SELECT
	CONCAT('[',el_to,' ',REGEXP_SUBSTR(el_to,'/[a-z]+/.*'),']') AS el_to,
    CONCAT('[[:',REPLACE(page_title,'_',' '),']]') AS page_title
FROM (SELECT DISTINCT rc_namespace, rc_cur_id FROM recentchanges WHERE rc_type IN (0,1) AND rc_namespace=0) rc
	INNER JOIN page ON rc_cur_id=page_id
	INNER JOIN externallinks ON el_from=rc_cur_id
WHERE
	#page_namespace=0 AND
	el_to REGEXP '^https?://www\.imdb\.com/[a-z]+/' AND # [a-z]{2}
    el_to NOT REGEXP '^https?://www.imdb.com/(' 
    	'character/ch[0-9]{7}|'
        'chart/|'
        'company/co[0-9]{7}|'
        'event/(all$|ev[0-9/]+)|'
        'genre/[a-z]+|'
        'keyword/[a-z]+|'
        'list/ls[0-9]{9}|'
        'media/[a-z]+|'
        'name/nm[0-9]{6}|'
        'news/ni[0-9]{7}|'
        'search|'
        'title/tt[0-9]{7}|'
        'video/|'
        'year/(18[7-9][0-9]|19[0-9]{2}|20[0-2][0-9])'
    ')'
SQL

Checking query status...
