[{"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":"Diligent Mia Kazoo","authId":"","name":"Diligent Mia Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Diligent Mia Kazoo","authId":"","name":"Diligent Mia Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":18351710,"name":"Adventure Echo Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Diligent/Mia/Kazoo/18351710.jpg","createDate":{"time":1351880710000,"minutes":25,"seconds":10,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Diligent/Mia/Kazoo/18351710.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":706,"difficulty":2.019297432777825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6656,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.328546,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Rolf Jigsaw","authId":"","name":"Twisty Rolf Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Rolf Jigsaw","authId":"","name":"Twisty Rolf Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"id":19395958,"name":"Earth Smash Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Twisty/Rolf/Jigsaw/19395958.jpg","createDate":{"time":1358421652000,"minutes":20,"seconds":52,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Twisty/Rolf/Jigsaw/19395958.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4183,"difficulty":2.4964779842619658,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17484,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.313226,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Marco Sprinkle","authId":"","name":"Gruesome Marco Sprinkle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Marco Sprinkle","authId":"","name":"Gruesome Marco Sprinkle","CNNId":"","myGameChains":null,"banStatus":null},"id":18335603,"name":"Universe Champion Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Marco/Sprinkle/18335603.jpg","createDate":{"time":1351696972000,"minutes":22,"seconds":52,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Marco/Sprinkle/18335603.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29127,"difficulty":2.2570892255431185,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":125748,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.296359,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Robin Mutant","authId":"","name":"Regular Robin Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Robin Mutant","authId":"","name":"Regular Robin Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":19592209,"name":"Echo Alien Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Robin/Mutant/19592209.jpg","createDate":{"time":1361648450000,"minutes":40,"seconds":50,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Robin/Mutant/19592209.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16639,"difficulty":1.8565255169020465,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17964,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.263134,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Leonardo Kungfu","authId":"","name":"Average Leonardo Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Leonardo Kungfu","authId":"","name":"Average Leonardo Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":18004969,"name":"Echo Omniverse Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Leonardo/Kungfu/18004969.jpg","createDate":{"time":1349554462000,"minutes":14,"seconds":22,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Leonardo/Kungfu/18004969.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":160,"difficulty":1.9333333333333331,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1535,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.257143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Goliath Goofball","authId":"","name":"Wild Goliath Goofball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Goliath Goofball","authId":"","name":"Wild Goliath Goofball","CNNId":"","myGameChains":null,"banStatus":null},"id":18005051,"name":"Magno Sonic Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wild/Goliath/Goofball/18005051.jpg","createDate":{"time":1349554581000,"minutes":16,"seconds":21,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wild/Goliath/Goofball/18005051.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":201,"difficulty":2.48227367870225,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6830,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.246496,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Andrew Goblin","authId":"","name":"Loud Andrew Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Andrew Goblin","authId":"","name":"Loud Andrew Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17810667,"name":"Magno Rustbucket Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Andrew/Goblin/17810667.jpg","createDate":{"time":1348807142000,"minutes":39,"seconds":2,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Andrew/Goblin/17810667.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":632,"difficulty":1.2419642857142856,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4650,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.236667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Bill Domino","authId":"","name":"Brawny Bill Domino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Bill Domino","authId":"","name":"Brawny Bill Domino","CNNId":"","myGameChains":null,"banStatus":null},"id":19053554,"name":"Ben Alien Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brawny/Bill/Domino/19053554.jpg","createDate":{"time":1355747042000,"minutes":24,"seconds":2,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brawny/Bill/Domino/19053554.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11352,"difficulty":1.5003238290592504,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34235,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.227483,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Timmy Paradox","authId":"","name":"Merry Timmy Paradox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Timmy Paradox","authId":"","name":"Merry Timmy Paradox","CNNId":"","myGameChains":null,"banStatus":null},"id":18783247,"name":"Challenge Adventure Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Merry/Timmy/Paradox/18783247.jpg","createDate":{"time":1354912422000,"minutes":33,"seconds":42,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Merry/Timmy/Paradox/18783247.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20,"difficulty":2.2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":958,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.222222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ruby Quarry","authId":"","name":"Soggy Ruby Quarry","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ruby Quarry","authId":"","name":"Soggy Ruby Quarry","CNNId":"","myGameChains":null,"banStatus":null},"id":17514323,"name":"Mega Whirlwind Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Soggy/Ruby/Quarry/17514323.jpg","createDate":{"time":1348083143000,"minutes":32,"seconds":23,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Soggy/Ruby/Quarry/17514323.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":372,"difficulty":1.44,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":995,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.222222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]