official - Quarry

SQL

USE enwiki_p;
SELECT
  page_title
FROM page
JOIN categorylinks
ON cl_from = page_id
WHERE cl_to = "Official_website_different_in_Wikidata_and_Wikipedia"
AND page_id IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar"
             #   AND  page_id NOT IN (SELECT
                 #     tl_from
                #    FROM templatelinks
               #     WHERE tl_title = 'موقع_رسمي'
               #     AND tl_namespace = 10)
                  AND  page_id NOT IN (                                     
                   
                    FROM arwiki_p.categorylinks SELECT   cl_from
                    WHERE cl_to = "قالب_موقع_رسمي_بوصلة_كما_في_ويكي_بيانات"
                   AND page_namespace = 14
                                      )
  
)
ORDER BY page_title
LIMIT 5000;
SQL

Checking query status...
