[{"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 = '9' 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":"Singular Suki Venom","authId":"","name":"Singular Suki Venom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Suki Venom","authId":"","name":"Singular Suki Venom","CNNId":"","myGameChains":null,"banStatus":null},"id":18351612,"name":"Adventure Champion Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Singular/Suki/Venom/18351612.jpg","createDate":{"time":1351879903000,"minutes":11,"seconds":43,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Singular/Suki/Venom/18351612.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":156,"difficulty":2.7714285714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1546,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Mary Ketchup","authId":"","name":"Bold Mary Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Mary Ketchup","authId":"","name":"Bold Mary Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":19436746,"name":"Force Sonic Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Mary/Ketchup/19436746.jpg","createDate":{"time":1359029112000,"minutes":5,"seconds":12,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Mary/Ketchup/19436746.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":55,"difficulty":2.5166666666666666,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1593,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.371429,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Snarky Don Wolf","authId":"","name":"Snarky Don Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Snarky Don Wolf","authId":"","name":"Snarky Don Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":19173309,"name":"Giga Force Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Snarky/Don/Wolf/19173309.jpg","createDate":{"time":1356366867000,"minutes":34,"seconds":27,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Snarky/Don/Wolf/19173309.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33167,"difficulty":1.9328534402180746,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82704,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.339804,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleek Liz Wolf","authId":"","name":"Sleek Liz Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleek Liz Wolf","authId":"","name":"Sleek Liz Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":18107119,"name":"Adventure Attack Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleek/Liz/Wolf/18107119.jpg","createDate":{"time":1350080286000,"minutes":18,"seconds":6,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleek/Liz/Wolf/18107119.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3010,"difficulty":2.4468651007112547,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5509,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.337566,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Pleasant Leo Cartoon","authId":"","name":"Pleasant Leo Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pleasant Leo Cartoon","authId":"","name":"Pleasant Leo Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19472351,"name":"Echo Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pleasant/Leo/Cartoon/19472351.jpg","createDate":{"time":1359640834000,"minutes":0,"seconds":34,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pleasant/Leo/Cartoon/19472351.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2025,"difficulty":2.4393682065217392,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7376,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333513,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Sharon Blubber","authId":"","name":"Stout Sharon Blubber","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Sharon Blubber","authId":"","name":"Stout Sharon Blubber","CNNId":"","myGameChains":null,"banStatus":null},"id":18429306,"name":"Turbo Ben Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stout/Sharon/Blubber/18429306.jpg","createDate":{"time":1352506258000,"minutes":10,"seconds":58,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stout/Sharon/Blubber/18429306.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":85,"difficulty":1.8888888888888888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1193,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Caitlin Popcorn","authId":"","name":"Regal Caitlin Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Caitlin Popcorn","authId":"","name":"Regal Caitlin Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19629648,"name":"Streak Streak Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regal/Caitlin/Popcorn/19629648.jpg","createDate":{"time":1362345301000,"minutes":15,"seconds":1,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regal/Caitlin/Popcorn/19629648.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":89,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Seismic Matt Turbo","authId":"","name":"Seismic Matt Turbo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Seismic Matt Turbo","authId":"","name":"Seismic Matt Turbo","CNNId":"","myGameChains":null,"banStatus":null},"id":19347436,"name":"Nitro Warp Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Seismic/Matt/Turbo/19347436.jpg","createDate":{"time":1357680478000,"minutes":27,"seconds":58,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Seismic/Matt/Turbo/19347436.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":693,"difficulty":2.32,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":711,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brutish Alan Kook","authId":"","name":"Brutish Alan Kook","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brutish Alan Kook","authId":"","name":"Brutish Alan Kook","CNNId":"","myGameChains":null,"banStatus":null},"id":18514930,"name":"Streak Rock Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brutish/Alan/Kook/18514930.jpg","createDate":{"time":1353273873000,"minutes":24,"seconds":33,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brutish/Alan/Kook/18514930.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":331,"difficulty":2.5238095238095237,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4451,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.330578,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Rudolph Calamari","authId":"","name":"Toxic Rudolph Calamari","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Rudolph Calamari","authId":"","name":"Toxic Rudolph Calamari","CNNId":"","myGameChains":null,"banStatus":null},"id":19906835,"name":"Echo Echo Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Rudolph/Calamari/19906835.jpg","createDate":{"time":1364219135000,"minutes":45,"seconds":35,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Rudolph/Calamari/19906835.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1428,"difficulty":2.4922750162818637,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26733,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.330082,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"61","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 = '9' 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":"70","currentPageToDisplay":7,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]