[linusoleander]

SELECT * FROM products P 
LEFT JOIN product_properties PP ON PP.product_id = P.ID 
LEFT JOIN property_values PV ON PV.ID = PP.property_ID 
WHERE property_values.value = 'crossover' AND property_values.value = 'red';