Error writing file '/tmp/MYiAgB21' (Errcode: 28 - No space left on device)
SELECT SQL_CALC_FOUND_ROWS p.*, Price FROM SC_products p LEFT JOIN SC_categories cat ON p.categoryID = cat.categoryID WHERE ( (p.productID IN (820,3534,1013,1016,1195,2084,1412,1431,1434,1443,3642,1459,1460,1461,1466,1481,1604,1610,1616,1674,1758,1759,1760,1775,1776,1783,1785,1965,2061,2062,2063,2064,2067,2079,2080,2082,2083,3165,2085,2086,2089,2090,2091,2092,2094,2096,2101,2104,2105,2106,2113,2114,2117,2118,2122,2124,2128,2129,2134,2135,2136,2138,2139,2140,2141,2147,2148,2149,2150,2151,2153,2154,2160,2162,2163,2186,2217,2222,2237,2240,2267,2268,2270,2277,3720,2314,2392,2393,2395,2396,2087,2479,2490,3651,2495,3708,2513,2514,2516,2517,2521,2522,2523,2501,2528,2531,2535,2536,2539,2541,2542,2543,2544,2545,2546,2547,2548,2549,2551,2552,2554,2555,2557,2559,2560,2561,2562,2563,2564,2565,2571,2577,2586,2589,2590,2596,2610,2612,2613,2615,2618,2621,2643,2653,2660,2949,2966,2988,2991,2998,3000,3002,3037,3045,3046,3066,3071,3402,3072,3073,3074,3075,3715,3085,3088,3095,3098,3099,3106,3057,2146,3270,3275,3080,3092,1247,2502,2617,2174,3100,2468,2144,2152,3086,3342,3346,3415,3416,3527,3493,3579,3499,3502,3503,3504,3519,3529,3532,3535,3533,3550,3551,3554,3553,3555,3561,3562,3563,3565,3564,3643,3652,3653,3655,3665,3664,3668,3685)) OR (p.categoryID IN (689)) ) AND ( p.enabled=1 AND `p`.`productID` NOT IN (673,908,674,675,676,677,862,904,913,1525,1317,1318,1319,1320,1322,1323,1503,1504,1506,906,707,754,755,678,679,680,926,928,1049,1151,1228,1360,1361,2316,2315,726,727,728,729,806,2266,746,747,751,752,865,866,773,1005,1002,1003,1004,795,796,797,889,798,801,844,845,846,847,848,997,2341,2342,2343,2344,1658,1321,1505,836,837,838,839,1047,857,860,861,944,938,939,945,1011,1039,1040,1230,1063,1078,1236,1238,1252,1253,1376,2275,2272,2273,2274,2278,2276,2277,2279,2280,2281,977,1101,1102,1015,1016,1017,1324,1067,1068,1069,1070,1071,1072,1215,1216,1226,2461,1377,1378,1379,1380,1467,1470,1468,1469,1541,1494,719,1495,1496,1497,1498,1499,1500,1501,1502,1638,1639,1640,2462,1677,1644,1746,2352,2351,2353,2350,2356,2357,2359,2358,2360,2361,2362,2561,2562,2563,2564,3037,2234,2235,669,668,670,671,672,905,909,910,682,683,684,685,686,687,688,689,690,691,692,708,709,879,710,711,722,723,724,725,736,871,872,880,756,757,758,896,759,760,765,768,769,770,771,772,785,775,776,784,783,788,1007,923,895,853,799,800,922,1655,1656,826,815,816,820,851,855,859,863,829,830,831,832,833,835,843,874,873,875,876,878,882,883,888,885,886,887,919,943,994,947,948,964,942,965,946,1621,963,966,967,978,996,979,980,986,987,988,990,991,992,1008,1013,1014,1012,1019,1020,1021,1022,1031,1033,1076,1050,1095,1231,1093,1232,1053,1057,1059,1060,1061,1064,1100,1074,1075,1089,1090,1091,1079,1082,1083,1751,1110,1121,1152,1153,1154,1158,1160,1162,1168,1170,1171,1172,1173,1174,1175,1176,1178,1179,1180,1196,1197,1199,1200,1201,1202,1243,1244,1245,1249,1251,1457,1404,1270,1272,1273,1274,1284,1285,1304,1290,1286,1287,1288,1289,1291,1292,1293,1294,1295,1302,2606,2607,2608,2609,1313,1314,1315,1316,1373,1398,1401,1354,1402,1727,1728,1411,1790,1405,1406,1407,1409,1410,1479,1526,1493,1566,1543,1625,1548,1749,1767,1574,1556,1561,1563,1564,1567,1646,1585,1591,1601,1602,1603,1605,1606,1754,1911,2616,2614,1798,1799,1800,1801,1802,1968,2095,2003,2102,2145,2155,2161,2306,2307,2308,2237,2238,2240,2241,2242,2243,2244,2245,2246,2247,2248,2250,2251,2282,2283,2284,2285,2286,2287,2288,2304,2291,2296,2300,2302,2372,2373,2374,2375,2404,2377,2378,2386,2391,2394,2399,2397,2398,2400,2401,2402,2403,2405,2406,2407,2408,2410,2409,2411,2471,2472,2473,2474,2467,2466,2553,2592,2593,2594,2595,3124,3123,3122,3121,3082,2990,2987,2986,2985,2984,2983,2982,2981,2980,2979,2978,2977,2976,2974,2972,2970,2968,2965,2964,2963,2962,2961,2960,2959,2958,2957,2956,2955,2954,2952,2950,2948,2947,2946,2945,2944,2943,2942,2941,2659,2658,2657,2656,2655,2654,2652,3169,3666,2007,2052,2053,2011,2008,2009,2010,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2032,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2049,2050,2051,2054,2055,2056,2940,2937,2936,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2895,2894,2893,2892,2891,2890,2889,2888,2887,2886,2885,2884,2883,2882,2881,2880,2879,2878,2877,2876,2875,2874,2873,2872,2871,2870,2869,2868,2867,2866,2864,2863,2862,2861,2858,2855,2853,2849,2848,2847,2846,2845,2844,2843,2842,2841,2840,2839,2838,2837,2836,2835,2834,2833,2832,2831,2830,2829,2828,2827,2826,2825,2824,2823,2822,2821,2820,2819,2818,2817,2816,2815,2814,2813,2812,2811,2810,2809,2808,2807,2806,2805,2804,2803,2802,2801,2800,2799,2798,2797,2796,2795,2794,2793,2792,2791,2790,2789,2788,2787,2786,2785,2784,2783,2782,2781,2780,2779,2778,2777,2776,2775,2774,2773,2772,2771,2770,2769,2768,2767,2766,2765,2764,2763,2762,2761,2760,2759,2758,2757,2756,2755,2754,2753,2752,2751,2750,2749,2748,2747,2746,2745,2744,2743,2742,2741,2740,2739,2738,2737,2736,2735,2734,2733,2732,2731,2730,2729,2728,2727,2726,2725,2724,2723,2722,2721,2720,2719,2718,2716,2715,2714,2713,2712,2711,2710,2709,2708,2707,2706,2705,2704,2703,2702,2700,2699,2698,2697,2696,2695,2694,2693,2692,2691,2690,2689,2688,2687,2686,2685,2684,2683,2682,2681,2680,2679,2678,2677,2676,2675,2674,2673,2672,2671,2670,2669,2668,2667,2666,2665,2663,2661,2927,2920,2917,2916,2915,2914,2913,2912,2911,2910,2909,3130,2938,2935,2934,2932,2865,2860,2859,2857,2856,2854,2850,3171,2933,2931,2930,2929,2928,2925,2924,2922,2139,1873) AND `p`.`categoryID` NOT IN (1, 701, 702, 703, 704, 705, 706, 768, 769, 770, 771, 772, 773) ) AND cat.enabled = 1 GROUP BY p.productID ORDER BY IF( top_descr is not null AND top_descr != '' AND top_descr != 'null' AND top_descr != '[]' AND in_stock > 0, 1, IF( expert_content_ru is not null AND expert_content_ru != '' AND expert_content_ru != 'null' AND expert_content_ru != '[]' AND in_stock > 0, 2, IF( in_stock > 0, 3, IF( top_descr is not null AND top_descr != '' AND top_descr != 'null' AND top_descr != '[]' AND in_stock = 0, 4, IF( expert_content_ru is not null AND expert_content_ru != '' AND expert_content_ru != 'null' AND expert_content_ru != '[]' AND in_stock = 0, 5, IF( in_stock = 0, 6, IF( top_descr is not null AND top_descr != '' AND top_descr != 'null' AND top_descr != '[]' AND in_stock < 0, 7, IF( expert_content_ru is not null AND expert_content_ru != '' AND expert_content_ru != 'null' AND expert_content_ru != '[]' AND in_stock < 0, 8, 9 ) ) ) ) ) ) ) ) ASC, Price ASC LIMIT 0,30