WP shortcuts in need of a WT shortcut

SQL

use fawiki_p;
select
  concat('وپ:', p.page_title) as shortcut,
  length(p.page_title) / 2 as shortcut_length,
  concat('وپ:', pl_title) as target
from pagelinks
join page p
  on pl_from = p.page_id
  and p.page_namespace = 4 -- Shortcut
  and p.page_is_redirect = 1
join (
    select p1.page_title
    from templatelinks
    join page p1
      on tl_from = p1.page_id
      and p1.page_namespace = 4 -- Wikipedia page with a shortcut
    join page p2
      on p1.page_title = p2.page_title
      and p2.page_namespace = 5 -- Talk page exists
    where 
      tl_title = 'میانبر'
  ) dest
  on dest.page_title = pl_title
SQL

Checking query status...
