string(18764) "
SELECT p.id as id
FROM #__ksenmart_products AS p
LEFT JOIN #__ksenmart_products_categories AS pc ON p.id = pc.product_id
WHERE p.published=1 AND (p.id in (4,5,6,8,10,17,353,355,358,398,412,450,451,452,455,457,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,575,576,577,578,579,580,581,584,585,586,587,588,589,591,592,593,594,595,596,597,598,599,600,601,604,610,611,612,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,681,682,683,684,685,686,692,715,716,717,718,719,720,721,722,724,725,726,728,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,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,870,871,872,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,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,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,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,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,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1131,1132,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,1164,1165,1166,1167,1168,1169,1170,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,1201,1202,1203,1204,1205,1206,1207,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,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,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1334,1335,1336,1337,1338,1341,1342,1343,1344,1345,1346,1347,1348,1350,1351,1352,1353,1354,1355,1357,1364,1368,1369,1370,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,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,1470,1475,1477,1478,1479,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,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1539,1540,1541,1542,1543,1544,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,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,1622,1623,1624,1625,1626,1628,1629,1630,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1648,1649,1662,1663,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,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,1775,1777,1778,1779,1780,1781,1782,1783,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1821,1822,1823,1824,1825,1826,1827,1828,1829,1830,1833,1834,1835,1836,1837,1838,1839,1840,1841,1842,1843,1844,1845,1846,1847,1848,1849,1850,1851,1852,1853,1854,1855,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,2134,2135,2148,2149,2150,2153,2156,2157,2158,2159,2160,2161,2162,2163,2165,2168,2172,2177,2182,2191,2194,2195,2200,2202,2206,2210,2214,2218,2222,2226,2230,2236,2237,2238,2239,2240,2241,2242,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2261,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2291,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2308,2311,2314,2317,2320,2321,2322,2323,2324,2325,2326,2327,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2342,2349,2351,2354,2358,2359,2369,2370,2374,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,2408,2411,2414,2415,2416,2417,2418,2419,2420,2429,2435,2443,2445,2449,2457,2461,2465,2476,2477,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2506,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,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,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,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2747,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,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,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2906,2907,2908,2909,2910,2911,2912,2913,2914,2915,2916,2917,2918,2919,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2987,2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3060,3061,3062,3063,3064,3065,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3250,3251,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3277,3278,3279,3280,3283,3284,3285,3286,3287,3288,3292,3297,3298,3303,3304,3305,3306,3307,3308,3310,3311,3312,3317,3322,3347,3348,3349,3374,3385,3387,3388,3389,3390,3391,3392,3393,3497,3498,3500,3501,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,3512,3548,3549,3550,3587,3588,3589,3590,3592,3594,3595,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3624,3625,3626,3627,3628,3629,3630,3631,3632,3640,3641,3642,3643,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3668,3670,4723,4724,4725,4728,4729,4732,4733,4739,4743,4753,4785,4802,4845,4846,4847,4848,4849,4850,4851,4852,4853,4854,4855,4856,4857,4858,4859,4860,4861,4887,4888,4889,4890,4891,4892,4893,4894,4895,4896,4897,4898,4899,4900,4901,4902,4903,4904,4905,4906,4907,4908,4909,4910,4911,4912,4913,4914,4915,4916,4917,4918,4919,4920,4921,4922,4923,4924,4925,4927,4928,4932,4933,4934,4935,4936,4937,4938,4939,4940,4941,4942,4943,4944,4947,4948,4950,4951,4952,4968,4969,4970,4971,4972,4973,4974,4975,4976,4977,4978,4979,4980,4981,4982,4983,4984,4985,4986,4987,4988,4989,4990,4991,4992,4993,4994,4995,4996,4997,4998,5009,5026,5027,5040,5045,5054,5181,5200,5207,5208,5209,5210,5211,5212,5213,5214,5215,5216,5217,5218,5219,5220,5221,5222,5223,5224,5225,5226,5227,5228,5229,5230,5231,5232,5233,5234,5235,5236,5237,5238,5239,5240,5241,5242,5247,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5269,5270,5271,5272,5333,5347,5348,5349,5350,5352,5393,5394,5395,5396,5397,5414,5437,5441,5448,5479,5480,5481,5482,5498,5499,5500,5501,5502,5535,5661,5662,5663,5664,5665,5666,5667,5671,5672,5673,5676,5677,5678,5753,5754,5790,5802,5810,5811,5812,5813,5814,5815,5816,5817,5818,5822,5823,5824,5825,5826,5827,5828,5829,5830,5831,5832,5833,5894,5895,5896,5922,5961,5962,5969,5971,6009,6030,6031,6037,6069,6094,6103,6104,6105,6106,6107,6108,6109,6110,6111,6112,6121,6122,6123,6124,6309,6310,6311,6312,6313,6314,6315,6316,6317,6318,6319,6320,6321,6322,6341,6349,6350,6351,6365,6367,6396,6397,6398,6399,6400,6415,6416,6419,6425,6492,6495,6512,6546,6555,6562,6632,6679,6691,6739,6789,6798,6799,6819,6839,6852,6879,6895,6899,6914,6920,6921,6922,6923,6924,6925,6943,6953,6957,6958,6970,6972,6976,6988,6989,6990,6991,7010,7011,7028,7036,7082,7087,7088,7089,7090,7093,7124,7129,7134,7135,7143,7146,7151,7179,7192,7209,7216,7218,7224,7225,7226,7227,7228,7229,7243,7244,7245,7248,7249,7250,7251,7253,7256,7265,7266,7289,7290,7314,7318,7321,7331,7332,7340,7350,7351,7364,7386,7405,7411,7433,7483,7484,7489,7490,7523,7524,7525,7526,7527,7528,7564,7568,7569,7570,7571,7572,7573,7574,7576,7606,7618,7631,7638,7640,7641,7642,7646,7649,7650,7656,7659,7677,7681,7683,7684,7685,7686,7687,7688,7689,7692,7693,7694,7704,7705,7706,7707,7708,7709,7710,7711,7712,7713,7714,7718,7719,7720,7721,7722,7723,7724,7725,7726,7727,7729,7730,7731,7732,7733,7734,7735,7736,7738,7739,7740,7741,7742,7744,7745,7747,7748,7749,7750,7751,7752,7753,7754,7755,7756,7757,7758,7759,7760,7761,7762,7763,7764,7765,7766,7767,7768,7769,7772,7773,7774,7775,7776,7777,7778,7779,7780,7781,7782,7784,7785,7786,7787,7788,7789,7790,7791,7792,7793,7794,7795,7796,7797,7799,7800,7801,7802,7803,7804,7807,7815,7816,7824,7825,7826,7832,7836,7840,7845,7846,7847,7848,7849,7850,7851,7852,7853,7854,7855,7856,7857,7858,7859,7860,7861,7862,7870,7882,7883,7891,7893,7898,7935,7941,7942,7943,7944,7945,7956,7957,7958,7959,7960,7961,7962,7963,7964,7965,7966,7967,7968,7969,7970,7971,7972,7973,7978,7979,7984,7985,7986,8023,8028,8029,8049,8052,8062,8085,8118,8126,8130,8146,8148,8173,8182,8203,8204,8227,8228,8234,8237,8238,8241,8243,8256,8263,8264,8265,8268,8278,8282,8284,8293,8299,8301,8304,8305,8311,8346,8371,8395,8400,8411,8412,8421,8427,8439,8440,8441,8442,8444,8445,8508,8539,8549,8550,8563,8576,8588,8589,8596,8600,8601,8602,8603,8604,8605,8606,8607,8610,8611,8612,8613,8614,8622,8630,8658,284142,284143,284144,284145,284153,284173,284178,284208,284211,284219,284228,284237,284238,284239,284240,284241,284260,284261,284262,284278,284316,284317,284318,284320,284322,284324,284328,284331,284340,284348,284349,284350,284351,284355,284356,284360,284362,284370,284376,284379,284380,284405,284408,284443,284450,284453,284458,284459,284460,284461,284462,284463,284464,284465,284466,284467,284469,284470,284471,284472,284473,284474,284475,284476,284477,284478,284479,284480,284481,284482,284519,284520,284526,284527,284528,284529,284530,284531,284532,284533,284534,284538,284539,284540,284541,284542,284544,284546,284547,284548,284549,284550,284551,284552,284553,284554,284555,284556,284557,284558,284559,284560,284561,284562,284563,284564,284565,284566,284567,284568,284569,284570,284571,284575,284576,284577,284578,284579,284580,284581,284582,284583,284584,284585,284586,284587,284588,284589,284592,284593,284595,284596,284597,284598,284599,284600,284602,284603,284604,284605,284606,284607,284609,284610,284611,284612,284613,284614,284646,284647,284651,284656,284674,284675,284676,284677,284678,284679,284680,284681,284682,284683,284684,284685,284686,284690,284701,284702,284703,284715,284734,284735,284736,284744,284761,284762,284773,284783,284785,284786,284787,284788,284789,284790,284791,284792,284795,284802,284856,284858,284888,284892,284893,284897,284910,284911,284957,284961,284976,284977,284978,284980,284981,284982,284983,284987,285008,285009,285010,285022,285023,285024,285025,285036,285037,285038,285042,285046,285047,285048,285049,285050,285051,285062,285063,285064,285066,285087,285098,285106,285109,285157,285158,285159,285160,285174,285184,285185,285186,285187,285190,285192,285193,285194,285195,285196,285197,285201,285209,285210,285213,285214,285221,285222,285223,285224,285225,285226,285271,285272,285274,285275,285276,285277,285278,285279,285280,285282,285283,285285,285286,285287,285293,285294,285295,285296,285297,285298,285299,285303,285304,285305,285306,285315,285329,285337,285338,285339,285340,285351,285353,285354,285355,285356,285357,285358,285359,285360,285361,285362,285363,285405,285411,285413,285422,285423,285424,285425,285426,285427,285428,285429,285430,285431,285432,285433,285434,285435,285436,285488,285490,285491,285492,285493,285494,285495,285496,285497,285498,285499,285506,285528,285529,285530,285531,285532,285533,285534,285537,285538,285547,285548,285559,285564,285565,285566,285567,285568,285570,285571,285574,285575,285576,285577,285578,285579,285580,285581,285582,285583,285584,285585,285586,285587,285588,285589,285590,285591,285592,285593,285594,285595,285597,285602,285603,285604,285605,285606,285607,285608,285609,285610,285611,285612,285613,285614,285615,285616,285617,285620,285622,285623,285625,285626,285627,285628,285629,285630,285642,285643,285644,285645,285649,285650,285652,285653,285654,285655,285656,285659,285660,285661,285662,285663,285664,285665,285666,285667,285668,285669,285670,285671,285672,285673,285674,285675,285676,285677,285678,285679,285680,285681,285682,285683,285684,285685,285686,285687,285688,285689,285690,285691,285692,285693,285694,285695,285696,285697,285698,285699,285700,285701,285702,285703,285704,285705,285706,285707,285708,285709,285710,285711,285712,285713,285714,285715,285716,285717,285718,285719,285720,285721,285722,285723,285724,285725,285726,285727,285728,285729,285730,285731,285732,285733,285734,285735,285736,285737,285738,285739,285740,285741,285742,285743,285744,285745,285746,285747,285748,285749,285750,285751,285752,285753,285754,285755,285756,285757,285758,285759,285760,285761,285762,285763,285764,285765,285766,285767,285768,285769,285770,285771,285772,285773,285774,285775,285776,285777,285778,285779,285780,285781,285782,285783,285784,285787,285788,285789,285790,285791,285793,285794,285795,285796,285797,285798,285799,285800,285801,285805,285806,285807,285808,285809,285810,285811,285812,285813,285814,285815,285816,285817,285818,285819,285946,285979,285985,285997,286045,286070,286072,286079,286086,286115,286174,286189,286212,286249,286257,286290,286301,286318,286347,286348,286349,286350,286376,286380,286398,286414,286561,286562,286563,286564,286566,286567,286568,286569,286573,286586,286588,286605,286606,286656,286664,286672,286695,286729,286745,286749,286750,286756,286788,286807,286816,286817,286818,286819,286820,286821,286822,286823,286824,286825,286826,286827,286828,286829,286830,286831,286832,286834,286835,286836,286837,286838,286839,286840,286841,286842,286843,286844,286845,286846,286847,286848,286849,286850,286851,286857,286858,286859,286860,286861,286862,286863,286864,286865,286866,286867,286868,286869,286870,286871,286872,286873)) AND (p.promotion=1) AND (p.parent_id=0)
GROUP BY p.id
ORDER BY pc.category_id desc"

