nlwiki Suspicious IMDb links

SQL

SELECT
	CONCAT('[//www.imdb.com',el_to_path,' ',REGEXP_SUBSTR(el_to_path,'/[a-z]+/.*'),']') AS el_to_path,
    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_domain_index REGEXP '^https?://com\\.imdb\\.(m|www)\\.$' AND
    el_to_path REGEXP '^/[a-z]+/' AND ( # [a-z]{2}
    el_to_path REGEXP '\\?ref_=' OR
    el_to_path NOT REGEXP '^/(' 
    	'character/ch[0-9]{7}/|'
        'chart/(bottom|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]+|rm[0-9]+/tt[0-9]+)?|'
        '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/[a-z0-9/]*|'
        'year/(18[7-9]|19[0-9]|20[0-2])[0-9]'
    ')(#.*)?$')
LIMIT 50
SQL

Checking query status...
