[{"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 = '5' 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":"Emperor Faith Python","authId":"","name":"Emperor Faith Python","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Emperor Faith Python","authId":"","name":"Emperor Faith Python","CNNId":"","myGameChains":null,"banStatus":null},"id":17756414,"name":"Lightning Hyper Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Emperor/Faith/Python/17756414.jpg","createDate":{"time":1348551794000,"minutes":43,"seconds":14,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Emperor/Faith/Python/17756414.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1445,"difficulty":2.267578104495725,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6317,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.180422,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing April Blade","authId":"","name":"Amazing April Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing April Blade","authId":"","name":"Amazing April Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":19874607,"name":"Escape Drone Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/April/Blade/19874607.jpg","createDate":{"time":1364044947000,"minutes":22,"seconds":27,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/April/Blade/19874607.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1657,"difficulty":2.3294871794871796,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3327,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.167264,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Raymond Aurora","authId":"","name":"Extreme Raymond Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Raymond Aurora","authId":"","name":"Extreme Raymond Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":19347386,"name":"Mission Solar Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Raymond/Aurora/19347386.jpg","createDate":{"time":1357680080000,"minutes":21,"seconds":20,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Raymond/Aurora/19347386.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":185,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":523,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.166667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Countess Lois Tiger","authId":"","name":"Countess Lois Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Countess Lois Tiger","authId":"","name":"Countess Lois Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19428220,"name":"Brainstorm Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Countess/Lois/Tiger/19428220.jpg","createDate":{"time":1358856321000,"minutes":5,"seconds":21,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Countess/Lois/Tiger/19428220.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":525,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1508,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.16,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Perseus Moonbeam","authId":"","name":"Toxic Perseus Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Perseus Moonbeam","authId":"","name":"Toxic Perseus Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"id":17216079,"name":"Nova Laser Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Perseus/Moonbeam/17216079.jpg","createDate":{"time":1342162362000,"minutes":52,"seconds":42,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Perseus/Moonbeam/17216079.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1347,"difficulty":2.394371702858545,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2882,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.142572,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Benjamin Unicycle","authId":"","name":"Valiant Benjamin Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Benjamin Unicycle","authId":"","name":"Valiant Benjamin Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"id":17966452,"name":"Energy Stone Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valiant/Benjamin/Unicycle/17966452.jpg","createDate":{"time":1349420481000,"minutes":1,"seconds":21,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valiant/Benjamin/Unicycle/17966452.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23745,"difficulty":2.478673436293277,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":271763,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.142461,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Heidi Tuxedo","authId":"","name":"Ancient Heidi Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Heidi Tuxedo","authId":"","name":"Ancient Heidi Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"id":18170573,"name":"Titan Battle Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Heidi/Tuxedo/18170573.jpg","createDate":{"time":1350377125000,"minutes":45,"seconds":25,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Heidi/Tuxedo/18170573.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":989,"difficulty":2.3627777777777776,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3337,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.132782,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wily Hannah Robot","authId":"","name":"Wily Hannah Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wily Hannah Robot","authId":"","name":"Wily Hannah Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":19362450,"name":"Brainstorm Dark Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wily/Hannah/Robot/19362450.jpg","createDate":{"time":1357944471000,"minutes":47,"seconds":51,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wily/Hannah/Robot/19362450.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5779,"difficulty":2.634550409044165,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":97990,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.115405,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Dylan Trapeze","authId":"","name":"Edgy Dylan Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Dylan Trapeze","authId":"","name":"Edgy Dylan Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"id":19180237,"name":"Humungousaur Fire Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Dylan/Trapeze/19180237.jpg","createDate":{"time":1356385933000,"minutes":52,"seconds":13,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Dylan/Trapeze/19180237.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":992,"difficulty":2.2186147186147185,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2112,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.113558,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Valeria Shamrock","authId":"","name":"Orange Valeria Shamrock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Valeria Shamrock","authId":"","name":"Orange Valeria Shamrock","CNNId":"","myGameChains":null,"banStatus":null},"id":19027096,"name":"Atomic Force Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Orange/Valeria/Shamrock/19027096.jpg","createDate":{"time":1355657755000,"minutes":35,"seconds":55,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Orange/Valeria/Shamrock/19027096.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14109,"difficulty":2.325908707698272,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":48758,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.105667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '5' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]