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

13.6 - 28 8PR TT PETLAS TA-60
13.6 - 28 8PR TT PETLAS TA-60
1,240.00Lei  1,145.00Lei
Reducere   8%
Facebook

Produse




10 - 16.5 10PR MALHOTRA 134 A2

In Stoc: 20


10 - 16.5 10PR MALHOTRA 134 A2

Utilizare: Industrial
Producator: MALHOTRA
Garantie: 2 Ani

Pret:   490.00Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea. Transport gratuit pentru minim 2 buc. Termen de livrare 24-72h. Infiintata in anul 1954, in India, Grupul Malhotra al Industries este renumit la nivel mondial in industria anvelopelor. Cu un zel vizionar si practici inovatoare, au construit de-a lungul celor 6 decenii de existenta un colos in materie de anvelope cu o gama variata de dimensiuni si modele, pentru diverse aplicatii. In portofoliul Malhotra ... mai multe informatii
10 - 16.5 10PR MITAS SKID STEER SK-05 TL

In Stoc: 20


10 - 16.5 10PR MITAS SKID STEER SK-05 TL

Utilizare: Bobcat
Producator: MITAS
Garantie: 2 Ani

Pret:   990.00Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. Anvelopele Mitas si Cultor sunt produse in Cehia,Serbia si Statele Unite sub licenta Continental Tyres.Gama de anvelope este diversificata in mai multe segmente de piata (agricultura ,constructi,motocross) Calitatea anvelopelor Mitas este recunscuta in toata Europa si America, fiind unul din principali producatori europeni de anvelope agricole ... mai multe informatii
10 - 16.5 8PR GALAXY BEEFY BABY

In Stoc: 20


10 - 16.5 8PR GALAXY BEEFY BABY

Utilizare: Bobcat
Producator: GALAXY
Garantie: 2 Ani

Pret:   830.00Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. Proiectate pentru buldoexcavatoare, manipulatoare si încarcatoare.Stabilitate si manevrare excelente.Tractiune puternica si aderenta buna.Anvelope cu durata lunga de viata,anvelope eficiente si economice.
10 - 16.5 8PR MITAS SK-02 TL

In Stoc: 20


10 - 16.5 8PR MITAS SK-02 TL

Utilizare: Bobcat
Producator: MITAS
Garantie: 2 Ani

Pret:   780.00Lei

... mai multe informatii


Detalii:Pretul afisat include tva si ecovaloarea.Transport gratuit pentru minim 2 buc.Termen de livrare 24-72h. Anvelopele Mitas si Cultor sunt produse in Cehia,Serbia si Statele Unite sub licenta Continental Tyres.Gama de anvelope este diversificata in mai multe segmente de piata (agricultura ,constructi,motocross) Calitatea anvelopelor Mitas este recunscuta in toata Europa si America, fiind unul din principali producatori europeni de anvelope agricole ... mai multe informatii