[{"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 = '12' 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":"General Blake Brute","authId":"","name":"General Blake Brute","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Blake Brute","authId":"","name":"General Blake Brute","CNNId":"","myGameChains":null,"banStatus":null},"id":17793418,"name":"Nitro Razor Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Blake/Brute/17793418.jpg","createDate":{"time":1348720065000,"minutes":27,"seconds":45,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Blake/Brute/17793418.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":438,"difficulty":2.4086580086580085,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3400,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.708995,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Gladys Nanobot","authId":"","name":"Frugal Gladys Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Gladys Nanobot","authId":"","name":"Frugal Gladys Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"id":18409240,"name":"Adventure Magno Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Gladys/Nanobot/18409240.jpg","createDate":{"time":1352282319000,"minutes":58,"seconds":39,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Gladys/Nanobot/18409240.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10111,"difficulty":1.1695829467418866,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21922,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.671749,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Mac Buffalo","authId":"","name":"Wacky Mac Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Mac Buffalo","authId":"","name":"Wacky Mac Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":19347478,"name":"Alien Danger Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Mac/Buffalo/19347478.jpg","createDate":{"time":1357680868000,"minutes":34,"seconds":28,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Mac/Buffalo/19347478.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4617,"difficulty":2.434710743801653,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5188,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.658508,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Conrad Atlas","authId":"","name":"Strong Conrad Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Conrad Atlas","authId":"","name":"Strong Conrad Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":18227048,"name":"Plasma Nano Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Conrad/Atlas/18227048.jpg","createDate":{"time":1350828601000,"minutes":10,"seconds":1,"hours":10,"month":9,"timezoneOffset":240,"year":112,"day":0,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Conrad/Atlas/18227048.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1726,"difficulty":2.227777777777778,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3260,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.650476,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Brittany Seesaw","authId":"","name":"Baroness Brittany Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Brittany Seesaw","authId":"","name":"Baroness Brittany Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18170681,"name":"Storm Razor Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Brittany/Seesaw/18170681.jpg","createDate":{"time":1350380395000,"minutes":39,"seconds":55,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Brittany/Seesaw/18170681.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":986,"difficulty":1.2835497835497836,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2866,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.639737,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ornery Jesse Bayou","authId":"","name":"Ornery Jesse Bayou","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ornery Jesse Bayou","authId":"","name":"Ornery Jesse Bayou","CNNId":"","myGameChains":null,"banStatus":null},"id":17541838,"name":"Shock Pursuit Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ornery/Jesse/Bayou/17541838.jpg","createDate":{"time":1348147513000,"minutes":25,"seconds":13,"hours":9,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ornery/Jesse/Bayou/17541838.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":471,"difficulty":2.6496805663472327,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3427,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.639456,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Gage Aardvark","authId":"","name":"Athletic Gage Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Gage Aardvark","authId":"","name":"Athletic Gage Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":17546718,"name":"Fury Solar Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Gage/Aardvark/17546718.jpg","createDate":{"time":1348161902000,"minutes":25,"seconds":2,"hours":13,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Gage/Aardvark/17546718.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3253,"difficulty":2.100150057550454,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6139,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.638329,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Mike Kook","authId":"","name":"Stormy Mike Kook","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Mike Kook","authId":"","name":"Stormy Mike Kook","CNNId":"","myGameChains":null,"banStatus":null},"id":18116444,"name":"Defense Nitro Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stormy/Mike/Kook/18116444.jpg","createDate":{"time":1350129275000,"minutes":54,"seconds":35,"hours":7,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stormy/Mike/Kook/18116444.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27116,"difficulty":1.7894873660214716,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":111790,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":3.631776,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Napoleon Sphere","authId":"","name":"Western Napoleon Sphere","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Napoleon Sphere","authId":"","name":"Western Napoleon Sphere","CNNId":"","myGameChains":null,"banStatus":null},"id":17553210,"name":"Omniverse Adventure Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Napoleon/Sphere/17553210.jpg","createDate":{"time":1348175903000,"minutes":18,"seconds":23,"hours":17,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Napoleon/Sphere/17553210.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1697,"difficulty":1.18376384644767,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2915,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.631019,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cosmic Travis Banjo","authId":"","name":"Cosmic Travis Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cosmic Travis Banjo","authId":"","name":"Cosmic Travis Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":17423242,"name":"Atomic Chill Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cosmic/Travis/Banjo/17423242.jpg","createDate":{"time":1347894005000,"minutes":0,"seconds":5,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cosmic/Travis/Banjo/17423242.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52397,"difficulty":1.3487848343772786,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":278839,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.62602,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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 = '12' 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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]