No. How much do you know about using WordPress filters? If not a lot… then first step would be to check them out in the WP Codex.
The members list class provides a filter named ‘sph_members_list_query’ which passes a query object. So in the theme spFunctions.php file you can use the
add_filter('sph_members_list_query', 'your_function_name');
call to create your own function to manipulate the SQL.
function your_function_name($spdb)
The $spdb object contains the following properties:
$spdb->table
$spdb->fields
$spdb->found_rows
$spdb->distinct
$spdb->left_join
$spdb->where
$spdb->orderby
$spdb->limits
I warn you though that this query is somewhat complex and is due to be reviewed in a future release (i.e., a 5.1 or later) to make it simpler – possibly breaking into more than one query.