Talk page of redirects with major edits from inexperienced user

SQL

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 not in (
    select rev_page from revision
    join actor_revision on actor_id = rev_actor
    join user on actor_user = user_id and user_editcount > 10
    where rev_minor_edit = 0 or rev_parent_id = 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
    )
  )
  /*
  and page_id not in (
    select tl_from from templatelinks where tl_target_id in (
      select lt_id from linktarget 
      where lt_title = 'Talk_page_of_redirect' and lt_namespace = 10
    )
  )
  */
  and page_id in (
    select cl_from from categorylinks
    where cl_to in ("Talk_pages_with_comments_before_the_first_section") and cl_type = 'page'
  )
)
and rd_title in (
  select page_title from page where page_namespace = 1 and page_is_redirect = 0
)

/*
select count(*) from page
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
    where rev_id = page_latest and rev_parent_id = 0
    and (actor_user is null or actor_user in (
      select user_id from user where user_editcount < 10
    ))
  )
  and page_id 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
    )
  )
  and page_id not in (
    select tl_from from templatelinks where tl_target_id in (
      select lt_id from linktarget 
      where lt_title = 'Talk_page_of_redirect' and lt_namespace = 10
    )
  )
)
*/

/*
select count(*) from page
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 not in (
    select rev_page from revision
    join actor_revision on actor_id = rev_actor
    join user on actor_user = user_id and user_editcount > 10
    where rev_minor_edit = 0 or rev_parent_id = 0
  )
  and page_id 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
    )
  )
  and page_id not in (
    select tl_from from templatelinks where tl_target_id in (
      select lt_id from linktarget 
      where lt_title = 'Talk_page_of_redirect' and lt_namespace = 10
    )
  )
)
*/
SQL

Checking query status...
