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', el_to_path AS path, pp_value
FROM categorylinks
	INNER JOIN page ON cl_from=page_id
    INNER JOIN externallinks ON cl_from=el_from
    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_to='Wikipedia:IMDb-code_niet_op_Wikidata' AND 
	el_to_domain_index REGEXP '//com\\.imdb\\.' AND 
	el_to_path REGEXP '^/[a-z]+/[a-z]{2}[0-9]+'
ORDER BY cl_sortkey_prefix, page_title
SQL

Checking query status...
