Home | Log In     

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,538,542,543,546,547,549,550,552,553,556,557,561,563,564,569,571,572,573,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,1620,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,2262,2264,2266,2268,2269,2270,2271,2272,2273,2274,2275,2276,2278,2280,2282,2283,2284,2286,2287,2288,2290,2291,2292,2293,2294,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,3081,3082,3084,3085,3086,3087,3088,3089,3090,3091,3093,3094,3095,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,4082,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,4167,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,538,542,543,546,547,549,550,552,553,556,557,561,563,564,569,571,572,573,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,1620,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,2262,2264,2266,2268,2269,2270,2271,2272,2273,2274,2275,2276,2278,2280,2282,2283,2284,2286,2287,2288,2290,2291,2292,2293,2294,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,3081,3082,3084,3085,3086,3087,3088,3089,3090,3091,3093,3094,3095,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,4082,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,4167,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 Categorie:

Dupa Producator:

Dupa Categorie:

Dupa Dimensiune:

Anvelope Agricole

Descriere Categorie:
Anvelope destinate agriculturi ,silviculturii ,constructiilor si terasamentelor ,gama diversificata de la cei mai mari producatori.


Buc. Imagine Produs Weight Denumire Pret
18 Anvelope agricole 12.4-24 8PR PETLAS TA-60 TT 2

Anvelope agricole 12.4-24 8PR PETLAS TA-60 TT

CARACTERISTICI & AVANTAJE Anvelopele Petlas TA-60 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta . Constructia carcasei, componentele si...
 1,241.31Lei

... mai multe informatii
7 Anvelope agricole 12.4-28 10PR MITAS TD-19 TT 2

Anvelope agricole 12.4-28 10PR MITAS TD-19 TT

CARACTERSITICI & AVANTAJE Anvelope versatile pentru orice fel de echipament agricol & industrial. Componente optimizate pentru o construtie robusta . Extrem de durabile. Utilizare pe termen indelungat. Protectie pentru rezistenta redusa la rulare & rezistenta la intemperii. Firele de cord mai plate pentru o distribuire uniforma  a presiunii pe sosea. DESPRE PRODUCATOR...
 1,650.73Lei

... mai multe informatii
4 Anvelope agricole 12.4-28 6PR MITAS TD-19 TT 2

Anvelope agricole 12.4-28 6PR MITAS TD-19 TT

CARACTERSITICI & AVANTAJE Anvelope versatile pentru orice fel de echipament agricol & industrial. Componente optimizate pentru o construtie robusta . Extrem de durabile. Utilizare pe termen indelungat. Protectie pentru rezistenta redusa la rulare & rezistenta la intemperii. Firele de cord mai plate pentru o distribuire uniforma  a presiunii pe sosea. DESPRE PRODUCATOR...
 1,704.22Lei

... mai multe informatii
20 Anvelope Agricole 12.4-28 6PR OZKA KNK50 117A6 TT 5

Anvelope Agricole 12.4-28 6PR OZKA KNK50 117A6 TT

CARACTERISTICI & AVANTAJE Anvelopele Ozka KNK50 este un profil de tractiune ce ofera o durata de viata lunga datorita compusului rezistent la uzura. Profilul de anvelopei permite o rezistenta ridicata la rulare si asigura o conducere confortabila, îmbunatatind performanta la aderenta iar geometria speciala asigura o autocuratare eficienta. Constructia carcasei, componentele si designul...
 1,353.58Lei

... mai multe informatii
4 Anvelope agricole 12.4-28 8PR ASCENSO TDB120 TL 5

Anvelope agricole 12.4-28 8PR ASCENSO TDB120 TL

CARACTERISTICI & AVANTAJE Nivel ridicat de tractiune Amprenta mare la sol Carcasa robusta si peretii lateralii flexibili Comportament excelent pe drum si confort sporit la rulare Stabilitate optima Garantie 5 ani DESPRE PRODUCATOR Mahansaria Tires Private Limited (MTPL) a început productia comerciala a marcii sale de cauciucuri off-road „Ascenso” la unitatea de...
 1,331.19Lei

... mai multe informatii
16 Anvelope Agricole 12.4-28 8PR GALAXY EARTHPRO 45 TT 7

Anvelope Agricole 12.4-28 8PR GALAXY EARTHPRO 45 TT

CARACTERISTICI & AVANTAJE Durata de viata a anvelopei este asigurata de materialul special conceput pentru uzura redusa precum si de cauciucul suplimentar adaugat pe centrul bamei. Unghiul bamei si raza acesteia sunt astfel concepute incat sa previna eventualele crapaturi la baza. De asemenea, stratul aditional de cauciuc da o mai mare rezistenta la punctie. DESPRE PRODUCATOR Galaxy s-a...
 1,473.62Lei

... mai multe informatii