SELECT
u.ID,
u.user_email,
u.display_name,
um1.meta_value AS first_name,
um2.meta_value AS last_name,
um3.meta_value AS phone_number,
um4.meta_value AS salutation,
um5.meta_value AS title
FROM wp_users u
LEFT JOIN wp_usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = 'first_name'
LEFT JOIN wp_usermeta um2 ON u.ID = um2.user_id AND um2.meta_key = 'last_name'
LEFT JOIN wp_usermeta um3 ON u.ID = um3.user_id AND um3.meta_key = 'phone_number'
LEFT JOIN wp_usermeta um4 ON u.ID = um4.user_id AND um4.meta_key = 'salutation'
LEFT JOIN wp_usermeta um5 ON u.ID = um5.user_id AND um5.meta_key = 'title'
;
that’s the right one. thanks jgraup for the hint
Related Posts:
- Export Specific User data without plugin
- Custom query_var causes displaying posts archive on front page
- What is the most efficient way of implementing a favorite post system?
- Export wordpress table to excel
- Why does get_the_time(‘F j’) return November 30 for all posts?
- Query by one meta_key and sort by another (possibly NULL value)
- Very slow query
- Search Terms – Querying on either description__like OR name__like in the same Term Query?
- Query & Sort Comments by custom comment meta
- is_archive() doesn’t work on public query var archive pages?
- How to count get_users query?
- cron job to auto delete posts of a specific post type older than x days
- Possible to get posts from multiple meta keys/values in a single query?
- Difference between fragment caching and wp_cache
- mysql query paging
- How to display all posts with today’s same month and day only?
- Select User by Joining Multiple Meta Value Results
- How do I find if a page has a template?
- Show featured image as background image from postQuery
- Using $wpdb->update but confused on the WHERE in and SET
- You have an error in your SQL syntax – Help with query
- Make one query for adding entries to database
- WordPress Loop: List All Posts by a Category & Subcategory
- Order query by post meta value
- add_query_arg() and empty variables inside
- Query Strings and Woocommerce
- Style Post Differently In Query
- WordPress post type “event” query string fix?
- how would I create a custom query to get all users, and a related post based on a postmeta field?
- Display posts with a start OR end date later than current date
- Order posts by custom field DATE value
- order one custom post type by modified time of another post type
- How to retrieve current wordpress profile page URL?
- Form redirect with query vars to page
- is_search called incorreclty
- Function to delete a post, it’s children and it’s grand children (half way there already)
- Nested loop : wich way/order?
- Dynamically adjust single-posttype.php query, based on current taxonomies
- Passing parameters to a static front page
- wp_list_pages() refuses to output posts
- Can’t seem to do combined query AND sort?
- Use mysql_query instead of $wpdb query
- sort query results by newest
- How to reset usual $query on search page to push custom $wpdb query there?
- Order by meta value pro first then meta value free in my search function
- Order by title – but now built in wordpress func, sort the_title
- Display posts between two particular dates
- pre saved posts query from db options table
- $post->ID not working in combination with a custom query
- Custom Query returns array, but I can’t see it’s elements
- How to delete all posts, categories and tags from WordPress database
- Ideas how to search & replace post_content when string contains a newline?
- How to insert Collate into WordPress search query?
- Query the WordPress database to get data together with replaced information
- $wpdb->prepare affecting the query?
- WordPress SQL search, how to handle SQL Injection?
- Optimize slow SQL query for multiple meta values
- Query for Custom Post Type UI Does Not Loop All the Post
- Updating with $qpdb->query() always returns 0 rows affected
- How to manage a particular “order by” for get_search_query()?
- Query to view scheduled or draft post
- How to return count of custom post type posts with a specific custom field value via $wpdb?
- How can I get the name of term post meta value which equals term id
- Help with Related Posts Function
- Trying to use WP_Query to return post with and without meta values
- How to add a Variable to post query
- Sort a list of a CPT ( job) if a meta is empty
- How do I export categories, site stats, comments and posts from wordpress to excel
- Export WordPress User Meta to CSV/Excel
- SQL query to delete users with multiple meta keys and comments
- Restore WordPress Backup Locally?
- Trouble migrating custom post types from non-wordpress cms
- “order” does not affect order of custom query
- Button to download export data WordPress in CSV file
- Create a new post on a specified publish date via link?
- Exclude Posts from a Widget
- New custom post type entries are not sorted correctly in admin using pre_get_posts
- Query String for the WP_QUERY parameters
- Counting And Monitoring How Much Queries My Script Used
- $wpdb query for price in custom field value
- Run an update query in a function
- Add generic page to WP_Query
- Multiple terms not working on taxonomy
- Sorting of coupons in the right way
- search.php is not generating the right results
- excludeCat function reverses order of blog posts
- Slow query when joining wp_posts with a lookup-table?
- Run search query again without pagination gives no results?
- Mysql query and odd results
- Using wp_list_table how to trigger update function “inline”?
- Filter multiple different main queries on custom pages
- WP_Query orderby meta key/value suddely stopped working
- WP_Query older new links navigation?
- How to get one result using wpdb class?
- Delete query won’t run
- Where can I find the SQL to get the most used information by wordpress database?
- WooCommerce Total # orders [closed]
- Modify a query using both a text field and a true/false AFC field
- How to figure out correct wp_options to have autoload=’yes’
- is it possible to use wp cli to export custom post types