[{"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 = '13' 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 Rhino","authId":"","name":"Creative Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Rhino","authId":"","name":"Creative Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":18640428,"name":"Atomic Fusion Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Rhino/18640428.jpg","createDate":{"time":1354304357000,"minutes":39,"seconds":17,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Rhino/18640428.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":996,"difficulty":2.9669816483505045,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14842,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.643963,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Brad Tornado","authId":"","name":"Nifty Brad Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Brad Tornado","authId":"","name":"Nifty Brad Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":18707656,"name":"Rumble Space Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Brad/Tornado/18707656.jpg","createDate":{"time":1354658517000,"minutes":1,"seconds":57,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Brad/Tornado/18707656.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4160,"difficulty":2.752893524630221,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57873,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.641534,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Gary Quark","authId":"","name":"Dormant Gary Quark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Gary Quark","authId":"","name":"Dormant Gary Quark","CNNId":"","myGameChains":null,"banStatus":null},"id":19347343,"name":"Charge BallWeevil Water","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dormant/Gary/Quark/19347343.jpg","createDate":{"time":1357679500000,"minutes":11,"seconds":40,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dormant/Gary/Quark/19347343.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":832,"difficulty":1.902663355868924,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20436,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.64129,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Chowder Sword","authId":"","name":"Digital Chowder Sword","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Chowder Sword","authId":"","name":"Digital Chowder Sword","CNNId":"","myGameChains":null,"banStatus":null},"id":18675781,"name":"Sonic Solar Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Chowder/Sword/18675781.jpg","createDate":{"time":1354546815000,"minutes":0,"seconds":15,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Chowder/Sword/18675781.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3802,"difficulty":1.7987100185495644,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15909,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.62529,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Benny Cartoon","authId":"","name":"Count Benny Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Benny Cartoon","authId":"","name":"Count Benny Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18520781,"name":"Spike Burst Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Count/Benny/Cartoon/18520781.jpg","createDate":{"time":1353350395000,"minutes":39,"seconds":55,"hours":13,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Count/Benny/Cartoon/18520781.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6541,"difficulty":1.5088339267753132,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10272,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.622438,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Amber Ballyhoo","authId":"","name":"Alien Amber Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Amber Ballyhoo","authId":"","name":"Alien Amber Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19537282,"name":"Star Metal Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Amber/Ballyhoo/19537282.jpg","createDate":{"time":1360794497000,"minutes":28,"seconds":17,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Amber/Ballyhoo/19537282.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4548,"difficulty":2.41632130524681,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15509,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.619599,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Sophia Dolphin","authId":"","name":"Venomous Sophia Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Sophia Dolphin","authId":"","name":"Venomous Sophia Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":19738690,"name":"Omniverse Lightning BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Venomous/Sophia/Dolphin/19738690.jpg","createDate":{"time":1363346543000,"minutes":22,"seconds":23,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Venomous/Sophia/Dolphin/19738690.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5396,"difficulty":2.798336526333249,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":167989,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.617973,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baffling Beatrice Banshee","authId":"","name":"Baffling Beatrice Banshee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baffling Beatrice Banshee","authId":"","name":"Baffling Beatrice Banshee","CNNId":"","myGameChains":null,"banStatus":null},"id":19313223,"name":"Ambush Mega Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baffling/Beatrice/Banshee/19313223.jpg","createDate":{"time":1357321716000,"minutes":48,"seconds":36,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baffling/Beatrice/Banshee/19313223.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1896,"difficulty":2.828900288023105,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19362,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.608097,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Vincent Ape","authId":"","name":"Daring Vincent Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Vincent Ape","authId":"","name":"Daring Vincent Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":19579339,"name":"Ultimate Ambush Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Daring/Vincent/Ape/19579339.jpg","createDate":{"time":1361457550000,"minutes":39,"seconds":10,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Daring/Vincent/Ape/19579339.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21855,"difficulty":2.1987920353251136,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":30521,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.603929,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Dan Slurp","authId":"","name":"Odd Dan Slurp","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Dan Slurp","authId":"","name":"Odd Dan Slurp","CNNId":"","myGameChains":null,"banStatus":null},"id":18525418,"name":"Rampage Atomic Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Odd/Dan/Slurp/18525418.jpg","createDate":{"time":1353399077000,"minutes":11,"seconds":17,"hours":3,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Odd/Dan/Slurp/18525418.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1918,"difficulty":2.3604494518673755,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12286,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.600457,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"51","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 = '13' 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":"60","currentPageToDisplay":6,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]