nn** - Quarry

SQL

USE enwiki_p;
SELECT   p.page_title
FROM page p
JOIN categorylinks
ON cl_from = p.page_id
WHERE cl_to = "Official_website_different_in_Wikidata_and_Wikipedia"
AND p.page_id  in (select ll_from from langlinks ll where ll_from=p.page_id)
and p.page_title in (select p2.page_title
                                from arwiki_p.page p2
                                where p2.page_is_redirect=0
                     and p2.page_namespace=0
                               and p2.page_id not in (SELECT
                      tl_from
                    FROM templatelinks
                    WHERE tl_title = 'موقع_رسمي'
                    AND tl_namespace = 10)
                    )
ORDER BY p.page_title
LIMIT 500;
SQL

Checking query status...
