1 - 14 diaginala 15
2 - 14 culoare negru
3 - 12 diagonala 45
4 - 12 culoare roz

FROM table1 at1 d LEFT JOIN table1 as at2
ON at1.product_id = at2.product_id
WHERE at1.attribute = 'culoare' and at1.value = 'negru' and at2.attribute = 'diagonala' and at2.value > 10;