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