[{"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":"Radiant Tom Gorilla","authId":"","name":"Radiant Tom Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radiant Tom Gorilla","authId":"","name":"Radiant Tom Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":19545940,"name":"Laser Brainstorm Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radiant/Tom/Gorilla/19545940.jpg","createDate":{"time":1360966755000,"minutes":19,"seconds":15,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radiant/Tom/Gorilla/19545940.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":165,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":497,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Jack Jupiter","authId":"","name":"Alien Jack Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Jack Jupiter","authId":"","name":"Alien Jack Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":19806800,"name":"Galaxy Crusher Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Jack/Jupiter/19806800.jpg","createDate":{"time":1363555430000,"minutes":23,"seconds":50,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Jack/Jupiter/19806800.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":245,"difficulty":2.2108843537414966,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":687,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bogus Angelica Dingbat","authId":"","name":"Bogus Angelica Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bogus Angelica Dingbat","authId":"","name":"Bogus Angelica Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"id":19472322,"name":"Hex Warp Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bogus/Angelica/Dingbat/19472322.jpg","createDate":{"time":1359639858000,"minutes":44,"seconds":18,"hours":8,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bogus/Angelica/Dingbat/19472322.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":150,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":515,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Gregory Skunk","authId":"","name":"Humorous Gregory Skunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Gregory Skunk","authId":"","name":"Humorous Gregory Skunk","CNNId":"","myGameChains":null,"banStatus":null},"id":18640330,"name":"Adventure Vilgax Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humorous/Gregory/Skunk/18640330.jpg","createDate":{"time":1354303147000,"minutes":19,"seconds":7,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humorous/Gregory/Skunk/18640330.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":107,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":487,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Andrew Goblin","authId":"","name":"Loud Andrew Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Andrew Goblin","authId":"","name":"Loud Andrew Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17810802,"name":"Humungousaur Ambush Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Andrew/Goblin/17810802.jpg","createDate":{"time":1348808699000,"minutes":4,"seconds":59,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Andrew/Goblin/17810802.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":135,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":511,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King DJ Bazooka","authId":"","name":"King DJ Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King DJ Bazooka","authId":"","name":"King DJ Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"id":18984318,"name":"Rescue Warrior Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/DJ/Bazooka/18984318.jpg","createDate":{"time":1355522621000,"minutes":3,"seconds":41,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/DJ/Bazooka/18984318.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30784,"difficulty":2.060259060644708,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":64110,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.868226,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sassy Joseph Nacho","authId":"","name":"Sassy Joseph Nacho","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sassy Joseph Nacho","authId":"","name":"Sassy Joseph Nacho","CNNId":"","myGameChains":null,"banStatus":null},"id":19861099,"name":"Adventure Assault Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sassy/Joseph/Nacho/19861099.jpg","createDate":{"time":1363957842000,"minutes":10,"seconds":42,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sassy/Joseph/Nacho/19861099.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6875,"difficulty":2.4293853689443003,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26560,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.850817,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Brandi Blammo","authId":"","name":"Captain Brandi Blammo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Brandi Blammo","authId":"","name":"Captain Brandi Blammo","CNNId":"","myGameChains":null,"banStatus":null},"id":18488358,"name":"Mega Atomic Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Brandi/Blammo/18488358.jpg","createDate":{"time":1353023565000,"minutes":52,"seconds":45,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Brandi/Blammo/18488358.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153,"difficulty":2.875,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":508,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.75,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Daniel Eel","authId":"","name":"Flying Daniel Eel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Daniel Eel","authId":"","name":"Flying Daniel Eel","CNNId":"","myGameChains":null,"banStatus":null},"id":19180262,"name":"Energy Pulse Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Daniel/Eel/19180262.jpg","createDate":{"time":1356385992000,"minutes":53,"seconds":12,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Daniel/Eel/19180262.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1869,"difficulty":2.495145117765873,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37128,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.737586,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Nicholas Pizza","authId":"","name":"Tough Nicholas Pizza","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Nicholas Pizza","authId":"","name":"Tough Nicholas Pizza","CNNId":"","myGameChains":null,"banStatus":null},"id":19251373,"name":"Brainstorm Star Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tough/Nicholas/Pizza/19251373.jpg","createDate":{"time":1356869364000,"minutes":9,"seconds":24,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tough/Nicholas/Pizza/19251373.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4294,"difficulty":2.4028476887209353,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18088,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.729617,"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 = '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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]