Pages included in category with the same title

Lists pages for which a category with the same name exists and the page is in this category.
First column is the page title, second column contains all the categories containing category with the same name as page.

SQL

USE huwiki_p;
SELECT article.page_title, GROUP_CONCAT(CONCAT('[[Kategória:',cl_cat.cl_to,']]') SEPARATOR ';')
FROM category
inner join page as article
on article.page_title = category.cat_title
#inner join categorylinks as cl_article
#on cl_page.cl_from = article.page_id and cl_page.cl_to = category.cat_title
inner join page as cat
on cat.page_namespace = 14 and cat.page_title = category.cat_title
inner join categorylinks as cl_cat
on cl_cat.cl_from = cat.page_id
WHERE article.page_namespace = 0
#ORDER BY page_title
GROUP BY article.page_title

SQL

Checking query status...