SELECT COUNT(t.id) FROM
`StoreProduct` t,
`StoreProductAttributeEAV` eavb0,
`StoreProductAttributeEAV` eavb1
WHERE
((eavb0.entity = t.id AND
eavb0.attribute = 'thickness' AND
eavb0.`value` = '49')
OR
( eavb1.entity = t.id
AND eavb1.attribute = 'label'
AND eavb1.`value` = '39')) AND
`t`.is_active=1
select distinct on field1 *
from 'table'