[{"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 = '2' 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":"Awesome Ted Blast","authId":"","name":"Awesome Ted Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Ted Blast","authId":"","name":"Awesome Ted Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":19588243,"name":"Nitro Smash Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Ted/Blast/19588243.jpg","createDate":{"time":1361598133000,"minutes":42,"seconds":13,"hours":0,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Ted/Blast/19588243.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1077,"difficulty":2.3726760502228634,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36706,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.274688,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Andrew Atom","authId":"","name":"Blustery Andrew Atom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Andrew Atom","authId":"","name":"Blustery Andrew Atom","CNNId":"","myGameChains":null,"banStatus":null},"id":19660791,"name":"Power Defense Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blustery/Andrew/Atom/19660791.jpg","createDate":{"time":1363002491000,"minutes":48,"seconds":11,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blustery/Andrew/Atom/19660791.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9424,"difficulty":2.66274015602001,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78857,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.260801,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Lorenzo Meteor","authId":"","name":"Grand Lorenzo Meteor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Lorenzo Meteor","authId":"","name":"Grand Lorenzo Meteor","CNNId":"","myGameChains":null,"banStatus":null},"id":17793413,"name":"Blaster Water Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grand/Lorenzo/Meteor/17793413.jpg","createDate":{"time":1348719986000,"minutes":26,"seconds":26,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grand/Lorenzo/Meteor/17793413.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":485,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":978,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Alicia Bingo","authId":"","name":"Aquatic Alicia Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Alicia Bingo","authId":"","name":"Aquatic Alicia Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":19967777,"name":"Rumble Nitro Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aquatic/Alicia/Bingo/19967777.jpg","createDate":{"time":1364648139000,"minutes":55,"seconds":39,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aquatic/Alicia/Bingo/19967777.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1583,"difficulty":1.9106732652484286,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4929,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.176502,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Skylar Flipper","authId":"","name":"Obscure Skylar Flipper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Skylar Flipper","authId":"","name":"Obscure Skylar Flipper","CNNId":"","myGameChains":null,"banStatus":null},"id":19391561,"name":"Blaster Adventure Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obscure/Skylar/Flipper/19391561.jpg","createDate":{"time":1358337648000,"minutes":0,"seconds":48,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obscure/Skylar/Flipper/19391561.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":193,"difficulty":2.583333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1891,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.125,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scruffy Yvonne Weasel","authId":"","name":"Scruffy Yvonne Weasel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scruffy Yvonne Weasel","authId":"","name":"Scruffy Yvonne Weasel","CNNId":"","myGameChains":null,"banStatus":null},"id":18287501,"name":"Humungousaur Droid Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scruffy/Yvonne/Weasel/18287501.jpg","createDate":{"time":1351357929000,"minutes":12,"seconds":9,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scruffy/Yvonne/Weasel/18287501.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":482,"difficulty":1.8925170068027208,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1824,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.1,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Healthy Alvin Castle","authId":"","name":"Healthy Alvin Castle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Healthy Alvin Castle","authId":"","name":"Healthy Alvin Castle","CNNId":"","myGameChains":null,"banStatus":null},"id":17622754,"name":"Ultra Rampage Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Healthy/Alvin/Castle/17622754.jpg","createDate":{"time":1348315757000,"minutes":9,"seconds":17,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Healthy/Alvin/Castle/17622754.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":864,"difficulty":2.3328823953823954,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1273,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.060595,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Richard Blizzard","authId":"","name":"Stealthy Richard Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Richard Blizzard","authId":"","name":"Stealthy Richard Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":18116873,"name":"Alien Ambush Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stealthy/Richard/Blizzard/18116873.jpg","createDate":{"time":1350131351000,"minutes":29,"seconds":11,"hours":8,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stealthy/Richard/Blizzard/18116873.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":347,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Adept Cindy Recess","authId":"","name":"Adept Cindy Recess","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Adept Cindy Recess","authId":"","name":"Adept Cindy Recess","CNNId":"","myGameChains":null,"banStatus":null},"id":19939665,"name":"Galaxy Pulse Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Adept/Cindy/Recess/19939665.jpg","createDate":{"time":1364474831000,"minutes":47,"seconds":11,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Adept/Cindy/Recess/19939665.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":515,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Proud Mary Spark","authId":"","name":"Proud Mary Spark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Proud Mary Spark","authId":"","name":"Proud Mary Spark","CNNId":"","myGameChains":null,"banStatus":null},"id":18469323,"name":"Force Mega Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Proud/Mary/Spark/18469323.jpg","createDate":{"time":1352756849000,"minutes":47,"seconds":29,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Proud/Mary/Spark/18469323.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":176,"difficulty":1.25,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1005,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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 = '2' 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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]