[{"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":"Earnest Summer Gator","authId":"","name":"Earnest Summer Gator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Summer Gator","authId":"","name":"Earnest Summer Gator","CNNId":"","myGameChains":null,"banStatus":null},"id":19574757,"name":"Earth Energy Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Summer/Gator/19574757.jpg","createDate":{"time":1361369068000,"minutes":4,"seconds":28,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Summer/Gator/19574757.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":504,"difficulty":2.144539472053811,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5779,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.815316,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Simon Glacier","authId":"","name":"Wacky Simon Glacier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Simon Glacier","authId":"","name":"Wacky Simon Glacier","CNNId":"","myGameChains":null,"banStatus":null},"id":19090047,"name":"Echo Techno Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Simon/Glacier/19090047.jpg","createDate":{"time":1356003763000,"minutes":42,"seconds":43,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Simon/Glacier/19090047.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":718,"difficulty":2.1402976487797916,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15028,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.796143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Marcus Gumshoe","authId":"","name":"Toxic Marcus Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Marcus Gumshoe","authId":"","name":"Toxic Marcus Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":17216068,"name":"Nova Charge Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Marcus/Gumshoe/17216068.jpg","createDate":{"time":1342162103000,"minutes":48,"seconds":23,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Marcus/Gumshoe/17216068.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":844,"difficulty":1.1960880999342538,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2845,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.78658,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Alvin Porpoise","authId":"","name":"Gigantic Alvin Porpoise","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Alvin Porpoise","authId":"","name":"Gigantic Alvin Porpoise","CNNId":"","myGameChains":null,"banStatus":null},"id":17685906,"name":"Adventure Rescue Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Alvin/Porpoise/17685906.jpg","createDate":{"time":1348385500000,"minutes":31,"seconds":40,"hours":3,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Alvin/Porpoise/17685906.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38,"difficulty":1.36,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":942,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.777778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Angelica Seesaw","authId":"","name":"Super Angelica Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Angelica Seesaw","authId":"","name":"Super Angelica Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"id":17586292,"name":"Animo Alien Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Angelica/Seesaw/17586292.jpg","createDate":{"time":1348257664000,"minutes":1,"seconds":4,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Angelica/Seesaw/17586292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33,"difficulty":2.4,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2015,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.77551,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Mordecai Warrior","authId":"","name":"Venomous Mordecai Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Mordecai Warrior","authId":"","name":"Venomous Mordecai Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":18469437,"name":"Energy Nitro Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Venomous/Mordecai/Warrior/18469437.jpg","createDate":{"time":1352757461000,"minutes":57,"seconds":41,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Venomous/Mordecai/Warrior/18469437.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":194,"difficulty":2.1659126984126984,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2606,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.772789,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Bruce Bronco","authId":"","name":"Negative Bruce Bronco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Bruce Bronco","authId":"","name":"Negative Bruce Bronco","CNNId":"","myGameChains":null,"banStatus":null},"id":19312868,"name":"Atomic Omniverse Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Negative/Bruce/Bronco/19312868.jpg","createDate":{"time":1357317907000,"minutes":45,"seconds":7,"hours":11,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Negative/Bruce/Bronco/19312868.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5515,"difficulty":1.9504035071497536,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":75593,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.742977,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Tyler","authId":"","name":"Obvious Tyler","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Tyler","authId":"","name":"Obvious Tyler","CNNId":"","myGameChains":null,"banStatus":null},"id":19313215,"name":"Adventure Chase Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obvious/Tyler/19313215.jpg","createDate":{"time":1357321409000,"minutes":43,"seconds":29,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obvious/Tyler/19313215.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3917,"difficulty":1.7498740567941502,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4373,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.742217,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Dexter Phantom","authId":"","name":"Ghostly Dexter Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Dexter Phantom","authId":"","name":"Ghostly Dexter Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":19931343,"name":"Water Beast Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghostly/Dexter/Phantom/19931343.jpg","createDate":{"time":1364405190000,"minutes":26,"seconds":30,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghostly/Dexter/Phantom/19931343.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1007,"difficulty":2.4576562980811634,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82752,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.69872,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Taylor Concrete","authId":"","name":"Electric Taylor Concrete","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Taylor Concrete","authId":"","name":"Electric Taylor Concrete","CNNId":"","myGameChains":null,"banStatus":null},"id":17552637,"name":"Ultimate Humungousaur Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Taylor/Concrete/17552637.jpg","createDate":{"time":1348175245000,"minutes":7,"seconds":25,"hours":17,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Taylor/Concrete/17552637.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":237,"difficulty":1.9583333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2379,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.666667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"121","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":"130","currentPageToDisplay":13,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]