Выборка из базы двух значений
SELECT product_id
FROM t_product_attribute
WHERE text = 'Мужские'
AND product_id IN (SELECT product_id FROM t_product_attribute WHERE text= 'Японский')
AND product_id IN (SELECT product_id FROM t_product_attribute WHERE text= 'Miyota')