SQL
AخA
use enwiki_p;
select #concat('[[:de:',p.page_title,'|',p.page_title,']]') as dewiki, concat('[[',p.page_title,']]') as enwiki, count(l.ll_lang) as 'number of iw'
concat('* [[:en:',p.page_title,'|',p.page_title,']] - [[',p.page_title,']] - ',count(l.ll_lang))
#p.page_title, count(l.ll_lang)
from langlinks l
join page p on p.page_id=l.ll_from
where # l.ll_from in (select tl.tl_from from templatelinks tl
# where tl.tl_title="Infobox_Athlète" and tl_namespace=10 and tl.tl_from_namespace=0)
#and
p.page_namespace=0 and l.ll_from not in (select m.ll_from from langlinks m where m.ll_lang="ar")
group by l.ll_from
#having count(l.ll_lang)>20
order by count(l.ll_lang) desc
limit 6;9
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.