مقالات غير يتيمة موسومة

SQL

USE arwiki_p;
SELECT page_title, 
       ((SELECT Count(pl_from) 
         FROM   pagelinks 
         WHERE  pl_from_namespace = 0 
                AND (( pl_title IN (SELECT page_title 
                                    FROM   redirect 
                                           INNER JOIN page 
                                                   ON rd_from = page_id 
                                    WHERE  page_namespace = 0 
                                           AND rd_title = p.page_title 
                                           AND rd_namespace = 0) )) 
                AND pl_namespace = 0 
                AND pl_from IN (SELECT page_id 
                                FROM   page 
                                WHERE  page_id = pl_from 
                                       AND page_namespace = 0 
                                       AND page_is_redirect = 0))) AS counts 
FROM   page p 
WHERE  page_namespace = 0 
       AND page_is_redirect = 0 
       AND page_id IN (SELECT cl_from 
                       FROM   categorylinks 
                       WHERE 
           cl_to like "%جميع_المقالات_اليتيمة%"
           AND cl_from = page_id) 
       AND page_id NOT IN (SELECT cl_from 
                           FROM   categorylinks 
                           WHERE  cl_to like "%صفحات_توضيح%" 
                                  AND cl_from = page_id) 
/*and page_title not in (select page_title from redirect inner join page on rd_from = page_id where page_namespace = 0 and rd_title = p.page_title)*/
HAVING counts > 3;
SQL

Checking query status...
