Categories in arwiki without links in wikidata

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

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

* Articles : http://quarry.wmflabs.org/query/8092
-----------------------------------------------------------------------
Resultset (21832 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_id not in (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 and tl_title="تحويل_تصنيف")
AND page_namespace = 14
ORDER BY page_title;
#limit 100;

SQL

Checking query status...