select count(*) from page

join revision on rev_page = page_id and rev_id = page_latest and rev_parent_id = 0

where page_namespace = 1 and page_is_redirect = 0

and page_title in (

  select page_title from page where page_namespace = 0 and page_is_redirect = 1

)

and page_id not in (

  select tl_from from templatelinks where tl_target_id in (

    select lt_id from linktarget 

    where lt_title in ('Talk_page_of_redirect', 'Old_RfD', 'Old_XfD_multi', 'Old_MfD') and lt_namespace = 10

  )

)

-- group by page_id

-- having count(rev_id) < 2