[{"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 = '2' 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":"Extinct Eduardo Unicycle","authId":"","name":"Extinct Eduardo Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extinct Eduardo Unicycle","authId":"","name":"Extinct Eduardo Unicycle","CNNId":"","myGameChains":null,"banStatus":null},"id":19503347,"name":"Slam Mega Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extinct/Eduardo/Unicycle/19503347.jpg","createDate":{"time":1360212835000,"minutes":53,"seconds":55,"hours":23,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extinct/Eduardo/Unicycle/19503347.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":483,"difficulty":2.381250373558066,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7771,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.167357,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Southern Gavin Ooze","authId":"","name":"Southern Gavin Ooze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Southern Gavin Ooze","authId":"","name":"Southern Gavin Ooze","CNNId":"","myGameChains":null,"banStatus":null},"id":17811026,"name":"Rustbucket Drone Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Southern/Gavin/Ooze/17811026.jpg","createDate":{"time":1348812037000,"minutes":0,"seconds":37,"hours":2,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Southern/Gavin/Ooze/17811026.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":267,"difficulty":2.375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":466,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.166667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Caleb Sword","authId":"","name":"Strong Caleb Sword","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Caleb Sword","authId":"","name":"Strong Caleb Sword","CNNId":"","myGameChains":null,"banStatus":null},"id":17954063,"name":"Mega Attack Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Caleb/Sword/17954063.jpg","createDate":{"time":1349348092000,"minutes":54,"seconds":52,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Caleb/Sword/17954063.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":251,"difficulty":1.4789115646258504,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2382,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.144444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active George Behemoth","authId":"","name":"Active George Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active George Behemoth","authId":"","name":"Active George Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":18260477,"name":"Humungousaur Rampage Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/George/Behemoth/18260477.jpg","createDate":{"time":1351156920000,"minutes":22,"seconds":0,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/George/Behemoth/18260477.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1054,"difficulty":1.4007766625495157,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2176,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.122874,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Juan Crater","authId":"","name":"Vast Juan Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Juan Crater","authId":"","name":"Vast Juan Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":18088963,"name":"Rustbucket Smash Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Juan/Crater/18088963.jpg","createDate":{"time":1349977893000,"minutes":51,"seconds":33,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Juan/Crater/18088963.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":161,"difficulty":2.505594405594406,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5101,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.121296,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Austin Dragoon","authId":"","name":"Babbling Austin Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Austin Dragoon","authId":"","name":"Babbling Austin Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19906439,"name":"Adventure Fusion Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Austin/Dragoon/19906439.jpg","createDate":{"time":1364216020000,"minutes":53,"seconds":40,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Austin/Dragoon/19906439.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":47,"difficulty":2.7777777777777777,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":568,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":19027319,"name":"Spike Drone Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Edd/Atlas/19027319.jpg","createDate":{"time":1355659906000,"minutes":11,"seconds":46,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Edd/Atlas/19027319.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":354,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Penny Coconut","authId":"","name":"Smelly Penny Coconut","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Penny Coconut","authId":"","name":"Smelly Penny Coconut","CNNId":"","myGameChains":null,"banStatus":null},"id":18226860,"name":"Solar Breaker Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smelly/Penny/Coconut/18226860.jpg","createDate":{"time":1350827880000,"minutes":58,"seconds":0,"hours":9,"month":9,"timezoneOffset":240,"year":112,"day":0,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smelly/Penny/Coconut/18226860.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":159,"difficulty":2.1146384479717812,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4286,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.10254,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Buster Steel","authId":"","name":"Valiant Buster Steel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Buster Steel","authId":"","name":"Valiant Buster Steel","CNNId":"","myGameChains":null,"banStatus":null},"id":18170389,"name":"Rampage Mega Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valiant/Buster/Steel/18170389.jpg","createDate":{"time":1350371169000,"minutes":6,"seconds":9,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valiant/Buster/Steel/18170389.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":474,"difficulty":2.2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":815,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.08,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Lucius Gamer","authId":"","name":"Lunar Lucius Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Lucius Gamer","authId":"","name":"Lunar Lucius Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":18707718,"name":"Champion Vilgax Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lunar/Lucius/Gamer/18707718.jpg","createDate":{"time":1354658596000,"minutes":3,"seconds":16,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lunar/Lucius/Gamer/18707718.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1946,"difficulty":2.2839956918081916,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7348,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.062566,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '2' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]