Can't sort custom column on user.php by number / meta_value_num?

Question

Everything else works fine but it's still not sorting by number.

Would just like to know what I'm doing wrong here

Here's the code

 function add_user_columns( $defaults ) {
 $defaults['user_votecount'] = __('Votes', 'user-column');
 return $defaults;
 }

 function add_custom_user_columns($value, $column_name, $id) {
  if( $column_name == 'user_votecount' ) {
    return get_the_author_meta( 'wp__user_like_count', $id ); }

 add_action('manage_users_custom_column', 'add_custom_user_columns', 15, 3);
 add_filter('manage_users_columns', 'add_user_columns', 15, 1);

 function user_sortable_columns( $columns ) {
$columns['user_votecount'] = 'Votes';
return $columns;
 }

 add_filter( 'manage_users_sortable_columns', 'user_sortable_columns' );

 function user_column_orderby( $vars ) {
    if ( isset( $vars['orderby'] ) && 'user_votecount' == $vars['orderby'] ) {
    $vars = array_merge( $vars, array(
        'meta_key' => 'wp__user_like_count',
        'orderby' => 'meta_value_num',
        'order'     => 'asc'
    ) );
}
return $vars;
 }
 add_filter( 'request', 'user_column_orderby' );

Answer 1

Instead of 'request' function, use this :

add_action('pre_user_query', 'user_column_orderby');
function user_column_orderby($userquery){
if('Votes'==$userquery->query_vars['orderby']) {
global $wpdb;
$userquery->query_from .= " LEFT OUTER JOIN $wpdb->usermeta AS alias ON ($wpdb-   >users.ID = alias.user_id) ";
$userquery->query_where .= " AND alias.meta_key = 'wp__user_like_count' ";
$userquery->query_orderby = " ORDER BY alias.meta_value ".($userquery->query_vars["order"] == "ASC" ? "asc " : "desc ");
}
}