[{"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":"Imperial Jacob Gremlin","authId":"","name":"Imperial Jacob Gremlin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Jacob Gremlin","authId":"","name":"Imperial Jacob Gremlin","CNNId":"","myGameChains":null,"banStatus":null},"id":18488377,"name":"Rock Fusion Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Imperial/Jacob/Gremlin/18488377.jpg","createDate":{"time":1353023671000,"minutes":54,"seconds":31,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Imperial/Jacob/Gremlin/18488377.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":401,"difficulty":2.3222222222222224,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1059,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.072222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Angelina Pumpkin","authId":"","name":"Venomous Angelina Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Angelina Pumpkin","authId":"","name":"Venomous Angelina Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"id":18106981,"name":"Target Echo Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Venomous/Angelina/Pumpkin/18106981.jpg","createDate":{"time":1350079840000,"minutes":10,"seconds":40,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Venomous/Angelina/Pumpkin/18106981.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":108,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3376,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.065801,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Quincy Gong","authId":"","name":"Imperial Quincy Gong","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Quincy Gong","authId":"","name":"Imperial Quincy Gong","CNNId":"","myGameChains":null,"banStatus":null},"id":19629672,"name":"Quake Steel Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Imperial/Quincy/Gong/19629672.jpg","createDate":{"time":1362345640000,"minutes":20,"seconds":40,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Imperial/Quincy/Gong/19629672.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3443,"difficulty":1.8884062606093284,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3741,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.055908,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Jimmy Scout","authId":"","name":"Ruthless Jimmy Scout","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Jimmy Scout","authId":"","name":"Ruthless Jimmy Scout","CNNId":"","myGameChains":null,"banStatus":null},"id":18498001,"name":"Galaxy Adventure Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Jimmy/Scout/18498001.jpg","createDate":{"time":1353147303000,"minutes":15,"seconds":3,"hours":5,"month":10,"timezoneOffset":300,"year":112,"day":6,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Jimmy/Scout/18498001.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1078,"difficulty":1.2425220612720613,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4816,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.032854,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Forrest Warrior","authId":"","name":"Ancient Forrest Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Forrest Warrior","authId":"","name":"Ancient Forrest Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":17793424,"name":"Sonic Solar Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Forrest/Warrior/17793424.jpg","createDate":{"time":1348720123000,"minutes":28,"seconds":43,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Forrest/Warrior/17793424.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":706,"difficulty":2.7194444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1765,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.027778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gnarly Jared Hiccup","authId":"","name":"Gnarly Jared Hiccup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gnarly Jared Hiccup","authId":"","name":"Gnarly Jared Hiccup","CNNId":"","myGameChains":null,"banStatus":null},"id":18613465,"name":"Metal Crusher Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gnarly/Jared/Hiccup/18613465.jpg","createDate":{"time":1353963766000,"minutes":2,"seconds":46,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gnarly/Jared/Hiccup/18613465.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":147,"difficulty":2.4444444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":830,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Brayden Galosh","authId":"","name":"Quirky Brayden Galosh","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Brayden Galosh","authId":"","name":"Quirky Brayden Galosh","CNNId":"","myGameChains":null,"banStatus":null},"id":18170407,"name":"Defense Hero Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Brayden/Galosh/18170407.jpg","createDate":{"time":1350371573000,"minutes":12,"seconds":53,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Brayden/Galosh/18170407.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1011,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty Jordan Walrus","authId":"","name":"Pretty Jordan Walrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty Jordan Walrus","authId":"","name":"Pretty Jordan Walrus","CNNId":"","myGameChains":null,"banStatus":null},"id":18287338,"name":"Animo Nitro Humungousaur","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pretty/Jordan/Walrus/18287338.jpg","createDate":{"time":1351357376000,"minutes":2,"seconds":56,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pretty/Jordan/Walrus/18287338.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":418,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":779,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Rachel","authId":"","name":"Honest Rachel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Rachel","authId":"","name":"Honest Rachel","CNNId":"","myGameChains":null,"banStatus":null},"id":18425988,"name":"Shadow Power Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Honest/Rachel/18425988.jpg","createDate":{"time":1352486718000,"minutes":45,"seconds":18,"hours":13,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Honest/Rachel/18425988.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44486,"difficulty":2.486073374833243,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":119401,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.989375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Florence Dragoon","authId":"","name":"Hyper Florence Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Florence Dragoon","authId":"","name":"Hyper Florence Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18260428,"name":"Adventure Big Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hyper/Florence/Dragoon/18260428.jpg","createDate":{"time":1351156201000,"minutes":10,"seconds":1,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hyper/Florence/Dragoon/18260428.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":257,"difficulty":2.500277777777778,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1858,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.979444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]