Comenzi telefonice: 0722.490.300    

SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(2244,2245), 1, 0)) as flag FROM zen_products_attributes p2a  JOIN zen_products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN zen_products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 WHERE p2a.products_id IN (2245,2244) AND p2a.options_id IN (2,1,3,8) AND p2a.options_id NOT IN (4,5,6,7) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_sort_order, pov.products_options_values_sort_order
Filtrare rezultate

Dupa Categorie:


Dupa Latime:


Dupa Diametru:

Anvelope agricole 14.9-28 8PR KABAT SGP-03 TT
Anvelope agricole 14.9-28 8PR KABAT SGP-03 TT
1,250.00Lei  1,160.00Lei
Reducere   7%

Promotii


Anvelope agricole 14.9-28 8PR KABAT SGP-03 TT
Anvelope agricole 14.9-28 8PR KABAT SGP-03 TT
1,250.00Lei 1,160.00Lei
Reducere 7%
Adauga In Cos
Anvelope agricole 12.4-28 8PR KABAT SGP-02
Anvelope agricole 12.4-28 8PR KABAT SGP-02
1,020.00Lei 970.00Lei
Reducere 5%
Adauga In Cos


Inapoi