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,823,664,435,1360,1028,449,880,445,682,615,545,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,615,545,178,1027,445,880,449,1028,1360,435,664,823,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:

14.9 - 28 8PR TA-60 TT PETLAS
14.9 - 28 8PR TA-60 TT PETLAS
1,370.00Lei  1,295.00Lei
Reducere   5%
Facebook

Promotii


440/80 - 24 168 A8 MICHELIN POWER CL TL
440/80 - 24 168 A8 MICHELIN POWER CL TL
3,450.00Lei 3,360.00Lei
Reducere 3%
Adauga In Cos
440/80-28 156 A8 MICHELIN POWER CL TL
440/80-28 156 A8 MICHELIN POWER CL TL
3,750.00Lei 3,550.00Lei
Reducere 5%
Adauga In Cos
7.50-20 6PR MITAS TF-05 TT
7.50-20 6PR MITAS TF-05 TT
410.00Lei 390.00Lei
Reducere 5%
Adauga In Cos

7.50-20 6PR MITAS TF-03 TT
7.50-20 6PR MITAS TF-03 TT
470.00Lei 430.00Lei
Reducere 9%
Adauga In Cos
7.50-20 6PR MITAS TF-01 TT
7.50-20 6PR MITAS TF-01 TT
450.00Lei 410.00Lei
Reducere 9%
Adauga In Cos
12.5/80-18 14PR MITAS BIG-BOY TL
12.5/80-18 14PR MITAS BIG-BOY TL
1,500.00Lei 1,350.00Lei
Reducere 10%
Adauga In Cos

13.6 - 28 8PR TT PETLAS TA-60
13.6 - 28 8PR TT PETLAS TA-60
1,240.00Lei 1,145.00Lei
Reducere 8%
Adauga In Cos
14.9 - 28 8PR TA-60 TT PETLAS
14.9 - 28 8PR TA-60 TT PETLAS
1,370.00Lei 1,295.00Lei
Reducere 5%
Adauga In Cos
11.5/80-15.3 12PR PETLAS IND-15
11.5/80-15.3 12PR PETLAS IND-15
830.00Lei 799.00Lei
Reducere 4%
Adauga In Cos

14.00-38 12PR BKT TR135 TT
14.00-38 12PR BKT TR135 TT
1,850.00Lei 1,550.00Lei
Reducere 16%
Adauga In Cos
14.00 - 38 10PR TA-60 TT PETLAS
14.00 - 38 10PR TA-60 TT PETLAS
1,860.00Lei 1,500.00Lei
Reducere 19%
Adauga In Cos
14.9-28 8PR CULTOR AS AGRI-19 TT
14.9-28 8PR CULTOR AS AGRI-19 TT
1,365.00Lei 1,250.00Lei
Reducere 8%
Adauga In Cos

14.00 - 38 8PR TA-60 TT PETLAS
14.00 - 38 8PR TA-60 TT PETLAS
1,590.00Lei 1,260.00Lei
Reducere 21%
Adauga In Cos
7.50-20 6PR MITAS TS-04 TT
7.50-20 6PR MITAS TS-04 TT
485.00Lei 455.00Lei
Reducere 6%
Adauga In Cos
7.50-20 6PR MITAS TD-13 TT
7.50-20 6PR MITAS TD-13 TT
485.00Lei 455.00Lei
Reducere 6%
Adauga In Cos


Inapoi