[{"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":"Average Ernie Whisper","authId":"","name":"Average Ernie Whisper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Average Ernie Whisper","authId":"","name":"Average Ernie Whisper","CNNId":"","myGameChains":null,"banStatus":null},"id":19477450,"name":"Water Water Water","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Average/Ernie/Whisper/19477450.jpg","createDate":{"time":1359756184000,"minutes":3,"seconds":4,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Average/Ernie/Whisper/19477450.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7591,"difficulty":2.1974411100054714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":28252,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.618082,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Popular Ivan Weasel","authId":"","name":"Popular Ivan Weasel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Popular Ivan Weasel","authId":"","name":"Popular Ivan Weasel","CNNId":"","myGameChains":null,"banStatus":null},"id":19402686,"name":"Escape Earth BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Popular/Ivan/Weasel/19402686.jpg","createDate":{"time":1358547131000,"minutes":12,"seconds":11,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Popular/Ivan/Weasel/19402686.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3314,"difficulty":2.552064777327935,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5157,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.50958,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Kennedy Noodle","authId":"","name":"Nimble Kennedy Noodle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Kennedy Noodle","authId":"","name":"Nimble Kennedy Noodle","CNNId":"","myGameChains":null,"banStatus":null},"id":18427052,"name":"Siege Fury Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nimble/Kennedy/Noodle/18427052.jpg","createDate":{"time":1352495718000,"minutes":15,"seconds":18,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nimble/Kennedy/Noodle/18427052.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6618,"difficulty":2.6933696317413043,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":121818,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.496756,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Travis Blast","authId":"","name":"Flying Travis Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Flying Travis Blast","authId":"","name":"Flying Travis Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":18469408,"name":"Adventure Rescue Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Flying/Travis/Blast/18469408.jpg","createDate":{"time":1352757370000,"minutes":56,"seconds":10,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Flying/Travis/Blast/18469408.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":228,"difficulty":1.5450892857142857,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1042,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.483333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Mike Cookie","authId":"","name":"Loony Mike Cookie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Mike Cookie","authId":"","name":"Loony Mike Cookie","CNNId":"","myGameChains":null,"banStatus":null},"id":18005007,"name":"Rampage Animo Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Mike/Cookie/18005007.jpg","createDate":{"time":1349554510000,"minutes":15,"seconds":10,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Mike/Cookie/18005007.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":851,"difficulty":1.7089285714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":989,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.47619,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Biff Penguin","authId":"","name":"Peppy Biff Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Biff Penguin","authId":"","name":"Peppy Biff Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":17957545,"name":"Giga Light Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peppy/Biff/Penguin/17957545.jpg","createDate":{"time":1349375558000,"minutes":32,"seconds":38,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peppy/Biff/Penguin/17957545.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8957,"difficulty":1.816110807746984,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17389,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.384501,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Natalia Snake","authId":"","name":"Towering Natalia Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Natalia Snake","authId":"","name":"Towering Natalia Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":18098353,"name":"Assault Droid Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Natalia/Snake/18098353.jpg","createDate":{"time":1350037665000,"minutes":27,"seconds":45,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Natalia/Snake/18098353.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2441,"difficulty":1.4689312702138886,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4415,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.358029,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Maxwell Ape","authId":"","name":"Awesome Maxwell Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Maxwell Ape","authId":"","name":"Awesome Maxwell Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":19604038,"name":"Hero Escape Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Maxwell/Ape/19604038.jpg","createDate":{"time":1361831242000,"minutes":27,"seconds":22,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Maxwell/Ape/19604038.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":624,"difficulty":1.3111111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1074,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.313889,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish Wayne Dinosaur","authId":"","name":"Freakish Wayne Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Freakish Wayne Dinosaur","authId":"","name":"Freakish Wayne Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":18995529,"name":"Iron Power Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Freakish/Wayne/Dinosaur/18995529.jpg","createDate":{"time":1355561822000,"minutes":57,"seconds":2,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Freakish/Wayne/Dinosaur/18995529.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":61,"difficulty":2.4388888888888887,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1611,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.28125,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Chrissy Unicorn","authId":"","name":"Quirky Chrissy Unicorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Chrissy Unicorn","authId":"","name":"Quirky Chrissy Unicorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19837169,"name":"Spark Chase Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Chrissy/Unicorn/19837169.jpg","createDate":{"time":1363741741000,"minutes":9,"seconds":1,"hours":21,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Chrissy/Unicorn/19837169.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25964,"difficulty":2.1373269324409274,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40895,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.263306,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]