[{"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 = '6' 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":"Spotted Finn Nebula","authId":"","name":"Spotted Finn Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spotted Finn Nebula","authId":"","name":"Spotted Finn Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":19472341,"name":"Plasma Vilgax Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spotted/Finn/Nebula/19472341.jpg","createDate":{"time":1359640557000,"minutes":55,"seconds":57,"hours":8,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spotted/Finn/Nebula/19472341.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":409,"difficulty":2.1122222222222224,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3406,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.611111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Solid William Snowball","authId":"","name":"Solid William Snowball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solid William Snowball","authId":"","name":"Solid William Snowball","CNNId":"","myGameChains":null,"banStatus":null},"id":19027327,"name":"Big Waterhazard Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solid/William/Snowball/19027327.jpg","createDate":{"time":1355659959000,"minutes":12,"seconds":39,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solid/William/Snowball/19027327.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":111,"difficulty":2.520923520923521,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6097,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.602401,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Jamie Fury","authId":"","name":"Jolly Jamie Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Jamie Fury","authId":"","name":"Jolly Jamie Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":19413701,"name":"Ultimate Fusion Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Jamie/Fury/19413701.jpg","createDate":{"time":1358682883000,"minutes":54,"seconds":43,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Jamie/Fury/19413701.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":711,"difficulty":2.4827898027898025,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8480,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.60202,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"id":17216392,"name":"Rock Echo Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vague/Avery/Parallax/17216392.jpg","createDate":{"time":1342179241000,"minutes":34,"seconds":1,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vague/Avery/Parallax/17216392.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4994,"difficulty":1.2407375214486016,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12126,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.601423,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Geoff Beast","authId":"","name":"Amazing Geoff Beast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Geoff Beast","authId":"","name":"Amazing Geoff Beast","CNNId":"","myGameChains":null,"banStatus":null},"id":19967807,"name":"Adventure Dark Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Geoff/Beast/19967807.jpg","createDate":{"time":1364648285000,"minutes":58,"seconds":5,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Geoff/Beast/19967807.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14627,"difficulty":2.100421848442931,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16535,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.594911,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Ryan Dynamite","authId":"","name":"Alien Ryan Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Ryan Dynamite","authId":"","name":"Alien Ryan Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"id":19526875,"name":"Adventure Ultimate Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Ryan/Dynamite/19526875.jpg","createDate":{"time":1360586348000,"minutes":39,"seconds":8,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Ryan/Dynamite/19526875.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":796,"difficulty":2.5952380952380953,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8760,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.585589,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Daniel Halo","authId":"","name":"Brawny Daniel Halo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Daniel Halo","authId":"","name":"Brawny Daniel Halo","CNNId":"","myGameChains":null,"banStatus":null},"id":19402723,"name":"Waterhazard Iron Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brawny/Daniel/Halo/19402723.jpg","createDate":{"time":1358547399000,"minutes":16,"seconds":39,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brawny/Daniel/Halo/19402723.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4591,"difficulty":2.638333016118365,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9917,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.585485,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Lance Zombie","authId":"","name":"Earnest Lance Zombie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Lance Zombie","authId":"","name":"Earnest Lance Zombie","CNNId":"","myGameChains":null,"banStatus":null},"id":19520618,"name":"Waterhazard Spike Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Lance/Zombie/19520618.jpg","createDate":{"time":1360495742000,"minutes":29,"seconds":2,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Lance/Zombie/19520618.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":409,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2133,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.583333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Cody Gator","authId":"","name":"Roaring Cody Gator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Cody Gator","authId":"","name":"Roaring Cody Gator","CNNId":"","myGameChains":null,"banStatus":null},"id":18782692,"name":"Energy Fire Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Roaring/Cody/Gator/18782692.jpg","createDate":{"time":1354911295000,"minutes":14,"seconds":55,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Roaring/Cody/Gator/18782692.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1029,"difficulty":2.0845301757066466,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2403,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.583249,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Amber Dragon","authId":"","name":"Haunted Amber Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Amber Dragon","authId":"","name":"Haunted Amber Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":19615298,"name":"Echo Smash Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Haunted/Amber/Dragon/19615298.jpg","createDate":{"time":1362142135000,"minutes":48,"seconds":55,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Haunted/Amber/Dragon/19615298.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25988,"difficulty":2.6491659117969486,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":35724,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.581075,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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 = '6' 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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]