[{"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 = '2' 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":"Baroness Susan Bonanza","authId":"","name":"Baroness Susan Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Susan Bonanza","authId":"","name":"Baroness Susan Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"id":19313231,"name":"Blaster Adventure Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Susan/Bonanza/19313231.jpg","createDate":{"time":1357321893000,"minutes":51,"seconds":33,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Susan/Bonanza/19313231.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3086,"difficulty":2.5312143263197915,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13617,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.497023,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Antonio Buzzard","authId":"","name":"Aromatic Antonio Buzzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Antonio Buzzard","authId":"","name":"Aromatic Antonio Buzzard","CNNId":"","myGameChains":null,"banStatus":null},"id":19531610,"name":"Humungousaur Siege Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aromatic/Antonio/Buzzard/19531610.jpg","createDate":{"time":1360689859000,"minutes":24,"seconds":19,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aromatic/Antonio/Buzzard/19531610.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10179,"difficulty":2.050710139319491,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29743,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.456822,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Bill Neptune","authId":"","name":"Organic Bill Neptune","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Bill Neptune","authId":"","name":"Organic Bill Neptune","CNNId":"","myGameChains":null,"banStatus":null},"id":17535206,"name":"Beast Big Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Organic/Bill/Neptune/17535206.jpg","createDate":{"time":1348107923000,"minutes":25,"seconds":23,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Organic/Bill/Neptune/17535206.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":76263,"difficulty":2.0016655613000482,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":361041,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":2.441203,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Drew Bronco","authId":"","name":"Average Drew Bronco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Drew Bronco","authId":"","name":"Average Drew Bronco","CNNId":"","myGameChains":null,"banStatus":null},"id":18488350,"name":"Nitro Assault Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Drew/Bronco/18488350.jpg","createDate":{"time":1353023382000,"minutes":49,"seconds":42,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Drew/Bronco/18488350.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":199,"difficulty":2.8,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":636,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.38,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Iris Whizbang","authId":"","name":"Icy Iris Whizbang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Iris Whizbang","authId":"","name":"Icy Iris Whizbang","CNNId":"","myGameChains":null,"banStatus":null},"id":18351673,"name":"Smash Star Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Iris/Whizbang/18351673.jpg","createDate":{"time":1351880410000,"minutes":20,"seconds":10,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Iris/Whizbang/18351673.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1901,"difficulty":1.6762437424976124,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2238,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.353024,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Goliath Planet","authId":"","name":"Extreme Goliath Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Goliath Planet","authId":"","name":"Extreme Goliath Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":19221773,"name":"Storm Plasma Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Goliath/Planet/19221773.jpg","createDate":{"time":1356692889000,"minutes":8,"seconds":9,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Goliath/Planet/19221773.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":145,"difficulty":2.111111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":545,"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":"Grand Max Wallaby","authId":"","name":"Grand Max Wallaby","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Max Wallaby","authId":"","name":"Grand Max Wallaby","CNNId":"","myGameChains":null,"banStatus":null},"id":19906809,"name":"Fury Adventure Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grand/Max/Wallaby/19906809.jpg","createDate":{"time":1364219008000,"minutes":43,"seconds":28,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grand/Max/Wallaby/19906809.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":684,"difficulty":1.6401674608658012,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8803,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.321363,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Trent Bayou","authId":"","name":"Barbaric Trent Bayou","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Trent Bayou","authId":"","name":"Barbaric Trent Bayou","CNNId":"","myGameChains":null,"banStatus":null},"id":18706471,"name":"Lightning Danger Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Barbaric/Trent/Bayou/18706471.jpg","createDate":{"time":1354656573000,"minutes":29,"seconds":33,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Barbaric/Trent/Bayou/18706471.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":647,"difficulty":2.0660714285714286,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":698,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.288393,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Naomi Quarry","authId":"","name":"Atomic Naomi Quarry","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Naomi Quarry","authId":"","name":"Atomic Naomi Quarry","CNNId":"","myGameChains":null,"banStatus":null},"id":18426861,"name":"Fury Warrior Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Naomi/Quarry/18426861.jpg","createDate":{"time":1352494430000,"minutes":53,"seconds":50,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Naomi/Quarry/18426861.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":755,"difficulty":2.417687074829932,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":957,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.257143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Gabriel Jupiter","authId":"","name":"Generous Gabriel Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Gabriel Jupiter","authId":"","name":"Generous Gabriel Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":19629623,"name":"Crusher Magno Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Generous/Gabriel/Jupiter/19629623.jpg","createDate":{"time":1362345176000,"minutes":12,"seconds":56,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Generous/Gabriel/Jupiter/19629623.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":420,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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 = '2' 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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]