تصانیف غیر موجودة

SQL

USE enwiki_p;
SELECT cl_to
FROM categorylinks
WHERE cl_from IN (
        SELECT DISTINCT ll_from
        FROM langlinks
        WHERE ll_lang = "ar"
        )
    AND cl_to NOT IN (
        SELECT DISTINCT page_title
        FROM langlinks
        LEFT JOIN page ON page_id = ll_from
        WHERE ll_lang = "ar"
        AND page_namespace = 14
        )
    AND cl_to NOT IN (
        SELECT DISTINCT pl_from
        FROM pagelinks
        WHERE pl_title LIKE "Template:Hidden_category" 
        OR pl_title LIKE "Template:Template_category"
        AND pl_namespace = 10
        AND pl_from_namespace = 14      
        )
    AND cl_from NOT IN (
        SELECT  page_title  
        FROM page
        WHERE page_title LIKE %"emplate"%
        )        
      
GROUP BY cl_to LIMIT 20;
SQL

Checking query status...
