use hewiki_p;

select * from page

where page_is_redirect = 1

and

(exists

# (select * from categorylinks

#  where cl_from = page_id) or

# exists

# (select * from templatelinks

#  where tl_from = page_id

#  and not tl_title = "שם_שגוי") or

# exists

 (select * from imagelinks

  where il_from = page_id))

​