select distinct(motors.cubic) from motors, reference, article where motors.cubic!="" and motors.id_motor=reference.id_motor and reference.id_part=article.id_part and article.active=1 and article.id_category not in ("221", "222", "226", "20", "21", "22", "23", "24", "25", "203", "204", "260", "261", "262", "263", "264", "265", "266", "267", "268", "270", "271", "272", "273", "274", "275", "276", "277", "279", "281", "282", "283", "284", "285", "286", "287", "289", "291", "292", "293", "294", "295", "296", "297", "298", "299", "300", "301", "302", "303", "305", "306", "307", "309", "310", "311", "312", "314", "315", "316" ) and (motors.id_reseller="1" or motors.id_reseller="7" or motors.id_reseller="4" or motors.id_reseller="9" or motors.id_reseller="11" or motors.id_reseller="0") and motors.brand ="HVA" order by motors.cubic Pieces moto pour HUSQVARNA

 

Centre de support

 

 

Centre de support ticket

 

 

Transporteur GLS