nlwiki MovieMeter ID for export to Wikidata

https://nl.wikipedia.org/wiki/Categorie:Wikipedia:Moviemeter_zonder_ID_op_Wikidata

`cmd` is bash-command line for wikibase-cli

SQL

SELECT
	page_title,
    CONCAT('claim_guid=$(wd add-claim ', pp_value, ' P', 
           CASE LEFT(cl_sortkey_prefix, 1) WHEN 'F' THEN '1970' WHEN 'P' THEN '9463' WHEN 'R' THEN '1969' ELSE '?' END,
           " '", RIGHT(cl_sortkey_prefix, LENGTH(cl_sortkey_prefix) - 1),
           "' | jq -r .claim.id); wd add-reference $claim_guid P143 Q10000") AS 'cmd'
FROM categorylinks, page, page_props
WHERE
	cl_to='Wikipedia:Moviemeter_zonder_ID_op_Wikidata' AND
    cl_from=page_id AND page_namespace=0 AND
    pp_page=page_id AND pp_propname='wikibase_item'
ORDER BY cl_sortkey_prefix

SQL

Checking query status...