Centralize empty talk pages of redirect

SQL

/*
select page_title from page where page_namespace = 0 and page_is_redirect = 0
and page_title in (select page_title from page where page_namespace = 1 and page_is_redirect = 0 and page_len < 7)
*/

/*
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_len < 7)
and rd_title in (select page_title from page where page_namespace = 1 and page_is_redirect = 0)
*/

select page_namespace, page_title, rd_namespace, rd_title from page p1
join redirect on rd_from = p1.page_id and rd_namespace % 2 = 0
where p1.page_is_redirect = 1 and p1.page_namespace % 2 = 0 and p1.page_namespace not in (2)
and p1.page_title in (
  select page_title from page where page_namespace = p1.page_namespace + 1 and page_is_redirect = 0 and page_len < 6
)
and rd_title in (
  select page_title from page where page_namespace = rd_namespace + 1 and page_is_redirect = 0
)

/*
select count(*) from page where page_namespace = 1 and page_is_redirect = 0 and page_len = 0
and page_title in (select page_title from page where page_namespace = 0 and page_is_redirect = 1)
*/
SQL

Checking query status...
