Untitled query #6714

SQL

USE arwiki_p;
SELECT page_title
FROM page p
JOIN templatelinks
ON tl_from = page_id
#WHERE page_id NOT like '%موقع_رسمي%'
#and page_namespace = 0
WHERE p.page_id IN (
                SELECT ll_from
                FROM langlinks
                #
                WHERE ll_lang = =p.page_id)
                and ll_from = page_id
                AND  page_id NOT IN (SELECT page_title
                 FROM categorylinks
                 WHERE cl_from = page_id
                 and cl_to = "Official_website_different_in_Wikidata_and_Wikipedia" ))
AND  page_id NOT IN (SELECT
                      tl_from
                    FROM templatelinks
                    WHERE tl_title = "موقع_رسمي"
                    AND tl_namespace = 10)
  and p.page_namespace = 0
ORDER BY page_title
LIMIT 500;
SQL

Checking query status...
