pmp edits (excluding bots) in the last 24 hrs

SQL

use fawiki_p;
select page_title,page_len,r1.rd_title
from page as p1 join redirect as r1 on rd_from = page_id
where -- talk page is a redirect
page_namespace  = 1
and page_is_redirect = 1
and exists (
  select null
  from page as p1
  -- related article is not a redirect
  where page_namespace = 0
  and page_title = p1.page_title
  and page_is_redirect = 0
)
and exists (
  select null
  from page as p2
  -- target's related article is a redirect
  where p2.page_namespace = 0
  and p2.page_title = r1.rd_title
  and p2.page_is_redirect = 1
  and exists (
    select null
    from redirect
    -- target's related article is a redirect back to the original title
    where rd_from = p2.page_id
    and rd_namespace = 0
    and rd_title = p1.page_title
  )
)
ORDER BY page_len DESC;
SQL

Checking query status...
