use hewiki_p;

select * from page

where (page_title like "%שבדי%" or page_title like "%נורבגי%")

and page_is_redirect = 0

and not page_namespace in (2, 3);

select page_namespace, page_title from page

where not page_namespace in (2, 3)

and ((exists

(select * from pagelinks

 where pl_from = page_id

 and (pl_title like "%שבדי%" or pl_title like "%נורבגי%")))

or (exists

(select * from templatelinks

 where tl_from = page_id

 and (tl_title like "%שבדי%" or tl_title like "%נורבגי%"))))

​