Reply To: Order user search results by mu.startdate

[Ernest Marcinko]

Hi,

Try this variation maybe:

add_filter('asp_query_args', 'asp_query_args_user_fields', 10, 1);
function asp_query_args_user_fields($args) {
  global $wpdb; 
  $args['user_query'] = array(
      'fields' => 'UNIX_TIMESTAMP(mu.startdate) as startdate, ',
      'join' => " LEFT JOIN $wpdb->pmpro_memberships_users mu ON $wpdb->users.ID = $wpdb->pmpro_memberships_users.user_id ",
      'where' => '',
      'orderby' => ' mu.startdate DESC, ',
      'groupby' => ''
  );
  return $args;
}