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(1014,937,3140,3136,3138,3141,3143,920,947,921,810,922,3144,3139,936,3137,954,3145,903,927,924,934,1484,1497,1494,753,1496,1483,923,784,743,757,814,755,931,919,782,939,933,745,3146,3147,925,1490,3135,781,1845,1498,935,941,1499,742,1847,1843,744,1840,639,637,1848,760,948,3134,1832,641,775,735,950,3133,949,807,642,890,785,786,783,1844,632,945,1492,741,2510,3064,953,787,3062,635,3065,818,1503,926,647,3061,633,790,909,959,1482,960,762,3066,1829,2304,675,2972,759,789,891,811,955,788,815,747,3131,1481,1480,3120,3122,3124,3129,634,893,3121,897,793,957,3123,929,1501,3125,3126,901,795,765,906,1491,748,3049,902,1836,3127,3050,894,764,3132,961,636,746,808,3128,908,763,892,3130,3068,794,1500,796,809,905,797,750,766,956,952,669,3067,2993,1488,2479,767,731,3069,963,895,730,2303,676,798,958,768,761,736,799,984,985,646,988,648,673,2302,838,983,982,910,670,962,1125,2476,638,801,911,833,727,2996,1733,817,754,164,1849,896,812,940,751,728,677,2300,800,778,777,769,1489,1795,2456,680,752,813,737,400,396,397,758,2821,1794,3070,2301,671,834,2094,898,907,2866,2868,2867,825,398,899,928,2994,2873,968,1735,2464,816,165,401,964,972,986,1141,399,2995,749,802,804,803,805,951,1331,904,2850,2819,721,1796,3071,3148,1834,3149,3150,629,628,626,627,630,3152,2340,2339,2338,625,2481,1820,966,722,601,402,1350,861,166,407,403,930,2386,987,679,3072,2477,900,723,2834,1797,532,406,832,2869,2870,1443,2855,2950,2851,3073,3074,2106,149,2204,410,779,3075,2342,623,681,2341,756,973,828,404,619,408,3151,405,3076,967,678,1352,1351,624,2372,717,683,771,1509,3195,1831,617,2299,409,912,516,1442,2343,2474,2954,729,1451,1804,3196,582,702,2871,975,2159,3153,2465,3157,772,738,1330,773,2839,2376,2375,1805,3194,672,3154,613,2218,2387,1841,2388,279,3197,3077,2468,413,718,3078,278,3200,2835,827,3156,614,414,411,976,1449,415,3052,974,3079,1441,701,2307,724,622,621,620,1748,2344,2872,412,616,2894,740,1806,3053,710,618,514,1450,829,2345,2852,3054,711,1798,280,668,3080,3155,1842,1495,914,1439,2997,2298,682,2192,513,2373,1438,942,2927,2895,1440,3199,2210,515,938,2874,1448,1827,989,780,946,2928,3055,1873,3198,1189,913,1353,2998,2853,830,517,1727,2744,726,1452,835,145,2901,2896,2875,917,1378,739,932,806,2836,699,2877,719,611,3201,1447,283,2822,518,3203,712,977,1507,2897,2951,519,1435,2383,1453,2837,969,3056,531,918,3158,1190,1437,1054,1485,2297,2446,1379,2309,2308,1871,1872,1025,2952,2310,2898,3202,3204,1219,2109,3042,362,1508,2312,2311,2382,2381,1455,1454,2854,2987,978,700,2899,831,698,1487,944,1024,2314,2313,521,1445,1436,1628,696,686,915,1486,1329,2191,1434,709,2296,3205,3207,612,610,281,3033,520,298,2858,2820,2856,2878,609,416,713,714,1833,2838,417,2929,694,2459,2879,1142,705,2319,2316,2315,2318,2900,2953,1807,2389,1446,1222,2813,640,282,979,3206,3212,684,1433,2223,943,3000,418,1073,2876,971,2857,421,3208,687,364,692,534,2455,419,2321,2320,707,3043,695,284,1800,2190,2930,725,1456,1809,1808,2394,3159,2346,2211,697,168,1799,3210,3211,3160,2295,542,2322,819,3058,169,167,288,3161,1458,1457,2842,663,2471,2219,685,1525,2830,980,297,2840,715,708,533,1328,2158,2157,2957,1821,2902,523,2470,2483,422,608,365,2293,1428,172,1354,970,2395,1444,2171,1055,1360,420,522,426,1835,423,525,2841,2903,2955,2323,1245,1247,1543,3162,535,3209,543,2095,2999,2931,2325,2324,2956,2881,826,606,3163,2156,1430,2329,2328,2327,2326,1246,526,589,424,2222,2347,1431,2330,2380,2379,2378,1459,2331,2859,2882,527,300,173,1493,427,2880,706,1000,3034,363,2860,290,662,1601,524,286,916,720,1460,556,2426,704,1854,1830,1253,1251,1609,1610,291,1607,1749,2472,2292,1432,821,654,2245,428,1581,1429,1812,1813,2932,607,287,2905,2904,1810,1072,2487,171,1361,285,2291,688,1248,536,1250,3165,820,3044,2948,3213,1811,425,691,588,170,3059,289,2333,2332,537,430,1071,2883,2933,2334,2335,2844,2843,1244,1030,1622,1252,1870,2348,1750,842,1325,174,2885,2887,1326,1523,175,3170,1140,2888,538,3166,1608,2906,2958,3081,557,3164,1751,2221,2220,1171,429,2457,2427,703,2289,1254,2244,1186,2290,1860,843,822,1605,2189,2187,716,1427,2452,292,649,3168,2482,664,2907,2959,431,367,3082,3083,1255,1784,3215,146,1069,1143,2205,176,689,544,1542,2349,2466,2108,299,651,546,1070,1144,366,2862,1026,1327,554,437,2288,1730,1147,368,539,3167,1324,2170,1380,665,997,2169,1815,732,2384,1461,2863,650,2286,1177,824,877,528,2986,1620,2934,2861,1814,2396,545,2397,293,438,432,295,1479,1478,1462,1463,1661,1885,1527,645,2287,178,2188,1803,439,303,2460,441,584,434,433,150,1323,436,3169,2935,2936,2336,1816,540,445,3216,305,880,530,302,435,2337,2428,3084,1425,3173,2908,1067,370,1068,449,3085,2227,294,1464,1477,549,2069,2283,440,2154,2418,1530,296,2475,2909,1321,1322,1001,3174,2937,1623,3217,1522,1356,307,2097,1381,1173,3171,2485,2845,2374,2890,2884,2846,2910,2886,2285,1183,888,548,2284,1184,1355,2350,889,2351,2168,1123,180,2155,448,2960,3172,3035,529,1320,1611,2451,2847,2961,2217,1711,841,301,446,2282,2280,823,3001,2469,3002,881,2962,181,579,2430,1475,1476,2429,1817,1818,733,2865,1243,655,1627,3086,1242,1213,1861,870,1580,2352,1624,304,1318,3089,3087,306,443,541,1415,1602,2911,2431,2281,2278,553,1578,452,2419,3003,177,447,2353,2831,1824,1007,453,451,2478,196,1319,3046,2963,454,2889,2186,2198,183,1472,2432,2433,2434,2225,547,1540,1599,2214,2448,3090,1510,2232,2279,2491,844,2480,1712,846,2508,3176,2913,845,652,558,659,661,1562,1466,1465,101,2229,2212,2060,590,2224,2421,2420,2488,2816,886,551,660,2454,1265,653,1188,1002,887,1658,1717,1122,2153,882,1131,369,309,442,2098,2354,1972,450,316,3091,1187,1573,1574,310,1563,2849,444,1468,1467,1473,1474,1469,2213,1133,1665,586,3088,1132,3175,463,1362,552,3004,2526,2915,102,459,3036,1572,1535,1342,2916,1178,2226,1075,3045,1383,3038,2966,1564,277,2965,2276,1289,1688,847,2423,1386,455,1358,1416,555,991,734,2967,885,1263,2473,1357,3092,1179,458,1302,1718,1384,855,2422,2275,851,186,791,2424,849,188,2938,1571,2277,148,311,856,1156,308,854,1683,3177,3218,1039,2070,994,2489,2008,2228,656,1363,1392,1616,1264,1262,2461,2059,2061,2355,1589,2152,373,457,1343,313,3037,1670,376,371,462,456,375,2009,1672,2437,2436,2435,2462,2075,2940,1382,1560,585,3178,2083,2939,470,315,2086,2085,312,2463,372,2438,2864,561,3179,1182,326,2833,1565,993,187,559,3005,190,2891,378,1150,2918,2071,570,1066,193,839,2408,184,460,792,320,3039,2269,192,1606,3040,3006,189,1385,461,666,200,467,1745,1006,1978,1955,2272,2274,1065,3093,2273,191,1614,1414,374,840,2409,1155,1154,465,1746,202,474,2941,1662,1590,2003,2942,1541,2410,477,317,2185,2439,879,1577,2808,1340,3182,2969,2268,3007,3180,2271,1677,2078,2073,848,693,999,1005,871,3181,1393,1389,1341,1521,2215,380,2991,2892,1240,1181,3183,571,572,3094,1241,1621,2267,1858,381,860,1866,1579,1697,314,2167,323,2411,2912,2266,1232,476,2270,2453,2458,2356,2385,1559,563,1338,2914,1875,471,591,1145,2817,1146,469,2964,472,1359,2151,464,560,2985,667,2207,1003,199,1679,1064,2848,550,884,1617,1233,2984,883,1615,1695,1211,2412,1367,1737,2413,2414,1413,466,3185,206,473,468,1668,1691,3184,1619,483,1412,1625,1172,1886,479,2357,3009,1403,874,3247,1074,3095,2264,1296,3047,2265,2490,3008,482,201,1724,1405,1388,2206,379,213,1682,3010,1673,2150,2944,565,1212,1528,2558,1618,2415,2230,2184,1576,1702,1345,491,1637,377,1339,3225,144,2358,3012,1734,1157,1526,2557,1151,3011,215,2147,1387,3096,573,2263,3219,127,1129,210,2467,328,485,2416,3097,3013,3186,330,321,2262,1680,1666,1952,850,643,2417,327,334,478,1365,1158,1391,205,325,2197,2441,2440,1336,1643,1225,857,873,194,1656,2236,1180,2359,1529,2110,2917,564,487,332,318,1390,329,1401,1234,3188,1235,333,1667,475,1470,198,1903,3098,1696,2234,1364,3099,1642,331,1588,575,2818,3041,1826,1238,1239,1684,1690,1210,2360,2361,1402,3187,2992,1935,1236,1228,1128,598,1604,382,1164,383,481,3221,490,2968,197,1176,1148,2943,2305,1471,1655,1161,872,209,567,2082,1010,1335,1511,1997,2970,480,1558,1257,3189,488,1701,597,1569,1166,1944,1165,862,324,322,1524,1185,587,592,2893,1041,1687,1738,207,1344,875,1192,3101,212,484,1036,1570,568,2233,1258,1699,1897,1626,1888,1887,489,1823,1191,1333,1261,1366,1298,2362,2363,492,1230,1260,3102,1990,1685,593,214,2149,143,2946,1593,1404,2231,1226,1259,2260,1705,2235,3100,1149,1582,493,3103,3222,2148,216,1731,3014,2442,2919,2443,3015,1209,1117,2399,2398,2400,2401,3016,2988,995,2261,486,384,2173,335,3017,1370,1587,2945,3104,336,2306,1943,576,1237,1288,2364,2402,852,1406,566,2241,1639,1659,1636,1399,1299,1371,495,1512,3018,1732,1884,3190,996,1893,1689,1663,1889,858,494,2146,2812,218,337,569,2259,1783,2405,1698,2403,2404,2004,2815,3191,1969,1953,1162,2172,1332,1612,496,1152,1153,1163,219,1945,2971,1038,1987,1704,3048,2072,1346,2183,1977,2216,1555,1063,1967,1654,1231,1713,1227,1193,1369,1076,2365,1671,385,2084,3192,562,2258,1557,222,1598,1368,1957,1653,142,1229,1126,1532,2406,2005,1531,1970,217,2444,577,1175,1295,1194,3248,2077,876,1400,3223,208,227,387,361,220,2011,1686,1037,3019,599,2001,2006,1398,1678,1505,1504,2814,500,1300,1205,1876,2010,1553,1556,223,1411,1951,2208,498,1208,1347,497,1584,1314,224,2981,1396,578,343,3106,499,2182,2800,141,1009,1062,360,1287,3020,1316,232,3107,1220,1534,2390,1533,226,2256,2407,1127,1196,1410,1170,339,2196,359,1714,1899,1937,1692,1221,1408,1294,1976,2982,2920,338,3227,1789,233,1583,1423,1635,2112,2257,3105,1721,3220,1726,2450,1891,1207,2449,1775,1890,1043,583,1315,2144,344,1851,1004,229,1348,574,1397,341,386,1424,195,2181,2983,2947,3226,2989,1061,1317,230,1640,2255,1708,992,1700,2254,1707,1118,358,1930,504,1349,502,231,1045,3021,1174,2366,1902,1722,3193,228,1301,1107,3224,1634,1947,1985,2253,859,2012,503,501,2921,1963,2174,234,2074,1998,1286,3233,1981,1709,2048,347,1681,2367,2000,236,3022,1042,152,3109,3108,1999,140,3110,1119,340,1293,1167,1044,1223,1203,1513,1120,1736,3249,1202,2080,1767,1958,2175,3024,1739,1907,594,2368,596,507,1060,2195,1879,2166,505,1585,2143,3111,2252,276,239,3112,1964,1586,580,1954,1995,388,1372,1311,506,1568,1728,2922,3025,240,1292,1285,2099,863,345,1962,351,1706,346,1931,1982,1874,2111,1313,3023,3026,2242,2065,2107,1644,225,1514,1660,2806,2002,1554,2804,266,242,2165,2007,2176,349,275,2369,253,1592,1664,1567,3237,1284,1552,1948,1058,1968,1115,864,139,2495,1819,235,602,1674,1168,138,238,1395,1729,258,509,1965,3232,1224,2054,1013,1710,256,1116,1291,1894,2142,1283,2251,3113,2105,1040,2237,2076,511,271,2140,2391,2050,2139,2141,2067,3027,2317,1740,1693,2164,2053,2079,1772,1768,262,2811,2923,1719,2802,2163,1597,2177,1905,1979,1633,352,2240,2239,2051,2138,2161,1596,1971,1216,1053,595,1059,2066,2949,2178,1942,153,1994,2250,2136,2425,1961,2137,255,1282,237,1960,2249,136,1932,154,1139,508,1515,1204,2828,865,2100,348,137,1641,151,998,1310,581,1297,1895,603,2371,1256,2064,1988,2370,1983,1218,2081,389,1591,1057,1877,1839,1121,265,1941,350,510,243,3029,2924,2392,1551,2162,1950,1594,1629,1281,3028,1407,866,1966,259,1215,1277,1694,1114,261,3030,1669,867,263,1630,1595,1377,273,272,1940,1217,2377,135,1956,1566,1138,1715,267,2180,156,2492,264,1280,1892,2055,1375,1373,1312,2135,2925,1883,1214,1613,1918,1909,2238,1199,1197,2393,1741,2134,512,1900,134,1052,1047,269,354,1631,1716,1762,1743,254,1290,3114,1308,2809,868,1603,3031,1742,2160,1980,1776,1720,390,132,1195,1550,1309,1908,1200,1376,1904,1198,1374,3032,270,3115,1169,3234,357,600,1986,268,1549,1959,3242,133,1703,1632,3229,3228,1760,2243,1276,1275,1974,2203,1878,1274,1973,1949,1975,2990,1675,1991,2027,155,160,1650,1137,2057,1159,1160,249,1417,2133,1548,1901,1516,2803,159,2132,1936,1279,1575,3236,274,251,244,1882,2926,1993,392,3116,391,2049,2030,130,2101,1725,2090,2018,1648,1273,1880,1881,1651,2193,604,2131,1756,157,1781,869,1272,2810,250,2130,131,3235,1652,2058,1676,1771,1744,1049,1547,3230,2052,158,1278,355,2035,2041,1910,1779,1934,1056,2063,3231,2209,1015,1135,1782,1757,1778,1946,1939,1517,3243,1136,3238,2056,3117,2807,1896,252,1933,1770,1769,2179,394,247,1649,2038,393,1915,1051,2088,2020,1545,2062,1938,1765,1305,2104,1048,1134,1723,1050,1996,1780,1914,395,2248,2087,2092,1766,2202,2046,248,2091,1764,1763,2025,1271,2042,2033,2093,245,1270,1922,356,3245,1911,1906,2980,3239,246,2129,2031,1927,1920,2068,1921,1759,2246,1912,1761,1992,1774,2103,2247,1518,1269,2089,162,2047,3241,1777,3118,1519,2028,1544,1647,1268,1773,2043,3119,1929,1984,1303,1752,2014,129,2102,1520,1420,1758,3244,163,2039,1267,1266,1989,1753,128,1418,1419,1755,1646,1924,2036,2013,1645,1923,2201,2037,1754,2032,2029,2015,2044,1919,1913,2016,2040,3240,2034,1926,2021,1925,2026,2017,1916,1928,2045,2023,1917,1898,2024,2019,2022), 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 (101,102,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,148,149,150,151,152,153,154,155,156,157,158,159,160,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,180,181,183,184,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,205,206,207,208,209,210,212,213,214,215,216,217,218,219,220,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,258,259,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,343,344,345,346,347,348,349,350,351,352,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,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,463,464,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,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,606,607,608,609,610,611,612,613,614,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,632,633,634,635,636,637,638,639,640,641,642,643,645,646,647,648,649,650,651,652,653,654,655,656,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,771,772,773,775,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,982,983,984,985,986,987,988,989,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1009,1010,1013,1014,1015,1024,1025,1026,1030,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1107,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1125,1126,1127,1128,1129,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1202,1203,1204,1205,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1305,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1335,1336,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1423,1424,1425,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1476,1477,1478,1479,1480,1481,1482,1483,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1503,1504,1505,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1540,1541,1542,1543,1544,1545,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1658,1659,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1675,1676,1677,1678,1679,1680,1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1745,1746,1748,1749,1750,1751,1752,1753,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783,1784,1789,1794,1795,1796,1797,1798,1799,1800,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1823,1824,1826,1827,1829,1830,1831,1832,1833,1834,1835,1836,1839,1840,1841,1842,1843,1844,1845,1847,1848,1849,1851,1854,1858,1860,1861,1866,1870,1871,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2146,2147,2148,2149,2150,2151,2152,2153,2154,2155,2156,2157,2158,2159,2160,2161,2162,2163,2164,2165,2166,2167,2168,2169,2170,2171,2172,2173,2174,2175,2176,2177,2178,2179,2180,2181,2182,2183,2184,2185,2186,2187,2188,2189,2190,2191,2192,2193,2195,2196,2197,2198,2201,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2291,2292,2293,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2317,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2446,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2485,2487,2488,2489,2490,2491,2492,2495,2508,2510,2526,2557,2558,2744,2800,2802,2803,2804,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2828,2830,2831,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2980,2981,2982,2983,2984,2985,2986,2987,2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3052,3053,3054,3055,3056,3058,3059,3061,3062,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3238,3239,3240,3241,3242,3243,3244,3245,3247,3248,3249) AND p2a.options_id IN (2,1,3,8) AND p2a.options_id NOT IN (4,5,6,7) 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 Latime:


