[{"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 = '11' 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":"Wily Terry Walrus","authId":"","name":"Wily Terry Walrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wily Terry Walrus","authId":"","name":"Wily Terry Walrus","CNNId":"","myGameChains":null,"banStatus":null},"id":18418340,"name":"Ambush Fusion Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wily/Terry/Walrus/18418340.jpg","createDate":{"time":1352406125000,"minutes":22,"seconds":5,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wily/Terry/Walrus/18418340.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12890,"difficulty":2.3208911275832085,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":188387,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.4054,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Dakota Beeswax","authId":"","name":"Virtual Dakota Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Dakota Beeswax","authId":"","name":"Virtual Dakota Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"id":19027369,"name":"Warp Ben Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Virtual/Dakota/Beeswax/19027369.jpg","createDate":{"time":1355660271000,"minutes":17,"seconds":51,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Virtual/Dakota/Beeswax/19027369.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25460,"difficulty":2.608019410468188,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":89789,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.401065,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Riley Klunk","authId":"","name":"Plucky Riley Klunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Riley Klunk","authId":"","name":"Plucky Riley Klunk","CNNId":"","myGameChains":null,"banStatus":null},"id":18096982,"name":"Rock Smash Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Plucky/Riley/Klunk/18096982.jpg","createDate":{"time":1350015913000,"minutes":25,"seconds":13,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Plucky/Riley/Klunk/18096982.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":43371,"difficulty":2.0426665953592904,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":255629,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.400793,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nervous Leonard Dragoon","authId":"","name":"Nervous Leonard Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nervous Leonard Dragoon","authId":"","name":"Nervous Leonard Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18428695,"name":"Techno Adventure Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nervous/Leonard/Dragoon/18428695.jpg","createDate":{"time":1352503683000,"minutes":28,"seconds":3,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nervous/Leonard/Dragoon/18428695.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10007,"difficulty":1.9166688627955077,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":242739,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.395718,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Taylor Nebula","authId":"","name":"Eager Taylor Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Taylor Nebula","authId":"","name":"Eager Taylor Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":17423511,"name":"Lightning Hero Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eager/Taylor/Nebula/17423511.jpg","createDate":{"time":1347894483000,"minutes":8,"seconds":3,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eager/Taylor/Nebula/17423511.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1773,"difficulty":2.6511022324915197,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63843,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.371657,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Chris Sorcerer","authId":"","name":"Wondrous Chris Sorcerer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Chris Sorcerer","authId":"","name":"Wondrous Chris Sorcerer","CNNId":"","myGameChains":null,"banStatus":null},"id":19361640,"name":"Rock Ultimate Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wondrous/Chris/Sorcerer/19361640.jpg","createDate":{"time":1357936685000,"minutes":38,"seconds":5,"hours":15,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wondrous/Chris/Sorcerer/19361640.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9627,"difficulty":1.5212823097872643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27912,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.349498,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Luis Possum","authId":"","name":"Superb Luis Possum","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Luis Possum","authId":"","name":"Superb Luis Possum","CNNId":"","myGameChains":null,"banStatus":null},"id":17811404,"name":"Thunder Assault Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superb/Luis/Possum/17811404.jpg","createDate":{"time":1348816681000,"minutes":18,"seconds":1,"hours":3,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superb/Luis/Possum/17811404.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4553,"difficulty":1.56403559185252,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":121239,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.349312,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Alfonso Windmill","authId":"","name":"Acoustic Alfonso Windmill","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Alfonso Windmill","authId":"","name":"Acoustic Alfonso Windmill","CNNId":"","myGameChains":null,"banStatus":null},"id":18631654,"name":"Shock Rumble Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Acoustic/Alfonso/Windmill/18631654.jpg","createDate":{"time":1354196596000,"minutes":43,"seconds":16,"hours":8,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Acoustic/Alfonso/Windmill/18631654.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36147,"difficulty":2.1152863954791528,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":111411,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.348278,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Beth Elephant","authId":"","name":"Vast Beth Elephant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Beth Elephant","authId":"","name":"Vast Beth Elephant","CNNId":"","myGameChains":null,"banStatus":null},"id":18004848,"name":"Magno Quake Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Beth/Elephant/18004848.jpg","createDate":{"time":1349554251000,"minutes":10,"seconds":51,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Beth/Elephant/18004848.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2140,"difficulty":2.7765630171662026,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":46277,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.340595,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Parker Kumquat","authId":"","name":"Grimy Parker Kumquat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Parker Kumquat","authId":"","name":"Grimy Parker Kumquat","CNNId":"","myGameChains":null,"banStatus":null},"id":19395947,"name":"Alien Energy Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grimy/Parker/Kumquat/19395947.jpg","createDate":{"time":1358421437000,"minutes":17,"seconds":17,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grimy/Parker/Kumquat/19395947.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4426,"difficulty":2.829157290662229,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":75329,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.304358,"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 = '11' 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"}}]