Hallo!
Comparing some of the special pages I wonder if it would be possible to add / expand sort criterias in MySQL queries especially because most of the pages here are limited and cached:
[[Special:Mostcategories]] sort by 1. number of references (members) *and* 2. title
[[Special:Mostimages]] sort by 1. number of references (how often imagy syntax is used) *and* 2. title
[[Special:Mostlinked]] sort by 1. number of references (links, category members, how often imagy syntax is used) *and* 2. namespace (by "ns value") *and* 3. title
[[Special:Mostlinkedcategories]] sort by 1. number of references (members) *and* 2. title
[[Special:Mostrevisions]] sort by 1. number of versions *and* 2. title
[[Special:Shortpages]] (ascending) and [[Special:Longpages]] (descending) sort by 1. number of bytes *and* 2. title
[[Special:Wantedcategories]] sort by 1. number of references (members) *and* 2. title
[[Special:Wantedpages]] sort by 1. number of references (links, category members, how often imagy syntax is used) *and* 2. namespace (by "ns value") *and* 3. title
[[Special:Whatlinkshere]] *sort by* 1. namespace (by "ns value") 2. title
see http://bugzilla.wikimedia.org/show_bug.cgi?id=2306 Special:Whatlinkshere lists ordered by creation timestamp - ordering and filtering should be possible
best regards reinhardt [[user:gangleri]]
On 05/05/06, Reinhardt WIEWE @ torg.is gangleri@torg.is wrote:
Hallo!
Comparing some of the special pages I wonder if it would be possible to add / expand sort criterias in MySQL queries especially because most of the pages here are limited and cached:
[snip]
This would be awesome, but requires two things:
1) We need to index querycache to hell. Not a problem, I don't think. 2) The QueryPage wrappers would need rewriting to fully support this (we don't want to end up with sorting &c. applied to our caching SELECT queries). Again, not *too* much of a problem; just time.
At one point, I had a namespace filter for some of these pages complete. It wasn't too neat, but wasn't too much of a mess either, although I never committed it.
Rob Church
wikitech-l@lists.wikimedia.org