nlwiki Categorie:Wikipedia:Desacode niet op Wikidata

SQL

SELECT COUNT(page_title) AS 'count', pi.cl_to AS cat
FROM categorylinks wdnow, page LEFT JOIN categorylinks pi ON (pi.cl_to REGEXP '^Plaats_in_|_van_' AND pi.cl_from=page_id)
WHERE wdnow.cl_to='Wikipedia:Desacode_niet_op_Wikidata' AND wdnow.cl_from=page_id AND page_namespace=0
GROUP BY cat
ORDER BY page_title
;
SELECT page_title, wdnow.cl_sortkey_prefix AS sort, pp_value AS 'item', REPLACE(ipnc.cl_sortkey_prefix,' ','') AS 'code', pi.cl_to AS cat
FROM
	categorylinks ipnc, 
    categorylinks wdnow, 
    page
    LEFT JOIN categorylinks pi ON (pi.cl_to REGEXP '^Plaats_in_|_van_' AND pi.cl_from=page_id)
    LEFT JOIN page_props ON (page_id=pp_page AND pp_propname='wikibase_item')
WHERE 
	ipnc.cl_to='Wikipedia:Indonesische_plaats_naar_code' AND ipnc.cl_from=page_id AND page_namespace=0
    wdnow.cl_to='Wikipedia:Desacode_niet_op_Wikidata' AND wdnow.cl_from=page_id
ORDER BY wdnow.cl_sortkey_prefix, page_title
SQL

Checking query status...
