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

14.00-38 8PR BKT TR135 TT
14.00-38 8PR BKT TR135 TT
1,590.00Lei  1,220.00Lei
Reducere   23%
Facebook

Noutati



16.00R25 177E ALLIANCE 630 TL

Nu exista in stoc


16.00R25 177E ALLIANCE 630 TL

Utilizare: IndustrialeProducator: 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.5L-16.1 10PR ALLIANCE 222 TL

Nu exista in stoc


16.5L-16.1 10PR ALLIANCE 222 TL

Utilizare: FlotatieProducator: 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 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
18.4-26 10PR ALLIANCE 345 TT

Nu exista in stoc


18.4-26 10PR ALLIANCE 345 TT

Utilizare: Anvelope ForestiereProducator: 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 exista in stoc


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

Utilizare: Anvelope ForestiereProducator: 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