ГлавнаяАкции

Акции

Акции

Фильтры

Ocean Ceramic INDIA NEW

Amelia Dove 60х120 GL

Акция

Артикул: OC0000094

Керамический гранит

Поверхность: Glossy

В наличии: 648 м2

Подрезково_Импорт: 648 м2

Цена: 2 190 ₽/м2 2 590 ₽

Ocean Ceramic INDIA NEW

Infinity Blick White 60х120

Акция

Артикул: OC0000116

Керамический гранит

Поверхность: Glossy

В наличии: 522.72 м2

Подрезково_Импорт: 522.72 м2

Цена: 2 000 ₽/м2 2 450 ₽

Ocean Ceramic INDIA NEW

Amelia Dove 60х120 matt

Акция

Артикул: OC0000115

Керамический гранит

Поверхность: Матовая

В наличии: 343.44 м2

Подрезково_Импорт: 343.44 м2

Цена: 1 990 ₽/м2 2 450 ₽

Ocean Ceramic INDIA NEW

Kolan Varde 60х120

Акция

Артикул: OC0000139

Керамический гранит

Поверхность: Матовая

В наличии: 20.88 м2

Подрезково_Импорт: 20.88 м2

Цена: 1 990 ₽/м2 2 450 ₽

Ocean Ceramic INDIA NEW

