Gebruiker:Valhallasw/pagina's met veel links
Query: select page_namespace,page_title,count(el_to),page_len,count(el_to)/page_len from nlwiki_p.externallinks left join nlwiki_p.page on el_from = page_id where el_index not like "http://org.wikipedia.%" and page_namespace = 0 group by el_from having count(el_to)/page_len > 0.005;
Result:
139 rows in set (5.21 sec)