Untitled query #6714

SQL

USE arwiki_p;
SELECT p.page_title
FROM page p
#JOIN templatelinks
#ON tl_from = page_id
#WHERE page_id NOT like '%موقع_رسمي%'
#and page_namespace = 0
where p.page_namespace=0
and p.page_id IN  (select ll_from from langlinks ll where ll_from=p.page_id)
                and ll_from = p.page_id
                AND  p.page_title  IN (SELECT p2.page_title
                 from enwiki_p.page p2
                 where p2.page_is_redirect=0 
                AND  p2.page_title  IN   (FROM categorylinks
                 WHERE cl_from = p2.page_title
            and cl_to = "Official_website_different_in_Wikidata_and_Wikipedia" ))   


  and p.page_namespace = 0
ORDER BY page_title
LIMIT 510;
SQL

Checking query status...
