red-cats with IW

SQL

USE enwiki_p;
SELECT CONCAT("Category:", page_title)
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 = "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
GROUP BY page_title
ORDER BY page_title;
SQL

Checking query status...
