history - Quarry

Fork of et-fr by Edgars2007

This query is marked as a draft This query has been published by Edgars2007.

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="Portail:Histoire/Articles_liés"
               )
group by l.ll_from
having count(l.ll_lang)>15
order by count(l.ll_lang) desc;

​x
 
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 ljoin page p on p.page_id=l.ll_fromand 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="Portail:Histoire/Articles_liés"               )group by l.ll_fromhaving count(l.ll_lang)>15order by count(l.ll_lang) desc;​

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...