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)) AND ( enabled=1)  ORDER BY sort_order, _name_sort LIMIT 0,24