Calcuta Emrald 60х120

Акция

Артикул: OC0000161

Керамический гранит

Поверхность: GEM (матовая с глазурован.прожилками)

В наличии: 243.36 м2

Подрезково_Импорт: 243.36 м2

Цена: 2 450 ₽/м2 2 890 ₽

Ocean Ceramic INDIA NEW

Zenia Gris 60х120

Акция

Артикул: OC0000163

Керамический гранит

Поверхность: Metallic

В наличии: 239.04 м2

Подрезково_Импорт: 239.04 м2

Цена: 2 350 ₽/м2 2 790 ₽

Ocean Ceramic INDIA NEW

Zenia Nero 60х120

Акция

Артикул: OC0000162

Керамический гранит

Поверхность: Metallic

В наличии: 90 м2

Подрезково_Импорт: 90 м2

Цена: 2 350 ₽/м2 2 790 ₽

Roca

Blossom Deco Arena 60X120

Акция

Артикул: F1DR254371

Керамический гранит

Поверхность: Матовая

В наличии: 17.28 м2

Подрезково_Импорт: 17.28 м2

Цена: 4 990 ₽/м2

Roca

Vesta Arena Soft 60X120

Акция

Артикул: GAV7B54371

Керамический гранит

Поверхность: Матовая

В наличии: по запросу

