red-cats with IW

SQL

USE enwiki_p;
SELECT /*CONCAT("Category:", page_title)*/CONCAT("# [[:en:Category:",page_title,"]]"), CONCAT("[[:d:",pp_value,"]]")
from page
join categorylinks on page_id=cl_from and page_namespace = 14
	/*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 cl_to = "Categorii_de_redirecționare"
#WHERE cl_to = "!Redirecionamentos_de_categorias"
WHERE cl_to = "Wikipedia_soft_redirected_categories"
and pp_value is not NULL
/*AND ll_title IS not NULL*/ 
# and page_title not like "%ţ%" and page_title not like "%ş%"
#AND page_namespace = 14/*(page_title like "%ţ%" or page_title like "%ş%")*/
GROUP BY page_title
ORDER BY page_title;
SQL

Checking query status...
