[{"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":"Superb Ken Magma","authId":"","name":"Superb Ken Magma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Ken Magma","authId":"","name":"Superb Ken Magma","CNNId":"","myGameChains":null,"banStatus":null},"id":17216358,"name":"Rush Adventure Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superb/Ken/Magma/17216358.jpg","createDate":{"time":1342177927000,"minutes":12,"seconds":7,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superb/Ken/Magma/17216358.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":207,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":711,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Kathleen Typhoon","authId":"","name":"Leaping Kathleen Typhoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Kathleen Typhoon","authId":"","name":"Leaping Kathleen Typhoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19363936,"name":"Waterhazard Waterhazard Waterhazard","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Leaping/Kathleen/Typhoon/19363936.jpg","createDate":{"time":1357957600000,"minutes":26,"seconds":40,"hours":21,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Leaping/Kathleen/Typhoon/19363936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":737,"difficulty":2.331269841269841,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":780,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.439732,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Jenna Zeppelin","authId":"","name":"Smelly Jenna Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Jenna Zeppelin","authId":"","name":"Smelly Jenna Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"id":19102167,"name":"Nano Hyper Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smelly/Jenna/Zeppelin/19102167.jpg","createDate":{"time":1356066453000,"minutes":7,"seconds":33,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smelly/Jenna/Zeppelin/19102167.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41700,"difficulty":1.9276531922830848,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":138882,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.390411,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Hercules Parrot","authId":"","name":"General Hercules Parrot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Hercules Parrot","authId":"","name":"General Hercules Parrot","CNNId":"","myGameChains":null,"banStatus":null},"id":18425305,"name":"Ambush Rustbucket Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Hercules/Parrot/18425305.jpg","createDate":{"time":1352480082000,"minutes":54,"seconds":42,"hours":11,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Hercules/Parrot/18425305.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25174,"difficulty":1.5723215715905439,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":68114,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.335766,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Cameron","authId":"","name":"Powerful Cameron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Powerful Cameron","authId":"","name":"Powerful Cameron","CNNId":"","myGameChains":null,"banStatus":null},"id":18349904,"name":"Hex Invasion Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Powerful/Cameron/18349904.jpg","createDate":{"time":1351865161000,"minutes":6,"seconds":1,"hours":10,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Powerful/Cameron/18349904.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23657,"difficulty":1.4988248495262282,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":103244,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.314484,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Aiden Amethyst","authId":"","name":"Venomous Aiden Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Aiden Amethyst","authId":"","name":"Venomous Aiden Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"id":17693289,"name":"Charge Adventure Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Venomous/Aiden/Amethyst/17693289.jpg","createDate":{"time":1348406891000,"minutes":28,"seconds":11,"hours":9,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Venomous/Aiden/Amethyst/17693289.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7916,"difficulty":1.6965573103070242,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":105945,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.302728,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Adjacent Zoe Aardvark","authId":"","name":"Adjacent Zoe Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Adjacent Zoe Aardvark","authId":"","name":"Adjacent Zoe Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":19331330,"name":"Whirlwind Ultra Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Adjacent/Zoe/Aardvark/19331330.jpg","createDate":{"time":1357473100000,"minutes":51,"seconds":40,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Adjacent/Zoe/Aardvark/19331330.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":418,"difficulty":2.411940829843643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5975,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.291033,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Bobby Centaur","authId":"","name":"Speedy Bobby Centaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Bobby Centaur","authId":"","name":"Speedy Bobby Centaur","CNNId":"","myGameChains":null,"banStatus":null},"id":17216230,"name":"Hyper Rescue Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Bobby/Centaur/17216230.jpg","createDate":{"time":1342171092000,"minutes":18,"seconds":12,"hours":5,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Bobby/Centaur/17216230.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1341,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.28,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Steven Rutabaga","authId":"","name":"Chaotic Steven Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chaotic Steven Rutabaga","authId":"","name":"Chaotic Steven Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"id":18098390,"name":"Universe Danger Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chaotic/Steven/Rutabaga/18098390.jpg","createDate":{"time":1350038214000,"minutes":36,"seconds":54,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chaotic/Steven/Rutabaga/18098390.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1770,"difficulty":2.0914673142993148,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18985,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.164521,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Val Yoyo","authId":"","name":"Genuine Val Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Val Yoyo","authId":"","name":"Genuine Val Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19906726,"name":"Adventure Crusher Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Genuine/Val/Yoyo/19906726.jpg","createDate":{"time":1364218412000,"minutes":33,"seconds":32,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Genuine/Val/Yoyo/19906726.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":148,"difficulty":2.583333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":416,"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}],"descending":false,"beginRecordId":"131","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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]