[{"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 = '3' 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":"Epic Summer Hedgehog","authId":"","name":"Epic Summer Hedgehog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Summer Hedgehog","authId":"","name":"Epic Summer Hedgehog","CNNId":"","myGameChains":null,"banStatus":null},"id":18559111,"name":"Rampage Alien Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Summer/Hedgehog/18559111.jpg","createDate":{"time":1353630682000,"minutes":31,"seconds":22,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Summer/Hedgehog/18559111.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1762,"difficulty":2.530473372781065,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4558,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.637627,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Dorothy Wombat","authId":"","name":"Verbose Dorothy Wombat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Dorothy Wombat","authId":"","name":"Verbose Dorothy Wombat","CNNId":"","myGameChains":null,"banStatus":null},"id":18618005,"name":"Battle Hex Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Verbose/Dorothy/Wombat/18618005.jpg","createDate":{"time":1354018055000,"minutes":7,"seconds":35,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Verbose/Dorothy/Wombat/18618005.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27024,"difficulty":1.7564649566482808,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37010,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.603268,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Rex Cuckoo","authId":"","name":"Captain Rex Cuckoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Rex Cuckoo","authId":"","name":"Captain Rex Cuckoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19180235,"name":"Champion Rescue Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Rex/Cuckoo/19180235.jpg","createDate":{"time":1356385923000,"minutes":52,"seconds":3,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Rex/Cuckoo/19180235.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":827,"difficulty":1.5740740740740742,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1705,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.594805,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Aaliyah Magician","authId":"","name":"Barbaric Aaliyah Magician","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Aaliyah Magician","authId":"","name":"Barbaric Aaliyah Magician","CNNId":"","myGameChains":null,"banStatus":null},"id":19413110,"name":"Rocket Assault Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Barbaric/Aaliyah/Magician/19413110.jpg","createDate":{"time":1358668068000,"minutes":47,"seconds":48,"hours":2,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Barbaric/Aaliyah/Magician/19413110.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2390,"difficulty":1.730009832548183,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72900,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.589851,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Connor Hippo","authId":"","name":"Icy Connor Hippo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Connor Hippo","authId":"","name":"Icy Connor Hippo","CNNId":"","myGameChains":null,"banStatus":null},"id":19413716,"name":"Assault Warrior Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Connor/Hippo/19413716.jpg","createDate":{"time":1358683667000,"minutes":7,"seconds":47,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Connor/Hippo/19413716.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":369,"difficulty":1.2708333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1789,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.541667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Major Ian Worm","authId":"","name":"Major Ian Worm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Major Ian Worm","authId":"","name":"Major Ian Worm","CNNId":"","myGameChains":null,"banStatus":null},"id":19347480,"name":"Galaxy Giga Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Major/Ian/Worm/19347480.jpg","createDate":{"time":1357680878000,"minutes":34,"seconds":38,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Major/Ian/Worm/19347480.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6486,"difficulty":1.7466012031003209,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9969,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.526271,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Jesse Glop","authId":"","name":"Elusive Jesse Glop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Jesse Glop","authId":"","name":"Elusive Jesse Glop","CNNId":"","myGameChains":null,"banStatus":null},"id":18285324,"name":"Lightning Escape Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elusive/Jesse/Glop/18285324.jpg","createDate":{"time":1351350693000,"minutes":11,"seconds":33,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elusive/Jesse/Glop/18285324.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26980,"difficulty":1.669476910316969,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44121,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.498388,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Iris Tornado","authId":"","name":"Evil Iris Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Iris Tornado","authId":"","name":"Evil Iris Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19279629,"name":"Omniverse Ultimate Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Iris/Tornado/19279629.jpg","createDate":{"time":1357043017000,"minutes":23,"seconds":37,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Iris/Tornado/19279629.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7040,"difficulty":1.3944902681245888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7845,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.495226,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Yorick Avator","authId":"","name":"Creative Yorick Avator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Yorick Avator","authId":"","name":"Creative Yorick Avator","CNNId":"","myGameChains":null,"banStatus":null},"id":18165090,"name":"Adventure Droid Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Yorick/Avator/18165090.jpg","createDate":{"time":1350332376000,"minutes":19,"seconds":36,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":1,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Yorick/Avator/18165090.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38884,"difficulty":1.3455445420404217,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":157784,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.491313,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Howard Zigzag","authId":"","name":"Howard Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Howard Zigzag","authId":"","name":"Howard Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"id":18286202,"name":"Robot Rustbucket Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Howard/Zigzag/18286202.jpg","createDate":{"time":1351353418000,"minutes":56,"seconds":58,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Howard/Zigzag/18286202.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1094,"difficulty":2.477575707733684,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65295,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.468223,"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 = '3' 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"}}]