use hewiki_p;

select * from page

where page_namespace = 0

and page_title like "%(%)%"

and not page_is_redirect

and exists

(select * from templatelinks

 where tl_from = page_id

 and tl_title = "פירוש_נוסף"

 and tl_namespace = 10)

​