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

Noutati



Anvelope agricole IF 900/65R46 190D TRELLEBORG TM1000 HP TL

Stoc furnizor


Anvelope agricole IF 900/65R46 190D TRELLEBORG TM1000 HP TL

Utilizare: Tractiune radialProducator: TRELLEBORG
Garantie: 5 Ani

Pret:   42,500.00Lei

... mai multe informatii


Detalii:Trelleborg Wheel Systems îmbunatateste TM1000, anvelopa sa emblematica conceputa pentru tractoare de mare putere, îmbunatatind banda de rulare cu tehnologia de mare succes ProgressiveTraction®, câstigatoare de mai multe premii. Aceasta tehnologie elibereaza putere suplimentara la sol si reduce stresul asupra solului, sporind în acelasi timp performanta masinii pentru aplicatii rutiere.
Anvelope agricole VF 750/65R26 177A8/177B TRELLEBORG TM3000 TL

Stoc furnizor


Anvelope agricole VF 750/65R26 177A8/177B TRELLEBORG TM3000 TL

Utilizare: Tractiune radialProducator: TRELLEBORG
Garantie: 5 Ani

Pret:   22,500.00Lei

... mai multe informatii


Detalii:DESPRE PRODUCATOR Trelleborg Wheel Systems face parte din grupul Trelleborg. Este un furnizor global de anvelope si roti complete pentru masini agricole si forestiere, camioane cu furca si alte echipamente de manipulare a materialelor. Compania ofera solutii extrem de specializate, pentru a crea valoare adaugata pentru clienti. Ofera produse de cea mai buna calitate, care permit utilizarea optima a diferitelor tipuri de masini, atât pe ... mai multe informatii
Anvelope agricole 750/65R26 166A8/166B PIRELLI PHP 65 TL

In Stoc: 12


Anvelope agricole 750/65R26 166A8/166B PIRELLI PHP 65 TL

Utilizare: Tractiune radialProducator: PIRELLI
Garantie: 7 Ani

Pret:   11,900.00Lei

... mai multe informatii


Detalii:Pentru a asigura cele mai ridicate performante ale echipamentului agricol, noul pneu radial Pirelli PHP permite o mare versatilitate a utilizarii, dubla fata de un pneu echivalent conventional. Linia PHP radial se produce în Brazilia în fabrica Santo Andre, si raspunde diverselor nevoi ale fermierilor europeni cu o mai buna tractiune, consum redus, fiabilitate excelenta si uzura regulata ale flancurilor. Aditional, comportamentul ... mai multe informatii
Anvelope agricole 600/70R30 152D/155A8 CONTI TRACTOR MASTER TL

In Stoc: 12


Anvelope agricole 600/70R30 152D/155A8 CONTI TRACTOR MASTER TL

Utilizare: Tractiune radialProducator: CONTINENTAL
Garantie: 5 Ani

Pret:   11,900.00Lei

... mai multe informatii


Detalii:TRACTOR MASTER cu noua tehnologie D.fine Lug. La fel ca anvelopele standard de tractor, TractorMaster vine cu o carcasa flexibila N.flex si o tehnologie special dezvoltata cu talon de un singur fir. Alungirea mare a materialului de nailon folosit pentru carcasa face ca anvelopa sa fie robusta si rezistenta la impact. Designul special al talonului cu un singur fir permite o performanta ridicata de deformare a peretelui lateral, asigurând o ... mai multe informatii