Untitled query #12502

SQL

use arwiki_p;
select now();

use arwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
where 
pl.pl_title NOT IN (Select page_title from page where page_namespace=0) and pl.pl_from_namespace=0 and pl.pl_namespace=0
and pl.pl_title NOT IN (select pl_title from pagelinks pl where pl_from=184158) and
pl.pl_title NOT IN 
(
select pl_title
from pagelinks pl
left join page p on pl.pl_from=p.page_id
where
page_namespace=10 and pl_from IN (select tl_from
from templatelinks
where
tl_from_namespace=10)
and pl_namespace=0
)
	and pl.pl_title REGEXP '(ٍ|ِ|ٌ|ُ)' 
group by pl.pl_title
having COUNT(pl.pl_title)>1
order by COUNT(pl.pl_title) DESC
limit 50;
SQL

Checking query status...