Цена: 4 990 ₽/м2

Roca

Vesta Vison Soft 60X120

Акция

Артикул: GAVRA54141

Керамический гранит

Поверхность: Матовая

В наличии: 56.88 м2

Подрезково_Импорт: 56.88 м2

Цена: 4 990 ₽/м2

Roca

Vesta Deco Arena Soft 60X120

Акция

Артикул: GAVR154371

Керамический гранит

Поверхность: Матовая

В наличии: 4.32 м2

Подрезково_Импорт: 4.32 м2

Цена: 4 990 ₽/м2

Ocean Ceramic IRAN

Apana Dark Grey 60х120

Акция

Артикул: IRN000004

Керамический гранит

Поверхность: Матовая

В наличии: 318.96 м2

Подрезково_Импорт: 318.96 м2

Цена: 2 000 ₽/м2

Ocean Ceramic IRAN

Apana Bone 60х120

Акция

Артикул: IRN000002

Керамический гранит

Поверхность: Матовая

В наличии: 25.92 м2

Подрезково_Импорт: 25.92 м2

Цена: 2 000 ₽/м2

Ocean Ceramic IRAN

Apana Brown 60х120

Акция

Артикул: IRN000003

Керамический гранит

Поверхность: Матовая

В наличии: 486.72 м2

Подрезково_Импорт: 486.72 м2

Цена: 2 000 ₽/м2

Ocean Ceramic IRAN

Isco Dark Gris 60х120

Акция

Артикул: IRN000009

Керамический гранит

Поверхность: Матовая

В наличии: 420.48 м2

Подрезково_Импорт: 420.48 м2

Цена: 2 000 ₽/м2 2 400 ₽

Ocean Ceramic IRAN

