SQL
AخA
select p1.page_title as title, p1.page_len as art_len, p2.page_len as talk_len, p2.page_len/p1.page_len as len_ratio from cswiki_p.page as p1 join cswiki_p.page as p2 on p1.page_title = p2.page_title where p1.page_namespace = 0 and p2.page_namespace = 1 having art_len >= 3000 and len_ratio > 1 order by len_ratio desc, talk_len desc, art_len desc, title asc;
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.