[{"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 = '9' 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":"Pretty Forrest Quark","authId":"","name":"Pretty Forrest Quark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pretty Forrest Quark","authId":"","name":"Pretty Forrest Quark","CNNId":"","myGameChains":null,"banStatus":null},"id":17530515,"name":"Rocket Streak Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pretty/Forrest/Quark/17530515.jpg","createDate":{"time":1348100829000,"minutes":27,"seconds":9,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pretty/Forrest/Quark/17530515.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":372,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":724,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tacky Hercules Bison","authId":"","name":"Tacky Hercules Bison","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tacky Hercules Bison","authId":"","name":"Tacky Hercules Bison","CNNId":"","myGameChains":null,"banStatus":null},"id":17793343,"name":"Solar Adventure Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tacky/Hercules/Bison/17793343.jpg","createDate":{"time":1348719149000,"minutes":12,"seconds":29,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tacky/Hercules/Bison/17793343.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":69,"difficulty":2.4444444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":720,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Jake Lobster","authId":"","name":"Comical Jake Lobster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Jake Lobster","authId":"","name":"Comical Jake Lobster","CNNId":"","myGameChains":null,"banStatus":null},"id":19480699,"name":"Cosmic Plumber Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Comical/Jake/Lobster/19480699.jpg","createDate":{"time":1359811744000,"minutes":29,"seconds":4,"hours":8,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Comical/Jake/Lobster/19480699.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":55,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":687,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Emerson Python","authId":"","name":"Hearty Emerson Python","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Emerson Python","authId":"","name":"Hearty Emerson Python","CNNId":"","myGameChains":null,"banStatus":null},"id":19347049,"name":"Danger Escape Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hearty/Emerson/Python/19347049.jpg","createDate":{"time":1357676304000,"minutes":18,"seconds":24,"hours":15,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hearty/Emerson/Python/19347049.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":93,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":748,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Bob Saber","authId":"","name":"Artful Bob Saber","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Bob Saber","authId":"","name":"Artful Bob Saber","CNNId":"","myGameChains":null,"banStatus":null},"id":18783491,"name":"Turbo Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artful/Bob/Saber/18783491.jpg","createDate":{"time":1354912950000,"minutes":42,"seconds":30,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artful/Bob/Saber/18783491.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":58,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":709,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Lorenzo Ghoul","authId":"","name":"Toxic Lorenzo Ghoul","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Lorenzo Ghoul","authId":"","name":"Toxic Lorenzo Ghoul","CNNId":"","myGameChains":null,"banStatus":null},"id":18536998,"name":"Gear Danger Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Lorenzo/Ghoul/18536998.jpg","createDate":{"time":1353510272000,"minutes":4,"seconds":32,"hours":10,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Lorenzo/Ghoul/18536998.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":708,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Scooby Bongo","authId":"","name":"Verbose Scooby Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Verbose Scooby Bongo","authId":"","name":"Verbose Scooby Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":18469393,"name":"Rampage Crusher Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Verbose/Scooby/Bongo/18469393.jpg","createDate":{"time":1352757293000,"minutes":54,"seconds":53,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Verbose/Scooby/Bongo/18469393.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":371,"difficulty":2.86,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":676,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.94,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Sam Fuzz","authId":"","name":"Famous Sam Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Sam Fuzz","authId":"","name":"Famous Sam Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"id":19951930,"name":"Big Mega Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Sam/Fuzz/19951930.jpg","createDate":{"time":1364559281000,"minutes":14,"seconds":41,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Sam/Fuzz/19951930.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":420,"difficulty":2.92,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":738,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.918367,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Athena Gamer","authId":"","name":"Digital Athena Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Athena Gamer","authId":"","name":"Digital Athena Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":19648326,"name":"Adventure Chase Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Athena/Gamer/19648326.jpg","createDate":{"time":1362833433000,"minutes":50,"seconds":33,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Athena/Gamer/19648326.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4042,"difficulty":2.8512311205769563,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51621,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.847097,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Landon Python","authId":"","name":"Captain Landon Python","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Landon Python","authId":"","name":"Captain Landon Python","CNNId":"","myGameChains":null,"banStatus":null},"id":19721034,"name":"Echo Ultimate Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Landon/Python/19721034.jpg","createDate":{"time":1363258641000,"minutes":57,"seconds":21,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Landon/Python/19721034.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":913,"difficulty":2.6030159078596564,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29219,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.845034,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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 = '9' 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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]