use hewiki_p;

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 = "פירושון")

​