use fawiki_p;

select p.page_title#, rd_title, tp.page_len

from page as p JOIN redirect ON rd_from = page_id AND rd_namespace = 1 JOIN page AS tp ON tp.page_title = rd_title AND tp.page_namespace = 1

where -- talk page is a redirect

p.page_namespace  = 1

and p.page_is_redirect = 1

and exists (

  select null

  from page

  -- related article is not a redirect

  where page_namespace = 0

  and page_title = p.page_title

  and page_is_redirect = 0

)

ORDER BY tp.page_len DESC;