USE fawiki_p;

Select concat('# [[',page_title,']] : (',count(pl_title),') [[[tools:~dispenser/cgi-bin/dab_solver.py?lang=fa&page=',page_title,'|اصلاح]]]')

FROM page Inner JOIN pagelinks ON pl_from = page_id and page_namespace = 0 AND page_is_redirect = 0 where

 pl_title IN (select page_title from categorylinks join page where

cl_to = 'همه_صفحه•های_ابهام•زدایی' and page_namespace = 0 and cl_from = page_id)

GROUP BY page_id order by count(pl_title) desc;