berlin - Quarry

SQL

select now();

use frwiki_p;
select count(l.ll_lang), p.page_title, 
(select m2.ll_title from langlinks m2 where m2.ll_from=l.ll_from and m2.ll_lang="en")
from langlinks l
join page p on p.page_id=l.ll_from
join categorylinks cla on cla.cl_type="page" and l.ll_from=cla.cl_from
where cla.cl_to="Portail:Berlin/Articles_liés"
and p.page_namespace=0 and not exists (select * from langlinks m where m.ll_from=l.ll_from and m.ll_lang="lv")
group by l.ll_from, cla.cl_to
having count(l.ll_lang)>5
order by count(l.ll_lang) desc
limit 1000;
SQL

Checking query status...
