[{"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 = '5' 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 Simon Banzai","authId":"","name":"Toxic Simon Banzai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Simon Banzai","authId":"","name":"Toxic Simon Banzai","CNNId":"","myGameChains":null,"banStatus":null},"id":18995554,"name":"Ben Attack Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Simon/Banzai/18995554.jpg","createDate":{"time":1355562139000,"minutes":2,"seconds":19,"hours":4,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Simon/Banzai/18995554.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5511,"difficulty":1.8805607348827549,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11230,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.1872,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prince Julian Skylark","authId":"","name":"Prince Julian Skylark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prince Julian Skylark","authId":"","name":"Prince Julian Skylark","CNNId":"","myGameChains":null,"banStatus":null},"id":19967729,"name":"Dark Cosmic Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prince/Julian/Skylark/19967729.jpg","createDate":{"time":1364647964000,"minutes":52,"seconds":44,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prince/Julian/Skylark/19967729.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":337,"difficulty":2.3625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":762,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.134137,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty Pete Troll","authId":"","name":"Pretty Pete Troll","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty Pete Troll","authId":"","name":"Pretty Pete Troll","CNNId":"","myGameChains":null,"banStatus":null},"id":18351654,"name":"Stone Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pretty/Pete/Troll/18351654.jpg","createDate":{"time":1351880258000,"minutes":17,"seconds":38,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pretty/Pete/Troll/18351654.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":399,"difficulty":1.775,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1093,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.133333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reliable Rosetta Gong","authId":"","name":"Reliable Rosetta Gong","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reliable Rosetta Gong","authId":"","name":"Reliable Rosetta Gong","CNNId":"","myGameChains":null,"banStatus":null},"id":18256896,"name":"Ben Clash Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reliable/Rosetta/Gong/18256896.jpg","createDate":{"time":1351115256000,"minutes":47,"seconds":36,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reliable/Rosetta/Gong/18256896.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1947,"difficulty":1.4874377291364504,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6191,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.13199,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Summer Shark","authId":"","name":"Awesome Summer Shark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Summer Shark","authId":"","name":"Awesome Summer Shark","CNNId":"","myGameChains":null,"banStatus":null},"id":19861014,"name":"Warp Hyper Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Summer/Shark/19861014.jpg","createDate":{"time":1363956993000,"minutes":56,"seconds":33,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Summer/Shark/19861014.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":169,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":559,"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":"Stout Ned Kungfu","authId":"","name":"Stout Ned Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Ned Kungfu","authId":"","name":"Stout Ned Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":18911930,"name":"Techno Metal Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stout/Ned/Kungfu/18911930.jpg","createDate":{"time":1355129518000,"minutes":51,"seconds":58,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stout/Ned/Kungfu/18911930.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":739,"difficulty":2.166666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1136,"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":"Solar Zelda Sprinkle","authId":"","name":"Solar Zelda Sprinkle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Zelda Sprinkle","authId":"","name":"Solar Zelda Sprinkle","CNNId":"","myGameChains":null,"banStatus":null},"id":17375994,"name":"Thunder Ambush Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solar/Zelda/Sprinkle/17375994.jpg","createDate":{"time":1346170495000,"minutes":14,"seconds":55,"hours":12,"month":7,"timezoneOffset":240,"year":112,"day":2,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solar/Zelda/Sprinkle/17375994.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36,"difficulty":1.955787037037037,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":536,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.083761,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Diagonal Clyde Unicycle","authId":"","name":"Diagonal Clyde Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Diagonal Clyde Unicycle","authId":"","name":"Diagonal Clyde Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"id":19364339,"name":"Adventure Drone Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Diagonal/Clyde/Unicycle/19364339.jpg","createDate":{"time":1357961780000,"minutes":36,"seconds":20,"hours":22,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Diagonal/Clyde/Unicycle/19364339.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":423,"difficulty":2.111111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":816,"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":"Defiant Minerva Firefly","authId":"","name":"Defiant Minerva Firefly","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Defiant Minerva Firefly","authId":"","name":"Defiant Minerva Firefly","CNNId":"","myGameChains":null,"banStatus":null},"id":19395943,"name":"Patrol Galaxy Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Defiant/Minerva/Firefly/19395943.jpg","createDate":{"time":1358421303000,"minutes":15,"seconds":3,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Defiant/Minerva/Firefly/19395943.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":151,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":527,"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":"Superior Crystal Soldier","authId":"","name":"Superior Crystal Soldier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Crystal Soldier","authId":"","name":"Superior Crystal Soldier","CNNId":"","myGameChains":null,"banStatus":null},"id":18676250,"name":"Champion Brainstorm Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superior/Crystal/Soldier/18676250.jpg","createDate":{"time":1354549791000,"minutes":49,"seconds":51,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superior/Crystal/Soldier/18676250.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":218,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":781,"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":"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 = '5' 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"}}]