unused non-redirected categories on rowiki

SQL

USE rowiki_p;
#select * from page /*join categorylinks*/ where page_id = "39407";
select * from category /*join categorylinks*/ where cat_title = "Pagini_de_categorisit";
/*
show columns from category;
show columns from categorylinks;
SELECT CONCAT("Categorie:",cat_title)
FROM category
JOIN page
ON cat_title = page_title AND page_namespace = 14
left JOIN templatelinks
ON tl_from = page_id
and tl_namespace = 10
WHERE tl_title not IN ("redcat", "RedCat", "redirect_categorie") 
AND cat_pages = 0;*/#*/

SQL

Checking query status...