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

[WordPress Trac]

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

Comment (by scribu):

 Yes, Core should handle it, but like I said, GROUP BY ID isn't going to
 cut it. You won't get the correct total:

 {{{
 SELECT COUNT(*)
 FROM wp_users
 ...
 GROUP BY ID
 }}}

 will always return 1.

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