Got error 122 from storage engine
SELECT SQL_CALC_FOUND_ROWS p.*, name_ru AS _name_sort FROM SC_products p LEFT JOIN SC_tagged_objects t2 ON p.productID=t2.object_id LEFT JOIN SC_tags t1 ON t2.tag_id=t1.id AND t2.object_type="product" WHERE ( ( t1.name LIKE '%термостат%') AND categoryID<>1 AND enabled=1) GROUP BY p.productID ORDER BY in_stock desc, sort_order, _name_sort LIMIT 0,40