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,2805,836,2625,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,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,752,750,910,954,837,2128,984,2823,2302,962,1787,1788,2670,958,812,749,801,813,1480,838,1125,670,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,2743,2113,2301,834,2094,671,2821,1796,1847,769,770,803,1489,964,2564,825,398,2669,2106,1849,968,2667,878,2338,2464,928,986,2769,1141,399,972,1331,1785,777,804,166,2825,2340,2339,625,1797,400,2819,1834,629,628,626,627,630,721,2126,779,930,2824,2481,912,805,738,1820,966,722,601,402,403,1350,861,981,1494,401,2386,987,2799,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,2752,2563,2777,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,2783,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,2767,147,412,616,515,2345,1023,1806,710,2682,518,1438,829,1827,2827,2793,668,711,414,2684,2690,904,1495,753,932,755,806,1492,1439,615,682,835,413,1848,2711,2121,2373,2192,1440,2122,989,1448,2109,1222,1189,900,830,517,1727,2446,2813,2123,2744,726,1452,145,1378,2691,917,2211,531,2693,2830,2223,1021,2712,719,611,2219,699,283,1447,2822,712,1379,519,1799,2713,2383,1453,2776,969,2826,1190,918,2699,915,936,946,2297,1507,2695,1329,2714,1054,1437,281,1436,977,2309,2308,1871,937,362,698,1872,416,1842,1025,1435,2108,1219,2310,417,696,938,942,757,943,944,280,2445,1508,831,1628,2833,2312,2311,1455,1454,2382,2381,2785,686,282,979,978,700,1833,2501,2726,2566,740,1024,521,2124,1445,2314,2313,2125,1073,520,2191,1434,1800,2296,709,612,610,739,695,2832,2820,609,713,714,298,2503,2567,694,692,2459,1142,705,168,2723,2727,1446,2319,2316,2315,2318,1807,2389,2158,2700,418,2703,2222,684,284,2511,1433,2504,421,971,288,687,1801,534,2719,2455,297,2321,2320,707,2513,2190,2702,2157,663,420,167,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,1328,173,608,172,535,525,363,2787,1055,1444,970,2395,522,1536,1428,826,1248,1250,2519,543,1253,1251,2531,427,2598,2795,2323,2095,2701,2705,916,2245,1830,2325,2324,1000,2599,2728,1252,2788,285,1493,2520,606,364,2156,1430,2709,1543,1835,1030,1749,2329,2328,2327,2326,1610,1609,526,589,2347,1539,1431,2585,2586,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,2784,422,1244,1607,2515,2487,2426,2632,291,2631,704,2472,2292,821,654,2789,2716,1254,1812,1813,607,287,428,1072,1810,300,820,2710,2291,688,536,1601,2735,2590,2794,1022,605,2734,2532,1811,691,557,175,588,425,170,289,2530,2333,2332,537,430,1427,174,1784,1750,2717,842,2516,1031,2244,2600,2633,2334,2335,2348,299,1325,1140,2715,689,1608,538,843,1751,1249,2521,2588,1605,1171,2189,2457,1069,1860,822,2289,366,1186,2427,176,2290,703,367,2452,716,292,649,1327,2170,2482,431,664,1143,2718,1803,1361,1255,1542,2535,2560,146,2601,2797,2629,2205,1523,1071,1032,2187,1027,544,2536,2349,429,2466,2169,2227,1144,546,2525,554,2706,1070,1730,2188,1026,178,437,2288,1326,665,539,545,1380,438,436,997,824,650,2217,1147,880,2561,1815,1177,2602,732,2396,2384,1461,877,528,1324,445,2724,1620,368,2518,2559,1814,2397,293,1527,1479,1478,1462,1463,1885,1661,435,645,2493,2287,651,2286,303,530,2460,1067,2786,584,434,150,1068,2168,1323,295,305,540,2225,823,2527,2336,1816,1322,2609,432,2608,2577,1425,2337,2428,301,296,2155,1002,1001,841,294,2737,2212,2418,2731,2732,2069,1464,1477,2154,2475,302,1321,2539,180,1320,1623,1522,2507,2224,1356,1611,2097,1381,1173,2485,1318,2285,1183,2725,888,2524,548,2374,2798,2284,1184,1355,2350,889,2351,1123,439,529,2451,440,2229,1711,2232,2720,2733,446,449,2213,2540,2283,2282,2707,2831,2469,2186,1213,183,881,1624,181,579,1825,2610,1416,1243,307,655,549,1028,2528,1627,2430,1475,1476,2429,1817,1818,1242,733,870,452,1824,1580,2352,304,2538,306,2522,450,2529,1573,2591,442,2617,541,1602,1415,661,309,2281,2419,553,2280,1007,2620,2431,447,1562,1578,2353,2578,2478,2652,2747,196,451,444,590,2278,547,1540,2279,660,1599,2491,454,2508,2214,2448,2757,1472,1510,1122,2432,2433,2434,844,443,846,1572,2480,2543,441,1712,652,845,453,558,2421,2420,1574,2736,2740,101,2070,2488,277,1657,1791,2060,1466,1465,2816,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,2741,2742,2537,375,1035,1075,2542,791,1178,1383,1289,188,1563,1564,448,186,2277,2276,2579,2152,847,1382,1688,2423,885,1718,2748,855,2422,1263,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,2650,1264,1262,2541,2461,2059,2061,2355,1589,656,1343,1746,184,792,1537,192,1670,371,462,666,2547,2009,193,1358,1672,2739,2745,2230,2462,1066,2437,2436,2612,2075,2435,991,460,1560,2546,585,459,2083,200,2086,2085,2463,372,2721,326,461,561,1565,2580,2438,2623,559,1150,317,1579,1530,1065,839,570,474,2408,373,1386,2071,1385,1606,1033,189,458,2553,1384,2808,467,1538,1978,1955,2272,2274,840,2581,2271,2273,191,1614,2409,1155,1154,1638,1414,2167,2661,313,323,465,1182,2651,999,202,2003,1662,1590,457,2410,2551,879,2439,2592,2593,2185,2722,848,2269,1577,2268,468,1677,312,1389,2634,2078,2073,693,190,1005,476,871,477,1340,994,1341,1521,1745,2151,2215,2549,1858,1621,1240,1181,860,2759,473,571,572,667,2796,1003,2621,2267,1241,379,1412,1697,314,199,380,2411,377,1559,1232,853,2453,2548,2458,2356,2385,563,1388,1145,1875,2486,2817,1146,187,2206,591,2641,206,1413,320,1359,560,464,2554,470,1737,1064,376,1339,2207,1679,2412,550,884,1617,2415,1233,2594,2595,2619,883,2413,1615,1695,325,482,2414,1211,2663,201,1668,1691,993,1619,215,483,1625,2613,1886,479,874,2357,2738,321,2265,1151,2490,2236,2758,1734,1074,1296,2266,1130,2234,2660,469,471,1724,466,1405,1387,2147,1682,1673,472,381,565,2754,2184,1212,2636,1528,2558,491,2552,1702,2270,1637,318,2635,329,1157,1172,2494,144,1526,2358,2557,1618,2264,2596,2263,332,2416,205,1129,2467,1006,485,2755,1336,330,1680,1666,331,334,1952,850,2746,643,2150,2417,2637,378,2638,2642,1158,2197,857,2751,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,1642,1588,2750,575,1576,2818,1826,1238,1392,2233,1239,480,1684,1690,1210,2360,2361,322,490,1010,1161,1935,1604,1236,1228,1128,875,2235,1164,1402,209,1558,2653,481,383,2770,2645,1176,1148,2231,2305,1471,872,1655,567,2082,1997,1511,1569,2262,1166,1257,1344,1701,597,1944,1404,1165,862,324,1524,492,1185,1738,587,2606,489,1333,2639,592,2730,2241,1041,1687,212,484,1036,2149,214,1888,568,1258,1823,2614,1699,1897,1887,1626,1191,1365,1192,1366,1261,1298,2556,2362,2363,1367,1230,1260,1990,1685,1017,593,2646,598,1570,2148,143,1593,382,1582,2729,1149,1226,1259,1705,1399,1345,1731,493,2644,2662,2399,2442,2443,2398,2400,2401,1209,1117,996,1193,2261,1194,216,486,335,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,2640,1884,1970,384,2756,1898,1893,2812,1889,1689,1663,2403,858,337,1370,219,2404,2004,2172,2405,496,1698,2815,1063,1206,1332,1969,1953,1162,488,1612,1152,1153,1163,2497,1019,1945,1876,1987,1704,2496,876,2072,1977,2216,1400,995,2208,1346,1371,1967,1654,1231,1713,1227,222,1368,1531,1369,1636,1398,1076,2084,1557,2365,1671,2664,1598,208,1957,1532,2406,1653,2005,142,1229,1126,2665,217,497,343,577,2444,1175,1295,2077,500,218,227,1396,1775,1556,361,2011,562,2001,2258,1533,2006,1686,1037,599,2390,1505,1018,1678,2814,2597,2010,341,1397,1300,1411,2576,2145,1951,387,2800,1553,224,2607,1208,1347,1584,2801,578,2182,2643,2766,1423,1038,2647,1009,1790,1899,1205,226,141,1287,1534,2572,2615,2657,2658,1220,1316,344,2407,1196,1170,339,1348,1410,1043,1555,232,1714,1937,583,1930,1692,1221,1294,1976,338,2573,1207,2144,229,1789,233,1583,1721,2616,1635,2112,385,230,1061,1726,2450,1902,1728,1891,1890,2449,386,1004,574,2257,2256,195,1424,1127,2773,1317,2181,502,2685,2174,992,2196,2574,1640,1708,1700,1707,1118,358,1062,499,1045,2771,2624,1174,2366,1739,1722,1301,234,1107,1634,1792,1963,859,1947,2175,504,1985,360,2012,2659,2195,2074,1998,231,1315,2166,2654,1286,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,507,596,1060,239,1879,2242,503,2253,346,235,1311,1314,1585,2774,2367,2655,1964,1586,580,1954,1995,2368,1554,1568,506,505,388,240,1292,2671,1285,2099,1313,345,1962,275,351,864,1706,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,2582,1819,1674,138,256,1013,2666,1729,2780,2142,511,509,1567,1965,1224,2054,2164,1710,1116,2829,1291,2656,1283,2240,1768,2239,2105,1040,2076,2672,2163,2583,2391,2140,2139,2050,2177,2425,2067,2811,2697,2317,2251,1740,1693,1772,2053,2079,1719,2178,2138,2802,237,1596,1597,2749,1961,1905,1979,1633,2081,2051,2161,1971,1216,1053,595,348,2066,2673,1942,153,1994,1932,1282,1960,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,2676,510,265,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,2509,1138,2604,1741,1715,2180,1312,2135,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,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,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,2688,157,392,2698,1272,250,1757,2131,2130,131,2778,1782,1652,2058,1676,1771,1056,1744,1547,2052,2687,158,1278,2035,2041,1910,2679,1770,1769,2810,1934,2063,393,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,2499,1920,2068,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,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,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,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,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,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,2754,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:

12.5/80-18 14PR MITAS BIG-BOY TL
12.5/80-18 14PR MITAS BIG-BOY TL
1,500.00Lei  1,350.00Lei
Reducere   10%
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.9-28 14PR OZKA IND-80 156 A8 TL

Nu exista in stoc


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

Utilizare: IndustrialeProducator: 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 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