Hewiki partial disambiguation redirection problems

SQL

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, p2.page_title as 'disambig'
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 = "פירושון")
SQL

Checking query status...
