test - Quarry

SQL

use arwiki_p;
SELECT #count(*)
p.page_title
#p.page_namespace, concat('* [[',p.page_title,']]')
#concat('Template:',p.page_title), CONCAT("Ssawiki"), concat('Template:',p.page_title)
#concat('* [[Template:',p.page_title,']]'), concat(' - [[:en:Template:',p.page_title,'|en]]')
from page p
where p.page_namespace=0
#and p.page_title not like "%/doc"
and p.page_is_redirect=0
#and p.page_id not in (SELECT  eu_page_id
			#		from wbc_entity_usage wb
			#		GROUP BY eu_page_id)
                    and p.page_id not in (select ll_from from langlinks ll where 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_namespace=0
                               and p2.page_id in (SELECT wb2.eu_page_id
													from enwiki_p.wbc_entity_usage wb2
												 	GROUP BY wb2.eu_page_id)
                          						     )
                    #limit 10;
and p.page_id not in (select cl_from
									from categorylinks
							where cl_to="Official_website_different_in_Wikidata_and_Wikipedia")
SQL

Checking query status...
