Got error 28 from storage engine: select games.*, gamecategories.sef as category_sef from games left join gamecategories on( gamecategories.id = games.categoryid ) where games.active = "Y" && ( games.id in (select gameid from gamecategories2 where categoryid = 10) ) order by games.hit desc limit 25