WP to UM SQL Query

Hi,

More advanced topic…

I need to convert this WP SQL Query into a similar UM Query:

$r = '3959';
$sql = $wpdb->prepare("
	SELECT $wpdb->$user_id,
		( " . $r . " * acos(
			cos( radians(%s) ) *
			cos( radians( latitude.meta_value ) ) *
			cos( radians( longitude.meta_value ) - radians(%s) ) +
			sin( radians(%s) ) *
			sin( radians( latitude.meta_value ) )
		) )
		AS distance, latitude.meta_value AS latitude, longitude.meta_value AS longitude
		FROM $wpdb->users
		INNER JOIN $wpdb->usermeta
			AS latitude
			ON $wpdb->$user_id = latitude.user_id
		INNER JOIN $wpdb->usermeta
			AS longitude
			ON $wpdb->$user_id = longitude.user_id
		WHERE 1=1
			AND ($wpdb->posts.post_status = 'publish' )
			AND latitude.meta_key = %s
			AND longitude.meta_key = %s
		HAVING distance < %s
		ORDER BY $wpdb->posts.menu_order ASC, distance ASC", $lat, $lng, $lat, $args['lat_meta_key'], $args['lng_meta_key'], $radius

Basically, my usermeta has 2 keys (latitude and longitude) along with their values already stored for each member.

Any help deciphering this would be very much appreciated. Thank you.

https://wordpress.org/plugins/ultimate-member/