[{"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 = '12' 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":"Grim Josiah Cyclone","authId":"","name":"Grim Josiah Cyclone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Josiah Cyclone","authId":"","name":"Grim Josiah Cyclone","CNNId":"","myGameChains":null,"banStatus":null},"id":17548229,"name":"Cosmic Nitro Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grim/Josiah/Cyclone/17548229.jpg","createDate":{"time":1348166936000,"minutes":48,"seconds":56,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grim/Josiah/Cyclone/17548229.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17,"difficulty":2.6419270833333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3316,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.600305,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Harry Fandango","authId":"","name":"Majestic Harry Fandango","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Harry Fandango","authId":"","name":"Majestic Harry Fandango","CNNId":"","myGameChains":null,"banStatus":null},"id":17551651,"name":"Smash Hex Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/Harry/Fandango/17551651.jpg","createDate":{"time":1348174032000,"minutes":47,"seconds":12,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/Harry/Fandango/17551651.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":303,"difficulty":2.0264462809917356,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3727,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.578512,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Benton Gamer","authId":"","name":"Average Benton Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Benton Gamer","authId":"","name":"Average Benton Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":19326757,"name":"Titan Dark Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Benton/Gamer/19326757.jpg","createDate":{"time":1357424547000,"minutes":22,"seconds":27,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Benton/Gamer/19326757.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":497,"difficulty":2.221219256933543,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4883,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.562211,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Zach Llama","authId":"","name":"Flying Zach Llama","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Zach Llama","authId":"","name":"Flying Zach Llama","CNNId":"","myGameChains":null,"banStatus":null},"id":18641473,"name":"Nitro Iron Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Zach/Llama/18641473.jpg","createDate":{"time":1354311138000,"minutes":32,"seconds":18,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Zach/Llama/18641473.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11518,"difficulty":1.5719197315047193,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34242,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.552086,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Robert Golem","authId":"","name":"General Robert Golem","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Robert Golem","authId":"","name":"General Robert Golem","CNNId":"","myGameChains":null,"banStatus":null},"id":19861086,"name":"Attack Attack Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Robert/Golem/19861086.jpg","createDate":{"time":1363957759000,"minutes":9,"seconds":19,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Robert/Golem/19861086.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3434,"difficulty":1.4415368634881687,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6073,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.527058,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Ramona Confetti","authId":"","name":"Bumbling Ramona Confetti","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Ramona Confetti","authId":"","name":"Bumbling Ramona Confetti","CNNId":"","myGameChains":null,"banStatus":null},"id":18287448,"name":"Atomic Techno Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bumbling/Ramona/Confetti/18287448.jpg","createDate":{"time":1351357749000,"minutes":9,"seconds":9,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bumbling/Ramona/Confetti/18287448.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":284,"difficulty":1.92,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2803,"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":"Artful Ace","authId":"","name":"Artful Ace","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Ace","authId":"","name":"Artful Ace","CNNId":"","myGameChains":null,"banStatus":null},"id":19504829,"name":"Charge Lightning Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artful/Ace/19504829.jpg","createDate":{"time":1360258802000,"minutes":40,"seconds":2,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artful/Ace/19504829.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9478,"difficulty":2.452296110328876,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37347,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.49376,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Edgar Dragon","authId":"","name":"King Edgar Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Edgar Dragon","authId":"","name":"King Edgar Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":19606132,"name":"Adventure Solar Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Edgar/Dragon/19606132.jpg","createDate":{"time":1361896271000,"minutes":31,"seconds":11,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Edgar/Dragon/19606132.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1064,"difficulty":1.1911111111111112,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3564,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.484298,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lanky Baxter Basilisk","authId":"","name":"Lanky Baxter Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lanky Baxter Basilisk","authId":"","name":"Lanky Baxter Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":17545525,"name":"Burst Stone Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lanky/Baxter/Basilisk/17545525.jpg","createDate":{"time":1348158440000,"minutes":27,"seconds":20,"hours":12,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lanky/Baxter/Basilisk/17545525.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2380,"difficulty":2.059580647565019,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2652,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.457923,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Dylan Blizzard","authId":"","name":"Crispy Dylan Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Dylan Blizzard","authId":"","name":"Crispy Dylan Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":18406463,"name":"Turbo Adventure Water","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crispy/Dylan/Blizzard/18406463.jpg","createDate":{"time":1352246410000,"minutes":0,"seconds":10,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crispy/Dylan/Blizzard/18406463.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1551,"difficulty":2.4388888888888887,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3416,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.391667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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 = '12' 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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]