select DISTINCT product.ID,product.post_title,product.type_id from wp_terms as terms left join wp_term_relationships as term_rel on terms.term_id = term_rel.term_taxonomy_id and terms.term_id in (117,161,29) left join wp_posts as product on product.ID = term_rel.object_id where product.post_type = 'product' and product.post_status = 'publish' and ID <> 8882 order by FIELD(terms.term_id,117,161,29) limit 0,10