use hewiki_p;

select page_namespace, page_title, tl_title from page join templatelinks

on tl_from = page_id

where page_is_redirect = 1

and not tl_title in ("שם_שגוי", "הפניה_לא_למחוק", "ללא_בוט", "משמאל לימין")

and not exists

(select * from imagelinks

 where il_from = page_id);

select page_title from page

where page_namespace = 0

and page_is_redirect = 1

and exists

(select * from categorylinks

 where cl_from = page_id

 and not cl_to = "דפים_המוסתרים_ממנועי_חיפוש")

​