[{"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 = '7' 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":"Captain Buster Mercury","authId":"","name":"Captain Buster Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Buster Mercury","authId":"","name":"Captain Buster Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":19053097,"name":"Terraspin Rampage Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Buster/Mercury/19053097.jpg","createDate":{"time":1355740825000,"minutes":40,"seconds":25,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Buster/Mercury/19053097.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2739,"difficulty":1.696156742957211,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57235,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.738282,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Val Yoyo","authId":"","name":"Genuine Val Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Val Yoyo","authId":"","name":"Genuine Val Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19906669,"name":"Force Burst Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Genuine/Val/Yoyo/19906669.jpg","createDate":{"time":1364218009000,"minutes":26,"seconds":49,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Genuine/Val/Yoyo/19906669.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":151,"difficulty":2.0318253968253965,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2514,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.721875,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy David Pulsar","authId":"","name":"Icy David Pulsar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy David Pulsar","authId":"","name":"Icy David Pulsar","CNNId":"","myGameChains":null,"banStatus":null},"id":18707747,"name":"Ultra Solar Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/David/Pulsar/18707747.jpg","createDate":{"time":1354658653000,"minutes":4,"seconds":13,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/David/Pulsar/18707747.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6459,"difficulty":1.9447174437902326,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44982,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.710918,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quick Steven Nanobot","authId":"","name":"Quick Steven Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quick Steven Nanobot","authId":"","name":"Quick Steven Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"id":18911744,"name":"Power Terraspin Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quick/Steven/Nanobot/18911744.jpg","createDate":{"time":1355125174000,"minutes":39,"seconds":34,"hours":2,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quick/Steven/Nanobot/18911744.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6327,"difficulty":2.120564990372646,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29370,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.700489,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Achilles Llama","authId":"","name":"Smelly Achilles Llama","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Achilles Llama","authId":"","name":"Smelly Achilles Llama","CNNId":"","myGameChains":null,"banStatus":null},"id":17548696,"name":"Force Steel Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smelly/Achilles/Llama/17548696.jpg","createDate":{"time":1348168470000,"minutes":14,"seconds":30,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smelly/Achilles/Llama/17548696.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2368,"difficulty":2.7574039053918433,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20689,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.687289,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Michael Lemonade","authId":"","name":"Elegant Michael Lemonade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Michael Lemonade","authId":"","name":"Elegant Michael Lemonade","CNNId":"","myGameChains":null,"banStatus":null},"id":17943952,"name":"Danger Drone Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elegant/Michael/Lemonade/17943952.jpg","createDate":{"time":1349281804000,"minutes":30,"seconds":4,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elegant/Michael/Lemonade/17943952.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1197,"difficulty":2.6506333578701997,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17944,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.685189,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Bart Popcorn","authId":"","name":"Grimy Bart Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Bart Popcorn","authId":"","name":"Grimy Bart Popcorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19906817,"name":"Hex Hyper Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grimy/Bart/Popcorn/19906817.jpg","createDate":{"time":1364219045000,"minutes":44,"seconds":5,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grimy/Bart/Popcorn/19906817.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":77,"difficulty":2.469688103606599,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14800,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.683126,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Max Taco","authId":"","name":"Stinky Max Taco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Max Taco","authId":"","name":"Stinky Max Taco","CNNId":"","myGameChains":null,"banStatus":null},"id":19347399,"name":"Challenge Echo Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stinky/Max/Taco/19347399.jpg","createDate":{"time":1357680210000,"minutes":23,"seconds":30,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stinky/Max/Taco/19347399.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2330,"difficulty":2.4424280892075654,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5123,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.671445,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vibrant Ed Fondue","authId":"","name":"Vibrant Ed Fondue","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vibrant Ed Fondue","authId":"","name":"Vibrant Ed Fondue","CNNId":"","myGameChains":null,"banStatus":null},"id":19707470,"name":"Adventure Target Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vibrant/Ed/Fondue/19707470.jpg","createDate":{"time":1363196564000,"minutes":42,"seconds":44,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vibrant/Ed/Fondue/19707470.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":63,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":402,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.666667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Quentin Hydra","authId":"","name":"Hyper Quentin Hydra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Quentin Hydra","authId":"","name":"Hyper Quentin Hydra","CNNId":"","myGameChains":null,"banStatus":null},"id":18782808,"name":"Terraspin Whirlwind Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hyper/Quentin/Hydra/18782808.jpg","createDate":{"time":1354911516000,"minutes":18,"seconds":36,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hyper/Quentin/Hydra/18782808.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2840,"difficulty":2.319562336857135,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5186,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.665809,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"11","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 = '7' 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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]