[{"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":"Icy Larry Ion","authId":"","name":"Icy Larry Ion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Larry Ion","authId":"","name":"Icy Larry Ion","CNNId":"","myGameChains":null,"banStatus":null},"id":17214721,"name":"Star Atomic Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Larry/Ion/17214721.jpg","createDate":{"time":1342131070000,"minutes":11,"seconds":10,"hours":18,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Larry/Ion/17214721.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153271,"difficulty":2.4941981792370043,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1484039,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":575,"rating":4.45478,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Bessie Fathom","authId":"","name":"Colossal Bessie Fathom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colossal Bessie Fathom","authId":"","name":"Colossal Bessie Fathom","CNNId":"","myGameChains":null,"banStatus":null},"id":18557136,"name":"Racer Atomic Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colossal/Bessie/Fathom/18557136.jpg","createDate":{"time":1353621963000,"minutes":6,"seconds":3,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colossal/Bessie/Fathom/18557136.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":813,"difficulty":2.6,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1777,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.416667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hypnotic Laura Squirrel","authId":"","name":"Hypnotic Laura Squirrel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hypnotic Laura Squirrel","authId":"","name":"Hypnotic Laura Squirrel","CNNId":"","myGameChains":null,"banStatus":null},"id":19995369,"name":"Omniverse Chill Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hypnotic/Laura/Squirrel/19995369.jpg","createDate":{"time":1364838610000,"minutes":50,"seconds":10,"hours":13,"month":3,"timezoneOffset":240,"year":113,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hypnotic/Laura/Squirrel/19995369.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":32,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":803,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.416667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Polly Mercury","authId":"","name":"Wacky Polly Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Polly Mercury","authId":"","name":"Wacky Polly Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":18345298,"name":"Ambush Storm Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Polly/Mercury/18345298.jpg","createDate":{"time":1351807561000,"minutes":6,"seconds":1,"hours":18,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Polly/Mercury/18345298.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":985,"difficulty":2.246482453323886,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10821,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.414133,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Dylan Insect","authId":"","name":"Gigantic Dylan Insect","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Dylan Insect","authId":"","name":"Gigantic Dylan Insect","CNNId":"","myGameChains":null,"banStatus":null},"id":19347459,"name":"Echo Echo Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Dylan/Insect/19347459.jpg","createDate":{"time":1357680725000,"minutes":32,"seconds":5,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Dylan/Insect/19347459.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1064,"difficulty":2.519047619047619,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2368,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.412698,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Clay Meteor","authId":"","name":"Mystic Clay Meteor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Clay Meteor","authId":"","name":"Mystic Clay Meteor","CNNId":"","myGameChains":null,"banStatus":null},"id":17965936,"name":"Echo Echo Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mystic/Clay/Meteor/17965936.jpg","createDate":{"time":1349412878000,"minutes":54,"seconds":38,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mystic/Clay/Meteor/17965936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1060,"difficulty":1.7364258605058065,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":377102,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.407311,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Anthony Slurp","authId":"","name":"Galactic Anthony Slurp","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Anthony Slurp","authId":"","name":"Galactic Anthony Slurp","CNNId":"","myGameChains":null,"banStatus":null},"id":18469390,"name":"Hyper Assault Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Anthony/Slurp/18469390.jpg","createDate":{"time":1352757288000,"minutes":54,"seconds":48,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Anthony/Slurp/18469390.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":107,"difficulty":2.8068027210884354,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2765,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.406085,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Jayden Banjo","authId":"","name":"King Jayden Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Jayden Banjo","authId":"","name":"King Jayden Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":19760163,"name":"Sonic Echo Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Jayden/Banjo/19760163.jpg","createDate":{"time":1363435150000,"minutes":59,"seconds":10,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Jayden/Banjo/19760163.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1603,"difficulty":2.4469613638400767,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7897,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.400042,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sluggish Lancelot Mutant","authId":"","name":"Sluggish Lancelot Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sluggish Lancelot Mutant","authId":"","name":"Sluggish Lancelot Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":19128334,"name":"Rush Rescue Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sluggish/Lancelot/Mutant/19128334.jpg","createDate":{"time":1356197014000,"minutes":23,"seconds":34,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sluggish/Lancelot/Mutant/19128334.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":412,"difficulty":1.8888888888888888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1573,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Leon Ballyhoo","authId":"","name":"Creepy Leon Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Leon Ballyhoo","authId":"","name":"Creepy Leon Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"id":17216331,"name":"Sonic Rush Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creepy/Leon/Ballyhoo/17216331.jpg","createDate":{"time":1342177122000,"minutes":58,"seconds":42,"hours":6,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creepy/Leon/Ballyhoo/17216331.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":725,"difficulty":1.2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1082,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.377778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"51","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":"60","currentPageToDisplay":6,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]