Category redirects connected in WD

SQL

USE commonswiki_p;
SELECT CONCAT('Category:',page_title)/*, pp_value*/
	FROM page
join categorylinks c1 on page_id=c1.cl_from
#join categorylinks c2 on page_id=c2.cl_from and c2.cl_to like "%облысының_елді_мекендері"
	/*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 = "Category_redirects"
AND pp_value is not NULL
#AND ll_title IS NULL
ORDER BY page_title;

SQL

Checking query status...