SQL
AخA
select p.page_id, p.page_namespace, p.page_title, p.page_len, l.translation_count from (
page p inner join (
select count(*) as translation_count, ll_from from langlinks group by ll_from
) l on p.page_id = l.ll_from
) where p.page_namespace = 0 order by l.translation_count desc limit 500;
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.