use lvwiki_p;

select now();

​

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 pl 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 pl

left join page p on pl.pl_from=p.page_id

where #pl.pl_title="1951._gada_Tour_de_France" and

page_namespace=10 and pl_from IN (select tl_from

from templatelinks

where

#(tl_title="Navbox" or tl_title="Sidebar") and

tl_from_namespace=10)

and pl_namespace=0

)

    #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 850;