Unfuck User Query

users.php

add_action( 'pre_user_query', 'fix_users' );

function fix_users( &$query ) {
	global $wpdb;
	
	if ( 'authors' !== $query->query_vars['who'] )
		return;
	
	$query->query_vars['fields'] = array( 'ID', 'display_name' );
	$query->query_fields = 'ID, display_name';
	$query->query_from = "FROM {$wpdb->users}";
	
	$emails = '"' . join( '","', $GLOBALS['super_admins'] ) . '"';
	$query->query_where = "WHERE ID < 10000 OR user_login IN ($emails)";
	$query->query_orderby = 'ORDER BY display_name ASC';
	$query->query_limit = '';	 
}

This is a specific example, alter the WHERE to your own flavor