Toolserver:User:LA2

LA2 is the username of Lars Aronsson, Sweden.

November 29, 2011: My link statistics have evolved to include some more namespaces (File, Author, Creator, Index, Museum, Portal) and all available websites. This runs as an SQL query on the toolserver for all databases (~la2/linkstats.sh), except for commons.wikimedia and en.wikipedia, where it times out. For these and for historic data, I have a different script (~la2/dumplinks.pl) that can parse the database dumps (page.sql and externallinks.sql). This is fine as a proof of concept. Now, in what format should these data be made available? And what kinds of reports are useful?

November 25, 2011: You can download linkstats.csv, containing statistics on external links for a number of Wikimedia projects. This is based on the following query:

select count(*), trim(leading 'www.' from substring_index(substring_index(el_to, '/', 3),'/',-1)) as site from externallinks, page where el_from = page_id and page_namespace=0 group by 2 having count(*) >= 10;

en:User:LA2 sv:Användare:LA2