[{"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 = '4' 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":"Sporty Derrick Fox","authId":"","name":"Sporty Derrick Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Derrick Fox","authId":"","name":"Sporty Derrick Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":19619644,"name":"Smash Ultimate Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sporty/Derrick/Fox/19619644.jpg","createDate":{"time":1362228595000,"minutes":49,"seconds":55,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sporty/Derrick/Fox/19619644.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":573,"difficulty":2.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4118,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.197279,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Baxter Crowbar","authId":"","name":"Dashing Baxter Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Baxter Crowbar","authId":"","name":"Dashing Baxter Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"id":19629661,"name":"Beast Space Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/Baxter/Crowbar/19629661.jpg","createDate":{"time":1362345375000,"minutes":16,"seconds":15,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/Baxter/Crowbar/19629661.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":490,"difficulty":1.6176870748299321,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1814,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.189116,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Matt Hawk","authId":"","name":"Reckless Matt Hawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Matt Hawk","authId":"","name":"Reckless Matt Hawk","CNNId":"","myGameChains":null,"banStatus":null},"id":19053384,"name":"Giga Energy Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Matt/Hawk/19053384.jpg","createDate":{"time":1355745597000,"minutes":59,"seconds":57,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Matt/Hawk/19053384.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":539,"difficulty":1.61234126984127,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2013,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.188968,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Marvin Magnet","authId":"","name":"Generous Marvin Magnet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Marvin Magnet","authId":"","name":"Generous Marvin Magnet","CNNId":"","myGameChains":null,"banStatus":null},"id":18515146,"name":"Razor Ambush Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Generous/Marvin/Magnet/18515146.jpg","createDate":{"time":1353274829000,"minutes":40,"seconds":29,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Generous/Marvin/Magnet/18515146.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2275,"difficulty":2.283246616216439,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8559,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.168346,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Dan Crash","authId":"","name":"Enormous Dan Crash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Dan Crash","authId":"","name":"Enormous Dan Crash","CNNId":"","myGameChains":null,"banStatus":null},"id":17953340,"name":"Crusher Razor Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Enormous/Dan/Crash/17953340.jpg","createDate":{"time":1349332602000,"minutes":36,"seconds":42,"hours":2,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Enormous/Dan/Crash/17953340.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":114,"difficulty":2.5555555555555554,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":973,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.166667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Cole Penguin","authId":"","name":"Ultimate Cole Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Cole Penguin","authId":"","name":"Ultimate Cole Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":17209281,"name":"Danger Nano Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Cole/Penguin/17209281.jpg","createDate":{"time":1341992687000,"minutes":44,"seconds":47,"hours":3,"month":6,"timezoneOffset":240,"year":112,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Cole/Penguin/17209281.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":394,"difficulty":2.3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1331,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.166667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish David Blast","authId":"","name":"Freakish David Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish David Blast","authId":"","name":"Freakish David Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":18488395,"name":"Light Cosmic Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Freakish/David/Blast/18488395.jpg","createDate":{"time":1353023802000,"minutes":56,"seconds":42,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Freakish/David/Blast/18488395.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":567,"difficulty":1.4461460684644076,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6549,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.155565,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Wes Pyramid","authId":"","name":"Feisty Wes Pyramid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Wes Pyramid","authId":"","name":"Feisty Wes Pyramid","CNNId":"","myGameChains":null,"banStatus":null},"id":18984198,"name":"Spidermonkey Breaker Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Feisty/Wes/Pyramid/18984198.jpg","createDate":{"time":1355522376000,"minutes":59,"seconds":36,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Feisty/Wes/Pyramid/18984198.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":497,"difficulty":2.697530864197531,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1927,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.144444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rude Ian Particle","authId":"","name":"Rude Ian Particle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rude Ian Particle","authId":"","name":"Rude Ian Particle","CNNId":"","myGameChains":null,"banStatus":null},"id":18417757,"name":"Warrior Animo Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rude/Ian/Particle/18417757.jpg","createDate":{"time":1352398602000,"minutes":16,"seconds":42,"hours":13,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rude/Ian/Particle/18417757.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20112,"difficulty":1.5459989402032988,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":108365,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.138509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Dixie Nibbles","authId":"","name":"Elegant Dixie Nibbles","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Dixie Nibbles","authId":"","name":"Elegant Dixie Nibbles","CNNId":"","myGameChains":null,"banStatus":null},"id":19342259,"name":"Laser Alien Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elegant/Dixie/Nibbles/19342259.jpg","createDate":{"time":1357588546000,"minutes":55,"seconds":46,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elegant/Dixie/Nibbles/19342259.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":81,"difficulty":2.7142857142857144,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5216,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.126531,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '4' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]