Got error 28 from storage engine
SELECT `pages`.*, `new_comments`.`count` AS `iNewCommentsCount`, IFNULL( `counter`.`iProductsCount`, 0 ) AS `iProductsCountInt` FROM `ss13_pl_pages` AS `pages` LEFT JOIN ( SELECT `iLink` AS `iPage`, COUNT( `iComment` ) AS `count` FROM `ss13_pl_pages_comments` WHERE `iAccepted` = 0 GROUP BY `iPage` ) AS `new_comments` USING( `iPage` ) LEFT JOIN ( SELECT COUNT( `iElement` ) AS `iProductsCount`, `iPage` FROM `ss13_pl_products_pages` INNER JOIN `ss13_pl_products` USING( `iProduct` ) WHERE `iStatus` >= 1 GROUP BY `iPage` ) AS `counter` USING( `iPage` ) ORDER BY iType ASC, iPosition ASC, sName ASC, sNameTitle ASC, iPage ASC