[{"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 = '16' 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":"Galactic Herman Mutant","authId":"","name":"Galactic Herman Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Herman Mutant","authId":"","name":"Galactic Herman Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":19671664,"name":"Doom Nova Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Herman/Mutant/19671664.jpg","createDate":{"time":1363040993000,"minutes":29,"seconds":53,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Herman/Mutant/19671664.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8321,"difficulty":2.61511560426524,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57184,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.584882,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hypnotic Madison Brick","authId":"","name":"Hypnotic Madison Brick","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hypnotic Madison Brick","authId":"","name":"Hypnotic Madison Brick","CNNId":"","myGameChains":null,"banStatus":null},"id":19816502,"name":"Omniverse Doom Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hypnotic/Madison/Brick/19816502.jpg","createDate":{"time":1363611753000,"minutes":2,"seconds":33,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hypnotic/Madison/Brick/19816502.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":87,"difficulty":2.611111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1540,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.57672,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Benjamin Mutant","authId":"","name":"Zany Benjamin Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Benjamin Mutant","authId":"","name":"Zany Benjamin Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":19688731,"name":"Kickin' Hawk Breaker Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Benjamin/Mutant/19688731.jpg","createDate":{"time":1363115731000,"minutes":15,"seconds":31,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Benjamin/Mutant/19688731.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1723,"difficulty":2.344112894493864,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19074,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.575935,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Alvin Mantis","authId":"","name":"Shiny Alvin Mantis","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Alvin Mantis","authId":"","name":"Shiny Alvin Mantis","CNNId":"","myGameChains":null,"banStatus":null},"id":19688417,"name":"Sonic Turbo Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Alvin/Mantis/19688417.jpg","createDate":{"time":1363114851000,"minutes":0,"seconds":51,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Alvin/Mantis/19688417.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":209,"difficulty":2.5228956228956227,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2162,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.575694,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Adrian Atom","authId":"","name":"Athletic Adrian Atom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Adrian Atom","authId":"","name":"Athletic Adrian Atom","CNNId":"","myGameChains":null,"banStatus":null},"id":19691028,"name":"Escape Adventure Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Adrian/Atom/19691028.jpg","createDate":{"time":1363120966000,"minutes":42,"seconds":46,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Adrian/Atom/19691028.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":921,"difficulty":2.732538811485007,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22229,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.572778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Austin Skeleton","authId":"","name":"Academic Austin Skeleton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Austin Skeleton","authId":"","name":"Academic Austin Skeleton","CNNId":"","myGameChains":null,"banStatus":null},"id":19705636,"name":"Kickin' Hawk Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Austin/Skeleton/19705636.jpg","createDate":{"time":1363188861000,"minutes":34,"seconds":21,"hours":11,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Austin/Skeleton/19705636.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34792,"difficulty":2.6653344058858055,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":491009,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.567173,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Joel Fiddle","authId":"","name":"Sturdy Joel Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Joel Fiddle","authId":"","name":"Sturdy Joel Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"id":19661157,"name":"Atomic Charge Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Joel/Fiddle/19661157.jpg","createDate":{"time":1363011495000,"minutes":18,"seconds":15,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Joel/Fiddle/19661157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11556,"difficulty":1.6751849095955316,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":69776,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.566796,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Augustus Blade","authId":"","name":"Sergeant Augustus Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Augustus Blade","authId":"","name":"Sergeant Augustus Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":19721046,"name":"Target Escape Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sergeant/Augustus/Blade/19721046.jpg","createDate":{"time":1363258783000,"minutes":59,"seconds":43,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sergeant/Augustus/Blade/19721046.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1237,"difficulty":2.3507282702888537,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1868,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.563358,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Leonard Kungfu","authId":"","name":"Tough Leonard Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Leonard Kungfu","authId":"","name":"Tough Leonard Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":19690494,"name":"Atomic Kickin' Hawk Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tough/Leonard/Kungfu/19690494.jpg","createDate":{"time":1363119980000,"minutes":26,"seconds":20,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tough/Leonard/Kungfu/19690494.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9,"difficulty":2.6677234530175706,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5117,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.559405,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Nevaeh Calliope","authId":"","name":"Ghastly Nevaeh Calliope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Nevaeh Calliope","authId":"","name":"Ghastly Nevaeh Calliope","CNNId":"","myGameChains":null,"banStatus":null},"id":19831685,"name":"Chill Patrol Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghastly/Nevaeh/Calliope/19831685.jpg","createDate":{"time":1363716088000,"minutes":1,"seconds":28,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghastly/Nevaeh/Calliope/19831685.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":739,"difficulty":1.7677797039780323,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12968,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.552023,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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 = '16' 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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]