Got error 28 from storage engine
SELECT `pages`.*, `new_comments`.`count` AS `iNewCommentsCount` 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` ) ORDER BY iType ASC, iPosition ASC, sName ASC, sNameTitle ASC, iPage ASC