wplv ruwiki pages

SQL

use ruwiki_p;
select p.page_title, count(l.ll_lang)
from langlinks l
join page p on l.ll_from=p.page_id
where p.page_title in (select p2.page_title
						from templatelinks tl
						join page p2 on tl.tl_namespace=p2.page_namespace and p2.page_id=tl.tl_from
						where tl.tl_from_namespace=10 and tl.tl_namespace=1 and tl.tl_title="Статья_проекта_Латвия")
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="en")
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
SQL

Checking query status...
