USE fawiki_p;

select distinct pl_title , GROUP_CONCAT(pagelist. page_title) , count(pagelist. page_title) from pagelinks join (select * from page join categorylinks on page_id = cl_from and cl_to = 'همه_صفحه•های_ابهام•زدایی' and page_namespace=0) as pagelist on pl_from= pagelist.page_id where pl_namespace=10 and pl_from_namespace=0 and not pl_title LIKE '%_/_%' group by pl_title order by 3 desc limit 100;

​