[{"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 = '8' 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":"Ruthless Reuben Quack","authId":"","name":"Ruthless Reuben Quack","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Reuben Quack","authId":"","name":"Ruthless Reuben Quack","CNNId":"","myGameChains":null,"banStatus":null},"id":18333748,"name":"Attack Adventure Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Reuben/Quack/18333748.jpg","createDate":{"time":1351673692000,"minutes":54,"seconds":52,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Reuben/Quack/18333748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7752,"difficulty":2.2110452943733145,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82329,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.593187,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Douglas Yoyo","authId":"","name":"Kinetic Douglas Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Douglas Yoyo","authId":"","name":"Kinetic Douglas Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19401811,"name":"Ben Adventure Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Douglas/Yoyo/19401811.jpg","createDate":{"time":1358537601000,"minutes":33,"seconds":21,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Douglas/Yoyo/19401811.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1822,"difficulty":2.814572444838229,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56480,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.590867,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Ulysses Jigsaw","authId":"","name":"Regal Ulysses Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Ulysses Jigsaw","authId":"","name":"Regal Ulysses Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18515139,"name":"Cannonbolt Humungousaur Burst","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regal/Ulysses/Jigsaw/18515139.jpg","createDate":{"time":1353274804000,"minutes":40,"seconds":4,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regal/Ulysses/Jigsaw/18515139.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":697,"difficulty":2.7421188358384287,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11573,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.586981,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Darla Samurai","authId":"","name":"Radical Darla Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Darla Samurai","authId":"","name":"Radical Darla Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":18613797,"name":"Cannonbolt Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radical/Darla/Samurai/18613797.jpg","createDate":{"time":1353966716000,"minutes":51,"seconds":56,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radical/Darla/Samurai/18613797.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8131,"difficulty":2.5242638623688243,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12465,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.583851,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Eva Goulash","authId":"","name":"Groovy Eva Goulash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Eva Goulash","authId":"","name":"Groovy Eva Goulash","CNNId":"","myGameChains":null,"banStatus":null},"id":19629561,"name":"Techno Battle Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Eva/Goulash/19629561.jpg","createDate":{"time":1362344626000,"minutes":3,"seconds":46,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Eva/Goulash/19629561.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20724,"difficulty":2.378345839235428,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":35086,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.579373,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Paige Rhombus","authId":"","name":"Famous Paige Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Paige Rhombus","authId":"","name":"Famous Paige Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"id":19568585,"name":"Mega Rampage Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Paige/Rhombus/19568585.jpg","createDate":{"time":1361237595000,"minutes":33,"seconds":15,"hours":20,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Paige/Rhombus/19568585.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2493,"difficulty":2.8031349206349203,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4603,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.577214,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Rolf Jigsaw","authId":"","name":"Twisty Rolf Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Rolf Jigsaw","authId":"","name":"Twisty Rolf Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"id":19395971,"name":"Iron Plasma Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Twisty/Rolf/Jigsaw/19395971.jpg","createDate":{"time":1358422387000,"minutes":33,"seconds":7,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Twisty/Rolf/Jigsaw/19395971.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2283,"difficulty":2.6868208951542285,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5295,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.571576,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Donald Citrus","authId":"","name":"Brave Donald Citrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Donald Citrus","authId":"","name":"Brave Donald Citrus","CNNId":"","myGameChains":null,"banStatus":null},"id":19387133,"name":"Cannonbolt Omniverse Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brave/Donald/Citrus/19387133.jpg","createDate":{"time":1358251920000,"minutes":12,"seconds":0,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brave/Donald/Citrus/19387133.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1881,"difficulty":2.338862709273614,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4775,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.56775,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Emerson Ghost","authId":"","name":"Silly Emerson Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Emerson Ghost","authId":"","name":"Silly Emerson Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":19387103,"name":"Space Storm Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Emerson/Ghost/19387103.jpg","createDate":{"time":1358251077000,"minutes":57,"seconds":57,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Emerson/Ghost/19387103.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":686,"difficulty":2.4829931972789114,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1765,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.558036,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Finn Magnet","authId":"","name":"Stealthy Finn Magnet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Finn Magnet","authId":"","name":"Stealthy Finn Magnet","CNNId":"","myGameChains":null,"banStatus":null},"id":18285230,"name":"Rock Animo Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stealthy/Finn/Magnet/18285230.jpg","createDate":{"time":1351350401000,"minutes":6,"seconds":41,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stealthy/Finn/Magnet/18285230.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":810,"difficulty":2.7287303201572226,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26765,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.55405,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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 = '8' 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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]