[{"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 = '4' 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":"Evil Evan Smidgen","authId":"","name":"Evil Evan Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Evan Smidgen","authId":"","name":"Evil Evan Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"id":18256902,"name":"Smash Ambush Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Evan/Smidgen/18256902.jpg","createDate":{"time":1351115265000,"minutes":47,"seconds":45,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Evan/Smidgen/18256902.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3996,"difficulty":1.1453488613471452,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4496,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.915298,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Drowzy Aaron Fizz","authId":"","name":"Drowzy Aaron Fizz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Drowzy Aaron Fizz","authId":"","name":"Drowzy Aaron Fizz","CNNId":"","myGameChains":null,"banStatus":null},"id":19967791,"name":"Clash Nano Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Drowzy/Aaron/Fizz/19967791.jpg","createDate":{"time":1364648211000,"minutes":56,"seconds":51,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Drowzy/Aaron/Fizz/19967791.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4932,"difficulty":2.4396492098593137,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9410,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.898142,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Ben Blizzard","authId":"","name":"Creative Ben Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Ben Blizzard","authId":"","name":"Creative Ben Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":19395614,"name":"Vilgax Ambush Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Ben/Blizzard/19395614.jpg","createDate":{"time":1358407070000,"minutes":17,"seconds":50,"hours":2,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Ben/Blizzard/19395614.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4143,"difficulty":2.195372600791081,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":60230,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.873066,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Russell Burro","authId":"","name":"Frugal Russell Burro","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Russell Burro","authId":"","name":"Frugal Russell Burro","CNNId":"","myGameChains":null,"banStatus":null},"id":17530602,"name":"Danger Ultra Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Russell/Burro/17530602.jpg","createDate":{"time":1348100924000,"minutes":28,"seconds":44,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Russell/Burro/17530602.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":319,"difficulty":1.8333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1023,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.857143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Christy Cartoon","authId":"","name":"Loud Christy Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Christy Cartoon","authId":"","name":"Loud Christy Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18089310,"name":"Shock Warp Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Christy/Cartoon/18089310.jpg","createDate":{"time":1349980023000,"minutes":27,"seconds":3,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Christy/Cartoon/18089310.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5330,"difficulty":2.3958301792588923,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13318,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.845637,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome CJ Galaxy","authId":"","name":"Awesome CJ Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome CJ Galaxy","authId":"","name":"Awesome CJ Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"id":19498322,"name":"Rescue Echo Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/CJ/Galaxy/19498322.jpg","createDate":{"time":1360103907000,"minutes":38,"seconds":27,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/CJ/Galaxy/19498322.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12441,"difficulty":1.889048661020803,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65601,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.844754,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble John Vulture","authId":"","name":"Humble John Vulture","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble John Vulture","authId":"","name":"Humble John Vulture","CNNId":"","myGameChains":null,"banStatus":null},"id":18392449,"name":"Lightning Force Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humble/John/Vulture/18392449.jpg","createDate":{"time":1352123454000,"minutes":50,"seconds":54,"hours":8,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humble/John/Vulture/18392449.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8969,"difficulty":2.397003413504956,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31960,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.837325,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Mordecai Figment","authId":"","name":"Regal Mordecai Figment","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Mordecai Figment","authId":"","name":"Regal Mordecai Figment","CNNId":"","myGameChains":null,"banStatus":null},"id":19825772,"name":"Hex Droid Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regal/Mordecai/Figment/19825772.jpg","createDate":{"time":1363654604000,"minutes":56,"seconds":44,"hours":20,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regal/Mordecai/Figment/19825772.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5151,"difficulty":2.0529235210693475,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":77666,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.809524,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Kate Yodel","authId":"","name":"Hefty Kate Yodel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Kate Yodel","authId":"","name":"Hefty Kate Yodel","CNNId":"","myGameChains":null,"banStatus":null},"id":17687340,"name":"Stone Pursuit Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hefty/Kate/Yodel/17687340.jpg","createDate":{"time":1348391539000,"minutes":12,"seconds":19,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hefty/Kate/Yodel/17687340.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2117,"difficulty":1.2269059644059643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3077,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.805812,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Devious Trevor Bingo","authId":"","name":"Devious Trevor Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Devious Trevor Bingo","authId":"","name":"Devious Trevor Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":19638666,"name":"Adventure Big Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Devious/Trevor/Bingo/19638666.jpg","createDate":{"time":1362607384000,"minutes":3,"seconds":4,"hours":17,"month":2,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Devious/Trevor/Bingo/19638666.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1582,"difficulty":2.19861051627387,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2430,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.735675,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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 = '4' 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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]