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_id IN ( SELECT ll_from  FROM langlinks WHERE ll_lang = "ar")
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;*/

USE enwiki_p;
SELECT   page_title as "English article"
from categorylinks inner join page 
#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   as "Lang code"
                FROM langlinks
                WHERE ll_lang = "ar"
and 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
                      p2.tl_from
                    FROM templatelinks p2
                    WHERE p2.tl_title = 'موقع_رسمي'
                    AND p2.tl_namespace = 10)
                 )
)
group by cl_from
ORDER BY p2.page_title
LIMIT 500;
SQL

Checking query status...
