[{"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 = '14' 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":"Friendly Kayak","authId":"","name":"Friendly Kayak","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Kayak","authId":"","name":"Friendly Kayak","CNNId":"","myGameChains":null,"banStatus":null},"id":19120516,"name":"Space Smash Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Kayak/19120516.jpg","createDate":{"time":1356156119000,"minutes":1,"seconds":59,"hours":1,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Kayak/19120516.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22103,"difficulty":2.231612127389664,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":243643,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.903918,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Pedro Steam","authId":"","name":"Ironic Pedro Steam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Pedro Steam","authId":"","name":"Ironic Pedro Steam","CNNId":"","myGameChains":null,"banStatus":null},"id":18613674,"name":"Droid Adventure Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironic/Pedro/Steam/18613674.jpg","createDate":{"time":1353965681000,"minutes":34,"seconds":41,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironic/Pedro/Steam/18613674.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":798,"difficulty":2.717725648472114,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19759,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.902257,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Exciting Lance Crash","authId":"","name":"Exciting Lance Crash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Exciting Lance Crash","authId":"","name":"Exciting Lance Crash","CNNId":"","myGameChains":null,"banStatus":null},"id":18641383,"name":"Blaster Steel Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Exciting/Lance/Crash/18641383.jpg","createDate":{"time":1354310533000,"minutes":22,"seconds":13,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Exciting/Lance/Crash/18641383.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17847,"difficulty":2.4691764300525585,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":28802,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.898545,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Dominic Vermin","authId":"","name":"Keen Dominic Vermin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Dominic Vermin","authId":"","name":"Keen Dominic Vermin","CNNId":"","myGameChains":null,"banStatus":null},"id":18558828,"name":"Warrior Plumber Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Dominic/Vermin/18558828.jpg","createDate":{"time":1353629534000,"minutes":12,"seconds":14,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Dominic/Vermin/18558828.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4850,"difficulty":2.318776027033749,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13665,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.893434,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peculiar Marvin Riddle","authId":"","name":"Peculiar Marvin Riddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peculiar Marvin Riddle","authId":"","name":"Peculiar Marvin Riddle","CNNId":"","myGameChains":null,"banStatus":null},"id":18963100,"name":"Chase Plumber Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peculiar/Marvin/Riddle/18963100.jpg","createDate":{"time":1355409425000,"minutes":37,"seconds":5,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peculiar/Marvin/Riddle/18963100.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4804,"difficulty":1.4158051555436995,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14502,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.847031,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Colin Galosh","authId":"","name":"Prickly Colin Galosh","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Colin Galosh","authId":"","name":"Prickly Colin Galosh","CNNId":"","myGameChains":null,"banStatus":null},"id":18537655,"name":"Patrol Shock BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prickly/Colin/Galosh/18537655.jpg","createDate":{"time":1353514199000,"minutes":9,"seconds":59,"hours":11,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prickly/Colin/Galosh/18537655.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1898,"difficulty":2.2099014548954,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18221,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.815506,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Mckenzie Skunk","authId":"","name":"Soggy Mckenzie Skunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Mckenzie Skunk","authId":"","name":"Soggy Mckenzie Skunk","CNNId":"","myGameChains":null,"banStatus":null},"id":19477148,"name":"Turbo Blaster Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Soggy/Mckenzie/Skunk/19477148.jpg","createDate":{"time":1359752989000,"minutes":9,"seconds":49,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Soggy/Mckenzie/Skunk/19477148.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27595,"difficulty":1.4840335132857443,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29882,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.797184,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tasteful Shelby Rocket","authId":"","name":"Tasteful Shelby Rocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tasteful Shelby Rocket","authId":"","name":"Tasteful Shelby Rocket","CNNId":"","myGameChains":null,"banStatus":null},"id":19639850,"name":"Humungousaur Challenge Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tasteful/Shelby/Rocket/19639850.jpg","createDate":{"time":1362642981000,"minutes":56,"seconds":21,"hours":2,"month":2,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tasteful/Shelby/Rocket/19639850.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17429,"difficulty":2.2511676132345357,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":60795,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.794101,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dazzling Madelyn Scribble","authId":"","name":"Dazzling Madelyn Scribble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dazzling Madelyn Scribble","authId":"","name":"Dazzling Madelyn Scribble","CNNId":"","myGameChains":null,"banStatus":null},"id":18613853,"name":"Quake Ultimate Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dazzling/Madelyn/Scribble/18613853.jpg","createDate":{"time":1353967080000,"minutes":58,"seconds":0,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dazzling/Madelyn/Scribble/18613853.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11520,"difficulty":2.291082601916761,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18541,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.792721,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Mandy Wiffle","authId":"","name":"Peppy Mandy Wiffle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Mandy Wiffle","authId":"","name":"Peppy Mandy Wiffle","CNNId":"","myGameChains":null,"banStatus":null},"id":19558113,"name":"Bloxx Metal Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peppy/Mandy/Wiffle/19558113.jpg","createDate":{"time":1361117272000,"minutes":7,"seconds":52,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peppy/Mandy/Wiffle/19558113.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16382,"difficulty":1.2522953964802703,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21846,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.786604,"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 = '14' 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"}}]