Categories in arwiki and orphan in wikidata

SQL

USE arwiki_p;
SELECT CONCAT("تصنيف:",page_title)#, pp_value
	FROM page
	LEFT JOIN langlinks
    	ON ll_from = page_id
#and pp_value IS NULL
WHERE page_namespace = 14
and page_id  in (SELECT pp_value FROM page_props WHERE pp_propname = 'wikibase_item' and pp_page = page_id)
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 ll_title IS NULL
AND page_title not like "%بذرة%"
AND page_title not like "%ويكيبيديون%"
#AND page_title  like "وفيات_%_هـ"
AND page_title not like "ويكيبيديون%"
#AND page_title not like "ص.م/%"
#AND page_title like "قرى_مديرية%"
ORDER BY page_title
limit 100;
SQL

Checking query status...
