[{"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":"Titanic Gage Gumbo","authId":"","name":"Titanic Gage Gumbo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Titanic Gage Gumbo","authId":"","name":"Titanic Gage Gumbo","CNNId":"","myGameChains":null,"banStatus":null},"id":19489043,"name":"Lightning Nova Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Titanic/Gage/Gumbo/19489043.jpg","createDate":{"time":1359915655000,"minutes":20,"seconds":55,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Titanic/Gage/Gumbo/19489043.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19363,"difficulty":2.3928016174016142,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27133,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.375714,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sinister Bethany Turtle","authId":"","name":"Sinister Bethany Turtle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sinister Bethany Turtle","authId":"","name":"Sinister Bethany Turtle","CNNId":"","myGameChains":null,"banStatus":null},"id":18241756,"name":"Robot Assault Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sinister/Bethany/Turtle/18241756.jpg","createDate":{"time":1350936919000,"minutes":15,"seconds":19,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":1,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sinister/Bethany/Turtle/18241756.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8887,"difficulty":1.8578646448419573,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":80120,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.348011,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rude Tabitha Twilight","authId":"","name":"Rude Tabitha Twilight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rude Tabitha Twilight","authId":"","name":"Rude Tabitha Twilight","CNNId":"","myGameChains":null,"banStatus":null},"id":18287354,"name":"Dark Fusion Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rude/Tabitha/Twilight/18287354.jpg","createDate":{"time":1351357410000,"minutes":3,"seconds":30,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rude/Tabitha/Twilight/18287354.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":193,"difficulty":1.92,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1914,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.34,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Dominic Fox","authId":"","name":"Academic Dominic Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Dominic Fox","authId":"","name":"Academic Dominic Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":19251371,"name":"Rocket Rocket Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Dominic/Fox/19251371.jpg","createDate":{"time":1356869295000,"minutes":8,"seconds":15,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Dominic/Fox/19251371.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2136,"difficulty":2.380678173015811,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6931,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.326683,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Raymond Trapeze","authId":"","name":"Shady Raymond Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Raymond Trapeze","authId":"","name":"Shady Raymond Trapeze","CNNId":"","myGameChains":null,"banStatus":null},"id":18469453,"name":"Drone Adventure Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shady/Raymond/Trapeze/18469453.jpg","createDate":{"time":1352757582000,"minutes":59,"seconds":42,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shady/Raymond/Trapeze/18469453.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3813,"difficulty":1.3127174908424908,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4172,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.304487,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Jake Ghost","authId":"","name":"Loyal Jake Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Jake Ghost","authId":"","name":"Loyal Jake Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":18170100,"name":"Techno Warp Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Jake/Ghost/18170100.jpg","createDate":{"time":1350360148000,"minutes":2,"seconds":28,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Jake/Ghost/18170100.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56004,"difficulty":1.83880276544302,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":262997,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.276974,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Hunter Cookie","authId":"","name":"Stealthy Hunter Cookie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stealthy Hunter Cookie","authId":"","name":"Stealthy Hunter Cookie","CNNId":"","myGameChains":null,"banStatus":null},"id":18264388,"name":"Racer Racer Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stealthy/Hunter/Cookie/18264388.jpg","createDate":{"time":1351199516000,"minutes":11,"seconds":56,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stealthy/Hunter/Cookie/18264388.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28237,"difficulty":1.8942507356678697,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":69972,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.26171,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Dewey Fang","authId":"","name":"Dandy Dewey Fang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Dewey Fang","authId":"","name":"Dandy Dewey Fang","CNNId":"","myGameChains":null,"banStatus":null},"id":19505468,"name":"Drone Escape Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dandy/Dewey/Fang/19505468.jpg","createDate":{"time":1360271180000,"minutes":6,"seconds":20,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dandy/Dewey/Fang/19505468.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5729,"difficulty":2.2863737649621863,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7349,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.258704,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Ginger Spatula","authId":"","name":"Normal Ginger Spatula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Ginger Spatula","authId":"","name":"Normal Ginger Spatula","CNNId":"","myGameChains":null,"banStatus":null},"id":18098357,"name":"Storm Pulse Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Normal/Ginger/Spatula/18098357.jpg","createDate":{"time":1350037685000,"minutes":28,"seconds":5,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Normal/Ginger/Spatula/18098357.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1562,"difficulty":1.3948743126378365,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4605,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.235646,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Joe Bazooka","authId":"","name":"Dandy Joe Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Joe Bazooka","authId":"","name":"Dandy Joe Bazooka","CNNId":"","myGameChains":null,"banStatus":null},"id":18005059,"name":"Star Techno Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dandy/Joe/Bazooka/18005059.jpg","createDate":{"time":1349554587000,"minutes":16,"seconds":27,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dandy/Joe/Bazooka/18005059.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":988,"difficulty":1.3710756033182505,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3759,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.228908,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]