[{"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 = '10' 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":"Amusing Ian Cinnamon","authId":"","name":"Amusing Ian Cinnamon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Ian Cinnamon","authId":"","name":"Amusing Ian Cinnamon","CNNId":"","myGameChains":null,"banStatus":null},"id":19854262,"name":"Attack Challenge Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amusing/Ian/Cinnamon/19854262.jpg","createDate":{"time":1363899372000,"minutes":56,"seconds":12,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amusing/Ian/Cinnamon/19854262.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17673,"difficulty":2.485862029203246,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":110997,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.477662,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Skylar Goofball","authId":"","name":"Stormy Skylar Goofball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Skylar Goofball","authId":"","name":"Stormy Skylar Goofball","CNNId":"","myGameChains":null,"banStatus":null},"id":19643467,"name":"Laser Adventure Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stormy/Skylar/Goofball/19643467.jpg","createDate":{"time":1362747390000,"minutes":56,"seconds":30,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":5,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stormy/Skylar/Goofball/19643467.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3345,"difficulty":1.7342774945570998,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6227,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.473041,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy William Rutabaga","authId":"","name":"Crazy William Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy William Rutabaga","authId":"","name":"Crazy William Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"id":18551635,"name":"Ambush Escape Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/William/Rutabaga/18551635.jpg","createDate":{"time":1353601679000,"minutes":27,"seconds":59,"hours":11,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/William/Rutabaga/18551635.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6645,"difficulty":1.7455496588691897,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37717,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.472311,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Gloria Nebula","authId":"","name":"Nifty Gloria Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Gloria Nebula","authId":"","name":"Nifty Gloria Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":17756183,"name":"Space Adventure Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Gloria/Nebula/17756183.jpg","createDate":{"time":1348548229000,"minutes":43,"seconds":49,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Gloria/Nebula/17756183.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29324,"difficulty":2.037991171385918,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":94121,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.469707,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Ernie Concrete","authId":"","name":"Complex Ernie Concrete","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Ernie Concrete","authId":"","name":"Complex Ernie Concrete","CNNId":"","myGameChains":null,"banStatus":null},"id":18336190,"name":"Galaxy Fury Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Complex/Ernie/Concrete/18336190.jpg","createDate":{"time":1351703122000,"minutes":5,"seconds":22,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Complex/Ernie/Concrete/18336190.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21031,"difficulty":2.089801124756703,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":41559,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.465433,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Ethan Gorilla","authId":"","name":"Bumbling Ethan Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Ethan Gorilla","authId":"","name":"Bumbling Ethan Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":19426549,"name":"Earth Rustbucket Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bumbling/Ethan/Gorilla/19426549.jpg","createDate":{"time":1358812130000,"minutes":48,"seconds":50,"hours":18,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bumbling/Ethan/Gorilla/19426549.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4055,"difficulty":2.590276999298143,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47341,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.462931,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Funky Bart Halo","authId":"","name":"Funky Bart Halo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Funky Bart Halo","authId":"","name":"Funky Bart Halo","CNNId":"","myGameChains":null,"banStatus":null},"id":20001950,"name":"Rumble Rocket Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Funky/Bart/Halo/20001950.jpg","createDate":{"time":1364884662000,"minutes":37,"seconds":42,"hours":2,"month":3,"timezoneOffset":240,"year":113,"day":2,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Funky/Bart/Halo/20001950.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1522,"difficulty":2.454941226698111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5472,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.446989,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Robert Atom","authId":"","name":"Alien Robert Atom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Robert Atom","authId":"","name":"Alien Robert Atom","CNNId":"","myGameChains":null,"banStatus":null},"id":19814915,"name":"Nitro Adventure Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Robert/Atom/19814915.jpg","createDate":{"time":1363591676000,"minutes":27,"seconds":56,"hours":3,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Robert/Atom/19814915.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14728,"difficulty":2.419054770938227,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":53148,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.4452,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Austin Particle","authId":"","name":"Enormous Austin Particle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Austin Particle","authId":"","name":"Enormous Austin Particle","CNNId":"","myGameChains":null,"banStatus":null},"id":19053488,"name":"Laser Crusher Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Enormous/Austin/Particle/19053488.jpg","createDate":{"time":1355746427000,"minutes":13,"seconds":47,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Enormous/Austin/Particle/19053488.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3733,"difficulty":1.6777403882667041,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13883,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.441538,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Pearl Moxie","authId":"","name":"Babbling Pearl Moxie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Pearl Moxie","authId":"","name":"Babbling Pearl Moxie","CNNId":"","myGameChains":null,"banStatus":null},"id":19632187,"name":"Attack Rumble Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Pearl/Moxie/19632187.jpg","createDate":{"time":1362410818000,"minutes":26,"seconds":58,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Pearl/Moxie/19632187.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2273,"difficulty":2.2267620058469735,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7208,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.439365,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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 = '10' 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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]