[{"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 = '6' 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":"Academic Scooby Citrus","authId":"","name":"Academic Scooby Citrus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Scooby Citrus","authId":"","name":"Academic Scooby Citrus","CNNId":"","myGameChains":null,"banStatus":null},"id":18287164,"name":"Nano Cosmic Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Scooby/Citrus/18287164.jpg","createDate":{"time":1351356897000,"minutes":54,"seconds":57,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Scooby/Citrus/18287164.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":162,"difficulty":1.6666666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":894,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.645833,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"id":17216418,"name":"Solar Turbo Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vague/Avery/Parallax/17216418.jpg","createDate":{"time":1342180770000,"minutes":59,"seconds":30,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vague/Avery/Parallax/17216418.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":478,"difficulty":1.08,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1123,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.645833,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Autumn Forklift","authId":"","name":"Colossal Autumn Forklift","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Autumn Forklift","authId":"","name":"Colossal Autumn Forklift","CNNId":"","myGameChains":null,"banStatus":null},"id":18469457,"name":"Danger Rush Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Autumn/Forklift/18469457.jpg","createDate":{"time":1352757600000,"minutes":0,"seconds":0,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Autumn/Forklift/18469457.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4604,"difficulty":1.6097662293843096,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15993,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.640793,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Izzy Monster","authId":"","name":"Galactic Izzy Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Izzy Monster","authId":"","name":"Galactic Izzy Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":19526271,"name":"Animo Hex Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Izzy/Monster/19526271.jpg","createDate":{"time":1360553124000,"minutes":25,"seconds":24,"hours":22,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Izzy/Monster/19526271.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9573,"difficulty":2.085956761974141,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26279,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.635123,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Juan Shock","authId":"","name":"Humorous Juan Shock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Juan Shock","authId":"","name":"Humorous Juan Shock","CNNId":"","myGameChains":null,"banStatus":null},"id":18079039,"name":"Razor Energy Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humorous/Juan/Shock/18079039.jpg","createDate":{"time":1349899637000,"minutes":7,"seconds":17,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humorous/Juan/Shock/18079039.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":671,"difficulty":1.5418837115265687,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3962,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.596509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly William Doodle","authId":"","name":"Smelly William Doodle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly William Doodle","authId":"","name":"Smelly William Doodle","CNNId":"","myGameChains":null,"banStatus":null},"id":18206762,"name":"Pursuit Defense Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smelly/William/Doodle/18206762.jpg","createDate":{"time":1350719640000,"minutes":54,"seconds":0,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smelly/William/Doodle/18206762.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30,"difficulty":1.8888888888888888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":524,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.555556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Tanner Boing","authId":"","name":"Fabulous Tanner Boing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Tanner Boing","authId":"","name":"Fabulous Tanner Boing","CNNId":"","myGameChains":null,"banStatus":null},"id":19854792,"name":"Droid Sonic Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Tanner/Boing/19854792.jpg","createDate":{"time":1363901361000,"minutes":29,"seconds":21,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Tanner/Boing/19854792.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3272,"difficulty":1.6950954520959318,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11183,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.514938,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Chris Stampede","authId":"","name":"Merry Chris Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Merry Chris Stampede","authId":"","name":"Merry Chris Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":18004637,"name":"Water Warrior Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Merry/Chris/Stampede/18004637.jpg","createDate":{"time":1349553871000,"minutes":4,"seconds":31,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Merry/Chris/Stampede/18004637.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14781,"difficulty":2.1712186814569847,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":154372,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.501002,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Jason Turnip","authId":"","name":"Gorgeous Jason Turnip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Jason Turnip","authId":"","name":"Gorgeous Jason Turnip","CNNId":"","myGameChains":null,"banStatus":null},"id":18558623,"name":"Burst Star Waterhazard","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gorgeous/Jason/Turnip/18558623.jpg","createDate":{"time":1353628658000,"minutes":57,"seconds":38,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gorgeous/Jason/Turnip/18558623.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":164,"difficulty":2.5555555555555554,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":704,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Joyous Frank Sunset","authId":"","name":"Joyous Frank Sunset","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Joyous Frank Sunset","authId":"","name":"Joyous Frank Sunset","CNNId":"","myGameChains":null,"banStatus":null},"id":17216370,"name":"Solar Charge Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Joyous/Frank/Sunset/17216370.jpg","createDate":{"time":1342178317000,"minutes":18,"seconds":37,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Joyous/Frank/Sunset/17216370.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":160,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":574,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"121","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 = '6' 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":"130","currentPageToDisplay":13,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]