Untitled query #31338

SQL

USE arwiki_p;
SELECT  page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title NOT IN (
  SELECT pl_title
  FROM pagelinks
  WHERE pl_from_namespace = 0
  AND pl_namespace = 0
  AND pl_title = page_title
  AND pl_from NOT IN
  (SELECT page_id
   FROM page
   LEFT JOIN pagelinks
   ON pl_title = page_title
   AND pl_namespace = page_namespace
   WHERE page_namespace=0
   AND page_is_redirect=1
   AND pl_namespace IS NULL)
)
    and page_id not 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)
/* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
ORDER BY page_len DESC
limit 1000;
SQL

Checking query status...
