Last modified: 2014-07-14 13:53:45 UTC
On a MediaWiki install we have special pages (https://www.wikidata.org/wiki/Special:SpecialPages) like Most linked-to pages and Pages with the most interwikis. The wikibase extension should add an extension for items with the most sitelinks. Rough query: SELECT ips_item_id, COUNT(ips_item_id) FROM wb_items_per_site GROUP by ips_item_id ORDER BY COUNT(ips_item_id) DESC LIMIT 100;
Maarten: You mean we should have such a special page on Wikidata? Or on the client (Wikipedia, Wikivoyage, Commons, ...)?
I was thinking about Wikidata itself.
Change 94830 had a related patch set uploaded by Bene: (bug 46217) Implement a special page to show items with the most sitelinks https://gerrit.wikimedia.org/r/94830
The suggested patch needs to be changed to allow more efficient SQL (see bug 40157 and bug 58032).
Change 94830 abandoned by Bene: (bug 46217) Implement a special page to show items with the most sitelinks Reason: this is not likely to get implemented this way https://gerrit.wikimedia.org/r/94830