[{"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 = '3' 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":"Doctor Nathan Octopus","authId":"","name":"Doctor Nathan Octopus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Nathan Octopus","authId":"","name":"Doctor Nathan Octopus","CNNId":"","myGameChains":null,"banStatus":null},"id":19643454,"name":"Dark Mission Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Nathan/Octopus/19643454.jpg","createDate":{"time":1362746939000,"minutes":48,"seconds":59,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":5,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Nathan/Octopus/19643454.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2260,"difficulty":2.470227393147078,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15498,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.446607,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Shaggy Phoenix","authId":"","name":"Crazy Shaggy Phoenix","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Shaggy Phoenix","authId":"","name":"Crazy Shaggy Phoenix","CNNId":"","myGameChains":null,"banStatus":null},"id":19707549,"name":"Laser Warrior Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Shaggy/Phoenix/19707549.jpg","createDate":{"time":1363196834000,"minutes":47,"seconds":14,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Shaggy/Phoenix/19707549.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2328,"difficulty":2.344247218868054,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4674,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.445338,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Skips Nova","authId":"","name":"Kinetic Skips Nova","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Skips Nova","authId":"","name":"Kinetic Skips Nova","CNNId":"","myGameChains":null,"banStatus":null},"id":18097913,"name":"Ben Titan Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Skips/Nova/18097913.jpg","createDate":{"time":1350031015000,"minutes":36,"seconds":55,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Skips/Nova/18097913.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":66,"difficulty":2.7666666666666666,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2268,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.436607,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Andrew Yam","authId":"","name":"Cartoony Andrew Yam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Andrew Yam","authId":"","name":"Cartoony Andrew Yam","CNNId":"","myGameChains":null,"banStatus":null},"id":18003899,"name":"Battle Jetray Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cartoony/Andrew/Yam/18003899.jpg","createDate":{"time":1349552434000,"minutes":40,"seconds":34,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cartoony/Andrew/Yam/18003899.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1039,"difficulty":1.5046176046176045,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1249,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.425432,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Arthur Fox","authId":"","name":"Shiny Arthur Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Arthur Fox","authId":"","name":"Shiny Arthur Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":17216075,"name":"Animo Storm Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Arthur/Fox/17216075.jpg","createDate":{"time":1342162126000,"minutes":48,"seconds":46,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Arthur/Fox/17216075.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2414,"difficulty":2.1836177017842187,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6721,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.42071,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty CJ Vector","authId":"","name":"Sporty CJ Vector","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty CJ Vector","authId":"","name":"Sporty CJ Vector","CNNId":"","myGameChains":null,"banStatus":null},"id":19638373,"name":"Smash Rush Jetray","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sporty/CJ/Vector/19638373.jpg","createDate":{"time":1362603005000,"minutes":50,"seconds":5,"hours":15,"month":2,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sporty/CJ/Vector/19638373.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4388,"difficulty":2.4608116447259074,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":30576,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.420698,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Ace Flywheel","authId":"","name":"Awesome Ace Flywheel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Ace Flywheel","authId":"","name":"Awesome Ace Flywheel","CNNId":"","myGameChains":null,"banStatus":null},"id":19545958,"name":"Streak Defense Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Ace/Flywheel/19545958.jpg","createDate":{"time":1360966955000,"minutes":22,"seconds":35,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Ace/Flywheel/19545958.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":738,"difficulty":2.0277777777777777,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1695,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.416667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Ingrid Nibbles","authId":"","name":"Groovy Ingrid Nibbles","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Ingrid Nibbles","authId":"","name":"Groovy Ingrid Nibbles","CNNId":"","myGameChains":null,"banStatus":null},"id":17941179,"name":"Attack Warrior Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Ingrid/Nibbles/17941179.jpg","createDate":{"time":1349253898000,"minutes":44,"seconds":58,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Ingrid/Nibbles/17941179.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26585,"difficulty":2.6215719325634175,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":219069,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.411127,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Robby Trooper","authId":"","name":"Count Robby Trooper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Robby Trooper","authId":"","name":"Count Robby Trooper","CNNId":"","myGameChains":null,"banStatus":null},"id":17808012,"name":"Rampage Attack Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Count/Robby/Trooper/17808012.jpg","createDate":{"time":1348793257000,"minutes":47,"seconds":37,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Count/Robby/Trooper/17808012.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2376,"difficulty":2.5280717368076946,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56537,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.406047,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Alan Giblets","authId":"","name":"Shy Alan Giblets","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Alan Giblets","authId":"","name":"Shy Alan Giblets","CNNId":"","myGameChains":null,"banStatus":null},"id":17736763,"name":"Plasma Humungousaur Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Alan/Giblets/17736763.jpg","createDate":{"time":1348462585000,"minutes":56,"seconds":25,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Alan/Giblets/17736763.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":298,"difficulty":2.3791722896986056,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9794,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.383458,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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 = '3' 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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]