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

SQL

USE enwiki_p;
SELECT  cl_to, COUNT(cl_from)
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 page_title
       WHERE page_title LIKE "%Pages%"
    OR  "%All%"
    OR LIKE "%articles%"
    OR LIKE "%using%"
    OR LIKE "%Good"
    OR LIKE "%Wikipedia%"
    OR LIKE "%missing%"
    OR LIKE "%with%"
    OR LIKE "%language%"
    OR LIKE "%use%")
GROUP BY cl_to
ORDER BY COUNT(cl_from) DESC
LIMIT 100;
SQL

Checking query status...
