Articles in arwiki not linked to wikidata

Fork of Articles in arwiki not link to wikidata by Mr. Ibrahem

This query is marked as a draft This query has been published by FShbib.

* Categories: http://quarry.wmflabs.org/query/8092
-----------------------------------------------------------------------
with redirect Resultset (420626 rows) 

without redirect:
2759
Resultset (1710 rows) 
- 189 صفحة توضيح 
Resultset (1521 rows)

SQL

USE arwiki_p;
SELECT CONCAT(page_title), pp_value
	FROM page
	LEFT JOIN langlinks
    	ON ll_from = page_id
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
WHERE ll_title IS NULL
and pp_value IS NULL
#and page_id not in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="تصنيف_مخفي")
#and page_id not in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="تصنيف_ويكيبيديا")
#AND page_title not like "%بذرة%" AND page_title not like "ص.م/%"
AND page_namespace = 0 and page_is_redirect = 0
ORDER BY page_title;

SQL

Checking query status...