Untitled query #10195

SQL

USE fawiki_p;
select page.page_title,GROUP_CONCAT(CONCAT ("[[الگو:",tem.page_title,"]]")), count(tem.page_title) as cnt from page join categorylinks on page_id = cl_from and 
cl_to = 'همه_صفحه‌های_ابهام‌زدایی' join pagelinks on pl_title = page_title JOIN 
(select * from page where page_namespace = 10 and page_is_redirect = 0) as tem WHERE tem.page_id=pl_from and 
pl_namespace = 0 AND pl_from_namespace=10  and NOT tem.page_title LIKE "%_/_%" and 
page.page_namespace = 0 group by page.page_title order by 3 desc limit 1000;
SQL

Checking query status...
