Error writing file '/tmp/MYXYLYPn' (Errcode: 28 - No space left on device)<hr>SELECT p.*, IF(LENGTH(name_ru), name_ru, name_ru) AS _name_sort, tc.caption as corner_caption FROM SC_products p 
	 LEFT JOIN SC_product_corners tc ON tc.id=p.corner_id 
	
	
	WHERE ( (p.productID IN (1787,1788,1792,1817,1820,1823,1828,1851,1857,1859,1861,1863,1877,1885,1888,1937,1941,1943,1954,1958,1961,1968,1983,1998,2045,2061,2100,2129,2176,2177,2179,2320,2350,2425,2440,2443,2446,2447,2448,2449,2452,2459,2461,2464,2472,2474,2475,2512,2548,2551,2576,2581,2586,2587,2590,2595,2596,2598,2612,2626,2628,2631,2635,2641,2649,2650,2651,2657,2658,2659,2661,2663,2664,2665,2675,2687,2689,2866,2867,2873,2880,2884,2890,2892,2905,2907,2909,2913,2934,2937,2942,2946,2952,2992,2994,2996,3000,3137,3138,3206,3226,3227,3234,3235,3266,3268,3358,3359,3374,3397,3399,3411,3414,3416,3418,3439,3442,3445,3455,3464,3469,3472,3485,3486,3506,3533,3566,3567,3568,3569,3584,3589,3612,3667,3697,3698,3736,3737,3738,3792,3828,3839,3842,3857,3858,3859,3860,3861,3864,3865,3870,3878,3879,3886,3905,3968,3969,3970,3991,3992,3993,3997,4001,4012,4014,4026,4029,4039,4043,4046,4056,4059,4062,4066,4070,4073,4077,4079,4080,4082,4083,4084,4085,4087,4088,4093,4094,4095,4096,4097,4099,4101,4105,4109,4112,4115,4118,4122,4124,4126,4129,4130,4131,4164,4165,4201,4202,4203,4204,4208,4209,4212,4226,4239,4254,4257,4259,4262,4265,4278,4283,4287,4288,4291,4293,4295,4296,4297,4298,4300,4307,4313,4318,4319,4320,4321,4322,4323,4324,4325,4332,4333,4334,4338,4345,4348,4362,4375,4400,4401,4423,4425,4426,4427,4428,4429,4444,4464,4466,4471,4534,4536,4543,4551)) OR (categoryID IN (1136)) ) AND ( enabled=1)  GROUP BY p.productID   ORDER BY sort_order, _name_sort LIMIT 126,21