nlwiki IMDb IDs for import to Wikidata

SQL

SELECT cl_sortkey_prefix, page_title, r0.rev_timestamp AS created, r1.rev_timestamp AS 'last-mod', '' AS el_to, pp_value
FROM categorylinks, externallinks
	INNER JOIN page ON cl_from=page_id
    INNER JOIN page_props ON cl_from=pp_page AND pp_propname='wikibase_item'
    INNER JOIN revision r0 ON cl_from=r0.rev_page AND r0.rev_parent_id=0
    INNER JOIN revision r1 ON cl_from=r1.rev_page AND r1.rev_id=page_latest
WHERE cl_from=el_from AND
	cl_to='Wikipedia:IMDb-code_niet_op_Wikidata' AND el_to REGEXP '^(https?:)?//(www\\.)?imdb\\.com/[a-z]+/[a-z]{2}[0-9]+/$'
ORDER BY cl_sortkey_prefix, page_title

SQL

Checking query status...