nlwiki Self-referencing categories

Lists category information for category pages that have a category-link to itself.
Excludes Noindex-category.

SQL

SELECT * FROM page WHERE page_namespace=8 AND page_title='Noindex-category'
SELECT revision.* FROM page, revision WHERE page_namespace=8 AND page_title='Noindex-category' AND page_latest=rev_id
SELECT slots.* FROM page, revision, slots WHERE page_namespace=8 AND page_title='Noindex-category' AND page_latest=rev_id AND rev_id=slot_revision_id;
SELECT * FROM content LIMIT 1;
/*SELECT cl_to AS cat
FROM categorylinks, page
WHERE cl_to!='Wikipedia:Niet_te_indexeren_pagina\'s' AND cl_from=page_id AND page_namespace=14 AND cl_to=page_title*/

SQL

Checking query status...