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_product_options_set PrdOptSet1 ON p.productID = PrdOptSet1.productID 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 (11602,36143,36148,36149,11682,11865,12372,12387,12388,12392,12391,36147,12273,36146,36156,11760,11802,36160,11727,36142,12548,23891,23896,36144,11863,12385,11728,11807,11767,11880,11764,11765,12448,12449,12450,12451,12452,12453,12454,12455,12456,12457,12458,12459,12460,12461,12462,42041,42040,42039,12274,12284,12288,12321,28276,42037,42036,42035,42038,12373,12399,12400,12401,12402,12432,12433,12434,12435,12436,12437,12438,42042,42043,42044,12441,12442,12443,12444,12445,12446,12447,42049,42046,42048,42047,42045,12463,12464,12465,12466,12467,12468,23432,23464,27268,23892,23893,23894,23895,11772,11806,12552,12570,12579,12582,12583,40847,11787,12551,12553,12581,12370,12374,12386,12390,12530,12177,12182,36740,36157,36158,36159,36151,36161,42111,11729,11730,11731,11732,11761,11762,11763,11766,11768,11769,11770,11771,12368,11773,11792,11804,11805,11808,11809,11810,12369,12531,22933,22934,12178,12179,12183,12184,12215,12216,12217,12218,12219,12220,12221,42050,12275,12276,12277,12278,12279,12280,12281,12282,12283,12285,12287,12289,12290,12291,12292,12293,23686,23684,12322,12323,12324,12325,12371,12186,12375,12414,12415,12416,12417,12418,12419,12420,12421,12422,12423,24491,42153,12424,12426,12427,12428,12403,12405,12408,12409,12410,12411,12412,12413,12439,12440,12532,12533,12057,12059,12580,12588,12591,12055,23433,23472,36152,36153,36154,36155,11745,11749,11753,11754,11755,11756,11757,11758,11759,12050,11738,11741,11743,11744,11914,24123,12051,11734,11735,11736,11737,12604,12597,12598,12599,12600,12601,12602,12603,12185,12187,12188,12189,12190,12191,12192,12193,12196,12197,12198,12199,12200,12201,12202,12203,12204,12205,42053,42054,42055,42056,12206,12225,12226,12227,12228,12229,12230,12231,12232,12233,12234,12235,12236,42051,12222,12223,12224,42052,23890)) AND ( p.enabled=1)) AND ( ( PrdOptSet1.variantID = 244 ) ) 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 0,64