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(1531,1533,613,616,614,435,880,445,682,1027,178), 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,178,1027,445,880,435,614,616,613,1533,1531) 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 Inaltime:


Dupa Diametru:

Anvelope agricole 14.00-38 8PR PETLAS TA-60 TT
Anvelope agricole 14.00-38 8PR PETLAS TA-60 TT
1,590.00Lei  1,260.00Lei
Reducere   21%

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.9-28 8PR PETLAS TA-60 TT
Anvelope agricole 14.9-28 8PR PETLAS TA-60 TT
1,370.00Lei 1,295.00Lei
Reducere 5%
Adauga In Cos

Anvelope agricole 14.9-28 8PR CULTOR AS AGRI-19 TT
Anvelope agricole 14.9-28 8PR CULTOR AS AGRI-19 TT
1,365.00Lei 1,265.00Lei
Reducere 7%
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,260.00Lei
Reducere 21%
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,290.00Lei
Reducere 19%
Adauga In Cos
Anvelope agricole 14.00-38 8PR ALLIANCE 357 TT
Anvelope agricole 14.00-38 8PR ALLIANCE 357 TT
1,300.00Lei 1,200.00Lei
Reducere 8%
Adauga In Cos


Inapoi