SELECT COUNT(DISTINCT(p.iID)) AS result FROM Product AS p INNER JOIN Offers AS o INNER JOIN Size AS s WHERE p.iCat = '6' AND o.fPrice >= '0' AND o.fPrice <= '75' AND o.iProductID = p.iID

Merk:


Kleur:


Prijs: