SELECT 1
WHERE EXISTS(
    SELECT 1 
    FROM PRODUCTATTRIBUTE a,
         PRODUCTATTRIBUTE b,
         PRODUCTATTRIBUTE c, etc.
    WHERE a.product_id = b.product_id
    AND b.product_id = c.product_id
        etc. 
    AND a.attr_id = "doors" and a.attr_value = "4",
    AND b.attr_val = "productionphase" and b.attr_value 
> "2"
    AND etc. 
)