[{"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 = '9' 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":"Genuine Aaron Trapeze","authId":"","name":"Genuine Aaron Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Aaron Trapeze","authId":"","name":"Genuine Aaron Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"id":19505449,"name":"Battle Techno Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Genuine/Aaron/Trapeze/19505449.jpg","createDate":{"time":1360270988000,"minutes":3,"seconds":8,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Genuine/Aaron/Trapeze/19505449.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":548,"difficulty":2.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":706,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Avery Aviator","authId":"","name":"Admiral Avery Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Avery Aviator","authId":"","name":"Admiral Avery Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":19126923,"name":"Attack Thunder Solar","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Avery/Aviator/19126923.jpg","createDate":{"time":1356193892000,"minutes":31,"seconds":32,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Avery/Aviator/19126923.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":247,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":724,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Antonio Karate","authId":"","name":"Academic Antonio Karate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Antonio Karate","authId":"","name":"Academic Antonio Karate","CNNId":"","myGameChains":null,"banStatus":null},"id":18486826,"name":"Laser Nova Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Antonio/Karate/18486826.jpg","createDate":{"time":1353009890000,"minutes":4,"seconds":50,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Antonio/Karate/18486826.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2090,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.958333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Alex Thud","authId":"","name":"Rowdy Alex Thud","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Alex Thud","authId":"","name":"Rowdy Alex Thud","CNNId":"","myGameChains":null,"banStatus":null},"id":18287525,"name":"Clash Space Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rowdy/Alex/Thud/18287525.jpg","createDate":{"time":1351358008000,"minutes":13,"seconds":28,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rowdy/Alex/Thud/18287525.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1846,"difficulty":1.406706114398422,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1907,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.837681,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Franklin Saturn","authId":"","name":"Infamous Franklin Saturn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Franklin Saturn","authId":"","name":"Infamous Franklin Saturn","CNNId":"","myGameChains":null,"banStatus":null},"id":17813344,"name":"Pulse Rocket Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infamous/Franklin/Saturn/17813344.jpg","createDate":{"time":1348832650000,"minutes":44,"seconds":10,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infamous/Franklin/Saturn/17813344.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4251,"difficulty":1.408674278183764,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4676,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.548041,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rational Devin Licorice","authId":"","name":"Rational Devin Licorice","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rational Devin Licorice","authId":"","name":"Rational Devin Licorice","CNNId":"","myGameChains":null,"banStatus":null},"id":19436768,"name":"Storm Alien Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rational/Devin/Licorice/19436768.jpg","createDate":{"time":1359029728000,"minutes":15,"seconds":28,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rational/Devin/Licorice/19436768.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":277,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":688,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Major Matt Dinosaur","authId":"","name":"Major Matt Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Major Matt Dinosaur","authId":"","name":"Major Matt Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":17687193,"name":"Patrol Storm Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Major/Matt/Dinosaur/17687193.jpg","createDate":{"time":1348390948000,"minutes":2,"seconds":28,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Major/Matt/Dinosaur/17687193.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":878,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Lloyd Cosmos","authId":"","name":"Stealthy Lloyd Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Lloyd Cosmos","authId":"","name":"Stealthy Lloyd Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":17955940,"name":"Burst Techno Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stealthy/Lloyd/Cosmos/17955940.jpg","createDate":{"time":1349364818000,"minutes":33,"seconds":38,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stealthy/Lloyd/Cosmos/17955940.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":860,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Egbert Glop","authId":"","name":"Doctor Egbert Glop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Egbert Glop","authId":"","name":"Doctor Egbert Glop","CNNId":"","myGameChains":null,"banStatus":null},"id":18427437,"name":"Razor Siege Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Egbert/Glop/18427437.jpg","createDate":{"time":1352497869000,"minutes":51,"seconds":9,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Egbert/Glop/18427437.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":206,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"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":18089078,"name":"Burst Force Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Christy/Cartoon/18089078.jpg","createDate":{"time":1349978606000,"minutes":3,"seconds":26,"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/18089078.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1578,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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 = '9' 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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]