[{"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 = '3' 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":"Obscure Isaac Lime","authId":"","name":"Obscure Isaac Lime","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Isaac Lime","authId":"","name":"Obscure Isaac Lime","CNNId":"","myGameChains":null,"banStatus":null},"id":18749714,"name":"Battle Clash Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obscure/Isaac/Lime/18749714.jpg","createDate":{"time":1354798737000,"minutes":58,"seconds":57,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obscure/Isaac/Lime/18749714.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5384,"difficulty":2.475231848237965,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18217,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.619714,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Vinny Hydra","authId":"","name":"Fiery Vinny Hydra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Vinny Hydra","authId":"","name":"Fiery Vinny Hydra","CNNId":"","myGameChains":null,"banStatus":null},"id":19208524,"name":"Ben BallWeevil Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Vinny/Hydra/19208524.jpg","createDate":{"time":1356614736000,"minutes":25,"seconds":36,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Vinny/Hydra/19208524.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":166,"difficulty":2.557182211727666,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7282,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.610823,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Rob Rutabaga","authId":"","name":"King Rob Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Rob Rutabaga","authId":"","name":"King Rob Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"id":19500584,"name":"Beast Adventure Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Rob/Rutabaga/19500584.jpg","createDate":{"time":1360166594000,"minutes":3,"seconds":14,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Rob/Rutabaga/19500584.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":380,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2327,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.60625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Rigby Javelin","authId":"","name":"Ancient Rigby Javelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Rigby Javelin","authId":"","name":"Ancient Rigby Javelin","CNNId":"","myGameChains":null,"banStatus":null},"id":19402729,"name":"Rustbucket Hyper Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Rigby/Javelin/19402729.jpg","createDate":{"time":1358547412000,"minutes":16,"seconds":52,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Rigby/Javelin/19402729.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3250,"difficulty":1.7048254383521495,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15223,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.591569,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Payten Blubber","authId":"","name":"Grubby Payten Blubber","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Payten Blubber","authId":"","name":"Grubby Payten Blubber","CNNId":"","myGameChains":null,"banStatus":null},"id":18538490,"name":"Lightning Energy Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grubby/Payten/Blubber/18538490.jpg","createDate":{"time":1353518496000,"minutes":21,"seconds":36,"hours":12,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grubby/Payten/Blubber/18538490.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":663,"difficulty":2.617922443291825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11805,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.581986,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Mason Electron","authId":"","name":"Dubious Mason Electron","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Mason Electron","authId":"","name":"Dubious Mason Electron","CNNId":"","myGameChains":null,"banStatus":null},"id":18558974,"name":"Quake Mission Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dubious/Mason/Electron/18558974.jpg","createDate":{"time":1353630134000,"minutes":22,"seconds":14,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dubious/Mason/Electron/18558974.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1808,"difficulty":2.7445884843811457,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15641,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.576702,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Bucky Pirate","authId":"","name":"Luminous Bucky Pirate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Bucky Pirate","authId":"","name":"Luminous Bucky Pirate","CNNId":"","myGameChains":null,"banStatus":null},"id":19475506,"name":"Fury Breaker Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Luminous/Bucky/Pirate/19475506.jpg","createDate":{"time":1359723534000,"minutes":58,"seconds":54,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Luminous/Bucky/Pirate/19475506.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2223,"difficulty":2.3052034623420554,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4410,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.573868,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crunchy Tyrone Crowbar","authId":"","name":"Crunchy Tyrone Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crunchy Tyrone Crowbar","authId":"","name":"Crunchy Tyrone Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"id":19539344,"name":"Breaker Ambush Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crunchy/Tyrone/Crowbar/19539344.jpg","createDate":{"time":1360844626000,"minutes":23,"seconds":46,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crunchy/Tyrone/Crowbar/19539344.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2540,"difficulty":2.7742257294234496,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34655,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.568738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Joshua Viking","authId":"","name":"Bouncing Joshua Viking","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Joshua Viking","authId":"","name":"Bouncing Joshua Viking","CNNId":"","myGameChains":null,"banStatus":null},"id":19532773,"name":"Solar Slam Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Joshua/Viking/19532773.jpg","createDate":{"time":1360708056000,"minutes":27,"seconds":36,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Joshua/Viking/19532773.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2249,"difficulty":2.703657890435457,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5130,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.553344,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Benson Toboggan","authId":"","name":"King Benson Toboggan","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Benson Toboggan","authId":"","name":"King Benson Toboggan","CNNId":"","myGameChains":null,"banStatus":null},"id":19505452,"name":"Shock Charge Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Benson/Toboggan/19505452.jpg","createDate":{"time":1360270997000,"minutes":3,"seconds":17,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Benson/Toboggan/19505452.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1998,"difficulty":2.5289256198347108,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2849,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.544643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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 = '3' 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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]