I installed a Wordpress plugin to display registered users and need it to sort by last name.

Here is the query I think needs to be changed.

$query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY user_nicename LIMIT $offset, $usersPerPage";

The plugin author suggested this, but it did not work.

$query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY $wpdb->usermeta.last_name LIMIT $offset, $usersPerPage";

Here is the link if you want to look at the whole php file.
http://wordpress.org/extend/plugins/wordpress-users/

I'm not familiar with wordpress but the following should work.

PHP Code:

$query = "SELECT ID, user_nicename FROM $wpdb->users WHERE ID = ANY (SELECT user_id FROM $wpdb->usermeta WHERE meta_value IN ($roles)) ORDER BY last_name LIMIT $offset, $usersPerPage"; 


Yeah, that doesn't work. When I use that no users are displayed.
I've done a lot of searching the last couple of days, I'm not so sure it's possible.
if you have any ideas I'm all ears.

Thanks