Select User by Joining Multiple Meta Value Results

Try this one with additional join on metadata

SELECT u.ID, u.display_name
FROM wp_users u 
LEFT JOIN wp_usermeta  um1 ON u.ID = um1.user_id
LEFT JOIN wp_usermeta  um2 ON u.ID = um2.user_id
WHERE um1.meta_value="value1" AND um1.meta_key = 'key1'
AND um2.meta_key = 'keyA' AND um2.meta_value="valueA"
GROUP BY u.ID

Also use group by

Related Posts:

  1. simple sql query on wp_postmeta very slow
  2. How many WordPress SQL Queries per page?
  3. Multipart/formatted MySQL query problem
  4. SQL query equivalent to WP User Query
  5. Are database queries created using WordPress filters protected from SQL injection?
  6. Grouping related postmeta data via SQL query
  7. Mysql / WordPress killing my server with 80k users [closed]
  8. Slow meta_query with about 4 milion record on wp_postmeta
  9. Select Multiple meta_value from WP DB; Single Query
  10. mySQL query. ORDER BY meta_key
  11. Update slug (URL) of pending posts via phpMyAdmin
  12. My SQL function to change user_name
  13. You have an error in your SQL syntax – Help with query
  14. MySQL variable in query
  15. how would I create a custom query to get all users, and a related post based on a postmeta field?
  16. Help with MySQL to $WPDB query
  17. SQL query to select posts from multiple categories
  18. How do I see the mysql query generated by get_posts( $args )?
  19. Alter query with posts_clauses to retrieve NULL values last
  20. Plugin will sort users by usermeta
  21. MySql Query very slow
  22. Searching With Apostrophe
  23. WordPress Query wp-terms SLOW
  24. Problem when try to add ++1 for user meta
  25. wpdb COALESCE won’t work
  26. Get posts from category with custom query
  27. How to exclude posts for current user
  28. how to insert missing tags into the posts through mySQL?
  29. Ideas how to search & replace post_content when string contains a newline?
  30. Valid SQL query return empty
  31. mysql query – how to escape apostrophe?
  32. Query the WordPress database to get data together with replaced information
  33. Query Nickname rather than Display Name in custom Woocommerce plugin
  34. Optimize slow SQL query for multiple meta values
  35. Updating with $qpdb->query() always returns 0 rows affected
  36. How to return count of custom post type posts with a specific custom field value via $wpdb?
  37. WordPress Mysql query and Duplicate
  38. Help with Related Posts Function
  39. Combining two meta_values within one row with query
  40. How to delete all images from code in all post_content
  41. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  42. Displaying data from custom table
  43. Get 2 meta values from meta key column
  44. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  45. SQL query to delete users with multiple meta keys and comments
  46. How to do a sql like query on serialized data of user meta data
  47. OR condition not working
  48. Trouble migrating custom post types from non-wordpress cms
  49. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  50. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  51. How to make MySQL search queries with quotes
  52. Querying users by meta value and getting a strange answer
  53. Update vs Insert logic but the last key is always inserted?
  54. Custom MySQL Query for Post and Post Meta
  55. Mysql query and odd results
  56. list or get meta_key where meta_value is ‘something’
  57. sql for querying post and their category
  58. Access Tables with number prefix
  59. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  60. Compare two numeric custom fields
  61. How to extract all ID variables from a query string?
  62. Query All users that has post
  63. Remove Unnecessary Mysql Query
  64. Is it good practice to use wpdb->query() function?
  65. wpdb::prepare() isn’t working
  66. How can I apply a meta query for a single custom post type in the main query?
  67. how to query multiple categories in wordpress?
  68. Strange string in console from wpdb query
  69. where should I reset query after using get_results?
  70. Using GROUP CONCAT in my-sql query with wp_usermeta table
  71. Exclude featured image and custom field from this get_attachment query
  72. Long running queries
  73. Form and custom query problem
  74. Export Specific User data without plugin
  75. Exclude all sticky posts front page twenty twelve
  76. get csv of users with user_meta
  77. Custom SQL Query passing array to WHERE p.id
  78. Run Username SQL Query from WordPress Child Theme Functions File
  79. get posts by tag to showing in a widget
  80. Edit Account – read and write to MySQL
  81. Mysql query not working on WordPress 4.2.2
  82. mySQL queries are executed twice on wordpress website
  83. get_post_meta with WP_query
  84. How properly create a blog template for wordpress?
  85. Is there a way to add a link directly into this media query?
  86. meta_query not working
  87. Cannot get sql request from Query object?
  88. WordPress query: merge meta key (number) values and sort
  89. Question about of query
  90. Modify behaviour of “s” parameter in wp_query
  91. Plugin MySQL SELECT custom data and filter on user meta
  92. Include a custom field in mysql query
  93. Limiting a filtered query
  94. WP_Query always returning the last custom post
  95. learn to run wpdb class
  96. Display old posts if no future posts exist
  97. how to add a read more button to my blog page?
  98. Query parsing only author ids
  99. Ascending & descending posts on same page with IF statement
  100. Meta Query compare with LIKE pulls similar post types: 55 and 155, and 1,155