Got error 28 from storage engine
SELECT SQL_CALC_FOUND_ROWS p.productID, p.categoryID, p.Price, p.PriceCID, p.Price_default, p.list_price, p.in_stock, p.sort_order, p.enabled, p.ordering_available, p.out_of_production, p.product_is_group, p.product_code, p.default_picture, p.new_product, p.specialoffer, p.sale, p.archive, p.slug, p.name_ru, p.brief_description_ru, p.customer_votes, p.customers_rating, p.items_sold, pics.thumbnail, pics.filename, pics.enlarged, p.name_ru AS _name_sort, p_models.childProductID, p_models.parentProductID, p_models_childs.childProductID AS hasModelChilds FROM SC_products p LEFT JOIN SC_products_models AS p_models ON p.productID=p_models.childProductID LEFT JOIN SC_products_models AS p_models_childs ON p.productID=p_models_childs.parentProductID LEFT JOIN SC_product_pictures pics ON p.default_picture = pics.photoID WHERE (p.categoryID IN (11811,11917,42017,42016,42015,42018,11884,11886,11889,11893,22947,22952,22955,42003,42115,42116,42139,11598,11902,11904,11905,11910,11913,41479,38955,41201,11599,11916,42014,11890,42004,11894,11907,11912,23328,42008,42009,11885,11911,42005,42006,42007,11887,11906,42010,42011,11909,11915,42012,42013,11883,11597)) AND ( p.enabled=1) AND (p_models.parentProductID IS NULL) GROUP BY p.productID ORDER BY p.ordering_available DESC, IF(p.in_stock>0,0,1) ASC, p.sort_order ASC, _name_sort LIMIT 256,64