[{"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 = '15' 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":"Baroness Benjamin Buzzard","authId":"","name":"Baroness Benjamin Buzzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Benjamin Buzzard","authId":"","name":"Baroness Benjamin Buzzard","CNNId":"","myGameChains":null,"banStatus":null},"id":19689297,"name":"Ben Rook Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Benjamin/Buzzard/19689297.jpg","createDate":{"time":1363117110000,"minutes":38,"seconds":30,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Benjamin/Buzzard/19689297.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":516,"difficulty":1.679873136123136,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1391,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.886905,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mirthful Don Kudzu","authId":"","name":"Mirthful Don Kudzu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mirthful Don Kudzu","authId":"","name":"Mirthful Don Kudzu","CNNId":"","myGameChains":null,"banStatus":null},"id":19721437,"name":"Droid Burst Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mirthful/Don/Kudzu/19721437.jpg","createDate":{"time":1363262218000,"minutes":56,"seconds":58,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mirthful/Don/Kudzu/19721437.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1052,"difficulty":1.4906849103277675,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1988,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.878698,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Lloyd Universe","authId":"","name":"Digital Lloyd Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Lloyd Universe","authId":"","name":"Digital Lloyd Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":19707515,"name":"Omniverse Galaxy Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Lloyd/Universe/19707515.jpg","createDate":{"time":1363196671000,"minutes":44,"seconds":31,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Lloyd/Universe/19707515.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":213,"difficulty":1.8312081857536404,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2843,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.866116,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Tyler Donkey","authId":"","name":"Fabulous Tyler Donkey","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Tyler Donkey","authId":"","name":"Fabulous Tyler Donkey","CNNId":"","myGameChains":null,"banStatus":null},"id":19816561,"name":"Animo Hyper Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Tyler/Donkey/19816561.jpg","createDate":{"time":1363612153000,"minutes":9,"seconds":13,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Tyler/Donkey/19816561.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1840,"difficulty":1.719249382206465,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20994,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.819396,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Solid Carlos Kazoo","authId":"","name":"Solid Carlos Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solid Carlos Kazoo","authId":"","name":"Solid Carlos Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19673508,"name":"Hyper Ultra Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solid/Carlos/Kazoo/19673508.jpg","createDate":{"time":1363043865000,"minutes":17,"seconds":45,"hours":19,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solid/Carlos/Kazoo/19673508.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":73,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":894,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.8,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Eric Knight","authId":"","name":"Glorious Eric Knight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Eric Knight","authId":"","name":"Glorious Eric Knight","CNNId":"","myGameChains":null,"banStatus":null},"id":19850970,"name":"Universe Ultimate Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Glorious/Eric/Knight/19850970.jpg","createDate":{"time":1363877325000,"minutes":48,"seconds":45,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Glorious/Eric/Knight/19850970.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19729,"difficulty":2.379711378101278,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":104406,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.798738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bright Conrad Mercury","authId":"","name":"Bright Conrad Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bright Conrad Mercury","authId":"","name":"Bright Conrad Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":19690564,"name":"Adventure Beast Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bright/Conrad/Mercury/19690564.jpg","createDate":{"time":1363120107000,"minutes":28,"seconds":27,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bright/Conrad/Mercury/19690564.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":695,"difficulty":2.5927535427535426,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":950,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.790342,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Ben Crater","authId":"","name":"Brave Ben Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Ben Crater","authId":"","name":"Brave Ben Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":19721182,"name":"Rook Clash Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brave/Ben/Crater/19721182.jpg","createDate":{"time":1363260076000,"minutes":21,"seconds":16,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brave/Ben/Crater/19721182.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3644,"difficulty":2.5274434211970656,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17859,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.788947,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Magnus Minotaur","authId":"","name":"Ultimate Magnus Minotaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Magnus Minotaur","authId":"","name":"Ultimate Magnus Minotaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19831253,"name":"Adventure Steel Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Magnus/Minotaur/19831253.jpg","createDate":{"time":1363713086000,"minutes":11,"seconds":26,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Magnus/Minotaur/19831253.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":239,"difficulty":1.3333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1333,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.76,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Foul Mikayla Cipher","authId":"","name":"Foul Mikayla Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Foul Mikayla Cipher","authId":"","name":"Foul Mikayla Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":19859912,"name":"Adventure Plasma Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Foul/Mikayla/Cipher/19859912.jpg","createDate":{"time":1363944519000,"minutes":28,"seconds":39,"hours":5,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Foul/Mikayla/Cipher/19859912.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":49141,"difficulty":1.9816297896757962,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":53902,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.726902,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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 = '15' 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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]