[{"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":"Blustery Beau Cartoon","authId":"","name":"Blustery Beau Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Beau Cartoon","authId":"","name":"Blustery Beau Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18783636,"name":"Cannonbolt Thunder Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blustery/Beau/Cartoon/18783636.jpg","createDate":{"time":1354913193000,"minutes":46,"seconds":33,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blustery/Beau/Cartoon/18783636.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":237,"difficulty":1.5214285714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1706,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.76,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Ezekiel Samurai","authId":"","name":"Ancient Ezekiel Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Ezekiel Samurai","authId":"","name":"Ancient Ezekiel Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":17216514,"name":"Dark Thunder Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Ezekiel/Samurai/17216514.jpg","createDate":{"time":1342183196000,"minutes":39,"seconds":56,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Ezekiel/Samurai/17216514.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6764,"difficulty":2.2149162078987574,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9609,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.754127,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Trevor Plankton","authId":"","name":"Shaggy Trevor Plankton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Trevor Plankton","authId":"","name":"Shaggy Trevor Plankton","CNNId":"","myGameChains":null,"banStatus":null},"id":17810670,"name":"Cannonbolt Rumble Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Trevor/Plankton/17810670.jpg","createDate":{"time":1348807172000,"minutes":39,"seconds":32,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Trevor/Plankton/17810670.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":58,"difficulty":2.3625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2130,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.754018,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jessica Javelin","authId":"","name":"Jessica Javelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jessica Javelin","authId":"","name":"Jessica Javelin","CNNId":"","myGameChains":null,"banStatus":null},"id":18749922,"name":"Echo Lightning Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jessica/Javelin/18749922.jpg","createDate":{"time":1354799728000,"minutes":15,"seconds":28,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jessica/Javelin/18749922.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5335,"difficulty":2.166616763966706,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29314,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.747258,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Ernie Goblin","authId":"","name":"Dandy Ernie Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Ernie Goblin","authId":"","name":"Dandy Ernie Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17813369,"name":"Streak Pulse Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dandy/Ernie/Goblin/17813369.jpg","createDate":{"time":1348832856000,"minutes":47,"seconds":36,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dandy/Ernie/Goblin/17813369.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29799,"difficulty":2.107319908469317,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61537,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.735782,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hypnotic Felix Twilight","authId":"","name":"Hypnotic Felix Twilight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hypnotic Felix Twilight","authId":"","name":"Hypnotic Felix Twilight","CNNId":"","myGameChains":null,"banStatus":null},"id":17216497,"name":"Chase Warp Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hypnotic/Felix/Twilight/17216497.jpg","createDate":{"time":1342182419000,"minutes":26,"seconds":59,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hypnotic/Felix/Twilight/17216497.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":805,"difficulty":2.2715072805981897,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1864,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.732143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Nicholas Martian","authId":"","name":"Complex Nicholas Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Nicholas Martian","authId":"","name":"Complex Nicholas Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":17216063,"name":"Shadow Mission Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Complex/Nicholas/Martian/17216063.jpg","createDate":{"time":1342161589000,"minutes":39,"seconds":49,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Complex/Nicholas/Martian/17216063.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5773,"difficulty":2.289621917370597,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8095,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":6,"rating":4.729854,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Devon Universe","authId":"","name":"Bouncing Devon Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Devon Universe","authId":"","name":"Bouncing Devon Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":17944264,"name":"Plumber Adventure Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Devon/Universe/17944264.jpg","createDate":{"time":1349284116000,"minutes":8,"seconds":36,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Devon/Universe/17944264.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":525,"difficulty":2.8095238095238093,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4243,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.709375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Ana Rhombus","authId":"","name":"Magical Ana Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Ana Rhombus","authId":"","name":"Magical Ana Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"id":18351605,"name":"Doom Mission Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magical/Ana/Rhombus/18351605.jpg","createDate":{"time":1351879815000,"minutes":10,"seconds":15,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magical/Ana/Rhombus/18351605.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1380,"difficulty":2.555990082884827,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":46446,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.69941,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Kenneth Foul","authId":"","name":"Captain Kenneth Foul","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Kenneth Foul","authId":"","name":"Captain Kenneth Foul","CNNId":"","myGameChains":null,"banStatus":null},"id":19489412,"name":"Patrol Ambush Cannonbolt","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Kenneth/Foul/19489412.jpg","createDate":{"time":1359918628000,"minutes":10,"seconds":28,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Kenneth/Foul/19489412.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":442,"difficulty":2.55476454028905,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25988,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.693703,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"11","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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]