SELECT p2pe.*, pe.products_extra_fields_name FROM products_to_products_extra_fields p2pe left join products_extra_fields pe using(products_extra_fields_id) WHERE p2pe.products_id= AND products_extra_fields_id in (1,2,6) ORDER BY products_extra_fields_id desc