[{"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":"Nautical David Cyborg","authId":"","name":"Nautical David Cyborg","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nautical David Cyborg","authId":"","name":"Nautical David Cyborg","CNNId":"","myGameChains":null,"banStatus":null},"id":17736690,"name":"Breaker Quake Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nautical/David/Cyborg/17736690.jpg","createDate":{"time":1348461767000,"minutes":42,"seconds":47,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nautical/David/Cyborg/17736690.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2337,"difficulty":2.1235600714214375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18472,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.717196,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Vincent Lizard","authId":"","name":"Super Vincent Lizard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Vincent Lizard","authId":"","name":"Super Vincent Lizard","CNNId":"","myGameChains":null,"banStatus":null},"id":17545529,"name":"Challenge Pursuit Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Vincent/Lizard/17545529.jpg","createDate":{"time":1348158478000,"minutes":27,"seconds":58,"hours":12,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Vincent/Lizard/17545529.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3035,"difficulty":2.451830220247951,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36116,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.717109,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Craig Maestro","authId":"","name":"Ironic Craig Maestro","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Craig Maestro","authId":"","name":"Ironic Craig Maestro","CNNId":"","myGameChains":null,"banStatus":null},"id":17813308,"name":"Patrol Pulse Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironic/Craig/Maestro/17813308.jpg","createDate":{"time":1348832384000,"minutes":39,"seconds":44,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironic/Craig/Maestro/17813308.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2759,"difficulty":2.669376644699588,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12369,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.715126,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Luke Fireball","authId":"","name":"Ghastly Luke Fireball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Luke Fireball","authId":"","name":"Ghastly Luke Fireball","CNNId":"","myGameChains":null,"banStatus":null},"id":17792853,"name":"Rocket Alien Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghastly/Luke/Fireball/17792853.jpg","createDate":{"time":1348714401000,"minutes":53,"seconds":21,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghastly/Luke/Fireball/17792853.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1394,"difficulty":2.437193353372951,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14145,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.713595,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Zach Steam","authId":"","name":"Cagey Zach Steam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Zach Steam","authId":"","name":"Cagey Zach Steam","CNNId":"","myGameChains":null,"banStatus":null},"id":17549210,"name":"Blaster Clash Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cagey/Zach/Steam/17549210.jpg","createDate":{"time":1348169641000,"minutes":34,"seconds":1,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cagey/Zach/Steam/17549210.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1170,"difficulty":2.3064751970176762,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11314,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.711342,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stunning Mark","authId":"","name":"Stunning Mark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stunning Mark","authId":"","name":"Stunning Mark","CNNId":"","myGameChains":null,"banStatus":null},"id":17542192,"name":"Mega Challenge Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stunning/Mark/17542192.jpg","createDate":{"time":1348148740000,"minutes":45,"seconds":40,"hours":9,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stunning/Mark/17542192.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5876,"difficulty":2.382921968757022,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47418,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.707836,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Golden Max Hedgehog","authId":"","name":"Golden Max Hedgehog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Golden Max Hedgehog","authId":"","name":"Golden Max Hedgehog","CNNId":"","myGameChains":null,"banStatus":null},"id":17576641,"name":"Dark Alien Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Golden/Max/Hedgehog/17576641.jpg","createDate":{"time":1348234118000,"minutes":28,"seconds":38,"hours":9,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Golden/Max/Hedgehog/17576641.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":810,"difficulty":1.6652115469906652,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7399,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.706172,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Reuben Robot","authId":"","name":"Ultimate Reuben Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Reuben Robot","authId":"","name":"Ultimate Reuben Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":18127360,"name":"Burst Smash Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Reuben/Robot/18127360.jpg","createDate":{"time":1350157908000,"minutes":51,"seconds":48,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Reuben/Robot/18127360.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1869,"difficulty":2.633694827294297,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17504,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.705663,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Adept Matt Tsunami","authId":"","name":"Adept Matt Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Adept Matt Tsunami","authId":"","name":"Adept Matt Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"id":18106368,"name":"Fusion Battle Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Adept/Matt/Tsunami/18106368.jpg","createDate":{"time":1350078157000,"minutes":42,"seconds":37,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Adept/Matt/Tsunami/18106368.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":97,"difficulty":2.9018270760780434,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":69682,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.703021,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Benson Sword","authId":"","name":"Ancient Benson Sword","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Benson Sword","authId":"","name":"Ancient Benson Sword","CNNId":"","myGameChains":null,"banStatus":null},"id":17542587,"name":"Ultimate Mega Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Benson/Sword/17542587.jpg","createDate":{"time":1348149954000,"minutes":5,"seconds":54,"hours":10,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Benson/Sword/17542587.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1602,"difficulty":1.7338169455816514,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3003,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.70019,"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 = '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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]