Cos de cumparaturi: IN COS 0 PRODUSE

Cauta

SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(102,127,210,281,357,358,359,360,361,416,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,542,543,547,549,552,553,556,557,561,563,564,569,572,575,579,583,584,585,587,588,589,590,592,593,594,595,596,598,599,600,602,603,604,607,654,656,659,664,686,826,827,828,830,831,883,887,1025,1036,1038,1040,1043,1044,1056,1057,1058,1059,1060,1061,1062,1064,1065,1066,1067,1068,1069,1070,1071,1072,1115,1116,1119,1122,1127,1128,1129,1130,1132,1135,1137,1140,1186,1192,1195,1196,1344,1345,1346,1347,1348,1349,1354,1355,1356,1357,1358,1359,1405,1406,1417,1444,1445,1446,1447,1448,1449,1450,1529,1543,1575,1576,1577,1578,1579,1580,1581,1582,1588,1589,1609,1610,1611,1612,1615,1617,1619,1622,1631,1633,1636,1637,1638,1641,1643,1644,1645,1646,1647,1649,1650,1731,1732,1738,1739,1740,1741,1742,1743,1744,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,2098,2100,2101,2102,2103,2104,2105,2203,2204,2209,2214,2215,2246,2249,2250,2251,2252,2253,2254,2255,2256,2259,2260,2261,2266,2268,2269,2270,2271,2272,2273,2274,2275,2276,2278,2280,2282,2283,2284,2286,2287,2288,2290,2291,2292,2293,2295,2296,2297,2301,2403,2405,2416,2448,2449,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2462,2466,2467,2469,2470,2471,2472,2473,2475,2478,2480,2482,2485,2553,2558,2800,2803,2808,2811,2949,2980,2981,2982,2983,2984,2985,2986,2987,3084,3085,3086,3087,3088,3089,3090,3091,3093,3094,3096,3097,3098,3100,3101,3102,3103,3104,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3242,3250,3279,3281,3282,3283,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,3314,3315,3317,3318,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3381,3384,3385,3395,3397,3398,3399,3400,3401,3402,3403,3404,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3419,3420,3421,3462,3532,3533,3536,3560,3563,3566,3567,3568,3569,3570,3571,3572,3574,3575,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3593,3594,3595,3596,3601,3604,3606,3607,3608,3665,3667,3672,3673,3674,3675,3676,3680,3683,3687,3692,3694,3695,3700,3708,3711,3717,3719,3722,3723,3724,3726,3727,3729,3730,3731,3739,3740,3745,3753,3757,3759,3761,3762,3763,3766,3768,3772,3787,3798,3799,3800,3801,3802,3803,3816,3817,3820,3823,3831,3834,3836,3844,3850,3851,3854,3874,3882,3884,3886,3890,3891,3892,3893,3895,3897,3898,3899,3900,3901,3903,3904,3905,3907,3908,3909,3911,3916,3917,3922,3926,3927,3930,3931,3932,3933,3934,3935,3941,3943,3946,3964,3968,3982,3986,3989,3991,3993,3997,4054,4055,4056,4057,4058,4059,4060,4061,4062,4063,4064,4065,4066,4067,4068,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4083,4085,4086,4087,4088,4136,4137,4138,4140,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4159,4160,4161,4162,4163,4164,4166,4171,4172,4173,4174,4181,4182,4184,4199), 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 (102,127,210,281,3711,357,358,359,360,361,416,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,542,543,547,549,552,553,556,557,561,563,564,569,572,575,579,583,584,585,587,588,589,590,592,593,594,595,596,598,599,600,602,603,604,607,654,656,659,664,686,826,827,828,830,831,883,887,1025,1036,1038,1040,1043,1044,1056,1057,1058,1059,1060,1061,1062,1064,1065,1066,1067,1068,1069,1070,1071,1072,1115,1116,1119,1122,1127,1128,1129,1130,1132,1135,1137,1140,1186,1192,1195,1196,1344,1345,1346,1347,1348,1349,1354,1355,1356,1357,1358,1359,1405,1406,1417,1444,1445,1446,1447,1448,1449,1450,1529,1543,1575,1576,1577,1578,1579,1580,1581,1582,1588,1589,1609,1610,1611,1612,1615,1617,1619,1622,1631,1633,1636,1637,1638,1641,1643,1644,1645,1646,1647,1649,1650,1731,1732,1738,1739,1740,1741,1742,1743,1744,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,2098,2100,2101,2102,2103,2104,2105,2203,2204,2209,2214,2215,2246,2249,2250,2251,2252,2253,2254,2255,2256,2259,2260,2261,2266,2268,2269,2270,2271,2272,2273,2274,2275,2276,2278,2280,2282,2283,2284,2286,2287,2288,2290,2291,2292,2293,2295,2296,2297,2301,2403,2405,2416,2448,2449,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2462,2466,2467,2469,2470,2471,2472,2473,2475,2478,2480,2482,2485,2553,2558,2800,2803,2808,2811,2949,2980,2981,2982,2983,2984,2985,2986,2987,3084,3085,3086,3087,3088,3089,3090,3091,3093,3094,3096,3097,3098,3100,3101,3102,3103,3104,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3242,3250,3279,3281,3282,3283,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,3314,3315,3317,3318,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3381,3384,3385,3462,3395,3397,3398,3399,3400,3401,3402,3403,3404,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3419,3420,3421,3532,3533,3536,3560,3563,3566,3567,3568,3569,3570,3571,3572,3574,3575,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3593,3594,3595,3596,3601,3604,3606,3607,3608,3665,3667,3672,3673,3674,3675,3676,3680,3683,3687,3692,3694,3695,3700,3708,3717,3719,3722,3723,3724,3726,3727,3729,3730,3731,3739,3740,3745,3753,3757,3759,3761,3762,3763,3766,3768,3772,3787,3897,4056,3798,3799,3800,3801,3802,3943,3803,3816,3817,3895,3891,4199,4054,4062,3890,3931,3820,3823,3831,3834,3836,3844,3850,3851,3854,3874,3882,3884,3886,3892,3893,3898,3899,3900,3901,3903,3904,3905,3907,3908,3909,3911,3916,3917,3922,3926,3927,3930,3932,3933,3934,3935,3941,3946,3964,3968,3982,3986,3989,3991,3993,3997,4055,4057,4058,4059,4060,4061,4063,4064,4065,4066,4067,4068,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4083,4085,4086,4087,4088,4136,4137,4138,4140,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4159,4160,4161,4162,4163,4164,4166,4171,4172,4173,4174,4181,4182,4184) 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 Producator:

