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 is already archived') 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 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/Archive/%')
) 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 (page_title,'_',' '), ']] → has tag but CfD req is closed') 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 EXISTS (SELECT 1 FROM templatelinks WHERE tl_from = page_id AND tl_namespace = 10 AND tl_title IN ('cfdh','cfdf','delh','delf'))
)
LIMIT 10;
SQL

Checking query status...
