WordPress SQL JOIN query

If you are going to do this is SQL, use a subquery.

SELECT *,
  (SELECT meta_value 
    FROM wp_commentmeta 
    WHERE meta_key = 'your-meta-key' 
    AND wp_commentmeta.comment_id = wp_comments.comment_ID LIMIT 1) as comment_author 
FROM wp_comments

Instead of the *, enumerate the fields you want but leave out comment_author. Obviously, $wpdb functions to keep the table names straight.

Related Posts:

  1. $wpdb->get_results(…) returns empty array despite correct query
  2. WPDB: how to get the value of a field in a custom database table
  3. Why is variable not working on custom sql query using wpdb?
  4. Get Current User Id Inside a Loop Returns 0 For a Shortcode
  5. Get stock by custom meta field on all Woocommerce variable products
  6. how to delete 30 day old data using PHP [closed]
  7. Display fields as values in array from external SQL DB
  8. Querying wpdb using PHP
  9. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  10. $wpdb->insert() does not Insert record in a table
  11. Fatal error: Call to a member function query() on a non-object
  12. How to retrieve the data from the sever and displaying it in a page?
  13. Use $wpdb or other PHP script method to find/replace in WP database
  14. How can I add a new row in a separate database when someone registers via WordPress?
  15. PHP -> SQL Query with Summing
  16. How to insert wp_users ->user login name to wp_terms when a new user registering?
  17. Why my query does not run with prepare
  18. wpdb getting avatars and author url
  19. Fetching review value using wpdb class
  20. WP_Query: How to get results from both meta_key options?
  21. get_terms with specific id order
  22. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  23. Passing in MySQL prepare statement parameter separately throwing error
  24. Database SQL query error
  25. get different meta-data of a complicated query at the same time
  26. WordPress SQL Prepare
  27. Creating multiple tables with Plugin
  28. can I extend the WP_Query class to deal with ‘duplicate’ posts created by joining to wp_posts?
  29. WordPress search query, how to modify the sql
  30. Modify post image in full size
  31. How to return count of items found in SQL query
  32. SQL Query Search page
  33. direct query to post_meta table
  34. Querying multiple meta_keys in WordPress SQL query
  35. Changing regular db connection to $wpdb
  36. Can’t send form data to wpdb when URL has query string
  37. How to sort search result by post_title, then by post_content
  38. Can i use php sql functions instead of $wpdb?
  39. wpdb::prepare was called incorrectly
  40. count number of user comments with a specific comment meta value
  41. PHP syntax error when using wpdb update?
  42. Duplicates with WP_Query loop
  43. my function doesn’t return my post from today
  44. Use wp_get_recent_posts with search term
  45. have_posts() execution failure
  46. Can’t search posts using WP_QUERY inside AJAX Function
  47. How can I use wp_query to show all product data using just the products ID?
  48. Getting id of poll from WP database
  49. Advanced Meta Query for Large Calendar Website (12k+ posts) (175k+ wp_postmeta rows)
  50. How to store post ID’s in cookie or session to display the same posts later
  51. auto-populating custom nav with all items from custom post type
  52. How to pass orderby params to $wpdb->prepare()?
  53. Create a Blog Template Page
  54. Exclude posts with specific metadata from search?
  55. Display an image if odd number of posts in grid
  56. Why doesn’t PhotoSmash plugin play well with wp_query?
  57. How to show meta value code HTML after x paragraph
  58. Form search query – displaying ACF “Post Object” field as results
  59. get_the_ID() doesnt work
  60. wpdb Cannot Update column in Database
  61. change the default order of posts only for specific categories
  62. How do I prepare strings for insertions as values into a MySQL table?
  63. How can I split my query result in 2 arrays?
  64. How to get post category list as select in front-end?
  65. WPDB – Read and write value from / to database
  66. Order a WP_Query by meta value where the value is an array
  67. How do I check if there is a tag in the title
  68. How to Generate a list of Most Commented post?
  69. Why won’t this wpdb get_results query return results?
  70. wordpress sql posts query won’t display the latest post in a specific category
  71. Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
  72. orderby meta_value_num is not working, giving default order
  73. How can I modify this code to make the search box include tags and meta
  74. WordPress get last inserted user id
  75. WP_Query for woocommerce products with a pattern as a post_title
  76. How do I make these combination select filters work when only one dropdown is set? They work in WordPress 5.8.2 but don’t in 5.8.3
  77. Fetch Data from an external MSSQL Database in a Managed WP hosting
  78. Ajax filter with loadmore button
  79. Query by pagename not Working
  80. Display featured image of post type category
  81. Delete post meta by serialized meta value
  82. Getting info about selected posts using one WP_Query
  83. Rewrite SQL query as a prepared statement and use in foreach loop
  84. Where to check in PHPmyAdmin / SQL database for subdomain
  85. For each 3 posts, show a different post type
  86. Weird Behaviour: Not all WordPress Posts appearing
  87. Can not manually create a database ( db, user, pass ) for a plugin
  88. How to merge 2 WordPress sites?
  89. Query category-specific, paginated posts and allow viewer to change sort order
  90. wordpress is_main_query() breaks
  91. allow previews outside wordpress folder (Outsourcing WP previews)
  92. Advanced Taxonomy query, with 3 post types
  93. Why does a meta_query break this WP_Query?
  94. How do I run the following script from my articles page?
  95. Execute multiple PHP Snippets causes error?
  96. use wpdb object on other file
  97. Three different queries on same page
  98. Warning: Undefined property: wpdb::$question_overview in C:\Wamp.NET\sites\proxyvragenmodule\wordpress\wp-includes\class-wpdb.php
  99. External WP_Query call from PHP crashed after version update
  100. WordPress Query with meta_key and order by another meta_key