[{"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 = '16' 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":"Spotted Aaron Coconut","authId":"","name":"Spotted Aaron Coconut","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spotted Aaron Coconut","authId":"","name":"Spotted Aaron Coconut","CNNId":"","myGameChains":null,"banStatus":null},"id":19752157,"name":"Adventure Kickin' Hawk Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spotted/Aaron/Coconut/19752157.jpg","createDate":{"time":1363392056000,"minutes":0,"seconds":56,"hours":20,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spotted/Aaron/Coconut/19752157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27161,"difficulty":2.401068000957487,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":193455,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.355238,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Vince Cyclone","authId":"","name":"Captain Vince Cyclone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Vince Cyclone","authId":"","name":"Captain Vince Cyclone","CNNId":"","myGameChains":null,"banStatus":null},"id":19981144,"name":"Kickin' Hawk Adventure Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Vince/Cyclone/19981144.jpg","createDate":{"time":1364736685000,"minutes":31,"seconds":25,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Vince/Cyclone/19981144.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8401,"difficulty":2.084446232984812,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":94320,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.353814,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Nelson Steam","authId":"","name":"Reckless Nelson Steam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Nelson Steam","authId":"","name":"Reckless Nelson Steam","CNNId":"","myGameChains":null,"banStatus":null},"id":19707531,"name":"Sonic Alien Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Nelson/Steam/19707531.jpg","createDate":{"time":1363196752000,"minutes":45,"seconds":52,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Nelson/Steam/19707531.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":382,"difficulty":2.3683035714285716,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1489,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.34966,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Dexter Venom","authId":"","name":"Amazing Dexter Venom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Dexter Venom","authId":"","name":"Amazing Dexter Venom","CNNId":"","myGameChains":null,"banStatus":null},"id":19691643,"name":"Danger Adventure Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Dexter/Venom/19691643.jpg","createDate":{"time":1363122192000,"minutes":3,"seconds":12,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Dexter/Venom/19691643.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7209,"difficulty":2.572881561922371,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18877,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.343904,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Matt Rumble","authId":"","name":"Massive Matt Rumble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Matt Rumble","authId":"","name":"Massive Matt Rumble","CNNId":"","myGameChains":null,"banStatus":null},"id":19760126,"name":"Earth Star Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Massive/Matt/Rumble/19760126.jpg","createDate":{"time":1363435036000,"minutes":57,"seconds":16,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Massive/Matt/Rumble/19760126.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153,"difficulty":2.5862258953168045,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2862,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.336473,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Rick Brick","authId":"","name":"Grizzly Rick Brick","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Rick Brick","authId":"","name":"Grizzly Rick Brick","CNNId":"","myGameChains":null,"banStatus":null},"id":19671511,"name":"Shadow Clash Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Rick/Brick/19671511.jpg","createDate":{"time":1363040664000,"minutes":24,"seconds":24,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Rick/Brick/19671511.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":109,"difficulty":2.4286324786324784,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1330,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.315541,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Alvin Monster","authId":"","name":"Jumping Alvin Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Alvin Monster","authId":"","name":"Jumping Alvin Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":19721085,"name":"Adventure Storm Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jumping/Alvin/Monster/19721085.jpg","createDate":{"time":1363259164000,"minutes":6,"seconds":4,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jumping/Alvin/Monster/19721085.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4527,"difficulty":2.504119970271278,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9961,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.305377,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Egbert Scribble","authId":"","name":"Kinetic Egbert Scribble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Egbert Scribble","authId":"","name":"Kinetic Egbert Scribble","CNNId":"","myGameChains":null,"banStatus":null},"id":19682117,"name":"Ultimate Nitro Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Egbert/Scribble/19682117.jpg","createDate":{"time":1363091394000,"minutes":29,"seconds":54,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Egbert/Scribble/19682117.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":563,"difficulty":1.5478400072150071,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2532,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.294118,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Wilbur Shock","authId":"","name":"Mumbling Wilbur Shock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Wilbur Shock","authId":"","name":"Mumbling Wilbur Shock","CNNId":"","myGameChains":null,"banStatus":null},"id":19707511,"name":"Universe Ben Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mumbling/Wilbur/Shock/19707511.jpg","createDate":{"time":1363196652000,"minutes":44,"seconds":12,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mumbling/Wilbur/Shock/19707511.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26191,"difficulty":2.188096678449555,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43134,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.28391,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Adept Robby Crater","authId":"","name":"Adept Robby Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Adept Robby Crater","authId":"","name":"Adept Robby Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":19684766,"name":"Ultra Light Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Adept/Robby/Crater/19684766.jpg","createDate":{"time":1363103156000,"minutes":45,"seconds":56,"hours":11,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Adept/Robby/Crater/19684766.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":126,"difficulty":2.5809523809523807,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1062,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.266667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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 = '16' 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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]