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(829,1628,3195,514,515,1450,3197,1831,3348,518,1449,830,2296,3200,531,2297,3199,827,516,2204,3196,532,828,826,517,3356,3357,522,1543,2287,2275,2285,2281,2272,2274,3201,2210,3203,519,1447,2295,2293,1827,3314,831,3206,3208,535,3082,538,2278,886,541,2289,542,3367,1445,2471,525,1622,1446,524,1444,543,3370,150,3081,546,547,550,3084,549,552,3062,3063,553,1620,2269,1617,1191,556,557,1140,523,2270,1185,3068,2214,3091,561,2215,2268,1619,569,571,3093,3096,3095,573,2264,2262,578,3071,3070,2301,528,579,3086,581,1138,582,583,1186,2288,2283,2059,2060,2271,2273,1612,584,1611,2282,3085,2286,2284,2280,2510,3061,3065,3066,3089,3421,3420,1609,1610,3419,1132,3092,3087,3417,2061,883,3416,1182,585,3415,871,3094,2261,2276,1615,1192,587,3067,669,2304,2303,675,2972,3064,2302,2292,589,588,526,2290,3088,3414,2266,1036,1731,1732,3098,3102,1529,2259,2256,2405,1129,1128,1127,3107,3099,3103,2260,3109,3108,3104,1196,3413,592,3106,593,2255,594,3111,676,3069,1125,677,529,530,1122,1637,2416,3101,2053,2048,2254,2252,3408,3110,2249,1644,2251,595,2250,1139,1119,3412,3112,596,3113,598,3097,2050,2054,599,2253,3115,600,629,628,626,627,630,679,3073,3075,3076,680,3072,601,623,622,621,620,1117,2403,3100,2051,2055,602,2049,1116,3411,1115,3410,3409,1631,3407,3406,3114,3116,2056,1195,1650,1137,2246,3117,3074,149,3077,619,2298,618,3078,2299,3080,3079,614,616,613,682,2057,2058,603,2052,3404,3403,604,3118,3119,3402,3401,3400,610,1135,3399,3398,2247,3397,3396,686,2294,607,3395,645,1621,1618,562,574,2267,2263,2258,2257,1525,3058,1142,3057,2418,841,842,1608,1143,1144,843,1730,844,2411,821,1607,822,2419,1602,2421,845,2420,846,824,823,847,1145,1606,2412,1147,1604,2423,2424,849,2279,851,2402,852,2404,2415,855,854,856,2422,1157,857,1159,2265,839,840,1150,1151,1149,1152,2406,2390,2407,859,860,2410,1161,2399,1162,1164,862,2393,1166,863,864,1168,2391,1169,1167,1170,865,2392,866,867,868,2387,3051,869,1190,1189,3499,1605,2408,1146,2413,1603,1524,1156,2409,1155,1154,1158,873,874,2417,2414,2398,2557,1153,1165,1163,1160,875,2400,2401,876,2216,1171,697,2397,877,3262,3257,702,701,3275,3274,699,3272,3273,3277,3276,3345,2446,2822,698,696,2830,3340,695,3056,3055,963,1733,3059,705), 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 (149,150,514,515,516,517,518,519,522,523,524,525,526,528,529,530,531,532,535,538,541,542,543,546,547,549,550,552,553,556,557,561,569,571,573,578,579,581,582,583,584,585,587,588,589,592,593,594,595,596,598,599,600,601,602,603,604,607,610,613,614,616,618,619,620,621,622,623,626,627,628,629,630,645,669,675,676,677,679,680,682,686,826,827,828,829,830,831,871,883,886,1036,1115,1116,1117,1119,1122,1125,1127,1128,1129,1132,1135,1137,1138,1139,1140,1182,1185,1186,1191,1192,1195,1196,1444,1445,1446,1447,1449,1450,1529,1543,1609,1610,1611,1612,1615,1617,1619,1620,1622,1628,1631,1637,1644,1650,1731,1732,1827,1831,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2204,2210,2214,2215,2246,2247,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,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2292,2293,2294,2295,2296,2297,2298,2299,2301,2302,2303,2304,2403,2405,2416,2471,2510,2972,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3084,3085,3086,3087,3088,3089,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3195,3196,3197,3199,3200,3201,3203,3206,3208,3257,3262,3272,3273,3274,3275,3276,3277,3314,3348,3356,3357,3367,3370,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3419,3420,3421,697,821,822,823,824,839,840,841,842,843,844,845,846,847,849,851,852,854,855,856,857,859,860,862,863,864,865,866,867,868,869,873,874,875,876,877,963,1142,1143,1144,1145,1146,1147,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1189,1190,1524,1525,1602,1603,1604,1605,1606,1607,1608,1730,1733,2216,2265,2279,2387,2390,2391,2392,2393,2397,2398,2399,2400,2401,2402,2404,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2417,2418,2419,2420,2421,2422,2423,2424,2557,3499,705,3051,3055,3056,3057,3058,3059,562,574,1618,1621,2257,2258,2263,2267,695,696,698,699,701,702,2446,2822,2830,3340,3345) 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:

