Skip to main content
2 of 2
Better formatting
Pieter Goosen
  • 55.4k
  • 23
  • 115
  • 209

If you have Unknown column wp_postmeta.meta_key in where clause

You probably want to join $wpdb->postmeta table into this query:

function custom_posts_join($join){
     global $wpdb;

     $join .= " LEFT JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id ";

     return $join;
}
add_filter( 'posts_join' , 'custom_posts_join');