select count(DISTINCT p.product_id) as totale from gn_product p LEFT JOIN gn_product_to_category pc on (p.product_id=pc.product_id) LEFT JOIN gn_category_description cd on (pc.category_id=cd.category_id) LEFT JOIN gn_category c on (pc.category_id=c.category_id) LEFT JOIN gn_product_description pd on (p.product_id=pd.product_id) WHERE pc.category_id = '269' AND p.price >= 0 AND p.price <= 20000 AND pd.language_id = '1' AND cd.language_id = '1' AND p.status = '1' AND c.status = '1' ORDER BY p.stock_status_id ASC, p.product_id DESC

Categorie

x

Chifney

-7%

Chifney Ferro

€ 30.00

€ 28.00

-6%

Chifney One Stallion TRUST

€ 80.00

€ 75.00

-10%

Filetto Chifney HAPPY MOUTH

€ 89.00

€ 80.52

-10%

Chifney Acciaio Inox 8mm

€ 20.00

€ 18.00

-15%

Chifney Acciaio WALDHAUSEN

€ 20.00

€ 17.08

-9%

Chifney Alluminio

€ 39.00

€ 35.50

-10%

Filetto Chifney

€ 57.00

€ 51.50