[wp-trac] [WordPress Trac] #17141: In WP Admin -> Posts, sorting the list by Author actually sorts by Author ID

[WordPress Trac]

#17141: In WP Admin -> Posts, sorting the list by Author actually sorts by Author
ID
----------------------------+------------------------------
 Reporter:  aneesme         |       Owner:
     Type:  defect (bug)    |      Status:  assigned
 Priority:  normal          |   Milestone:  Awaiting Review
Component:  Administration  |     Version:  3.1
 Severity:  normal          |  Resolution:
 Keywords:                  |
----------------------------+------------------------------

Comment (by nofearinc):

 @scribu, I don't think that there is a way to order authors by author name
 without using a JOIN clause. A join would indeed affect the performance
 seriously having a large posts or users table but currently order_by takes
 place only for fields from the posts table.

 There could probably be an extra screen (implemented by a plugin) for
 listing this, but a join-driven one.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17141#comment:7>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software