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 p.iBrand = '144' AND o.fPrice >= '0' AND o.fPrice <= '999999999' AND o.iProductID = p.iID

Merk:


Kleur:


Prijs: