[{"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 = '7' 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":"Cartoony Ace Alien","authId":"","name":"Cartoony Ace Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Ace Alien","authId":"","name":"Cartoony Ace Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":19517260,"name":"Ultimate Escape Terraspin","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cartoony/Ace/Alien/19517260.jpg","createDate":{"time":1360447247000,"minutes":0,"seconds":47,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cartoony/Ace/Alien/19517260.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2688,"difficulty":2.5415299243153537,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39368,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.481184,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Lester Diamond","authId":"","name":"Ultimate Lester Diamond","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Lester Diamond","authId":"","name":"Ultimate Lester Diamond","CNNId":"","myGameChains":null,"banStatus":null},"id":17456290,"name":"Dark Warrior Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Lester/Diamond/17456290.jpg","createDate":{"time":1347934154000,"minutes":9,"seconds":14,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Lester/Diamond/17456290.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":2.770833333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1010,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.479167,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Alyssa Barnacle","authId":"","name":"Awful Alyssa Barnacle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Alyssa Barnacle","authId":"","name":"Awful Alyssa Barnacle","CNNId":"","myGameChains":null,"banStatus":null},"id":19609095,"name":"Cosmic Mega Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awful/Alyssa/Barnacle/19609095.jpg","createDate":{"time":1361978850000,"minutes":27,"seconds":30,"hours":10,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awful/Alyssa/Barnacle/19609095.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":89,"difficulty":2.4026785714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1773,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.455908,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Genghis Macaw","authId":"","name":"Singular Genghis Macaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Genghis Macaw","authId":"","name":"Singular Genghis Macaw","CNNId":"","myGameChains":null,"banStatus":null},"id":19221982,"name":"Warrior Giga Whirlwind","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Singular/Genghis/Macaw/19221982.jpg","createDate":{"time":1356695698000,"minutes":54,"seconds":58,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Singular/Genghis/Macaw/19221982.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":232,"difficulty":2.8444444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1002,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.447619,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Gretel Bongo","authId":"","name":"Radical Gretel Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Gretel Bongo","authId":"","name":"Radical Gretel Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":18127712,"name":"Mega Mega Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radical/Gretel/Bongo/18127712.jpg","createDate":{"time":1350158582000,"minutes":3,"seconds":2,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radical/Gretel/Bongo/18127712.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":736,"difficulty":2.84,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1080,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.441667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Kaden Dragoon","authId":"","name":"Zany Kaden Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Kaden Dragoon","authId":"","name":"Zany Kaden Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19312120,"name":"Razor Assault Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Kaden/Dragoon/19312120.jpg","createDate":{"time":1357309263000,"minutes":21,"seconds":3,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Kaden/Dragoon/19312120.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11653,"difficulty":2.3556376985875658,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36264,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.412947,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evasive Caden Glitch","authId":"","name":"Evasive Caden Glitch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evasive Caden Glitch","authId":"","name":"Evasive Caden Glitch","CNNId":"","myGameChains":null,"banStatus":null},"id":18469293,"name":"Nova Battle Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evasive/Caden/Glitch/18469293.jpg","createDate":{"time":1352756693000,"minutes":44,"seconds":53,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evasive/Caden/Glitch/18469293.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2039,"difficulty":2.3600730603246083,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6527,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.379766,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Diego Steel","authId":"","name":"Bouncing Diego Steel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Diego Steel","authId":"","name":"Bouncing Diego Steel","CNNId":"","myGameChains":null,"banStatus":null},"id":18127818,"name":"Storm Escape Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Diego/Steel/18127818.jpg","createDate":{"time":1350158790000,"minutes":6,"seconds":30,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Diego/Steel/18127818.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5775,"difficulty":2.500542600703,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34680,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.379319,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Carlos Brine","authId":"","name":"Obvious Carlos Brine","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Carlos Brine","authId":"","name":"Obvious Carlos Brine","CNNId":"","myGameChains":null,"banStatus":null},"id":18513748,"name":"Rock Ambush Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obvious/Carlos/Brine/18513748.jpg","createDate":{"time":1353268579000,"minutes":56,"seconds":19,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obvious/Carlos/Brine/18513748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":785,"difficulty":2.6,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2154,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.36,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Princess Calvin Pulse","authId":"","name":"Princess Calvin Pulse","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Princess Calvin Pulse","authId":"","name":"Princess Calvin Pulse","CNNId":"","myGameChains":null,"banStatus":null},"id":17552262,"name":"Storm Challenge Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Princess/Calvin/Pulse/17552262.jpg","createDate":{"time":1348174789000,"minutes":59,"seconds":49,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Princess/Calvin/Pulse/17552262.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":688,"difficulty":2.2434128834128835,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6099,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.344389,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"51","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 = '7' 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":"60","currentPageToDisplay":6,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]