Produse : Cauciucuri Agricole | www.cauciucuriagricole.ro, Cauciucuri Agricole. www.cauciucuriagricole.ro

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(353,2489,271,273,276,1394,177,1334,213,1046,1393,1319,319,327,1338,1335,1403,674,2096,1561,1008,203,1426,1012,220,1409,1550,2141,2137,2134,1014,1304,662,161,1546,286,920,921,922,919,923,925,927,924,810,933,926,931,934,782,1844,1845,939,1843,940,742,814,781,735,1498,1490,744,745,941,784,949,1499,935,807,1496,947,948,950,641,1832,632,640,783,785,945,759,786,2510,636,775,811,673,646,633,634,893,953,985,2304,890,789,891,892,761,790,760,1497,1481,959,960,765,983,988,982,1840,635,897,909,818,1829,675,793,795,787,1503,788,746,808,762,815,748,747,648,1502,794,797,1491,669,1501,956,754,1794,836,637,639,894,895,896,764,902,901,1500,798,809,908,905,957,767,763,1484,1485,1483,929,1482,1795,1836,164,766,961,2625,796,799,1841,906,768,2479,800,817,2805,731,963,638,911,1486,1487,951,952,2626,2303,2628,730,676,1828,752,750,910,954,837,2648,984,2302,962,958,812,749,801,813,1480,2627,838,1125,2128,2649,670,2476,778,727,1733,2668,903,736,907,816,1786,728,677,1787,1788,2300,833,2670,2456,751,802,737,758,1124,680,1735,165,396,397,1822,2301,2823,834,2094,671,2821,1796,1847,769,770,803,1489,964,825,398,2106,1849,968,2113,1016,2338,2464,928,986,2769,1141,399,972,1331,1785,777,804,166,2743,2340,2339,625,1797,400,2819,1834,629,628,626,627,630,721,779,930,2564,2667,878,2669,2481,912,805,738,1820,966,722,601,402,403,1350,861,1494,401,2386,2825,987,679,2477,2126,771,756,973,723,772,532,2565,405,406,1600,981,832,2114,974,2799,2342,149,681,2116,2341,2204,410,1831,623,2115,404,619,2117,2502,2777,2824,678,407,898,899,1488,773,955,1443,516,967,1351,624,617,278,1442,2372,683,717,408,2118,2210,2343,1509,1747,2298,2299,2218,2474,582,729,1451,1804,1798,2127,2683,702,2159,2465,1330,1352,1034,2376,2375,1805,2752,2563,2387,672,618,1873,2681,613,914,780,1450,1441,279,975,2388,2468,2562,718,513,622,621,620,976,514,2119,827,2680,409,614,913,1449,415,2344,2307,2783,724,1353,411,701,147,412,616,515,2345,1806,710,2682,518,1438,2120,829,1827,668,711,414,2684,904,1495,753,932,755,806,1492,1439,615,682,835,413,1848,2373,1023,2690,2192,1440,2767,989,2711,1448,2109,1222,2827,1189,900,830,517,2121,2793,1727,2446,2813,2744,726,1452,145,1378,917,2211,531,2830,2223,2122,719,611,2219,699,283,1447,2822,2712,712,1379,519,1799,2123,2383,1453,969,1190,918,2691,1021,2693,915,936,946,2297,1507,1329,2713,1054,1437,281,1436,977,2309,2308,1871,937,362,698,1872,416,1842,1025,1435,2108,2776,1219,2826,2310,417,2695,696,2699,938,942,757,943,944,280,2445,1508,831,1628,2714,2833,2312,2311,1455,1454,2382,2381,686,282,979,978,700,1833,2566,740,1024,521,2124,1445,2314,2313,1073,520,2191,1434,1800,2296,2501,2785,709,612,610,739,695,2820,609,713,714,298,2726,2567,694,692,2459,1142,705,168,1446,2319,2316,2315,2318,1807,2389,2158,418,2832,2222,2125,684,284,1433,2503,421,971,288,687,534,2455,297,2727,2321,2320,707,2703,2190,2157,663,420,167,1801,1245,1247,2504,2511,2723,2295,725,1456,1809,1808,2394,2700,2346,697,1246,2719,423,2513,1354,169,980,419,542,2702,819,2322,741,2514,1525,2293,2471,2533,1458,1457,426,2694,685,2696,533,715,708,743,1360,523,1821,2470,2171,2483,2534,1328,173,608,172,535,525,363,1055,1444,970,2395,522,1428,826,2512,1248,1250,543,1253,1251,2584,2589,427,2323,2692,2095,916,2245,1830,2325,2324,1000,1536,1252,285,1493,606,364,2156,1430,2709,1543,1835,1749,2329,2328,2327,2326,1610,1609,526,2701,589,2347,1431,2531,2787,1581,2598,2705,424,2519,2221,1870,2330,2380,2379,2378,1459,2795,527,2331,365,1432,706,171,1622,1429,290,524,2599,556,720,1460,2728,2704,2517,422,1244,1607,1030,1539,2487,2520,2788,2585,2586,2426,2630,291,704,2472,2292,821,654,2789,1254,1812,1813,607,287,428,1072,1810,300,820,2710,2291,688,2515,536,1601,2784,2587,2632,2631,605,1811,691,557,175,588,425,170,289,2333,2332,537,430,1427,174,1784,1750,2716,842,2735,2734,2244,2532,2590,2794,2334,2335,2348,1022,299,1325,1140,689,1608,538,2530,843,1751,1249,1605,1171,2189,2516,2457,1069,2633,1860,2717,822,2289,366,1031,1186,2427,2600,176,2290,703,367,2715,2452,716,292,649,1327,2170,2482,431,664,1143,1361,1255,2521,1542,146,2588,2205,1523,1071,2187,1027,544,2349,429,2466,2169,2227,1144,546,554,2797,1070,2535,2560,2629,2718,1730,2188,1026,178,437,2288,1326,2601,665,539,1803,545,1032,1380,438,436,997,824,650,2217,1147,2525,880,2536,1815,1177,732,2396,2384,1461,2706,877,528,1324,445,1620,368,1814,2397,293,1527,1479,1478,1462,1463,1885,1661,2724,435,645,2561,2287,651,2286,2602,303,530,2460,1067,2559,584,434,150,1068,2168,1323,295,305,540,2518,2225,823,2336,1816,1322,2493,432,1425,2337,2428,301,296,2155,1002,1001,2786,841,294,2609,2212,2418,2069,1464,1477,2154,2475,302,1321,180,2608,1320,1623,1522,2224,1356,2577,1611,2097,1381,1173,2485,1318,2285,1183,888,548,2737,2527,2374,2284,1184,1355,2350,889,2351,1123,439,529,2451,440,2731,2732,2229,2539,2507,1711,2232,2725,2798,446,449,2213,2283,2282,2831,2469,2186,1213,183,881,1624,181,579,1416,2720,1243,307,655,2524,549,1028,1627,2430,1475,1476,2429,1817,1818,1242,733,870,452,2707,1824,1580,2352,304,306,2733,450,2528,1573,2540,442,1825,2610,541,1602,1415,661,309,2281,2419,553,2280,1007,2431,447,1562,1578,2353,2478,196,451,444,590,2278,547,1540,2279,2529,660,2538,1599,2491,454,2508,2214,2448,1472,2591,1510,1122,2432,2433,2434,844,443,846,1572,2480,441,1712,652,845,2747,453,558,2421,2420,1574,2522,101,2070,2488,277,1657,2578,2060,1466,1465,2816,2617,2620,2228,2652,310,886,551,2454,1265,653,1188,887,1658,1717,2226,882,2543,1131,369,2098,2354,1972,1342,316,1187,370,2198,1302,2740,1541,2757,1791,1468,1467,1473,1474,1469,1133,1535,1665,586,1132,1363,308,1362,102,463,552,555,2526,2153,2736,2545,375,1075,791,1178,1383,1289,188,1563,1564,448,186,2277,2276,2152,847,1382,1688,2423,2523,885,1718,855,2422,1263,2473,456,734,1179,2275,851,374,2424,849,1357,315,1571,311,2742,2537,856,1156,148,854,1683,659,1039,1616,1035,455,2542,2008,2618,2579,2741,1264,2748,1262,2461,2059,2061,2355,2622,1589,656,1343,1746,184,792,192,1670,371,462,666,2009,193,1358,1672,2745,2230,2544,1029,2462,1066,2437,2436,2611,2650,2075,2435,991,460,1560,2541,585,459,2083,200,2086,2085,2463,372,326,461,1537,561,2547,1565,2438,559,1150,317,1579,1530,1065,839,570,474,2408,373,1386,2071,1385,1606,189,458,1384,2808,467,2721,1978,1955,2272,2274,840,2546,2271,2273,2612,191,1614,2409,1155,1154,1638,1414,2167,313,323,465,1182,999,202,2003,1662,1590,457,2410,879,1033,2580,2581,2439,2553,2185,1538,848,2739,2269,1577,2268,468,1677,2623,312,1389,2078,2661,2073,693,190,1005,476,871,477,1340,994,1341,1521,1745,2151,2215,2722,1858,1621,1240,1181,860,473,571,2551,572,667,1003,2267,1241,379,2634,2651,1412,1697,314,199,380,2411,377,1559,1232,853,2453,2549,2458,2592,2593,2356,2385,563,2759,1388,1145,1875,2486,2817,1146,187,2206,591,206,1413,320,1359,560,464,470,1737,1064,376,1339,2207,1679,2412,550,884,1617,2415,1233,2796,883,2413,2621,1615,1695,325,482,2414,2641,1211,201,1668,1691,993,1619,215,483,2548,1625,1886,479,2554,874,2357,321,2265,1151,2490,2236,1734,1074,1296,2266,1130,2234,469,471,1724,466,1405,1387,2147,1682,1673,472,381,565,2594,2595,2613,2619,2184,1212,1528,2558,491,2663,1702,2270,1637,318,329,1157,1172,2758,144,1526,2358,2557,2660,2738,1618,2264,2263,332,2416,205,1129,2467,1006,485,2755,1336,330,1680,1666,331,334,1952,850,643,2552,2150,2417,2635,2636,2637,378,1158,2197,857,2441,2440,2596,2494,873,1643,1225,2746,194,1656,1180,573,1529,2110,2359,564,1390,1401,328,1234,1235,478,197,1667,475,2751,198,1470,2605,1903,1696,2638,2642,210,1364,1642,1588,2555,575,1576,2818,1826,1238,1392,2233,1239,480,1684,1690,1210,2360,2361,322,490,1010,1161,1935,1604,2750,1236,1228,1128,875,2235,1164,1402,209,1558,481,383,1176,1148,2231,2305,1471,872,1655,567,2082,1997,1511,1569,2262,2770,1166,1257,1344,1701,2653,597,1944,1404,1165,862,324,1524,492,1185,1738,587,489,1333,592,1041,1687,212,484,1036,2149,214,1888,568,1258,2606,1823,1699,1897,1887,1626,2639,2645,1191,1365,1192,1366,1261,1298,2362,2363,2730,1367,1230,1260,1990,1685,593,598,1570,2148,143,1593,382,1582,1149,1226,1259,2614,1017,1705,2646,1399,1345,2556,1731,493,2729,2399,2442,2443,2398,2400,2401,1209,1117,996,1193,2261,1194,216,486,335,2644,2662,207,1587,487,1783,495,336,1943,2402,569,576,2306,2173,1237,1288,2260,2364,852,2183,1406,566,2259,1639,1659,1299,333,1512,2146,1732,494,1884,1970,384,2756,1898,1893,2812,1889,1689,1663,2403,858,337,1370,219,2404,2004,2172,2640,2405,496,1698,2815,1063,1206,1332,1969,1953,1162,488,1612,1152,1153,1163,1945,1876,1987,1704,876,2072,1977,2216,1400,1019,995,2208,1346,1371,1967,1654,1231,1713,1227,2497,222,1368,1531,1369,1636,1398,2496,1076,2084,1557,2365,1671,1598,208,1957,1532,2406,1653,2005,142,1229,1126,217,497,343,577,2444,1175,1295,2664,2077,500,218,227,1396,1775,1556,361,2011,562,2001,2258,1533,2006,1686,1037,2665,599,2390,1505,1678,2814,2010,341,1397,1300,1411,2576,2145,1951,387,2800,1553,224,1018,1208,1347,1584,578,2182,2766,1423,1038,2597,2607,1009,1899,1205,226,141,1287,1534,2572,2801,2643,2647,1220,1316,344,2407,1790,1196,1170,339,1348,1410,1043,1555,232,1714,1937,583,2615,1930,2657,2658,1692,1221,1294,1976,338,2573,1207,2144,229,1789,233,1583,1721,1635,2112,385,230,1061,1726,2450,1902,1891,1890,2449,386,1004,2616,574,2257,2256,195,1424,1127,2773,1317,502,2174,992,2196,2574,1640,1708,1700,1707,1118,358,1062,2685,499,1045,2771,1174,2366,1739,1722,1301,234,1107,1634,1792,1963,859,1947,2175,504,1985,360,2012,2195,2624,2074,1998,231,1315,2166,1286,2659,2575,1981,1709,2048,359,236,2255,2000,2654,1681,501,1042,152,1999,140,340,2254,1119,1349,863,1167,1293,1223,1203,1767,1513,1120,498,1736,1202,2080,1044,1958,2143,1907,594,507,596,1060,239,1879,2242,503,2253,346,235,1311,1314,1585,2774,2367,1964,1586,580,1954,1995,2368,2655,1554,1568,1728,506,505,388,240,1292,1285,2099,1313,345,1962,275,351,864,1706,2671,347,2775,2176,2804,1931,1982,1874,2806,2111,1552,1168,228,2065,2107,1644,225,1514,1660,2002,2237,253,238,1372,2252,1395,258,2165,1058,2007,602,349,2753,2369,242,1592,1664,1894,1284,1948,2550,1968,1115,2495,139,1819,1674,138,256,1013,1729,2780,2142,511,2582,509,2666,1567,1965,1224,2054,2164,1710,1116,1291,1283,2240,1768,2239,2105,1040,2076,2656,2163,2391,2140,2829,2139,2050,2672,2583,2177,2425,2067,2811,2317,2251,1740,1693,1772,2053,2079,2697,1719,2178,2138,2802,237,1596,1597,2749,1961,1905,1979,1633,2081,2051,2161,1971,1216,1053,595,348,2066,1942,153,1994,1932,1282,1960,2673,136,1895,255,154,2136,508,1515,865,1204,2828,2377,2100,352,137,1641,350,1059,1551,1139,998,1310,151,581,2603,1297,2250,1407,603,1408,2371,1256,2064,1892,1988,2370,1983,1218,1217,389,1591,243,1877,1956,2568,1566,1121,2781,867,1941,2249,510,265,2676,259,2392,1950,261,1594,1629,1281,866,1762,1966,263,1215,1277,1694,272,1114,1904,1197,1669,266,1200,2492,1630,1595,267,2569,2782,1940,135,2772,1138,2604,1741,1715,2180,1312,2135,2509,1057,1280,1375,1373,1900,2055,1883,1214,2160,2393,1613,1776,1918,1909,1742,357,1199,2674,512,134,1052,156,2570,2809,2764,1743,264,354,1631,1716,254,1290,1047,2238,868,1980,2677,1720,1603,2162,132,1195,2571,1908,2243,1376,269,1374,1198,1309,1169,268,1308,600,1986,1549,1959,133,1703,1632,2678,390,1159,1760,1276,1275,1974,2689,2203,1878,1274,1973,1949,1548,1975,1675,1936,2675,2686,2132,1991,2027,155,249,160,1160,1650,1137,2057,355,2133,1417,1901,1516,2803,1377,1279,1575,159,270,274,1781,251,1882,244,1993,391,2049,2030,130,2101,1779,1725,2090,2018,1648,869,1273,1880,1881,2193,1651,604,1756,157,392,2688,1272,250,1757,2131,2130,2698,131,2778,1782,1652,2058,1676,1771,1056,1744,1547,2052,158,1278,2687,2035,2041,1910,1770,1769,2810,1934,2063,393,2679,1015,1135,1049,1778,252,1946,1939,1517,2761,1136,2056,2807,2760,1765,1933,2179,394,1649,2038,247,1915,1051,1896,2763,1766,2088,2020,1545,2209,1780,2062,1763,1938,2765,1305,2104,1134,1723,1050,1048,1996,1914,2248,2087,2092,2202,2046,2790,248,2779,2091,1764,2025,1271,2042,2033,2129,2500,2093,245,395,1270,1922,356,1911,1906,2762,246,2031,1927,1920,2068,2499,1921,1759,1912,2498,2792,1761,1752,1992,1774,1777,2103,2247,1518,1269,1773,2089,162,2246,2047,1519,1544,2028,2791,1647,1268,1929,1984,1303,2505,2043,2014,129,2102,1520,1758,163,1645,2039,1267,1266,1989,1753,128,1419,1755,1646,2708,1418,2036,2013,2201,1923,2037,1754,2032,2029,2015,1924,2044,1919,1913,2016,2040,2034,1926,2021,1925,2026,2017,1916,1928,2045,2023,1917,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,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,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,203,205,206,207,208,209,210,212,213,214,215,216,217,218,219,220,222,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,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,319,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,353,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,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,605,606,607,608,609,610,611,612,613,614,615,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,643,645,646,648,649,650,651,652,653,654,655,656,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,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,770,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,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,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,981,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,1008,1009,1010,1012,1013,1014,1015,1016,1017,1018,1019,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,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,1124,1125,1126,1127,1128,1129,1130,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,1206,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,1249,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,1304,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,1334,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,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1423,1424,1425,1426,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,1502,1503,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,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,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,1600,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,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,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,1747,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,1785,1786,1787,1788,1789,1790,1791,1792,1794,1795,1796,1797,1798,1799,1800,1801,1803,1804,1805,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1831,1832,1833,1834,1835,1836,1840,1841,1842,1843,1844,1845,1847,1848,1849,1858,1860,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,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2138,2139,2140,2141,2142,2143,2144,2145,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,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,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2239,2240,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,2445,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,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2507,2508,2509,2510,2511,2512,2513,2514,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2547,2548,2549,2550,2551,2552,2553,2554,2555,2556,2557,2558,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833) 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:

