nlwiki Lists of players not categorized in club category

SQL

SELECT page_title, GROUP_CONCAT(cl_to SEPARATOR ' | ') AS cl_to
FROM page pl LEFT JOIN categorylinks ON cl_from=pl.page_id
WHERE page_namespace=0 AND page_is_redirect=0 AND page_title REGEXP '^Lijst_van_spelers_van_' AND
	NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation') AND
	NOT EXISTS (SELECT *
                FROM categorylinks
                WHERE cl_from=page_id AND cl_to=REGEXP_REPLACE(page_title,'^Lijst_van_spelers_van_','')) AND
	EXISTS (SELECT *
            FROM page pc
            WHERE pc.page_namespace=14 AND pc.page_title=REGEXP_REPLACE(pl.page_title,'^Lijst_van_spelers_van_',''))

SQL

Checking query status...