[{"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 = '1' 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":"Magnetic Trinity Walrus","authId":"","name":"Magnetic Trinity Walrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Trinity Walrus","authId":"","name":"Magnetic Trinity Walrus","CNNId":"","myGameChains":null,"banStatus":null},"id":18107128,"name":"Storm Smash Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Trinity/Walrus/18107128.jpg","createDate":{"time":1350080310000,"minutes":18,"seconds":30,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Trinity/Walrus/18107128.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13151,"difficulty":1.6289051809659296,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15751,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.15828,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Gwen Venom","authId":"","name":"Gorgeous Gwen Venom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Gwen Venom","authId":"","name":"Gorgeous Gwen Venom","CNNId":"","myGameChains":null,"banStatus":null},"id":19611971,"name":"Swampfire Alien Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gorgeous/Gwen/Venom/19611971.jpg","createDate":{"time":1362055663000,"minutes":47,"seconds":43,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gorgeous/Gwen/Venom/19611971.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":602,"difficulty":1.402110051064501,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4022,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.152034,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valorous Susannah Stampede","authId":"","name":"Valorous Susannah Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valorous Susannah Stampede","authId":"","name":"Valorous Susannah Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":17216540,"name":"Streak Crusher Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valorous/Susannah/Stampede/17216540.jpg","createDate":{"time":1342184254000,"minutes":57,"seconds":34,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valorous/Susannah/Stampede/17216540.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5698,"difficulty":2.3664005562678874,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6383,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.149069,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Kevin Aviator","authId":"","name":"Merry Kevin Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Kevin Aviator","authId":"","name":"Merry Kevin Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":17572012,"name":"Giga Spike Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Merry/Kevin/Aviator/17572012.jpg","createDate":{"time":1348217089000,"minutes":44,"seconds":49,"hours":4,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Merry/Kevin/Aviator/17572012.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":50102,"difficulty":2.0263204680623677,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":205253,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":6,"rating":4.148822,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Alex Moppet","authId":"","name":"Colossal Alex Moppet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Alex Moppet","authId":"","name":"Colossal Alex Moppet","CNNId":"","myGameChains":null,"banStatus":null},"id":19052396,"name":"Adventure Stone Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Alex/Moppet/19052396.jpg","createDate":{"time":1355729902000,"minutes":38,"seconds":22,"hours":2,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Alex/Moppet/19052396.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":31891,"difficulty":2.4002785393914414,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51903,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.135234,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Jared Goblin","authId":"","name":"Cute Jared Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Jared Goblin","authId":"","name":"Cute Jared Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17813356,"name":"Beast Pulse Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cute/Jared/Goblin/17813356.jpg","createDate":{"time":1348832741000,"minutes":45,"seconds":41,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cute/Jared/Goblin/17813356.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5744,"difficulty":2.3214959226581264,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12459,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.127582,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Colton Seesaw","authId":"","name":"Grizzly Colton Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Colton Seesaw","authId":"","name":"Grizzly Colton Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"id":17736863,"name":"Swampfire Power Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Colton/Seesaw/17736863.jpg","createDate":{"time":1348464223000,"minutes":23,"seconds":43,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Colton/Seesaw/17736863.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2586,"difficulty":2.4880303822263627,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15438,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.122211,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Bruce Avator","authId":"","name":"Enormous Bruce Avator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Bruce Avator","authId":"","name":"Enormous Bruce Avator","CNNId":"","myGameChains":null,"banStatus":null},"id":19623987,"name":"Robot Adventure Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Enormous/Bruce/Avator/19623987.jpg","createDate":{"time":1362269857000,"minutes":17,"seconds":37,"hours":19,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Enormous/Bruce/Avator/19623987.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2087,"difficulty":1.3466340653102065,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29936,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.115929,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Clark Klunk","authId":"","name":"Galactic Clark Klunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Clark Klunk","authId":"","name":"Galactic Clark Klunk","CNNId":"","myGameChains":null,"banStatus":null},"id":19487615,"name":"Steel Razor Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Clark/Klunk/19487615.jpg","createDate":{"time":1359902721000,"minutes":45,"seconds":21,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Clark/Klunk/19487615.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5535,"difficulty":2.9194082997686785,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37053,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.113589,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Sid Mummy","authId":"","name":"Nifty Sid Mummy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Sid Mummy","authId":"","name":"Nifty Sid Mummy","CNNId":"","myGameChains":null,"banStatus":null},"id":19472361,"name":"Shadow Nano Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Sid/Mummy/19472361.jpg","createDate":{"time":1359641125000,"minutes":5,"seconds":25,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Sid/Mummy/19472361.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":180,"difficulty":2.9313971202516096,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7643,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.090627,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","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 = '1' 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":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]