Custom Query for searching through custom fields

I think you need a join.

$myquery = $wpdb->get_col(
    $wpdb->prepare(
        "SELECT DISTINCT meta_value FROM $wpdb->postmeta
         INNER JOIN $wpdb->posts ON $wpdb->postmeta.post_id = $wpdb->posts.ID
         WHERE
             meta_key = %s AND
             post_status IN ('publish')",
        $metakey
    )
);

Related Posts:

  1. Differences between wpdb->get_results() and wpdb->query()
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Custom $wpdb Query for Custom Post Type by Category
  6. Can’t pass table to $wpdb->prepare
  7. $wpdb->get_var not returning a result
  8. Most effective use of DB querys
  9. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  10. wpdb::prepare() isn’t working
  11. $wpdb doesn’t appear to work on page inside of a plugin
  12. Strange string in console from wpdb query
  13. Using $wpdb->update but confused on the WHERE in and SET
  14. What’s wrong with my $wpdb prepare?
  15. Make one query for adding entries to database
  16. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  17. Alter a specific query on WordPress
  18. wpdb->term_taxonomy count posts from both published and private posts?
  19. wpdb print all post meta
  20. Plugin will sort users by usermeta
  21. wpdb query problem to access previous 3 days posts
  22. Changing status of Published posts which have less Content to “Draft”
  23. How to write: $wpdb->update having WHERE NOT value pair in the array
  24. I can’t figure out what’s wrong with this statement. $wpdb->query update
  25. Use mysql_query instead of $wpdb query
  26. wpdb COALESCE won’t work
  27. Custom Query – Based on user input
  28. Custom SQL Query passing array to WHERE p.id
  29. Get posts from category with custom query
  30. Custom Query returns array, but I can’t see it’s elements
  31. Valid SQL query return empty
  32. mysql query – how to escape apostrophe?
  33. $wpdb->prepare affecting the query?
  34. prepare function sql safe method
  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. How do I query for posts by custom meta and those that have been stickied?
  39. Help with Related Posts Function
  40. wpdb update multiple row?
  41. Formatting a date/time returned from a custom $wpdb query
  42. Improve performance of slow query
  43. How do I get specific readable results from this query and array results
  44. implementing my wp_query using $wpdb class
  45. Exclude Posts from a Widget
  46. Fastest and most efficient SQL query to check if UID exists
  47. Use $wpdb->get_results with filter based on array
  48. $wpdb query for price in custom field value
  49. Display result from custom post meta query
  50. Wpdb empty result only if language is Russian
  51. Run an update query in a function
  52. How to fix this insert? Don’t work for me!
  53. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  54. Update vs Insert logic but the last key is always inserted?
  55. There is way to improve this query? wordpress get post data and some meta data
  56. $wpdb: how to use a query as a base for another query?
  57. Wpdb generates too many queries
  58. Mysql query and odd results
  59. How to reference same column name but different table in custom db query
  60. Retrieving custom field array value through db query
  61. How to get one result using wpdb class?
  62. Delete query won’t run
  63. update $wpdb one query
  64. Get all image from single page using this query
  65. How to tune search argument in WP_Query to show only exactly the same results?
  66. Date query year and month OR just year
  67. get post id using the $query_vars variable
  68. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  69. How select a specific query when setting offset?
  70. convert custom query to wp_query
  71. Select two sums with single get_var statement
  72. Optimizing Query used for a Shortcode
  73. sql select query in wordpress ‘page’ [closed]
  74. Group custom post listing in admin section
  75. problem with sql query in wordpress plugin
  76. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  77. plugin code is pulling information from database in one instance and not in other. What is wrong?
  78. WordPress query posts with multiple post_meta data
  79. Order posts by date, but also give priority for a specific term
  80. How to insert Collate into WordPress search query?
  81. Combine “Exclude” Query in functions.php
  82. Wrap/close ‘query’ for a first-letter ordered listing of posts
  83. wpdb query with dynamic column name?
  84. get products by custom date variable
  85. How to delete all images from code in all post_content
  86. How to insert a value to decimal type field using wpdb->prepare?
  87. How to sort by two meta keys in admin area?
  88. How to get inserted row IDs for bulk/batch insert with wpdb query?
  89. Restrict WordPress search to a single ACF field
  90. wp query multiple values > display a specific value first
  91. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  92. Nested select statements not working
  93. Pagination adds search query (again)
  94. wpdb get_results() returns only 2 rows
  95. Add generic page to WP_Query
  96. Advanced Custom Fields Query with Different Values of the Same Key
  97. No results for taxonomy archive page
  98. Filter the feed page post limit
  99. Modify Global Posts Plugin
  100. SQL Query : how copy all tags of post into their post content in wordpress by sql query