7.50-20 6PR MITAS TD-13 TT
7.50-20 6PR MITAS TD-13 TT
485.00Lei  455.00Lei
Reducere   6%
Facebook

Produse




16.00R25 177E ALLIANCE 630 TL

Nu este pe Stoc


16.00R25 177E ALLIANCE 630 TL

Utilizare: Industriale
Producator: ALLIANCE
Garantie: 2 Ani

Pret:  

... mai multe informatii
Sold Zero


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. ANVELOPE INDUSTRIALE & OTR Gama larga de anvelope Alliance destinate aplicatiilor industriale si off-road, asigura solutii personalizate pentru o multitudine de aplicatii din aceste categorii. Aplicatiile de terasament, transport, precum si utilajele si echipamentele industriale beneficiaza de proiectarea si profilele unice ale anvelopelor ... mai multe informatii
16.9-28 14PR OZKA IND-80 156 A8 TL

Nu este pe Stoc


16.9-28 14PR OZKA IND-80 156 A8 TL

Utilizare: Industriale
Producator: OZKA
Garantie: 2 Ani

Pret:  

... mai multe informatii
Sold Zero


Detalii:Anvelopele Ozka IND-80 sunt proiectate pentru echipamente industriale si de constructii.Pereti laterali intariti pentru rezistenta mai mare la taiere si utile pentru toate lucrarile de tractiune.Carcasele reinnoite ale anvelopelor ofera caracteristici imbunatatite de amortizare, contribuind la conducerea mai confortabila, fara vibratii si fara zgomote pe sosea.Anvelopele Ozka sunt fabricate in Turcia.
18.4-26 10PR ALLIANCE 345 TT

