Title: wp_usermeta listing problem
Last modified: August 30, 2016

---

# wp_usermeta listing problem

 *  [RonaldS](https://wordpress.org/support/users/norus/)
 * (@norus)
 * [11 years ago](https://wordpress.org/support/topic/wp_usermeta-listing-problem/)
 * In WordPress I need a listing generated from table wp_usermeta which shows following
   results per row per user_id :
    user_id, city, first_name+ ” “+lastname
 * This is an example of the data in table wp_usermeta.
 * 126 city Utrecht
    126 last_name Huisman 126 first_name Fred 100 city Eibergen
   100 last_name Van der Heide 100 first_name Toon 90 city Hengelo 90 last_name 
   Klaver 90 first_name Gezien
 * What I need is following result:
    126 Utrecht Fred Huisman 100 Eibergen Toon 
   Van der Heide 90 Hengelo Gezien Klaver
 * Below script is wors. But it gives you an idea of the table _ fields:
 *     ```
       SELECT wp_users.ID, wp_usermeta.meta_key , wp_usermeta.meta_value
       FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
       WHERE
       wp_usermeta.meta_key = "city"
       OR
       wp_usermeta.meta_key = "first_name" + "last_name"
       OR
       (wp_usermeta.meta_key = "lastwill_public" AND wp_usermeta.meta_value = "1")
       AND wp_usermeta.meta_value is null
       ORDER BY wp_users.ID DESC
       ```
   
 * Who can help me getting the result.
    In advance thanks!

The topic ‘wp_usermeta listing problem’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [RonaldS](https://wordpress.org/support/users/norus/)
 * Last activity: [11 years ago](https://wordpress.org/support/topic/wp_usermeta-listing-problem/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics