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(613,616,614,445,682,1027), 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 (682,1027,445,614,616,613) 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.00-38 8PR BKT TR135 TT
Anvelope agricole 14.00-38 8PR BKT TR135 TT
1,590.00Lei  1,390.00Lei
Reducere   13%

Promotii


Anvelope agricole 7.50-20 6PR MITAS TF-05 TT
Anvelope agricole 7.50-20 6PR MITAS TF-05 TT
410.00Lei 390.00Lei
Reducere 5%
Adauga In Cos
Anvelope agricole 7.50-20 6PR MITAS TF-03 TT
Anvelope agricole 7.50-20 6PR MITAS TF-03 TT
470.00Lei 430.00Lei
Reducere 9%
Adauga In Cos
Anvelope agricole 7.50-20 6PR MITAS TF-01 TT
Anvelope agricole 7.50-20 6PR MITAS TF-01 TT
430.00Lei 410.00Lei
Reducere 5%
Adauga In Cos

Anvelope agricole 14.00-38 8PR PETLAS TA-60 TT
Anvelope agricole 14.00-38 8PR PETLAS TA-60 TT
1,590.00Lei 1,350.00Lei
Reducere 15%
Adauga In Cos
Anvelope agricole 7.50-20 6PR MITAS TS-04 TT
Anvelope agricole 7.50-20 6PR MITAS TS-04 TT
485.00Lei 455.00Lei
Reducere 6%
Adauga In Cos
Anvelope agricole 14.00-38 8PR BKT TR135 TT
Anvelope agricole 14.00-38 8PR BKT TR135 TT
1,590.00Lei 1,390.00Lei
Reducere 13%
Adauga In Cos


Inapoi