Nu este pe Stoc


18.4-26 10PR ALLIANCE 345 TT

Utilizare: Anvelope Forestiere
Producator: ALLIANCE
Garantie: 2 Ani

Pret:  

... mai multe informatii
Sold Zero


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. Anvelopele Forestiere Alliance sunt dezvoltate pentru utilaje forestiere moderne, ca troliurile forestiere, utilaje de transport si de colectare forestiere si tractoare forestiere de mare putere. Aceste anvelope sunt excelente si pentru excavatoare cu roti, încarcatoare, basculante, buldoexcavatoare, tractoare industriale si utilaje care ... mai multe informatii
18.4-30 14PR ALLIANCE 345 TL (460/85R30)

Nu este pe Stoc


18.4-30 14PR ALLIANCE 345 TL (460/85R30)

Utilizare: Anvelope Forestiere
Producator: ALLIANCE
Garantie: 2 Ani

Pret:  

... mai multe informatii
Sold Zero


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. Anvelopele Forestiere Alliance sunt dezvoltate pentru utilaje forestiere moderne, ca troliurile forestiere, utilaje de transport si de colectare forestiere si tractoare forestiere de mare putere. Aceste anvelope sunt excelente si pentru excavatoare cu roti, încarcatoare, basculante, buldoexcavatoare, tractoare industriale si utilaje care ... mai multe informatii