Dupa Inaltime:


Dupa Diametru:

Anvelope agricole 7.50-20 6PR MITAS TF-05 TT
Anvelope agricole 7.50-20 6PR MITAS TF-05 TT
410.00Lei  390.00Lei
Reducere   5%

Noutati



Anvelope agricole 710/50R26.5 172D ALLIANCE 390 TL

Stoc furnizor


Anvelope agricole 710/50R26.5 172D ALLIANCE 390 TL

Utilizare: FlotationProducator: ALLIANCE
Garantie: 2 Ani

Pret:  

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. Anvelopele agricole Alliance ofera performante de top în toate conditiile de utilizare. Sunt destinate atât aplicatiilor agricole cât si utilizarii ocazionale pe carosabil. Alliance este lider în domeniul Row Crop Narrow Radial . Oferta de anvelopa de tractor, atât în constructie Diagonala cât si Radiala, este extinsa, de la utilaje cu ... mai multe informatii
CAMERE AER 410-5 KABAT TR87

In Stoc: 20


CAMERE AER 410-5 KABAT TR87

Utilizare: Camere aerProducator: KABAT
Garantie: 1 Ani

Pret:   27.50Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea Kabat company este un producator din Polonia de înalta clasa de produse diverse din cauciuc. Afacerea de baza este productia de camere aer pentru anvelope, dar oferta consta intr-o gama foarte larga de produse din cauciuc. Sunt o companie dinamica in crestere, deschisa la cerintele de astazi din piata si de nevoile clientilor . În cursul unei activitati de peste 20 de ani, a dezvoltat o calitate ... mai multe informatii
CAMERE AER 155/80R12 KABAT TR13

In Stoc: 20


CAMERE AER 155/80R12 KABAT TR13

Utilizare: Camere aerProducator: KABAT
Garantie: 1 Ani

Pret:   30.00Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea Kabat company este un producator din Polonia de înalta clasa de produse diverse din cauciuc. Afacerea de baza este productia de camere aer pentru anvelope, dar oferta consta intr-o gama foarte larga de produse din cauciuc. Sunt o companie dinamica in crestere, deschisa la cerintele de astazi din piata si de nevoile clientilor . În cursul unei activitati de peste 20 de ani, a dezvoltat o calitate ... mai multe informatii
CAMERE AER 135/80R12 KABAT TR13

In Stoc: 20


CAMERE AER 135/80R12 KABAT TR13

Utilizare: Camere aerProducator: KABAT
Garantie: 1 Ani

Pret:   35.00Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea Kabat company este un producator din Polonia de înalta clasa de produse diverse din cauciuc. Afacerea de baza este productia de camere aer pentru anvelope, dar oferta consta intr-o gama foarte larga de produse din cauciuc. Sunt o companie dinamica in crestere, deschisa la cerintele de astazi din piata si de nevoile clientilor . În cursul unei activitati de peste 20 de ani, a dezvoltat o calitate ... mai multe informatii