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_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?://(m|www)\.imdb\.com/[a-z]+/' AND ( # [a-z]{2}
    el_to REGEXP '\\?ref_=' OR
    el_to NOT REGEXP '^https?://www\.imdb\.com/(' 
    	'character/ch[0-9]{7}/|'
        'chart/top(\\?[0-9a-z_=/]+)?|'
        '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]{7,8}(/(1|[0-9a-z#/]+)?)?|'
        'news/ni[0-9]{7,8}/?|'
        'search/[a-z]+\\?.*|'
        'title/tt[0-9]{7,8}(/([0-9a-z#/=\\?]+)?)?|'
        'video/|'
        'year/(18[7-9][0-9]|19[0-9]{2}|20[0-2][0-9])'
    ')(#.*)?$')
LIMIT 50
SQL

Checking query status...
