[wp-trac] [WordPress Trac] #17582: Problems with duplicated users

[WordPress Trac]

#17582: Problems with duplicated users
--------------------------+---------------------
 Reporter:  scribu        |       Owner:  ryan
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:  3.2
Component:  Query         |     Version:
 Severity:  normal        |  Resolution:  fixed
 Keywords:  has-patch     |
--------------------------+---------------------

Comment (by Denis-de-Bernardy):

 Curious to know why a group by wasn't used, instead of a distinct.

 The distinct will cause the data to be sort by all fields in their select
 order, at which point dupe are eliminated.

 If we were to append the order by clause with the ID and then group by and
 order by the latter, by contrast, we'd eliminate the dups without needing
 to re-order at all.

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