select * from page where page_is_redirect=1 and not exists( select 1 from redirect where rd_from=page_id )
