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,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 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
20 Anvelope agricole 300/70R20 110A8 PETLAS TA-110 TL 5

Anvelope agricole 300/70R20 110A8 PETLAS TA-110 TL

CARACTERISTICI & AVANTAJE Anvelopa agricola Petlas TA-110  este o anvelopa radiala de tractiune pentru aplicatii agricole de inalta performanta si durata de viata lunga. Avanseaza cu usurinta pe orice tip de suprafata datorita proprietatilor de autocuratare excelente Structura robusta si ranforsata confera anvelopei o durabilitate superioara, datorita compozitiei speciale a benzii de...
 1,655.64Lei

... mai multe informatii
20 Anvelope agricole 300/70R20 110A8/110B MITAS AC-70T TL 2

Anvelope agricole 300/70R20 110A8/110B MITAS AC-70T TL

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...
 2,181.40Lei

... mai multe informatii
4 Anvelope agricole 300/85R42 144A8/141B MITAS AC-85 TL 2

Anvelope agricole 300/85R42 144A8/141B MITAS AC-85 TL

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...
 3,803.82Lei

... mai multe informatii
10 Anvelope agricole 300/85R42 147A8/144B MITAS AC-90 TL 2

Anvelope agricole 300/85R42 147A8/144B MITAS AC-90 TL

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...
 3,750.00Lei

... mai multe informatii
4 Anvelope agricole 300/90R46 148D/151A8 KLEBER CROPKER TL 5

Anvelope agricole 300/90R46 148D/151A8 KLEBER CROPKER TL

DESPRE PRODUCATOR Kléber a început productia în 1910 ca filiala a BFGoodrich în Franta. Dupa schimbarea dreptului de proprietate în 1980, a devenit membru al Grupului Michelin. Gama de anvelope Kléber ofera variante atât pentru autoturisme si autoutilitare cât si pentru camioane si utilaje agricole si industriale. Anvelopele Kléber intra...
 7,265.48Lei

... mai multe informatii
20 Anvelope agricole 300/95R46 148A8 PETLAS TA-120 TL 2

Anvelope agricole 300/95R46 148A8 PETLAS TA-120 TL

CARACTERISTICI & AVANTAJE Anvelopele agricole pentru culturile pe randuri , numite si " Row crop " sunt o linie speciala de anvelope, cu o latime a sectiunii care este ingusta si un raport nominal de aspect care este inalt. Aceste anvelope sunt foarte potrivite pentru operatii intre randurile de cultura - cultivare, recoltare, arat sau ierbicidat . Anvelopele pentru culturile pe...
 3,504.96Lei

... mai multe informatii