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