How to Mysql select a list of posts with meta_values AND all relevant categories?
SQL-wise, you only need to join to the wp_posts table once. Joining to the terms stuff will give you multiple rows, so it’s probably easiest to group these and then use GROUP_CONCAT() to flatten the terms into a comma-separated string (updated to use LEFT joins): global $wpdb; $sql = $wpdb->prepare( ‘SELECT p.ID, p.post_title AS Product, … Read more