Most linked non-existing pages including templates (ltwiki)

SQL

select concat(_utf8'# [[',replace(`a`.`pl_title`,_utf8'_',_utf8' '),_utf8']] ([[:Specialus:Whatlinkshere/',
       replace(`a`.`pl_title`,_utf8'_',_utf8' '),_utf8'|',`a`.`kiekis`,_utf8' nuorodos]])') AS `title`
from (select `p`.`pl_title` AS `pl_title`,count(1) AS `kiekis`
  from `pagelinks` `p`
  where ((not(exists(select 1 AS `1`
    from `page` `pg`
    where ((`p`.`pl_namespace` = `pg`.`page_namespace`)
    and (`p`.`pl_title` = `pg`.`page_title`)))))
    and (`p`.`pl_namespace` = 0))
  group by `p`.`pl_namespace`,`p`.`pl_title`) `a`
where (`a`.`kiekis` > 10) order by `a`.`kiekis` desc;

SQL

Checking query status...