<td>
<td attr="">
SELECT meta_value
FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)
WHERE
(wp_term_relationships.term_taxonomy_id IN ('1,2,3,4,5,6'))
AND wp_posts.post_type = 'product'
AND wp_posts.post_status = 'publish'
AND wp_postmeta.meta_key = '_price'