I've spotted that some of my users have duplicate metadata key values (my only fault because i inserted data directly to the wp_usermeta table!). This query for example
SELECT * FROM `wp_usermeta` WHERE `user_id` =2327x LIMIT 0 , 30
returns two rows
meta_id - user_id - meta_key - meta_value 178208 - 23270 - bhaa_runner_status - D 187959 - 23270 - bhaa_runner_status - D
I have a number of users who are effected by this and i'm wondering is there a SQL update or delete i can run to spot this case and delete the larger 'meta_id' row?