[{"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":"Magnetic Maggie Meteor","authId":"","name":"Magnetic Maggie Meteor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Maggie Meteor","authId":"","name":"Magnetic Maggie Meteor","CNNId":"","myGameChains":null,"banStatus":null},"id":18409184,"name":"Sonic Space Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Maggie/Meteor/18409184.jpg","createDate":{"time":1352280841000,"minutes":34,"seconds":1,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Maggie/Meteor/18409184.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":146,"difficulty":1.9583333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1482,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.4375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Ray Oyster","authId":"","name":"Immortal Ray Oyster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Ray Oyster","authId":"","name":"Immortal Ray Oyster","CNNId":"","myGameChains":null,"banStatus":null},"id":18514610,"name":"Nitro Titan Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Ray/Oyster/18514610.jpg","createDate":{"time":1353272344000,"minutes":59,"seconds":4,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Ray/Oyster/18514610.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":286,"difficulty":2.08,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":791,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.397222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Charles Apple","authId":"","name":"Hearty Charles Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Charles Apple","authId":"","name":"Hearty Charles Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":19446309,"name":"Thunder Metal Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hearty/Charles/Apple/19446309.jpg","createDate":{"time":1359190916000,"minutes":1,"seconds":56,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hearty/Charles/Apple/19446309.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3049,"difficulty":1.5798290598290599,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9949,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.358134,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Variable Lindsey Snake","authId":"","name":"Variable Lindsey Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Variable Lindsey Snake","authId":"","name":"Variable Lindsey Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":17622231,"name":"Omniverse Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Variable/Lindsey/Snake/17622231.jpg","createDate":{"time":1348314908000,"minutes":55,"seconds":8,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Variable/Lindsey/Snake/17622231.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":92,"difficulty":1.34,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1055,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spooky Chris Rhino","authId":"","name":"Spooky Chris Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spooky Chris Rhino","authId":"","name":"Spooky Chris Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":19638664,"name":"Invasion Power Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spooky/Chris/Rhino/19638664.jpg","createDate":{"time":1362607378000,"minutes":2,"seconds":58,"hours":17,"month":2,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spooky/Chris/Rhino/19638664.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1094,"difficulty":1.4220384780814836,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5188,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.313914,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Joshua Frost","authId":"","name":"Colossal Joshua Frost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Joshua Frost","authId":"","name":"Colossal Joshua Frost","CNNId":"","myGameChains":null,"banStatus":null},"id":18513430,"name":"Echo Echo Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Joshua/Frost/18513430.jpg","createDate":{"time":1353266586000,"minutes":23,"seconds":6,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Joshua/Frost/18513430.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1070,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.276786,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Scooby Sprout","authId":"","name":"Duke Scooby Sprout","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Scooby Sprout","authId":"","name":"Duke Scooby Sprout","CNNId":"","myGameChains":null,"banStatus":null},"id":18247285,"name":"Spike Fire Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Duke/Scooby/Sprout/18247285.jpg","createDate":{"time":1351004154000,"minutes":55,"seconds":54,"hours":10,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Duke/Scooby/Sprout/18247285.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2035,"difficulty":1.1537414965986394,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3111,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.223129,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Nathan Jalapeno","authId":"","name":"Elusive Nathan Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Nathan Jalapeno","authId":"","name":"Elusive Nathan Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"id":18557093,"name":"Storm Fire Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elusive/Nathan/Jalapeno/18557093.jpg","createDate":{"time":1353621749000,"minutes":2,"seconds":29,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elusive/Nathan/Jalapeno/18557093.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":413,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":747,"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":"Empress Ninja","authId":"","name":"Empress Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Empress Ninja","authId":"","name":"Empress Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":19578949,"name":"Titan Giga Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Empress/Ninja/19578949.jpg","createDate":{"time":1361449941000,"minutes":32,"seconds":21,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Empress/Ninja/19578949.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":643,"difficulty":2.683091057605379,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56320,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.204552,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Violet Snake","authId":"","name":"Active Violet Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Violet Snake","authId":"","name":"Active Violet Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":18351334,"name":"Echo Light Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Violet/Snake/18351334.jpg","createDate":{"time":1351877313000,"minutes":28,"seconds":33,"hours":13,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Violet/Snake/18351334.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":66,"difficulty":1.7,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":728,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.2,"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 = '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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]