Most linked redirects in lvwiki

SQL

use lvwiki_p;
select pl.pl_title, COUNT(pl.pl_title)
from pagelinks pl
#left join page p on pl.pl_from=p.page_id
where pl.pl_title="1951._gada_Tour_de_France" and
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 where pl_from=184158) and
#and p.page_id NOT IN (select tl_from from templatelinks where tl_title="Navbox" and tl_from_namespace=10)
pl.pl_title NOT IN (select pl_title from pagelinks where pl_namespace = 0  and pl_from=288933)
	#and pl.pl_title NOT LIKE "%Tour_de_France"
group by pl.pl_title
having COUNT(pl.pl_title)>10
order by COUNT(pl.pl_title) DESC
limit 15;
SQL

Checking query status...
