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 (809,812,810,814,811,736,662,665,743,742,744,745,739,746,747,740,655,741,738,737,752,749,750,751,753,748,813,654)) AND ( enabled=1)  ORDER BY sort_order, _name_sort LIMIT 72,24