Untitled query #52592

SQL

select distinct pl_title from pagelinks as pl where 
pl.pl_namespace=0 and pl.pl_from_namespace=0
and pl.pl_title not like '%_in_%'
and ((select page_id from page where page_title=pl_title and page_namespace=0) is null) 
and ((select count(pl3.pl_title) from pagelinks as pl3 where pl3.pl_title=pl.pl_title and pl3.pl_namespace=0 and pl3.pl_from_namespace=10) = 0)
and ((select count(pl2.pl_title) from pagelinks as pl2 where pl2.pl_title=pl.pl_title and pl2.pl_namespace=0 and pl2.pl_from_namespace=0) > 50) 
limit 100;
SQL

Checking query status...
