Assessment pages and categories not link to wikidata (arwiki)

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.

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_title NOT LIKE '%عداد_تصنيفات%' 
AND (page_title LIKE '%_الأهمية%' 
     OR page_title LIKE '%ذات_صنف%' 
     OR page_title LIKE '%غير_مقيمة%' 
     OR page_title LIKE '%_حسب_الجودة%' 
     OR page_title LIKE '%_حسب_الأهمية%' 
     OR page_title LIKE '%مقالات_مشروع_ويكي%')
AND page_namespace = 14
ORDER BY page_title;
#limit 100;

SQL

Checking query status...