Untagged empty categories (arwiki)

SQL

USE arwiki_p;
SELECT distinct CONCAT('# [[:تصنيف:',page_title,']]') AS page_title, str_to_date(rev_timestamp, '%Y%m%d%H%i%s') AS rev_timestamp
FROM categorylinks
RIGHT JOIN page
ON cl_to = page_title
JOIN revision
ON rev_page = page_id
WHERE page_namespace = 14
AND page_is_redirect = 0
AND rev_parent_id = 0
AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'تحويل_تصنيف')
AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'تصنيف_فارغ')
AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'توضيح_تصنيف')
AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_title = 'تصنيف_غير_مستخدم') 
AND cl_to IS NULL
SQL

Checking query status...
