[{"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 = '8' 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":"Immortal Zoe Zombie","authId":"","name":"Immortal Zoe Zombie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Zoe Zombie","authId":"","name":"Immortal Zoe Zombie","CNNId":"","myGameChains":null,"banStatus":null},"id":19606117,"name":"Doom Atomic Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Zoe/Zombie/19606117.jpg","createDate":{"time":1361895823000,"minutes":23,"seconds":43,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Zoe/Zombie/19606117.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":768,"difficulty":1.373015873015873,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2202,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.662143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Zeb Giraffe","authId":"","name":"Academic Zeb Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Zeb Giraffe","authId":"","name":"Academic Zeb Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"id":19180239,"name":"Cannonbolt Cannonbolt Cannonbolt","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Zeb/Giraffe/19180239.jpg","createDate":{"time":1356385933000,"minutes":52,"seconds":13,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Zeb/Giraffe/19180239.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":488,"difficulty":1.55625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3427,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.654762,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Buster Cartoon","authId":"","name":"Imperial Buster Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Buster Cartoon","authId":"","name":"Imperial Buster Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18633103,"name":"Cannonbolt Escape Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Imperial/Buster/Cartoon/18633103.jpg","createDate":{"time":1354216991000,"minutes":23,"seconds":11,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Imperial/Buster/Cartoon/18633103.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":58965,"difficulty":1.4747408407251474,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":103142,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.649414,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Bert Cosmos","authId":"","name":"Elegant Bert Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Bert Cosmos","authId":"","name":"Elegant Bert Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":17216113,"name":"Nano Cannonbolt Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elegant/Bert/Cosmos/17216113.jpg","createDate":{"time":1342163894000,"minutes":18,"seconds":14,"hours":3,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elegant/Bert/Cosmos/17216113.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":926,"difficulty":1.395,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2258,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":3.648842,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Jackson Tiger","authId":"","name":"Rowdy Jackson Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Jackson Tiger","authId":"","name":"Rowdy Jackson Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19208485,"name":"Siege Mission Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rowdy/Jackson/Tiger/19208485.jpg","createDate":{"time":1356614310000,"minutes":18,"seconds":30,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rowdy/Jackson/Tiger/19208485.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":560,"difficulty":2.283333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3021,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Spike Stampede","authId":"","name":"Epic Spike Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Spike Stampede","authId":"","name":"Epic Spike Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":18378946,"name":"Adventure Nitro Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Spike/Stampede/18378946.jpg","createDate":{"time":1352039209000,"minutes":26,"seconds":49,"hours":9,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Spike/Stampede/18378946.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13510,"difficulty":1.8668816499733543,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51787,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.616623,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Uncommon Benjamin Warp","authId":"","name":"Uncommon Benjamin Warp","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Uncommon Benjamin Warp","authId":"","name":"Uncommon Benjamin Warp","CNNId":"","myGameChains":null,"banStatus":null},"id":18260507,"name":"Ultimate Hyper Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Uncommon/Benjamin/Warp/18260507.jpg","createDate":{"time":1351157279000,"minutes":27,"seconds":59,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Uncommon/Benjamin/Warp/18260507.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":207,"difficulty":1.3408289241622575,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2052,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.614499,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Chad Dogfish","authId":"","name":"Brisk Chad Dogfish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Chad Dogfish","authId":"","name":"Brisk Chad Dogfish","CNNId":"","myGameChains":null,"banStatus":null},"id":19326781,"name":"Lightning Blaster Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Chad/Dogfish/19326781.jpg","createDate":{"time":1357424687000,"minutes":24,"seconds":47,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Chad/Dogfish/19326781.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1251,"difficulty":1.7384579288462967,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6391,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.597982,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy CJ Pumpkin","authId":"","name":"Loopy CJ Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy CJ Pumpkin","authId":"","name":"Loopy CJ Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"id":19575795,"name":"Champion Spike Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loopy/CJ/Pumpkin/19575795.jpg","createDate":{"time":1361386674000,"minutes":57,"seconds":54,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loopy/CJ/Pumpkin/19575795.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48351,"difficulty":2.034376523345707,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":81325,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.528827,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Kaylee Goulash","authId":"","name":"Loud Kaylee Goulash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Kaylee Goulash","authId":"","name":"Loud Kaylee Goulash","CNNId":"","myGameChains":null,"banStatus":null},"id":19540741,"name":"Blaster Hyper Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Kaylee/Goulash/19540741.jpg","createDate":{"time":1360874551000,"minutes":42,"seconds":31,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Kaylee/Goulash/19540741.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":876,"difficulty":2.289277389277389,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5323,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.473214,"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 = '8' 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"}}]