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

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 page_title LIKE'%rticles%'
        OR  page_title LIKE'%needing%'
        OR  page_title LIKE'%containing%'
        OR  page_title LIKE'%ategor%'
        OR  page_title LIKE'%with%'
        OR  page_title LIKE'%ommons%'
        OR  page_title LIKE'%ikidata%'
        OR  page_title LIKE'%ages%'
        OR  page_title LIKE'%language%'
        OR  page_title LIKE'%dates%'
        OR  page_title LIKE'%nfobox%'
        )
GROUP BY cl_to
ORDER BY COUNT(cl_from) DESC LIMIT 100;
SQL

Checking query status...