Dupa Categorie:

Dupa Dimensiune:

Livrare gratuita

Garantie 48 luni

Retur in 30 de zile

Anvelope Agricole

Anvelope agricole 500/50-17 18PR OZKA KNK46 TL

Nu exista comentarii.

Utilizare: Implement
Garantie: 5 Ani

Stoc Furnizor RO

Produsele cu status "Stoc Furnizor RO " au cantitatea disponibila peste 5 bucati, se comanda la furnizori interni RO si se expediaza in 7-14 zile lucratoare.

Producator: OZKA

Pret: 1,367.76Lei

Pret pe bucata, TVA inclus
Taxa verde inclusa

Adauga in Cos:

Detalii:
DESPRE PRODUCATOR

Anvelopele agricole Ozka sunt dezvoltate pentru a eficientiza activitatile agricole. Datorita modelelor cu caneluri si suprafete de rulare imbunatatite, anvelopele Ozka ofera tractiune maxima pe camp si o manevrare mai buna pe sosea.

Tractiunea excelenta si autocuratarea , impreuna cu posibilitatea de a suporta unelte mai grele sau incarcaturi mai mari, permit un castig important de timp.

Carcasele reinnoite ale anvelopelor ofera caracteristici imbunatatite de amortizare, contribuind la conducerea mai confortabile fara vibratii si fara zgomote pe sosea.Anvelopele Ozka sunt fabricate in Turcia.