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 = '236' 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

Cravatte, Plastron e Spille

-10%
-5%

Plastron Bambino ELT

€ 19.00

€ 18.00

-16%

Plastron Caprice BUSSE

€ 31.00

€ 26.00

-19%

Plastron Elmira BUSSE

€ 32.00

€ 26.00

-14%

Plastron Emilia BUSSE

€ 29.00

€ 25.00

-11%

Cravatta Elastica

€ 19.00

€ 17.00

-4%

Cravatta Classic KINGLAND

€ 23.00

€ 22.00

-11%

Plastron 100% Cotone Rigato

€ 35.00

€ 31.00

-10%
-8%

Cravatta New Slim EQUILINE

€ 50.00

€ 46.00

-23%

Plastron Ladies WALDHAUSEN

€ 19.00

€ 14.64

-17%
-17%

Spilla Plastron Frustino

€ 19.00

€ 15.86

-9%

Plastron 100x100 Cotone

€ 34.00

€ 31.00