[{"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 = '14' 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":"Sleepy Charles Gremlin","authId":"","name":"Sleepy Charles Gremlin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Charles Gremlin","authId":"","name":"Sleepy Charles Gremlin","CNNId":"","myGameChains":null,"banStatus":null},"id":18522170,"name":"Fusion Force Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleepy/Charles/Gremlin/18522170.jpg","createDate":{"time":1353363941000,"minutes":25,"seconds":41,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleepy/Charles/Gremlin/18522170.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3315,"difficulty":2.2971156256031673,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14187,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.792596,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Patrick Banjo","authId":"","name":"Witty Patrick Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Patrick Banjo","authId":"","name":"Witty Patrick Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":18707638,"name":"Titan Lightning Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Witty/Patrick/Banjo/18707638.jpg","createDate":{"time":1354658490000,"minutes":1,"seconds":30,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Witty/Patrick/Banjo/18707638.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13152,"difficulty":2.7042071540610984,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43119,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.782743,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Benjamin Zinger","authId":"","name":"Zany Benjamin Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Benjamin Zinger","authId":"","name":"Zany Benjamin Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":18523207,"name":"Crusher Water Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Benjamin/Zinger/18523207.jpg","createDate":{"time":1353369981000,"minutes":6,"seconds":21,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Benjamin/Zinger/18523207.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3285,"difficulty":2.1246618247082933,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11899,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.782678,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Poseidon Wolf","authId":"","name":"Aquatic Poseidon Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Poseidon Wolf","authId":"","name":"Aquatic Poseidon Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":19568716,"name":"Alien Atomic Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aquatic/Poseidon/Wolf/19568716.jpg","createDate":{"time":1361239548000,"minutes":5,"seconds":48,"hours":21,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aquatic/Poseidon/Wolf/19568716.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4417,"difficulty":1.699485263284189,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":35787,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.77459,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Minerva Zing","authId":"","name":"Active Minerva Zing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Minerva Zing","authId":"","name":"Active Minerva Zing","CNNId":"","myGameChains":null,"banStatus":null},"id":19112118,"name":"Burst Light Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Minerva/Zing/19112118.jpg","createDate":{"time":1356124766000,"minutes":19,"seconds":26,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Minerva/Zing/19112118.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7835,"difficulty":1.8874349886919952,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":79823,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.759053,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Danny Buffalo","authId":"","name":"Colonel Danny Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Danny Buffalo","authId":"","name":"Colonel Danny Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":18525939,"name":"BallWeevil Adventure Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Danny/Buffalo/18525939.jpg","createDate":{"time":1353415877000,"minutes":51,"seconds":17,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Danny/Buffalo/18525939.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1399,"difficulty":2.840918381455872,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":148594,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.758811,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Beth Parallax","authId":"","name":"Virtual Beth Parallax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Beth Parallax","authId":"","name":"Virtual Beth Parallax","CNNId":"","myGameChains":null,"banStatus":null},"id":18783645,"name":"Robot Alien Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Virtual/Beth/Parallax/18783645.jpg","createDate":{"time":1354913216000,"minutes":46,"seconds":56,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Virtual/Beth/Parallax/18783645.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6633,"difficulty":2.592311175884406,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22419,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.752518,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Lloyd Moonbeam","authId":"","name":"Epic Lloyd Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Lloyd Moonbeam","authId":"","name":"Epic Lloyd Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"id":18963097,"name":"Chill Adventure Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Lloyd/Moonbeam/18963097.jpg","createDate":{"time":1355409418000,"minutes":36,"seconds":58,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Lloyd/Moonbeam/18963097.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5167,"difficulty":1.8148448662215637,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17793,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.748854,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Joe Beeswax","authId":"","name":"Icy Joe Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Joe Beeswax","authId":"","name":"Icy Joe Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"id":19497242,"name":"Sonic Cosmic Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Joe/Beeswax/19497242.jpg","createDate":{"time":1360088537000,"minutes":22,"seconds":17,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Joe/Beeswax/19497242.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2819,"difficulty":2.5531467617994292,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36332,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.74857,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Bert Lizard","authId":"","name":"Haunted Bert Lizard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Bert Lizard","authId":"","name":"Haunted Bert Lizard","CNNId":"","myGameChains":null,"banStatus":null},"id":18613822,"name":"Dark Big Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Haunted/Bert/Lizard/18613822.jpg","createDate":{"time":1353966888000,"minutes":54,"seconds":48,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Haunted/Bert/Lizard/18613822.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2448,"difficulty":2.702306189313472,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12660,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.748509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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 = '14' 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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]