Members widget - sorting by 'Newest' not always reliable

[johnbillion]

I get the feeling I might have a hard job getting people to reproduce this one.

One (out of five) of my BuddyPress installations is not sorting the list of 'Newest' members in the Members widget correctly. See the widget on the front page of ​http://gaatalk.net/ . MySQL is returning the results unordered even though the query is thus:

SELECT DISTINCT ID as user_id, DATE_ADD( user_registered, INTERVAL 0 HOUR ) as user_registered FROM wp_users WHERE spam = 0 AND deleted = 0 AND user_status = 0 ORDER BY user_registered DESC

(The query can be found on line 131 of bp-core/bp-core-classes.php)

The results should be sorted by user_registered descending. After some tinkering, I found that it will correctly return the results ordered by user_registered if DISTINCT is removed from the query.

As ID is an auto_increment column, DISTINCT can be removed from the query without side effect. Any chance this could be considered?

[johnbillion]

patch

[apeatling]

I seem to recall this causing negative side effects when using that query in other places. I'm bumping this to 1.1 for consideration.

[johnbillion]

This SQL query now has a filter on it ('bp_core_newest_users_sql') so anyone experiencing the same issue can filter the query and remove the word 'DISTINCT'.

Recommending as WONTFIX due to the edge case nature and a workaround being available.

[apeatling]

Thanks.

[(none)]

Milestone Core 1.1 deleted