[{"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":"Neutral Chester Narwhal","authId":"","name":"Neutral Chester Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Neutral Chester Narwhal","authId":"","name":"Neutral Chester Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"id":17216276,"name":"Rock Solar Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Neutral/Chester/Narwhal/17216276.jpg","createDate":{"time":1342174084000,"minutes":8,"seconds":4,"hours":6,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Neutral/Chester/Narwhal/17216276.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5513,"difficulty":2.417885613253446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":396814,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.849725,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Rocky Fox","authId":"","name":"Sparkly Rocky Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Rocky Fox","authId":"","name":"Sparkly Rocky Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":19027772,"name":"Cannonbolt Danger Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sparkly/Rocky/Fox/19027772.jpg","createDate":{"time":1355662423000,"minutes":53,"seconds":43,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sparkly/Rocky/Fox/19027772.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21483,"difficulty":2.248764715819434,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":159268,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.849663,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Katelyn Daffodil","authId":"","name":"Complex Katelyn Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Katelyn Daffodil","authId":"","name":"Complex Katelyn Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"id":17944234,"name":"Hero Humungousaur Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Complex/Katelyn/Daffodil/17944234.jpg","createDate":{"time":1349283913000,"minutes":5,"seconds":13,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Complex/Katelyn/Daffodil/17944234.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12463,"difficulty":2.796498925664952,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":184516,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.845604,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brainy Oliver Snowball","authId":"","name":"Brainy Oliver Snowball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brainy Oliver Snowball","authId":"","name":"Brainy Oliver Snowball","CNNId":"","myGameChains":null,"banStatus":null},"id":18106284,"name":"Slam Nova Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brainy/Oliver/Snowball/18106284.jpg","createDate":{"time":1350077938000,"minutes":38,"seconds":58,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brainy/Oliver/Snowball/18106284.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5108,"difficulty":2.4553600463989405,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":109636,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.796536,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Grace Bolt","authId":"","name":"Stinky Grace Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Grace Bolt","authId":"","name":"Stinky Grace Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":19580350,"name":"Ambush Mission Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stinky/Grace/Bolt/19580350.jpg","createDate":{"time":1361472876000,"minutes":54,"seconds":36,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stinky/Grace/Bolt/19580350.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4384,"difficulty":2.9217873462106203,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32972,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.794516,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Eduardo Scorpion","authId":"","name":"Strong Eduardo Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Eduardo Scorpion","authId":"","name":"Strong Eduardo Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"id":17216372,"name":"Cannonbolt Alien Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Eduardo/Scorpion/17216372.jpg","createDate":{"time":1342178361000,"minutes":19,"seconds":21,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Eduardo/Scorpion/17216372.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7346,"difficulty":1.3536010529416351,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26801,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.777035,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Isabelle Martian","authId":"","name":"Obscure Isabelle Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Isabelle Martian","authId":"","name":"Obscure Isabelle Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":17216423,"name":"Ambush Animo Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obscure/Isabelle/Martian/17216423.jpg","createDate":{"time":1342180788000,"minutes":59,"seconds":48,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obscure/Isabelle/Martian/17216423.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2549,"difficulty":1.4398409048338916,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24978,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.772287,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Connie Baloney","authId":"","name":"Silly Connie Baloney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Connie Baloney","authId":"","name":"Silly Connie Baloney","CNNId":"","myGameChains":null,"banStatus":null},"id":18911922,"name":"Omniverse Sonic Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Connie/Baloney/18911922.jpg","createDate":{"time":1355129407000,"minutes":50,"seconds":7,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Connie/Baloney/18911922.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13616,"difficulty":2.691407178583429,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24690,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.766105,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Maggie Hambone","authId":"","name":"Elusive Maggie Hambone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elusive Maggie Hambone","authId":"","name":"Elusive Maggie Hambone","CNNId":"","myGameChains":null,"banStatus":null},"id":17622819,"name":"Titan Hex Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elusive/Maggie/Hambone/17622819.jpg","createDate":{"time":1348315862000,"minutes":11,"seconds":2,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elusive/Maggie/Hambone/17622819.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":917,"difficulty":1.792752903390834,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17351,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.765566,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Bobby Kazoo","authId":"","name":"Sturdy Bobby Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Bobby Kazoo","authId":"","name":"Sturdy Bobby Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19760155,"name":"Droid Storm Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Bobby/Kazoo/19760155.jpg","createDate":{"time":1363435122000,"minutes":58,"seconds":42,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Bobby/Kazoo/19760155.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":834,"difficulty":2.747574182503898,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7657,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.761752,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]