Isco Light Gris 60х120

Акция

Артикул: IRN000010

Керамический гранит

Поверхность: Матовая

В наличии: 210.96 м2

Подрезково_Импорт: 210.96 м2

Цена: 2 000 ₽/м2 2 400 ₽

Ocean Ceramic IRAN

Apana Black 60х120

Акция

Артикул: IRN000021

Керамический гранит

Поверхность: Матовая

В наличии: 225.36 м2

Подрезково_Импорт: 225.36 м2

Цена: 2 400 ₽/м2 2 990 ₽

Ocean Ceramic IRAN

Copper Gris 60х120

Акция

Артикул: IRN000025

Керамический гранит

Поверхность: Матовая

В наличии: 297.36 м2

Подрезково_Импорт: 297.36 м2

Цена: 2 000 ₽/м2 2 500 ₽

Ocean Ceramic IRAN

Lumina Bone 60х120

Акция

Артикул: IRN000024

Керамический гранит

Поверхность: Матовая

В наличии: 55.44 м2

Подрезково_Импорт: 55.44 м2

Цена: 2 000 ₽/м2 2 500 ₽

Roca

Niza Coral 20х20

Акция

Артикул: RCN000002

Керамический гранит

Поверхность: Матовая

В наличии: 13.04 м2

Подрезково_Импорт: 13.04 м2

Цена: 4 990 ₽/м2

Roca

Niza Azul 20х20

Акция

Артикул: RCN000001

Керамический гранит

Поверхность: Матовая

В наличии: 63.4 м2

Подрезково_Импорт: 63.4 м2

Цена: 4 990 ₽/м2

Aparici

Joliet Ivory Prisma 7.4х29.75

Акция

Артикул: ACJ000008

Керамическая плитка

Поверхность: Матовая

В наличии: 43.656 м2

Подрезково_Импорт: 43.656 м2

Цена: 4 990 ₽/м2 7 418 ₽

Aparici

Joliet White Prisma 7.4х29.75

Акция

Артикул: ACJ000009

Керамическая плитка

Поверхность: Матовая

В наличии: 38.926 м2

Подрезково_Импорт: 38.926 м2

Цена: 4 990 ₽/м2 7 418 ₽

Aparici

Joliet Toffee 7.4х29.75

Акция

Артикул: ACJ000011

Керамическая плитка

Поверхность: Глянцевая

В наличии: 0.006 м2

Подрезково_Импорт: 0.006 м2

Цена: 8 990 ₽/м2 10 028 ₽

Aparici

Joliet Toffee Prisma 7.4х29.75

Акция

Артикул: ACJ000012

Керамическая плитка

Поверхность: Глянцевая

В наличии: 5.182 м2

Подрезково_Импорт: 5.182 м2

Цена: 8 990 ₽/м2 10 028 ₽

Aparici

Joliet Grey Prisma 7.4х29.75

Акция

Артикул: ACJ000010

Керамическая плитка

Поверхность: Матовая

В наличии: 29.682 м2

Подрезково_Импорт: 29.682 м2

Цена: 3 990 ₽/м2 7 418 ₽

Aparici

Joliet Sapphire Prisma 7.4х29.75

Акция

Артикул: ACJ000007

Керамическая плитка

Поверхность: Глянцевая

В наличии: 36.984 м2

Подрезково_Импорт: 36.984 м2

Из них в резерве: 1.848

Цена: 6 990 ₽/м2 10 028 ₽

Aparici

Joliet Jade 7.4х29.75

Акция

Артикул: ACJ000001

Керамическая плитка

Поверхность: Глянцевая

В наличии: 0.131 м2

Подрезково_Импорт: 0.131 м2

Цена: 8 990 ₽/м2 10 684 ₽

Aparici

Joliet Ivory 7.4х29.75

Акция

Артикул: ACJ000004

Керамическая плитка

Поверхность: Матовая

В наличии: 0.794 м2

Подрезково_Импорт: 0.794 м2

Цена: 4 990 ₽/м2 7 418 ₽

Aparici

Joliet Sapphire 7.4х29.75

Акция

Артикул: ACJ000002

Керамическая плитка

Поверхность: Глянцевая

В наличии: 27.503 м2

Подрезково_Импорт: 27.503 м2

Цена: 6 990 ₽/м2 10 028 ₽

1234