[{"getBestRatedByHero":{"content":{"limit":200,"numberOfItemsPerPage":10,"pagesArray":["1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20"],"count":200,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"Hero.count\" from (SELECT Game.id AS \"Game.id\",Player.name AS \"Game.creator.name\", Game.name AS \"Game.name\", Game.img AS \"Game.base64img\", Game.createDate AS \"Game.createDate\",GameStat.timesShared AS \"Game.statistic.timesShared\", GameStat.timesWon AS\"Game.statistic.timesWon\",GameStat.timesPlayed AS \"Game.statistic.timesPlayed\", ROUND(GameStat.rating,6) AS \"Game.statistic.rating\", GameStat.difficulty AS \"Game.statistic.difficulty\" FROM Game LEFT OUTER JOIN HERO ON Game.heroId = Hero.id LEFT OUTER JOIN GOAL ON Game.goalid = Goal.id LEFT OUTER JOIN GameStat ON Game.id = GameStat.gameid INNER JOIN Player ON Game.creatorId = Player.id AND game.id in (select gameid from (select gameid from game, GameStat where GAME.heroId = '2' AND Game.status = 1 AND createdate BETWEEN SYSDATE-'280' AND SYSDATE AND GameStat.timesPlayed >= '0' AND GameStat.rating >= '0.0' AND Game.id = GameStat.gameid order by GameStat.timesPlayed desc) where rownum <= 200) ORDER BY GameStat.rating DESC) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Chester Diamond","authId":"","name":"Creative Chester Diamond","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Chester Diamond","authId":"","name":"Creative Chester Diamond","CNNId":"","myGameChains":null,"banStatus":null},"id":18487908,"name":"Danger Dark Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Chester/Diamond/18487908.jpg","createDate":{"time":1353020377000,"minutes":59,"seconds":37,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Chester/Diamond/18487908.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":111,"difficulty":1.5208333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1154,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Will Goulash","authId":"","name":"Silly Will Goulash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Will Goulash","authId":"","name":"Silly Will Goulash","CNNId":"","myGameChains":null,"banStatus":null},"id":17470869,"name":"Earth Quake Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Will/Goulash/17470869.jpg","createDate":{"time":1347986952000,"minutes":49,"seconds":12,"hours":12,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Will/Goulash/17470869.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":242,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":805,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Connie Octopus","authId":"","name":"Speedy Connie Octopus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Connie Octopus","authId":"","name":"Speedy Connie Octopus","CNNId":"","myGameChains":null,"banStatus":null},"id":19102983,"name":"Alien Adventure Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Connie/Octopus/19102983.jpg","createDate":{"time":1356080787000,"minutes":6,"seconds":27,"hours":4,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Connie/Octopus/19102983.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26384,"difficulty":1.378415555498806,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":137083,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.177173,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Miguel Ruckus","authId":"","name":"Dramatic Miguel Ruckus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Miguel Ruckus","authId":"","name":"Dramatic Miguel Ruckus","CNNId":"","myGameChains":null,"banStatus":null},"id":18345277,"name":"Humungousaur Rush Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dramatic/Miguel/Ruckus/18345277.jpg","createDate":{"time":1351807372000,"minutes":2,"seconds":52,"hours":18,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dramatic/Miguel/Ruckus/18345277.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":189,"difficulty":1.2138888888888888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3091,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.125,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Kara Scythe","authId":"","name":"Grubby Kara Scythe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Kara Scythe","authId":"","name":"Grubby Kara Scythe","CNNId":"","myGameChains":null,"banStatus":null},"id":18286699,"name":"Humungousaur Mission Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grubby/Kara/Scythe/18286699.jpg","createDate":{"time":1351355405000,"minutes":30,"seconds":5,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grubby/Kara/Scythe/18286699.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":121,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":493,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Cody Porpoise","authId":"","name":"Sparkly Cody Porpoise","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Cody Porpoise","authId":"","name":"Sparkly Cody Porpoise","CNNId":"","myGameChains":null,"banStatus":null},"id":18004517,"name":"Droid Danger Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sparkly/Cody/Porpoise/18004517.jpg","createDate":{"time":1349553672000,"minutes":1,"seconds":12,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sparkly/Cody/Porpoise/18004517.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":176,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":719,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Flapjack Zip","authId":"","name":"Grim Flapjack Zip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Flapjack Zip","authId":"","name":"Grim Flapjack Zip","CNNId":"","myGameChains":null,"banStatus":null},"id":18207185,"name":"Adventure Sonic Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grim/Flapjack/Zip/18207185.jpg","createDate":{"time":1350723944000,"minutes":5,"seconds":44,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grim/Flapjack/Zip/18207185.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":542,"difficulty":1.797222222222222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":771,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.094444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Ronald Quarry","authId":"","name":"Jumping Ronald Quarry","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Ronald Quarry","authId":"","name":"Jumping Ronald Quarry","CNNId":"","myGameChains":null,"banStatus":null},"id":17685853,"name":"Ultimate Turbo Burst","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jumping/Ronald/Quarry/17685853.jpg","createDate":{"time":1348385216000,"minutes":26,"seconds":56,"hours":3,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jumping/Ronald/Quarry/17685853.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":144,"difficulty":1.18,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":352,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.083333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Yucky Kenny Sardine","authId":"","name":"Yucky Kenny Sardine","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Yucky Kenny Sardine","authId":"","name":"Yucky Kenny Sardine","CNNId":"","myGameChains":null,"banStatus":null},"id":18004928,"name":"Crusher Solar Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Yucky/Kenny/Sardine/18004928.jpg","createDate":{"time":1349554402000,"minutes":13,"seconds":22,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Yucky/Kenny/Sardine/18004928.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":588,"difficulty":1.3333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":914,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.083333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Biff Penguin","authId":"","name":"Peppy Biff Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Biff Penguin","authId":"","name":"Peppy Biff Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":17419939,"name":"Alien Ambush Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peppy/Biff/Penguin/17419939.jpg","createDate":{"time":1347821453000,"minutes":50,"seconds":53,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peppy/Biff/Penguin/17419939.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":312,"difficulty":1.7037037037037037,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1253,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.035498,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","sql":"SELECT Game.id AS \"Game.id\",Player.name AS \"Game.creator.name\", Game.name AS \"Game.name\", Game.img AS \"Game.base64img\", Game.createDate AS \"Game.createDate\",GameStat.timesShared AS \"Game.statistic.timesShared\", GameStat.timesWon AS\"Game.statistic.timesWon\",GameStat.timesPlayed AS \"Game.statistic.timesPlayed\", ROUND(GameStat.rating,6) AS \"Game.statistic.rating\", GameStat.difficulty AS \"Game.statistic.difficulty\" FROM Game LEFT OUTER JOIN HERO ON Game.heroId = Hero.id LEFT OUTER JOIN GOAL ON Game.goalid = Goal.id LEFT OUTER JOIN GameStat ON Game.id = GameStat.gameid INNER JOIN Player ON Game.creatorId = Player.id AND game.id in (select gameid from (select gameid from game, GameStat where GAME.heroId = '2' AND Game.status = 1 AND createdate BETWEEN SYSDATE-'280' AND SYSDATE AND GameStat.timesPlayed >= '0' AND GameStat.rating >= '0.0' AND Game.id = GameStat.gameid order by GameStat.timesPlayed desc) where rownum <= 200) ORDER BY GameStat.rating DESC","endRecordId":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]