# select concat(page, "{{כ}} ([[", disambig, "]])") from

select concat(page, "{{כ}} (", lists, ")") from

(select page, count(disambig1) as counter, group_concat(disambig1) as lists from

 (select distinct concat('[[', disambig, ']]') as disambig1, page, ns from

((select concat('# [[', case p1.page_namespace when 0 then '' when 6 then ':קובץ:' when 10 then 'תבנית:'

       else 'פורטל:' end,

       replace(p1.page_title, "_", " "), ']]') as page,

       replace(p2.page_title, "_", " ") as disambig,

       p1.page_namespace as ns

from pagelinks join page as p1 join page as p2 join redirect

on p1.page_id = pl_from

and pl_title = p2.page_title

and p2.page_id = rd_from

where pl_namespace = 0

and p1.page_namespace in (0, 6, 10, 100)

and rd_namespace = 0

and rd_title in

(select page_title

from page join categorylinks

on page_namespace = 0

and page_id = cl_from

and cl_to = 'פירושונים')

and not exists

(select * from categorylinks as cl1

 where cl1.cl_from = p1.page_id

 and cl1.cl_to = 'פירושונים')

and not p2.page_title like "%_(פירושונים)"

and p1.page_is_redirect = 0

and not exists

(select * from templatelinks

 where tl_from = p1.page_id

 and tl_title = "פירושון")

union

select concat('# [[', case p1.page_namespace when 0 then '' when 6 then ':קובץ:' when 10 then 'תבנית:'

       else 'פורטל:' end,

       replace(p1.page_title, "_", " "), ']]') as page,

       replace(p2.page_title, "_", " ") as disambig,

       p1.page_namespace as ns

from page as p1 join pagelinks on p1.page_id = pagelinks.pl_from and p1.page_namespace in (0, 6, 10, 100)

join page as p2 on pagelinks.pl_namespace = p2.page_namespace and pagelinks.pl_title = p2.page_title

where p1.page_is_redirect = 0

and not p2.page_title like "%_(פירושונים)"

and exists

(select * from categorylinks

 where p2.page_id = cl_from

 and cl_to = 'פירושונים')

and not exists

(select * from categorylinks

 where p1.page_id = cl_from

 and cl_to = 'פירושונים')

and exists

(select * from templatelinks

 where tl_from = p1.page_id

 and tl_title = "פירושון")) as t)

order by ns, page, disambig) tt

group by page

 order by count(disambig1) desc) ttt

where counter > 1

​