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, 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
ORDER BY wdnow.cl_sortkey_prefix, page_title

SQL

Checking query status...