"SELECT idProductMultilanguage FROM (SELECT @rownum:=@rownum+1 AS ProductCount, idProductMultilanguage FROM product_multilanguage, product_has_categories phc, product p, (SELECT @rownum:=0) r WHERE phc.idProduct = product_idProduct AND p.idProduct = product_idProduct AND product_id_language = 1  AND phc.idCategories = 172 ORDER BY p.product_ref ASC) AS Products WHERE ProductCount > 0 AND ProductCount < 10"