nlwiki Lists of players not categorized in club category

SQL

SELECT page_title
FROM page pl 
WHERE page_namespace=0 AND page_is_redirect=0 AND page_title REGEXP '^Lijst_van_spelers_van_' AND
	NOT EXISTS (SELECT *
                FROM categorylinks, page pc
                WHERE
                	cl_from=pl.page_id AND
                	cl_to=REGEXP_REPLACE(pl.page_title,'^Lijst_van_spelers_van_','') AND
                    pc.page_namespace=14 AND
                    pc.page_title=cl_to)
;
SELECT
	page_title,
    cl_to,
    (EXISTS (SELECT * FROM page pc WHERE page_namespace=14 AND
             page_title=REGEXP_REPLACE(pl.page_title,'^Lijst_van_spelers_van_',''))) AS `exists`
FROM page pl LEFT JOIN categorylinks ON cl_from=pl.page_id AND cl_to NOT REGEXP '^Lijsten_van_voetballers_van_'
WHERE page_namespace=0 AND page_is_redirect=0 AND page_title REGEXP '^Lijst_van_spelers_van_'
HAVING cl_to IS NULL AND `exists`=1
SQL

Checking query status...
