[{"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":"Cunning Rob Tornado","authId":"","name":"Cunning Rob Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cunning Rob Tornado","authId":"","name":"Cunning Rob Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19707572,"name":"Rampage Kickin' Hawk Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cunning/Rob/Tornado/19707572.jpg","createDate":{"time":1363196902000,"minutes":48,"seconds":22,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cunning/Rob/Tornado/19707572.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2378,"difficulty":2.806109682699098,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37905,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.324823,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Rex Equinox","authId":"","name":"Shaggy Rex Equinox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Rex Equinox","authId":"","name":"Shaggy Rex Equinox","CNNId":"","myGameChains":null,"banStatus":null},"id":19721218,"name":"Adventure Alien Kickin' Hawk","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Rex/Equinox/19721218.jpg","createDate":{"time":1363260447000,"minutes":27,"seconds":27,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Rex/Equinox/19721218.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":61,"difficulty":1.6666666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1092,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.291667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Josiah Potato","authId":"","name":"Alien Josiah Potato","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Josiah Potato","authId":"","name":"Alien Josiah Potato","CNNId":"","myGameChains":null,"banStatus":null},"id":19988125,"name":"Racer Assault Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Josiah/Potato/19988125.jpg","createDate":{"time":1364773825000,"minutes":50,"seconds":25,"hours":19,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Josiah/Potato/19988125.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9996,"difficulty":1.3758671531644429,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.1403,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Felix Balloon","authId":"","name":"Superb Felix Balloon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Felix Balloon","authId":"","name":"Superb Felix Balloon","CNNId":"","myGameChains":null,"banStatus":null},"id":19939699,"name":"Energy Danger Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superb/Felix/Balloon/19939699.jpg","createDate":{"time":1364475139000,"minutes":52,"seconds":19,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superb/Felix/Balloon/19939699.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":382,"difficulty":2.363815942829101,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5978,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.023713,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Brandon Larva","authId":"","name":"General Brandon Larva","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Brandon Larva","authId":"","name":"General Brandon Larva","CNNId":"","myGameChains":null,"banStatus":null},"id":19691007,"name":"Energy Whirlwind Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Brandon/Larva/19691007.jpg","createDate":{"time":1363120916000,"minutes":41,"seconds":56,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Brandon/Larva/19691007.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":94,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1272,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Rhett Rhino","authId":"","name":"Brisk Rhett Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Rhett Rhino","authId":"","name":"Brisk Rhett Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":19707547,"name":"Assault Laser Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Rhett/Rhino/19707547.jpg","createDate":{"time":1363196832000,"minutes":47,"seconds":12,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Rhett/Rhino/19707547.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":380,"difficulty":2.5493827160493825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2235,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.927335,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scurvy Ernest Spleen","authId":"","name":"Scurvy Ernest Spleen","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scurvy Ernest Spleen","authId":"","name":"Scurvy Ernest Spleen","CNNId":"","myGameChains":null,"banStatus":null},"id":19759778,"name":"Adventure Plumber Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scurvy/Ernest/Spleen/19759778.jpg","createDate":{"time":1363433483000,"minutes":31,"seconds":23,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scurvy/Ernest/Spleen/19759778.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":199,"difficulty":1.5805555555555555,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1312,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.914286,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cranky Edd Sphere","authId":"","name":"Cranky Edd Sphere","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cranky Edd Sphere","authId":"","name":"Cranky Edd Sphere","CNNId":"","myGameChains":null,"banStatus":null},"id":19691594,"name":"Fury Warp Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cranky/Edd/Sphere/19691594.jpg","createDate":{"time":1363122089000,"minutes":1,"seconds":29,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cranky/Edd/Sphere/19691594.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":910,"difficulty":2.4166666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1482,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.830556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Geoff Ghoul","authId":"","name":"Famous Geoff Ghoul","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Geoff Ghoul","authId":"","name":"Famous Geoff Ghoul","CNNId":"","myGameChains":null,"banStatus":null},"id":19760020,"name":"Adventure Mega Kickin' Hawk","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Geoff/Ghoul/19760020.jpg","createDate":{"time":1363434604000,"minutes":50,"seconds":4,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Geoff/Ghoul/19760020.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":57,"difficulty":1.386111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1664,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.752778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cheerful Benson Beast","authId":"","name":"Cheerful Benson Beast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cheerful Benson Beast","authId":"","name":"Cheerful Benson Beast","CNNId":"","myGameChains":null,"banStatus":null},"id":19691562,"name":"Fury Adventure Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cheerful/Benson/Beast/19691562.jpg","createDate":{"time":1363122041000,"minutes":0,"seconds":41,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cheerful/Benson/Beast/19691562.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":714,"difficulty":1.3353142532208275,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":955,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.685242,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]