SELECT
    product.title,
    stock,
    price,
    GROUP_CONCAT(p.title, ': ', pv.value SEPARATOR ', ') property_values
FROM product
INNER JOIN product_property_value pv ON pv.product_id = product.id
INNER JOIN property p ON p.id = pv.property_id
  AND (p.code = 'color' AND pv.value = 'Красный')
  AND (p.code = 'width' AND (pv.value = 4 OR pv.value = 5))
  AND (p.code = 'height' AND pv.value = 5)
GROUP BY product.id;