[{"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 = '15' 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":"Tacky Holly Viking","authId":"","name":"Tacky Holly Viking","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tacky Holly Viking","authId":"","name":"Tacky Holly Viking","CNNId":"","myGameChains":null,"banStatus":null},"id":19854761,"name":"Humungousaur Energy Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tacky/Holly/Viking/19854761.jpg","createDate":{"time":1363901207000,"minutes":26,"seconds":47,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tacky/Holly/Viking/19854761.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1640,"difficulty":1.8409391534391535,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2907,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.749868,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Ben Rutabaga","authId":"","name":"Wondrous Ben Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Ben Rutabaga","authId":"","name":"Wondrous Ben Rutabaga","CNNId":"","myGameChains":null,"banStatus":null},"id":19667587,"name":"Adventure Rook Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wondrous/Ben/Rutabaga/19667587.jpg","createDate":{"time":1363033120000,"minutes":18,"seconds":40,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wondrous/Ben/Rutabaga/19667587.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":162,"difficulty":1.3918367346938776,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":918,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.738095,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Timothy Grackle","authId":"","name":"Nomadic Timothy Grackle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Timothy Grackle","authId":"","name":"Nomadic Timothy Grackle","CNNId":"","myGameChains":null,"banStatus":null},"id":19736885,"name":"Adventure Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nomadic/Timothy/Grackle/19736885.jpg","createDate":{"time":1363323456000,"minutes":57,"seconds":36,"hours":0,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nomadic/Timothy/Grackle/19736885.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36567,"difficulty":1.3852488058841959,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":76414,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.552392,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Brittney Thing","authId":"","name":"Colonel Brittney Thing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Brittney Thing","authId":"","name":"Colonel Brittney Thing","CNNId":"","myGameChains":null,"banStatus":null},"id":19967802,"name":"Siege Beast Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Brittney/Thing/19967802.jpg","createDate":{"time":1364648262000,"minutes":57,"seconds":42,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Brittney/Thing/19967802.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6879,"difficulty":1.5705785571071422,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21236,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.477274,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Bailey Enigma","authId":"","name":"Bold Bailey Enigma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Bailey Enigma","authId":"","name":"Bold Bailey Enigma","CNNId":"","myGameChains":null,"banStatus":null},"id":19707526,"name":"Mission Iron Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Bailey/Enigma/19707526.jpg","createDate":{"time":1363196720000,"minutes":45,"seconds":20,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Bailey/Enigma/19707526.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":447,"difficulty":2.380952380952381,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":871,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.42328,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble Justin Mango","authId":"","name":"Humble Justin Mango","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble Justin Mango","authId":"","name":"Humble Justin Mango","CNNId":"","myGameChains":null,"banStatus":null},"id":19874540,"name":"Universe Adventure Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humble/Justin/Mango/19874540.jpg","createDate":{"time":1364044658000,"minutes":17,"seconds":38,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humble/Justin/Mango/19874540.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":560,"difficulty":2.361111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1712,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.42,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Ian Alien","authId":"","name":"Amusing Ian Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Ian Alien","authId":"","name":"Amusing Ian Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":19691168,"name":"Adventure Warp Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amusing/Ian/Alien/19691168.jpg","createDate":{"time":1363121240000,"minutes":47,"seconds":20,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amusing/Ian/Alien/19691168.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":47,"difficulty":2.7777777777777777,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":957,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Gracie Samurai","authId":"","name":"Icy Gracie Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Gracie Samurai","authId":"","name":"Icy Gracie Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":19691633,"name":"Mega Nano Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Gracie/Samurai/19691633.jpg","createDate":{"time":1363122172000,"minutes":2,"seconds":52,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Gracie/Samurai/19691633.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1170,"difficulty":1.4838942307692307,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5291,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.319986,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Ronald Samurai","authId":"","name":"Infamous Ronald Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Ronald Samurai","authId":"","name":"Infamous Ronald Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":19806819,"name":"Gear Adventure Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infamous/Ronald/Samurai/19806819.jpg","createDate":{"time":1363555462000,"minutes":24,"seconds":22,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infamous/Ronald/Samurai/19806819.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1747,"difficulty":1.4662622549019608,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2893,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.316213,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Trinity Panda","authId":"","name":"Grimy Trinity Panda","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Trinity Panda","authId":"","name":"Grimy Trinity Panda","CNNId":"","myGameChains":null,"banStatus":null},"id":19721401,"name":"Charge Fire Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grimy/Trinity/Panda/19721401.jpg","createDate":{"time":1363261898000,"minutes":51,"seconds":38,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grimy/Trinity/Panda/19721401.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":471,"difficulty":2.164192949907236,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2004,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.313986,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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 = '15' 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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]