CfDs on Commons needing review

SQL

USE commonswiki_p;
(SELECT CONCAT ('* [[:Category:', REPLACE (page_title,'_',' '), ']] → has CfD cat but tag is missing or possibly malformed') AS catlist FROM page
INNER JOIN categorylinks ON cl_from = page_id AND cl_to LIKE 'CfD_%'
WHERE page_namespace = 14 AND page_is_redirect = 0
AND NOT EXISTS (SELECT 1 FROM templatelinks WHERE tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Category_for_discussion')
) UNION
(SELECT CONCAT ('* [[:Category:', REPLACE (page_title,'_',' '), ']] → has tag but CfD cat is missing') AS catlist FROM page
INNER JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Category_for_discussion'
WHERE page_namespace = 14 AND page_is_redirect = 0
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to LIKE 'CfD_%')
) UNION
(SELECT CONCAT ('* [[:Category:', REPLACE (page_title,'_',' '), ']] → has tag but link to discussion page is missing') AS catlist FROM page
INNER JOIN templatelinks ON tl_from = page_id AND tl_namespace = 10 AND tl_title = 'Category_for_discussion'
WHERE page_namespace = 14 AND page_is_redirect = 0
AND NOT EXISTS (SELECT 1 FROM pagelinks WHERE pl_from = page_id AND pl_from_namespace = 14 AND pl_namespace = 4 AND pl_title LIKE 'Categories_for_discussion/%')
) UNION
(SELECT CONCAT ('* [[:Category:', REPLACE (cp.page_title,'_',' '), ']] → has tag but discussion seems to be closed') AS catlist FROM page cp
INNER JOIN templatelinks ON tl_from = cp.page_id AND tl_namespace = 10 AND tl_title = 'Category_for_discussion'
INNER JOIN pagelinks ON pl_from = cp.page_id AND pl_from_namespace = 14 AND pl_namespace = 4 AND pl_title LIKE 'Categories_for_discussion/%'
INNER JOIN page dp ON dp.page_title = pl_title AND dp.page_namespace = 4
WHERE cp.page_namespace = 14 AND cp.page_is_redirect = 0
AND EXISTS (SELECT 1 FROM templatelinks WHERE tl_from = dp.page_id AND tl_namespace = 10 AND tl_title IN ('Cfdh','Delh'))
)
ORDER BY catlist
LIMIT 500;
SQL

Checking query status...
