[{"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 = '12' 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":"Abnormal Ezekiel Twist","authId":"","name":"Abnormal Ezekiel Twist","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Ezekiel Twist","authId":"","name":"Abnormal Ezekiel Twist","CNNId":"","myGameChains":null,"banStatus":null},"id":18207277,"name":"Rampage Ambush Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abnormal/Ezekiel/Twist/18207277.jpg","createDate":{"time":1350725270000,"minutes":27,"seconds":50,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abnormal/Ezekiel/Twist/18207277.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1006,"difficulty":2.2414247517188692,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10283,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.351999,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Jay Samurai","authId":"","name":"Kinetic Jay Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Jay Samurai","authId":"","name":"Kinetic Jay Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":18005083,"name":"Solar Hex Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Jay/Samurai/18005083.jpg","createDate":{"time":1349554613000,"minutes":16,"seconds":53,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Jay/Samurai/18005083.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48714,"difficulty":1.4747993240394315,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83625,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.347901,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Otto Nacho","authId":"","name":"Dubious Otto Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Otto Nacho","authId":"","name":"Dubious Otto Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":17953675,"name":"Sonic Alien Gravattack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dubious/Otto/Nacho/17953675.jpg","createDate":{"time":1349340200000,"minutes":43,"seconds":20,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dubious/Otto/Nacho/17953675.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":474,"difficulty":2.7039896001434465,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3160,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.347364,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold David Goblin","authId":"","name":"Bold David Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold David Goblin","authId":"","name":"Bold David Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17587734,"name":"Spark Omniverse Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/David/Goblin/17587734.jpg","createDate":{"time":1348259364000,"minutes":29,"seconds":24,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/David/Goblin/17587734.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11129,"difficulty":1.6884962375997186,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43915,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.33616,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Jack Flipper","authId":"","name":"Hefty Jack Flipper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Jack Flipper","authId":"","name":"Hefty Jack Flipper","CNNId":"","myGameChains":null,"banStatus":null},"id":18406454,"name":"Iron Assault Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hefty/Jack/Flipper/18406454.jpg","createDate":{"time":1352246305000,"minutes":58,"seconds":25,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hefty/Jack/Flipper/18406454.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1371,"difficulty":2.3000000000000003,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4153,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.316071,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stunning Donald Polliwog","authId":"","name":"Stunning Donald Polliwog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stunning Donald Polliwog","authId":"","name":"Stunning Donald Polliwog","CNNId":"","myGameChains":null,"banStatus":null},"id":18127806,"name":"Light Gravattack Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stunning/Donald/Polliwog/18127806.jpg","createDate":{"time":1350158753000,"minutes":5,"seconds":53,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stunning/Donald/Polliwog/18127806.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1922,"difficulty":2.730021774791788,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14786,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.303751,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Rapunzel Pumpkin","authId":"","name":"Haunted Rapunzel Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Rapunzel Pumpkin","authId":"","name":"Haunted Rapunzel Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"id":17542501,"name":"Lightning Assault Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Haunted/Rapunzel/Pumpkin/17542501.jpg","createDate":{"time":1348149614000,"minutes":0,"seconds":14,"hours":10,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Haunted/Rapunzel/Pumpkin/17542501.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2385,"difficulty":2.08258776253988,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2880,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.301706,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Dexter Vitamin","authId":"","name":"Odd Dexter Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Dexter Vitamin","authId":"","name":"Odd Dexter Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"id":19606130,"name":"Cosmic Patrol Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Odd/Dexter/Vitamin/19606130.jpg","createDate":{"time":1361896099000,"minutes":28,"seconds":19,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Odd/Dexter/Vitamin/19606130.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1591,"difficulty":2.3153827751196174,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2740,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.294082,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Thomas Wallop","authId":"","name":"Immortal Thomas Wallop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Thomas Wallop","authId":"","name":"Immortal Thomas Wallop","CNNId":"","myGameChains":null,"banStatus":null},"id":19421420,"name":"Quake Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Thomas/Wallop/19421420.jpg","createDate":{"time":1358775426000,"minutes":37,"seconds":6,"hours":8,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Thomas/Wallop/19421420.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1759,"difficulty":2.0474109224109225,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4306,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.293796,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Ben Gamer","authId":"","name":"Extreme Ben Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Ben Gamer","authId":"","name":"Extreme Ben Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":19391493,"name":"Adventure Alien Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Ben/Gamer/19391493.jpg","createDate":{"time":1358335508000,"minutes":25,"seconds":8,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Ben/Gamer/19391493.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9565,"difficulty":2.3141598923475724,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59684,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.282122,"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 = '12' 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"}}]