2017 - Quarry

SQL

#use arwiki_p;
SELECT CONCAT('',arwikisource_p.page.page_title,'') AS ar
	FROM arwiki_p.page
	LEFT JOIN arwiki_p.langlinks
    	ON arwiki_p.langlinks.ll_from = arwiki_p.page.page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page =  arwiki_p.page.page_id
	LEFT JOIN frwiki_p.page  # (SELECT * FROM frwiki_p.page) AS enp 
	    ON arwiki_p.page.page_title= frwiki_p.page.page_title
WHERE arwiki_p.langlinks.ll_title IS NULL
and pp_value IS NULL
and arwiki_p.page.page_namespace = 0
and arwiki_p.page.page_is_redirect = 0 
#and pp_value is null
limit 5;
SQL

Checking query status...
