[{"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 = '8' 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":"Ruthless Trevor Iguana","authId":"","name":"Ruthless Trevor Iguana","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Trevor Iguana","authId":"","name":"Ruthless Trevor Iguana","CNNId":"","myGameChains":null,"banStatus":null},"id":19468440,"name":"Energy Big Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Trevor/Iguana/19468440.jpg","createDate":{"time":1359539290000,"minutes":48,"seconds":10,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Trevor/Iguana/19468440.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":618,"difficulty":1.8,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2123,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Crystal Snake","authId":"","name":"Admiral Crystal Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Crystal Snake","authId":"","name":"Admiral Crystal Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":18170157,"name":"Techno Titan Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Crystal/Snake/18170157.jpg","createDate":{"time":1350361015000,"minutes":16,"seconds":55,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Crystal/Snake/18170157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":102,"difficulty":2.672222222222222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2134,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Cindy Wingding","authId":"","name":"Agile Cindy Wingding","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Cindy Wingding","authId":"","name":"Agile Cindy Wingding","CNNId":"","myGameChains":null,"banStatus":null},"id":18617839,"name":"Warp Challenge Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Agile/Cindy/Wingding/18617839.jpg","createDate":{"time":1354012705000,"minutes":38,"seconds":25,"hours":5,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Agile/Cindy/Wingding/18617839.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6375,"difficulty":2.3566978306092348,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9485,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.325793,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Franklin Bronco","authId":"","name":"Evil Franklin Bronco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Franklin Bronco","authId":"","name":"Evil Franklin Bronco","CNNId":"","myGameChains":null,"banStatus":null},"id":17216264,"name":"Plasma Clash Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Franklin/Bronco/17216264.jpg","createDate":{"time":1342173771000,"minutes":2,"seconds":51,"hours":6,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Franklin/Bronco/17216264.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2455,"difficulty":2.257637006975381,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10193,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.321978,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Tanner Umbrella","authId":"","name":"Amusing Tanner Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Tanner Umbrella","authId":"","name":"Amusing Tanner Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"id":19461408,"name":"Cannonbolt Ultimate Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amusing/Tanner/Umbrella/19461408.jpg","createDate":{"time":1359374249000,"minutes":57,"seconds":29,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amusing/Tanner/Umbrella/19461408.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":832,"difficulty":2.2450351084322375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7047,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.28386,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Zeke Popcorn","authId":"","name":"Cagey Zeke Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Zeke Popcorn","authId":"","name":"Cagey Zeke Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"id":17793464,"name":"Chase Adventure Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cagey/Zeke/Popcorn/17793464.jpg","createDate":{"time":1348720990000,"minutes":43,"seconds":10,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cagey/Zeke/Popcorn/17793464.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5943,"difficulty":1.5077214228559586,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26643,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.27434,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Horatio Forklift","authId":"","name":"Crazy Horatio Forklift","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Horatio Forklift","authId":"","name":"Crazy Horatio Forklift","CNNId":"","myGameChains":null,"banStatus":null},"id":17216531,"name":"Search Storm Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Horatio/Forklift/17216531.jpg","createDate":{"time":1342183949000,"minutes":52,"seconds":29,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Horatio/Forklift/17216531.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5262,"difficulty":1.5520825446901896,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":92302,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":37,"rating":4.255694,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Bucky Pirate","authId":"","name":"Luminous Bucky Pirate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Bucky Pirate","authId":"","name":"Luminous Bucky Pirate","CNNId":"","myGameChains":null,"banStatus":null},"id":19480727,"name":"Robot Star Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Luminous/Bucky/Pirate/19480727.jpg","createDate":{"time":1359811941000,"minutes":32,"seconds":21,"hours":8,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Luminous/Bucky/Pirate/19480727.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1956,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2218,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Jillian Ballyhoo","authId":"","name":"Babbling Jillian Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Jillian Ballyhoo","authId":"","name":"Babbling Jillian Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"id":18287642,"name":"Ultimate Cannonbolt Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Jillian/Ballyhoo/18287642.jpg","createDate":{"time":1351358425000,"minutes":20,"seconds":25,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Jillian/Ballyhoo/18287642.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2626,"difficulty":1.7092018832399283,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7393,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.235844,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Rachel Samurai","authId":"","name":"Eager Rachel Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Rachel Samurai","authId":"","name":"Eager Rachel Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":18106436,"name":"Big Iron Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eager/Rachel/Samurai/18106436.jpg","createDate":{"time":1350078332000,"minutes":45,"seconds":32,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eager/Rachel/Samurai/18106436.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":648,"difficulty":2.1723809523809523,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2451,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.233929,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '8' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]