[{"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 = '7' 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":"Orange Samuel Biscuit","authId":"","name":"Orange Samuel Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Samuel Biscuit","authId":"","name":"Orange Samuel Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"id":19721256,"name":"Burst Racer Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Orange/Samuel/Biscuit/19721256.jpg","createDate":{"time":1363260644000,"minutes":30,"seconds":44,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Orange/Samuel/Biscuit/19721256.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":289,"difficulty":2.7291666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":420,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.458503,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dainty Greg Hawk","authId":"","name":"Dainty Greg Hawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dainty Greg Hawk","authId":"","name":"Dainty Greg Hawk","CNNId":"","myGameChains":null,"banStatus":null},"id":17813229,"name":"Metal Hyper Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dainty/Greg/Hawk/17813229.jpg","createDate":{"time":1348831985000,"minutes":33,"seconds":5,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dainty/Greg/Hawk/17813229.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":523,"difficulty":1.4979591836734694,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":900,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.452778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Leo Domino","authId":"","name":"Captain Leo Domino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Leo Domino","authId":"","name":"Captain Leo Domino","CNNId":"","myGameChains":null,"banStatus":null},"id":18207134,"name":"Solar Galaxy Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Leo/Domino/18207134.jpg","createDate":{"time":1350723258000,"minutes":54,"seconds":18,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Leo/Domino/18207134.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":49,"difficulty":1.6666666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":759,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.444444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Adrian Concrete","authId":"","name":"Reckless Adrian Concrete","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Adrian Concrete","authId":"","name":"Reckless Adrian Concrete","CNNId":"","myGameChains":null,"banStatus":null},"id":19395966,"name":"Light Escape Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Adrian/Concrete/19395966.jpg","createDate":{"time":1358422297000,"minutes":31,"seconds":37,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Adrian/Concrete/19395966.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1103,"difficulty":1.6666666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1427,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.28,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Ben Wolf","authId":"","name":"Curious Ben Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Ben Wolf","authId":"","name":"Curious Ben Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":17755486,"name":"Adventure Smash Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Ben/Wolf/17755486.jpg","createDate":{"time":1348541773000,"minutes":56,"seconds":13,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Ben/Wolf/17755486.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":310,"difficulty":1.4,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1121,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.270833,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Jeff Thorax","authId":"","name":"Amazing Jeff Thorax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Jeff Thorax","authId":"","name":"Amazing Jeff Thorax","CNNId":"","myGameChains":null,"banStatus":null},"id":17216433,"name":"Champion Dark Nitro","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Jeff/Thorax/17216433.jpg","createDate":{"time":1342181124000,"minutes":5,"seconds":24,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Jeff/Thorax/17216433.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":932,"difficulty":1.35,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2054,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.240103,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eloquent Steven Vitamin","authId":"","name":"Eloquent Steven Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eloquent Steven Vitamin","authId":"","name":"Eloquent Steven Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"id":17942357,"name":"Hero Breaker Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eloquent/Steven/Vitamin/17942357.jpg","createDate":{"time":1349269170000,"minutes":59,"seconds":30,"hours":8,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eloquent/Steven/Vitamin/17942357.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":124093,"difficulty":1.6556486079464097,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":135488,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.203872,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smart Wes Whisper","authId":"","name":"Smart Wes Whisper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smart Wes Whisper","authId":"","name":"Smart Wes Whisper","CNNId":"","myGameChains":null,"banStatus":null},"id":17216182,"name":"Doom Magno Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smart/Wes/Whisper/17216182.jpg","createDate":{"time":1342168745000,"minutes":39,"seconds":5,"hours":4,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smart/Wes/Whisper/17216182.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":586,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":698,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Kristin Wallop","authId":"","name":"Athletic Kristin Wallop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Kristin Wallop","authId":"","name":"Athletic Kristin Wallop","CNNId":"","myGameChains":null,"banStatus":null},"id":19488962,"name":"Galaxy Rush Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Kristin/Wallop/19488962.jpg","createDate":{"time":1359914879000,"minutes":7,"seconds":59,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Kristin/Wallop/19488962.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":202,"difficulty":1.625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":832,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.104167,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Northern Savannah Parsec","authId":"","name":"Northern Savannah Parsec","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Northern Savannah Parsec","authId":"","name":"Northern Savannah Parsec","CNNId":"","myGameChains":null,"banStatus":null},"id":17784386,"name":"Star Cosmic Humungousaur","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Northern/Savannah/Parsec/17784386.jpg","createDate":{"time":1348692799000,"minutes":53,"seconds":19,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Northern/Savannah/Parsec/17784386.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":152,"difficulty":2.7916666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":413,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.083333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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 = '7' 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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]