[{"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 = '15' 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":"Edgy Nicolas Mustard","authId":"","name":"Edgy Nicolas Mustard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Nicolas Mustard","authId":"","name":"Edgy Nicolas Mustard","CNNId":"","myGameChains":null,"banStatus":null},"id":19861080,"name":"Animo Titan Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Nicolas/Mustard/19861080.jpg","createDate":{"time":1363957673000,"minutes":7,"seconds":53,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Nicolas/Mustard/19861080.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2932,"difficulty":2.653126285479227,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4435,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.598049,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Flapjack Pirate","authId":"","name":"Captain Flapjack Pirate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Flapjack Pirate","authId":"","name":"Captain Flapjack Pirate","CNNId":"","myGameChains":null,"banStatus":null},"id":19760149,"name":"Rook Turbo Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Flapjack/Pirate/19760149.jpg","createDate":{"time":1363435106000,"minutes":58,"seconds":26,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Flapjack/Pirate/19760149.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2091,"difficulty":2.6730403960939935,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17274,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.592987,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Gus Polka","authId":"","name":"Quirky Gus Polka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Gus Polka","authId":"","name":"Quirky Gus Polka","CNNId":"","myGameChains":null,"banStatus":null},"id":19760166,"name":"Water Big Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Gus/Polka/19760166.jpg","createDate":{"time":1363435180000,"minutes":59,"seconds":40,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Gus/Polka/19760166.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2154,"difficulty":2.2258064216460367,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6623,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.590771,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Joel Venus","authId":"","name":"Elegant Joel Venus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Joel Venus","authId":"","name":"Elegant Joel Venus","CNNId":"","myGameChains":null,"banStatus":null},"id":19667334,"name":"Adventure Alien Rook","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elegant/Joel/Venus/19667334.jpg","createDate":{"time":1363032392000,"minutes":6,"seconds":32,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elegant/Joel/Venus/19667334.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":155,"difficulty":2.881597035443189,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":968,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.589351,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Ted Blast","authId":"","name":"Awesome Ted Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Ted Blast","authId":"","name":"Awesome Ted Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":19680424,"name":"Plasma Nano Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Ted/Blast/19680424.jpg","createDate":{"time":1363073527000,"minutes":32,"seconds":7,"hours":3,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Ted/Blast/19680424.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2045,"difficulty":2.528328827911911,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13557,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.574666,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Joel Fiddle","authId":"","name":"Sturdy Joel Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Joel Fiddle","authId":"","name":"Sturdy Joel Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"id":19661133,"name":"Mission Clash Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Joel/Fiddle/19661133.jpg","createDate":{"time":1363011246000,"minutes":14,"seconds":6,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Joel/Fiddle/19661133.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7263,"difficulty":2.526425512124225,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22199,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.572186,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Melvin Flamingo","authId":"","name":"Superior Melvin Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Melvin Flamingo","authId":"","name":"Superior Melvin Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"id":19681463,"name":"Rook Ultimate Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superior/Melvin/Flamingo/19681463.jpg","createDate":{"time":1363087290000,"minutes":21,"seconds":30,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superior/Melvin/Flamingo/19681463.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":208,"difficulty":1.5983245149911818,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":935,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.56875,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Bert Hippo","authId":"","name":"Ancient Bert Hippo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Bert Hippo","authId":"","name":"Ancient Bert Hippo","CNNId":"","myGameChains":null,"banStatus":null},"id":19840863,"name":"Techno Target Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Bert/Hippo/19840863.jpg","createDate":{"time":1363788752000,"minutes":12,"seconds":32,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Bert/Hippo/19840863.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":295,"difficulty":1.6481481481481481,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1210,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.567901,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Hugo Tiger","authId":"","name":"Unknown Hugo Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Hugo Tiger","authId":"","name":"Unknown Hugo Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19707383,"name":"Plumber Gear Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Hugo/Tiger/19707383.jpg","createDate":{"time":1363196257000,"minutes":37,"seconds":37,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Hugo/Tiger/19707383.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":613,"difficulty":2.7511136860497905,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4737,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.566876,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Knight","authId":"","name":"Fearless Knight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Knight","authId":"","name":"Fearless Knight","CNNId":"","myGameChains":null,"banStatus":null},"id":19680317,"name":"Dark Warrior Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Knight/19680317.jpg","createDate":{"time":1363070698000,"minutes":44,"seconds":58,"hours":2,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Knight/19680317.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":231,"difficulty":2.590302432610125,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3792,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.566329,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"61","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 = '15' 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":"70","currentPageToDisplay":7,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]