Author: Michael.Keppler
Description:
Example on English Wikipedia: https://en.wikipedia.org/w/index.php?title=Special:WantedPages&limit=500&offset=0
Wanted pages are sorted by count descending. It would be nice to have alphabetic
sorting of the page title as second sort order to get a better overview if many
wanted pages have the same count.
This can be implemented by someone who knows PHP and SQL in SpecialWantedPages.php.
Version: 1.23.0
Severity: enhancement
Michael.Keppler wrote:
Just a second note: If this is implemented, maybe the index on brokenlinks.bl_to
should be changed too for performance reasons. But I'm a complete database idiot
and don't know if SORT BY COUNT(somevalue) can profit from any kind of index.
I can still reproduce this problem today. :)
Entries with the same count are sorted with a non-evident criteria. I also think alphabetical sorting would be more interesting. Easy fix?
PS: I fouund this report after noticing that it *was* the oldest report that hadn't received any response http://korma.wmflabs.org/browser/bugzilla_response_time.html
Change 338965 had a related patch set uploaded (by EddieGP):
Improve sorting on SpecialWanted*-Pages
Change 338965 merged by jenkins-bot:
[mediawiki/core] Improve sorting on SpecialWanted*-Pages
Reopening as patch is wrong/going to be reverted in master
[19:20:36] <twentyafterfour> Error: 1054 Unknown column 'qc_ra.rd_namespace' in 'order clause' [19:20:55] <twentyafterfour> I see that error in wmf.16 [19:21:14] <jynus> qc_ra, that is new [19:21:57] <wikibugs_> (PS2) Chad: Scap3: Prep MediaWiki to be available from /srv/deployment [puppet] - https://gerrit.wikimedia.org/r/342788 [19:22:03] <twentyafterfour> the whole query was SELECT qc_type,qc_namespace AS `namespace`,qc_title AS `title`,qc_value AS `value` FROM `querycache` WHERE qc_type = 'DoubleRedirects' ORDER BY qc_ra.rd_namespace,qc_ra.rd_title LIMIT 5001
Change 343805 had a related patch set uploaded (by EddieGP):
[mediawiki/core] Follow-up Improve sorting on SpecialWanted*-Pages
Change 343805 merged by jenkins-bot:
[mediawiki/core@master] Follow-up Improve sorting on SpecialWanted*-Pages
New fix merged. Doesn't change the default behaviour by now, so this time it should finally work without breaking anything :-)