تصانيف يتيمة في ويكيداتا

SQL

USE arwiki_p;
#5038
#4916
SELECT CONCAT("# [[Category:",page_title,"]]"), CONCAT("[[:d:",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 pp_value is not NULL
AND ll_title IS NULL
AND page_namespace = 14
ORDER BY page_title;
#V.2
/*USE rowiki_p;
SELECT CONCAT("*[[:Categorie:",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
JOIN categorylinks
	ON page_id = cl_from
WHERE
page_namespace = 14 
    AND cl_to = "Categorii_de_redirecționare"
AND pp_value is not NULL
AND ll_title IS NULL#LIKE "Ciot%"
ORDER BY page_title;*/
SQL

Checking query status...
