Talk page of redirects with major edits from anonymous user

SQL

select count(*) from page
join revision on rev_page = page_id and rev_id = page_latest and rev_parent_id = 0
join actor_revision on actor_id = rev_actor and actor_user is null
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
)

/*
select page_title, rd_title from page
join redirect on rd_from = page_id and rd_namespace = 0
where page_namespace = 0 and page_is_redirect = 1
and page_title in (
  select page_title from page where page_namespace = 1 and page_is_redirect = 0
  and page_id in (
    select rev_page from revision
    join actor_revision on actor_id = rev_actor and actor_user is null
    where rev_id = page_latest and rev_parent_id = 0
  )
)
and rd_title in (
  select page_title from page where page_namespace = 1 and page_is_redirect = 0
)
*/

/*
and page_id not in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget 
    where lt_title = 'WikiProject_banner' and lt_namespace = 828
  )
)
*/
-- group by page_id
-- having count(rev_id) < 2
SQL

Checking query status...
