et-fr - Quarry

use ruwiki_p;
select p.page_title, count(l.ll_lang), (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
where p.page_namespace=0 and p.page_title in (
			select p1.page_title
from templatelinks pl
join page p1 on pl.tl_from_namespace=p1.page_namespace and p1.page_id=pl.tl_from
where pl.tl_from_namespace=1 and pl.tl_title="Статья_проекта_Эстония"

)
		#where pla.page_namespace=1 and cla.cl_type="page" and cla.cl_to="WikiProject_Russia_articles")
and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="lv")
#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
limit 5000;

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
and p.page_namespace=0 and not exists (select * from langlinks m where m.ll_from=l.ll_from and m.ll_lang="lv")
	and exists (select * from categorylinks cla where cla.cl_type="page" and l.ll_from=cla.cl_from
               										and cla.cl_to in ("Portail:Estonie/Articles_liés","Portail:Tallinn/Articles_liés")
               )
group by l.ll_from
having count(l.ll_lang)>5
order by count(l.ll_lang) desc;

SQL

Checking query status...