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(3501,604,159,1367,362,3508), 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 (3508,604,3501,159,1367,362) AND p2a.options_id IN (8,10) AND p2a.options_id NOT IN (4,5,6,7,2,3,1) 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 Dimensiune:

Promotii


Anvelope agricole 600/70R30 155 A8/B VOLTYRE AGRO DR 117 TL
Anvelope agricole 600/70R30 155 A8/B VOLTYRE AGRO DR 117 TL
4,955.00Lei 4,855.00Lei
Reducere 2%

Pret pe bucata, TVA & Taxa verde incluse

Anvelope agricole 710/70R38 166D/169A8 MITAS RD-03 TL
Anvelope agricole 710/70R38 166D/169A8 MITAS RD-03 TL
10,150.00Lei 10,050.00Lei
Reducere 1%

Pret pe bucata, TVA & Taxa verde incluse

Anvelope agricole 650/75R32 172A8 ALLIANCE 375 TL
Anvelope agricole 650/75R32 172A8 ALLIANCE 375 TL
9,305.00Lei 9,200.00Lei
Reducere 1%

Pret pe bucata, TVA & Taxa verde incluse


Anvelope industriale 18.4-26 12PR PETLAS IND-25 TL
Anvelope industriale 18.4-26 12PR PETLAS IND-25 TL
2,250.00Lei 2,150.00Lei
Reducere 4%

Pret pe bucata, TVA & Taxa verde incluse

Anvelope industriale 10-16.5 8PR PETLAS IND-15 TL
Anvelope industriale 10-16.5 8PR PETLAS IND-15 TL
595.00Lei 565.00Lei
Reducere 5%

Pret pe bucata, TVA & Taxa verde incluse

Anvelope agricole 520/85R38 155 A8 VOLTYRE AGRO DR-109 TL
Anvelope agricole 520/85R38 155 A8 VOLTYRE AGRO DR-109 TL
4,600.00Lei 4,500.00Lei
Reducere 2%

Pret pe bucata, TVA & Taxa verde incluse



Inapoi