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);

#and

#(exists

# (select * from categorylinks

#  where cl_from = page_id) or

# exists

# (select * from templatelinks

select * from page

where page_namespace in (2, 3)

and page_is_redirect = 1

and exists

(select * from categorylinks

 where cl_from = page_id)

​