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 (29,71,70) 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 <> 8803 order by FIELD(terms.term_id,29,71,70) limit 0,10