[{"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 = '3' 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":"Toxic Zeke Apple","authId":"","name":"Toxic Zeke Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Zeke Apple","authId":"","name":"Toxic Zeke Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":18929659,"name":"Adventure Alien Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Zeke/Apple/18929659.jpg","createDate":{"time":1355217979000,"minutes":26,"seconds":19,"hours":4,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Zeke/Apple/18929659.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18427,"difficulty":1.3480254833718492,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45273,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.4496,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Penny Behemoth","authId":"","name":"Gruesome Penny Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Penny Behemoth","authId":"","name":"Gruesome Penny Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":18116532,"name":"Hero Steel Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Penny/Behemoth/18116532.jpg","createDate":{"time":1350129725000,"minutes":2,"seconds":5,"hours":8,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Penny/Behemoth/18116532.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33224,"difficulty":1.6752359003152921,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43468,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.449049,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Zoe Alien","authId":"","name":"Captain Zoe Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Zoe Alien","authId":"","name":"Captain Zoe Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":19580341,"name":"Champion Ambush Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Zoe/Alien/19580341.jpg","createDate":{"time":1361472789000,"minutes":53,"seconds":9,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Zoe/Alien/19580341.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1242,"difficulty":1.4751382876382877,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2230,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.435595,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Marcus Bongo","authId":"","name":"Crispy Marcus Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Marcus Bongo","authId":"","name":"Crispy Marcus Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":18409232,"name":"Danger Lightning Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crispy/Marcus/Bongo/18409232.jpg","createDate":{"time":1352282101000,"minutes":55,"seconds":1,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crispy/Marcus/Bongo/18409232.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":216,"difficulty":2.85429375385906,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22003,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.401202,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unlucky Bert Gazebo","authId":"","name":"Unlucky Bert Gazebo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unlucky Bert Gazebo","authId":"","name":"Unlucky Bert Gazebo","CNNId":"","myGameChains":null,"banStatus":null},"id":18005032,"name":"Siege Adventure Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unlucky/Bert/Gazebo/18005032.jpg","createDate":{"time":1349554558000,"minutes":15,"seconds":58,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unlucky/Bert/Gazebo/18005032.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":647,"difficulty":1.807900432900433,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2394,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.321226,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Felix Zip","authId":"","name":"Digital Felix Zip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Felix Zip","authId":"","name":"Digital Felix Zip","CNNId":"","myGameChains":null,"banStatus":null},"id":19421416,"name":"Quake Adventure Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Felix/Zip/19421416.jpg","createDate":{"time":1358775418000,"minutes":36,"seconds":58,"hours":8,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Felix/Zip/19421416.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":206,"difficulty":2.875,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1757,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.291667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Zoe Dinosaur","authId":"","name":"Complex Zoe Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Zoe Dinosaur","authId":"","name":"Complex Zoe Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19186934,"name":"Racer Adventure Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Complex/Zoe/Dinosaur/19186934.jpg","createDate":{"time":1356438065000,"minutes":21,"seconds":5,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Complex/Zoe/Dinosaur/19186934.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5856,"difficulty":2.4757628755870846,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10977,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.276006,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Aaron Meteor","authId":"","name":"Edgy Aaron Meteor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Aaron Meteor","authId":"","name":"Edgy Aaron Meteor","CNNId":"","myGameChains":null,"banStatus":null},"id":18488442,"name":"Assault Magno Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Aaron/Meteor/18488442.jpg","createDate":{"time":1353024310000,"minutes":5,"seconds":10,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Aaron/Meteor/18488442.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6100,"difficulty":1.4555770043107614,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9393,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.249195,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Rigby Pinwheel","authId":"","name":"Academic Rigby Pinwheel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Rigby Pinwheel","authId":"","name":"Academic Rigby Pinwheel","CNNId":"","myGameChains":null,"banStatus":null},"id":18378764,"name":"Star Laser Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Rigby/Pinwheel/18378764.jpg","createDate":{"time":1352038438000,"minutes":13,"seconds":58,"hours":9,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Rigby/Pinwheel/18378764.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13160,"difficulty":2.206373651073509,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27542,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.203383,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Kyle Mackerel","authId":"","name":"Icy Kyle Mackerel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Kyle Mackerel","authId":"","name":"Icy Kyle Mackerel","CNNId":"","myGameChains":null,"banStatus":null},"id":18911947,"name":"Jetray Battle Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Kyle/Mackerel/18911947.jpg","createDate":{"time":1355129979000,"minutes":59,"seconds":39,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Kyle/Mackerel/18911947.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1719,"difficulty":2.3842732714855477,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5977,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.156626,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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 = '3' 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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]