Title: WP to UM SQL Query
Last modified: September 1, 2016

---

# WP to UM SQL Query

 *  Resolved [dberg89](https://wordpress.org/support/users/dberg89/)
 * (@dberg89)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/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/](https://wordpress.org/plugins/ultimate-member/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [dberg89](https://wordpress.org/support/users/dberg89/)
 * (@dberg89)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/wp-to-um-sql-query/#post-7470557)
 * Solved!

Viewing 1 replies (of 1 total)

The topic ‘WP to UM SQL Query’ is closed to new replies.

 * ![](https://ps.w.org/ultimate-member/assets/icon-256x256.png?rev=3160947)
 * [Ultimate Member – User Profile, Registration, Login, Member Directory, Content Restriction & Membership Plugin](https://wordpress.org/plugins/ultimate-member/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ultimate-member/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ultimate-member/)
 * [Active Topics](https://wordpress.org/support/plugin/ultimate-member/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ultimate-member/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ultimate-member/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [dberg89](https://wordpress.org/support/users/dberg89/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/wp-to-um-sql-query/#post-7470557)
 * Status: resolved