Cautare Avansata


Buc. Imagine Produs Weight Denumire Pret
20 Anvelope agricole 10.0/75-15.3 10PR MITAS IM-04 TL 2

Anvelope agricole 10.0/75-15.3 10PR MITAS IM-04 TL

Anvelope versatile pentru roti cu rulare libera pe orice fel de echipament agricol. Componente optimizate si o constructie robusta a anvelopelor in functie de lucrarea ce urmeaza sa fie efectuata, fac ca anvelopele Mitas sa fie extrem de durabile, astfel incat pot fi utilizate pe termen indelungat. Suprafata de rulare grea cu 5 nervuri pentru protectii cu rezistenta redusa la rulare si in acelasi...
595.00Lei

... mai multe informatii

20 Anvelope agricole 10.0/75-15.3 10PR MITAS TS-05 TL 2

Anvelope agricole 10.0/75-15.3 10PR MITAS TS-05 TL

Anvelope versatile pentru roti cu rulare libera pe orice fel de echipament agricol. Componente optimizate si o constructie robusta a anvelopelor in functie de lucrarea ce urmeaza sa fie efectuata, fac ca anvelopele Mitas sa fie extrem de durabile, astfel incat pot fi utilizate pe termen indelungat. Suprafata de rulare grea cu 5 nervuri pentru protectii cu rezistenta redusa la rulare si in acelasi...
695.00Lei

... mai multe informatii

15 Anvelope agricole 10.0/75-15.3 10PR MRL MAW-200 TL 2

Anvelope agricole 10.0/75-15.3 10PR MRL MAW-200 TL

Anvelope Implement Ideale pentru masinile de împrastiat îngrasaminte, remorcile autoîncarcatoare, presele de balotat, plugurile cu discuri si echipamentele agricole. Anvelope versatile pentru roti cu rulare libera pe orice fel de echipament agricol, suprafata de rulare grea cu 5 nervuri pentru protectii cu rezistenta redusa la rulare si rezistent la intemperii. *DESPRE PRODUCATOR Infiintata in...
350.00Lei

... mai multe informatii

20 Anvelope agricole 10.0/75-15.3 10PR PETLAS UN-1 TL 2

Anvelope agricole 10.0/75-15.3 10PR PETLAS UN-1 TL

Anvelopele Petlas UN-1 au fost dezvoltate pentru aplicatii de prelucrare a solului si transport cu utilaje si remorci. Constructia dura si robusta a carcasei prelungeste durata lunga de viata a anvelopei. Designul profilului optimizat si al canelurilor duc la o distribuire uniforma a presiunii pe sosea, avand ca rezultat o uzura uniforma continuand sa performeze chiar si atunci cand sunt pe...
495.00Lei

... mai multe informatii

20 Anvelope agricole 10.0/75-15.3 10PR PETLAS UN-1 TL RF 2

Anvelope agricole 10.0/75-15.3 10PR PETLAS UN-1 TL RF

Anvelopele Petlas UN-1 au fost dezvoltate pentru aplicatii de prelucrare a solului si transport cu utilaje si remorci. Constructia dura si robusta a carcasei prelungeste durata lunga de viata a anvelopei. Designul profilului optimizat si al canelurilor duc la o distribuire uniforma a presiunii pe sosea, avand ca rezultat o uzura uniforma continuand sa performeze chiar si atunci cand sunt pe...
514.00Lei

... mai multe informatii

20 Anvelope agricole 10.0/75-15.3 10PR PETLAS UN-1 TT 2

Anvelope agricole 10.0/75-15.3 10PR PETLAS UN-1 TT

Anvelopele Petlas UN-1 au fost dezvoltate pentru aplicatii de prelucrare a solului si transport cu utilaje si remorci. Constructia dura si robusta a carcasei prelungeste durata lunga de viata a anvelopei. Designul profilului optimizat si al canelurilor duc la o distribuire uniforma a presiunii pe sosea, avand ca rezultat o uzura uniforma continuand sa performeze chiar si atunci cand sunt pe...
472.00Lei

... mai multe informatii


Inapoi