[{"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 = '4' 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":"Putrid Ethan Penguin","authId":"","name":"Putrid Ethan Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Ethan Penguin","authId":"","name":"Putrid Ethan Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":17216560,"name":"Defense Hyper Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Putrid/Ethan/Penguin/17216560.jpg","createDate":{"time":1342184720000,"minutes":5,"seconds":20,"hours":9,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Putrid/Ethan/Penguin/17216560.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20793,"difficulty":1.6416173058899157,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":126805,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":84,"rating":3.227388,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Crystal Thing","authId":"","name":"Ultimate Crystal Thing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Crystal Thing","authId":"","name":"Ultimate Crystal Thing","CNNId":"","myGameChains":null,"banStatus":null},"id":18004945,"name":"Spidermonkey Atomic Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Crystal/Thing/18004945.jpg","createDate":{"time":1349554415000,"minutes":13,"seconds":35,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Crystal/Thing/18004945.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":140,"difficulty":1.9583333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":907,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.222222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Kaitlyn Mystery","authId":"","name":"Cartoony Kaitlyn Mystery","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Kaitlyn Mystery","authId":"","name":"Cartoony Kaitlyn Mystery","CNNId":"","myGameChains":null,"banStatus":null},"id":17793440,"name":"Fusion Fury Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cartoony/Kaitlyn/Mystery/17793440.jpg","createDate":{"time":1348720463000,"minutes":34,"seconds":23,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cartoony/Kaitlyn/Mystery/17793440.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":878,"difficulty":1.7151785714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1267,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.214732,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Queen Hazel Parsec","authId":"","name":"Queen Hazel Parsec","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Queen Hazel Parsec","authId":"","name":"Queen Hazel Parsec","CNNId":"","myGameChains":null,"banStatus":null},"id":18641392,"name":"Storm Earth Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Queen/Hazel/Parsec/18641392.jpg","createDate":{"time":1354310589000,"minutes":23,"seconds":9,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Queen/Hazel/Parsec/18641392.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6676,"difficulty":2.3360321433325475,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22568,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.20734,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Wallace Viking","authId":"","name":"Radical Wallace Viking","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Wallace Viking","authId":"","name":"Radical Wallace Viking","CNNId":"","myGameChains":null,"banStatus":null},"id":19168629,"name":"Big Omniverse Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radical/Wallace/Viking/19168629.jpg","createDate":{"time":1356343746000,"minutes":9,"seconds":6,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radical/Wallace/Viking/19168629.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4919,"difficulty":1.6603517036122324,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67463,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.1499,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Sandra Fandango","authId":"","name":"Shy Sandra Fandango","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Sandra Fandango","authId":"","name":"Shy Sandra Fandango","CNNId":"","myGameChains":null,"banStatus":null},"id":18287542,"name":"Nitro Adventure Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Sandra/Fandango/18287542.jpg","createDate":{"time":1351358081000,"minutes":14,"seconds":41,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Sandra/Fandango/18287542.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":796,"difficulty":1.3813932980599648,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2046,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.146587,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Lila Flamingo","authId":"","name":"Magical Lila Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Lila Flamingo","authId":"","name":"Magical Lila Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"id":18639743,"name":"Smash Ultimate Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magical/Lila/Flamingo/18639743.jpg","createDate":{"time":1354296957000,"minutes":35,"seconds":57,"hours":12,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magical/Lila/Flamingo/18639743.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2708,"difficulty":2.26549355944723,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51477,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.144312,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Faith Kudzu","authId":"","name":"Imperial Faith Kudzu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Faith Kudzu","authId":"","name":"Imperial Faith Kudzu","CNNId":"","myGameChains":null,"banStatus":null},"id":18550215,"name":"Adventure Robot Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Imperial/Faith/Kudzu/18550215.jpg","createDate":{"time":1353596117000,"minutes":55,"seconds":17,"hours":9,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Imperial/Faith/Kudzu/18550215.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5182,"difficulty":2.640615625949828,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44313,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.042045,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Nelson Deadbolt","authId":"","name":"Creative Nelson Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Nelson Deadbolt","authId":"","name":"Creative Nelson Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"id":17774102,"name":"Big Quake Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Nelson/Deadbolt/17774102.jpg","createDate":{"time":1348634347000,"minutes":39,"seconds":7,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Nelson/Deadbolt/17774102.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":97,"difficulty":2.842768277838877,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59507,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.951703,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Gerard Jungle","authId":"","name":"Visible Gerard Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Gerard Jungle","authId":"","name":"Visible Gerard Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":19279531,"name":"Adventure Fusion Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Visible/Gerard/Jungle/19279531.jpg","createDate":{"time":1357041527000,"minutes":58,"seconds":47,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Visible/Gerard/Jungle/19279531.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1366,"difficulty":1.3105168640882927,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4457,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.926178,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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 = '4' 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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]