Got error 122 from storage engine
SELECT SQL_CALC_FOUND_ROWS `products`.*, `promoted`.`iPromotedMin`, `producers`.`sName` AS `prodsName`, `producers`.`sLogoUrl` AS `prodsLogoUrl`, `products`.`TiAvailable` AS `iAvailable`, `products`.`fPrice` AS `fCatalogPrice`, `vat`.`fVatValue`, ss13_pl_calculateProductPriceForUser( NULL, `products`.`iProduct`, 0 ) AS `fPrice`, LEAST( `products`.`TiCanBuy`, ss13_pl_getProductCanBuyForUser ( NULL, `products`.`iProduct` ) ) AS `iCanBuy`, `products`.`TiVariantsCount` AS `iVariantCount`, ss13_pl_getProductVisiblePriceForUser ( NULL, `products`.`iProduct` ) AS `iVisiblePrice` FROM `ss13_pl_products` AS `products` LEFT JOIN ( SELECT MIN( `iPromoted` ) `iPromotedMin`, `iProduct` FROM `ss13_pl_products_promoted` WHERE `iTimeValid` IS NULL OR `iTimeValid` >= UNIX_TIMESTAMP() GROUP BY `iProduct` ) `promoted` USING( `iProduct` ) INNER JOIN `ss13_vat` AS `vat` USING( `iVat` ) LEFT JOIN `ss13_pl_producers` AS `producers` USING( `iProducer` ) WHERE 1 AND `products`.`iProduct` IN ( '2743', '2745', '2744', '2746', '2836', '2834', '3031' ) AND EXISTS ( SELECT 1 FROM `ss13_pl_products_pages` AS `products_pages` WHERE `products`.`iProduct` = `products_pages`.`iProduct` AND `products_pages`.`iPage` IN ( '11', '31', '36', '182', '16', '166', '185', '127', '159', '168', '184', '155', '169', '170', '156', '160', '161', '158', '167', '144', '154', '174', '181', '183', '172', '162', '163', '68', '33', '34', '4', '17', '6', '5', '7', '8', '78', '77', '90', '91', '164', '165', '2', '9', '32', '20', '22', '19', '21', '18', '72', '92', '74', '194', '195', '196', '187', '189', '191', '190', '188', '197', '198', '199', '200', '192', '193' ) LIMIT 1 ) AND ss13_pl_getProductVisibleForUser ( NULL, `products`.`iProduct` ) >= 1 AND `products`.`iStatus` >= 1 ORDER BY RAND() LIMIT 0,10