[{"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 = '16' 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":"Fabulous Jared","authId":"","name":"Fabulous Jared","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Jared","authId":"","name":"Fabulous Jared","CNNId":"","myGameChains":null,"banStatus":null},"id":19661213,"name":"Adventure Rocket Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Jared/19661213.jpg","createDate":{"time":1363011912000,"minutes":25,"seconds":12,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Jared/19661213.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13384,"difficulty":1.8562030710588269,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23287,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.551936,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Absurd Bill Ballyhoo","authId":"","name":"Absurd Bill Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Absurd Bill Ballyhoo","authId":"","name":"Absurd Bill Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19933847,"name":"Adventure Cosmic Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Absurd/Bill/Ballyhoo/19933847.jpg","createDate":{"time":1364417915000,"minutes":58,"seconds":35,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Absurd/Bill/Ballyhoo/19933847.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2283,"difficulty":1.4230692276910764,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2499,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.511127,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Shane Twist","authId":"","name":"Humorous Shane Twist","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humorous Shane Twist","authId":"","name":"Humorous Shane Twist","CNNId":"","myGameChains":null,"banStatus":null},"id":19707565,"name":"Fire Thunder Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humorous/Shane/Twist/19707565.jpg","createDate":{"time":1363196886000,"minutes":48,"seconds":6,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humorous/Shane/Twist/19707565.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6498,"difficulty":1.3250037547696847,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15054,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.504542,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Ezekiel Figment","authId":"","name":"Leaping Ezekiel Figment","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Ezekiel Figment","authId":"","name":"Leaping Ezekiel Figment","CNNId":"","myGameChains":null,"banStatus":null},"id":19759479,"name":"Iron Adventure Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Leaping/Ezekiel/Figment/19759479.jpg","createDate":{"time":1363431868000,"minutes":4,"seconds":28,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Leaping/Ezekiel/Figment/19759479.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30166,"difficulty":2.571367384530222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":120646,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":2.501992,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Roy Elf","authId":"","name":"Digital Roy Elf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Roy Elf","authId":"","name":"Digital Roy Elf","CNNId":"","myGameChains":null,"banStatus":null},"id":19691318,"name":"Lightning Ambush Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Roy/Elf/19691318.jpg","createDate":{"time":1363121610000,"minutes":53,"seconds":30,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Roy/Elf/19691318.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":178,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":903,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cheerful Kyle Biscuit","authId":"","name":"Cheerful Kyle Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cheerful Kyle Biscuit","authId":"","name":"Cheerful Kyle Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"id":19721374,"name":"Chill Giga Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cheerful/Kyle/Biscuit/19721374.jpg","createDate":{"time":1363261607000,"minutes":46,"seconds":47,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cheerful/Kyle/Biscuit/19721374.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":415,"difficulty":2.3583333333333334,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1540,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Scott Rebel","authId":"","name":"Super Scott Rebel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Scott Rebel","authId":"","name":"Super Scott Rebel","CNNId":"","myGameChains":null,"banStatus":null},"id":19662927,"name":"Lightning Star Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Scott/Rebel/19662927.jpg","createDate":{"time":1363019297000,"minutes":28,"seconds":17,"hours":12,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Scott/Rebel/19662927.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":246,"difficulty":1.5805555555555555,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":902,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.466667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Perseus Volcano","authId":"","name":"Stormy Perseus Volcano","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Perseus Volcano","authId":"","name":"Stormy Perseus Volcano","CNNId":"","myGameChains":null,"banStatus":null},"id":19759339,"name":"Razor Streak Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stormy/Perseus/Volcano/19759339.jpg","createDate":{"time":1363431026000,"minutes":50,"seconds":26,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stormy/Perseus/Volcano/19759339.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17,"difficulty":2.390625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1583,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.433333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Bill Haystack","authId":"","name":"Visible Bill Haystack","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Bill Haystack","authId":"","name":"Visible Bill Haystack","CNNId":"","myGameChains":null,"banStatus":null},"id":19721070,"name":"Pursuit Whirlwind Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Visible/Bill/Haystack/19721070.jpg","createDate":{"time":1363259090000,"minutes":4,"seconds":50,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Visible/Bill/Haystack/19721070.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":111,"difficulty":1.8348214285714286,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1200,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.432981,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Doc Cobra","authId":"","name":"Crazy Doc Cobra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Doc Cobra","authId":"","name":"Crazy Doc Cobra","CNNId":"","myGameChains":null,"banStatus":null},"id":19990977,"name":"Droid Ultimate Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Doc/Cobra/19990977.jpg","createDate":{"time":1364808211000,"minutes":23,"seconds":31,"hours":5,"month":3,"timezoneOffset":240,"year":113,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Doc/Cobra/19990977.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11152,"difficulty":2.011035932119114,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18238,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.38154,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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 = '16' 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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]