SELECT wp_postmeta.* FROM wp_postmeta LEFT JOIN wp_posts ON wp_posts.ID = wp_postmeta.post_id WHERE wp_posts.post_status = 'publish' AND wp_posts.post_type = 'post' AND ( wp_postmeta.meta_key = 'relevantLine' AND wp_postmeta.meta_value = '339' ) AND ( ( wp_postmeta.meta_key = 'brandOne' AND wp_postmeta.meta_value = '30' ) OR ( wp_postmeta.meta_key = 'brandTwo' AND wp_postmeta.meta_value = '30' ) OR ( wp_postmeta.meta_key = 'brandThree' AND wp_postmeta.meta_value = '30' ) ) AND wp_posts.post_date >= '2014-03-25' AND wp_posts.post_date <= '2014-11-27' GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC