Triple meta_key on custom SELECT query
Your Query is incorrect. To retrive meta values for triple meta_key you will need 3 different joins using posts meta on posts table. Check code below: // Example value $user_id = 1; // Calculate average post rating for user $ratings_query = $wpdb->get_results( $wpdb->prepare(” SELECT pmeta.meta_value FROM wp_posts LEFT JOIN $wpdb->postmeta AS pmeta ON (pmeta.post_id = … Read more