[{"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 = '13' 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":"Baroque Naomi Martian","authId":"","name":"Baroque Naomi Martian","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroque Naomi Martian","authId":"","name":"Baroque Naomi Martian","CNNId":"","myGameChains":null,"banStatus":null},"id":18707622,"name":"Gear Invasion Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroque/Naomi/Martian/18707622.jpg","createDate":{"time":1354658475000,"minutes":1,"seconds":15,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroque/Naomi/Martian/18707622.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2967,"difficulty":2.4421067482207093,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19266,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.390293,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Flint Glop","authId":"","name":"Famous Flint Glop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Flint Glop","authId":"","name":"Famous Flint Glop","CNNId":"","myGameChains":null,"banStatus":null},"id":18640641,"name":"Energy Laser Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Flint/Glop/18640641.jpg","createDate":{"time":1354306039000,"minutes":7,"seconds":19,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Flint/Glop/18640641.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2021,"difficulty":2.5764088866314787,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17219,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.389958,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Zeus Zip","authId":"","name":"Babbling Zeus Zip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Zeus Zip","authId":"","name":"Babbling Zeus Zip","CNNId":"","myGameChains":null,"banStatus":null},"id":18930279,"name":"Titan Adventure Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Zeus/Zip/18930279.jpg","createDate":{"time":1355227185000,"minutes":59,"seconds":45,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Zeus/Zip/18930279.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8434,"difficulty":2.331488757511038,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":113446,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.383308,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Drowzy Bryce Gargoyle","authId":"","name":"Drowzy Bryce Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Drowzy Bryce Gargoyle","authId":"","name":"Drowzy Bryce Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"id":18633662,"name":"Nano Adventure Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Drowzy/Bryce/Gargoyle/18633662.jpg","createDate":{"time":1354223381000,"minutes":9,"seconds":41,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Drowzy/Bryce/Gargoyle/18633662.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":31645,"difficulty":1.4752892579868564,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":102374,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.379707,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gullible Lance Moonbeam","authId":"","name":"Gullible Lance Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gullible Lance Moonbeam","authId":"","name":"Gullible Lance Moonbeam","CNNId":"","myGameChains":null,"banStatus":null},"id":19647483,"name":"Ultra Adventure Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gullible/Lance/Moonbeam/19647483.jpg","createDate":{"time":1362808959000,"minutes":2,"seconds":39,"hours":1,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gullible/Lance/Moonbeam/19647483.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1319,"difficulty":2.5732341955709237,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":195934,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.374449,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Gregory Dingo","authId":"","name":"Athletic Gregory Dingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Gregory Dingo","authId":"","name":"Athletic Gregory Dingo","CNNId":"","myGameChains":null,"banStatus":null},"id":19933869,"name":"Escape Lightning Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Gregory/Dingo/19933869.jpg","createDate":{"time":1364418078000,"minutes":1,"seconds":18,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Gregory/Dingo/19933869.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1180,"difficulty":2.440987066808264,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19304,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.373945,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Mia Ogre","authId":"","name":"Obvious Mia Ogre","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Mia Ogre","authId":"","name":"Obvious Mia Ogre","CNNId":"","myGameChains":null,"banStatus":null},"id":18521561,"name":"Hyper Charge Whirlwind","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obvious/Mia/Ogre/18521561.jpg","createDate":{"time":1353358282000,"minutes":51,"seconds":22,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obvious/Mia/Ogre/18521561.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":439,"difficulty":2.1605046805046806,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19473,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.369524,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Wesley Trapeze","authId":"","name":"Stout Wesley Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Wesley Trapeze","authId":"","name":"Stout Wesley Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"id":19198275,"name":"Racer Force Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stout/Wesley/Trapeze/19198275.jpg","createDate":{"time":1356539881000,"minutes":38,"seconds":1,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stout/Wesley/Trapeze/19198275.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2216,"difficulty":2.4477716534844154,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18345,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.367833,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Xavier Tuxedo","authId":"","name":"Bold Xavier Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Xavier Tuxedo","authId":"","name":"Bold Xavier Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"id":19025057,"name":"Sonic Storm Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Xavier/Tuxedo/19025057.jpg","createDate":{"time":1355635986000,"minutes":33,"seconds":6,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Xavier/Tuxedo/19025057.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15027,"difficulty":2.2679550275470857,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":62821,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.360793,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Tyler Dragon","authId":"","name":"Epic Tyler Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Tyler Dragon","authId":"","name":"Epic Tyler Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":19545225,"name":"Fusion BallWeevil Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Tyler/Dragon/19545225.jpg","createDate":{"time":1360958515000,"minutes":1,"seconds":55,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Tyler/Dragon/19545225.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1440,"difficulty":1.6666849086736353,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50881,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.355136,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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 = '13' 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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]