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 (155,156)
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 <> 8782
order by FIELD(terms.term_id,155,156)
limit 0,10
