Out of sort memory, consider increasing server sort buffer size<hr>SELECT p.*, IF(LENGTH(name_ru), name_ru, name_ru) AS _name_sort FROM SC_products p WHERE (categoryID IN (694,695,693,628,778,770,771,773,780,779,781,696,775,755,756,782,783,785,823,560,614,625,626,806,786,801,817,624,633,622,623,769,621,638,704,705,707,702,703,706,672,708,701,819,754,760,761,820,821,822,634,646,647,678,698,679,680,818,645,648,650,776,649,651,653,727,728,729,677,627,731,730,757,767,789,797,798,800,802,803,804,788,787,791,795,796,790,793,805,815,816,792,799,620)) AND ( enabled=1)  ORDER BY sort_order, _name_sort LIMIT 0,24