Category redirects connected in WD

SQL

USE ruwikinews_p;#enwiki_p;#commonswiki_p;
SELECT CONCAT('Category:',page_title)/*, pp_value*/,count(ll_title)
	FROM page
join categorylinks c1 on page_id=c1.cl_from
	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 page_namespace = 14 /*AND page_is_redirect = 1*/
    AND c1.cl_to = "Викиновости:Перенаправления_на_категории"#"Wikipedia_soft_redirected_categories"
    #"!Redirecionamentos_de_categorias"# - pt
    #"Categorii_de_redirecționare"# - ro || "Wikipedia_soft_redirected_categories"# - en || "Category_redirects" - commons
AND pp_value is not NULL
GROUP BY page_title
#AND ll_title IS NULL
ORDER BY page_title;
SQL

Checking query status...
