[{"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 = '8' 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":"Ruthless Erik Cosmos","authId":"","name":"Ruthless Erik Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Erik Cosmos","authId":"","name":"Ruthless Erik Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":17793432,"name":"Alien Cannonbolt Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Erik/Cosmos/17793432.jpg","createDate":{"time":1348720332000,"minutes":32,"seconds":12,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Erik/Cosmos/17793432.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":895,"difficulty":1.652936507936508,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1985,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.14623,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kooky Joshua Quasar","authId":"","name":"Kooky Joshua Quasar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kooky Joshua Quasar","authId":"","name":"Kooky Joshua Quasar","CNNId":"","myGameChains":null,"banStatus":null},"id":19505459,"name":"Earth Drone Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kooky/Joshua/Quasar/19505459.jpg","createDate":{"time":1360271090000,"minutes":4,"seconds":50,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kooky/Joshua/Quasar/19505459.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1712,"difficulty":2.4648743069795698,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6332,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.129095,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Benton Avocado","authId":"","name":"Babbling Benton Avocado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Babbling Benton Avocado","authId":"","name":"Babbling Benton Avocado","CNNId":"","myGameChains":null,"banStatus":null},"id":18351707,"name":"Pursuit Adventure Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Babbling/Benton/Avocado/18351707.jpg","createDate":{"time":1351880680000,"minutes":24,"seconds":40,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Babbling/Benton/Avocado/18351707.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":781,"difficulty":1.2497441951987407,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2221,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.128452,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rancid Dana Banjo","authId":"","name":"Rancid Dana Banjo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rancid Dana Banjo","authId":"","name":"Rancid Dana Banjo","CNNId":"","myGameChains":null,"banStatus":null},"id":19632331,"name":"Sonic Nitro Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rancid/Dana/Banjo/19632331.jpg","createDate":{"time":1362414821000,"minutes":33,"seconds":41,"hours":11,"month":2,"timezoneOffset":300,"year":113,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rancid/Dana/Banjo/19632331.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5575,"difficulty":2.2535094229924764,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":28075,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.125735,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Chris Samurai","authId":"","name":"Dubious Chris Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Chris Samurai","authId":"","name":"Dubious Chris Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":17778622,"name":"Ultimate Omniverse Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dubious/Chris/Samurai/17778622.jpg","createDate":{"time":1348672605000,"minutes":16,"seconds":45,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dubious/Chris/Samurai/17778622.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":63,"difficulty":1.5510204081632653,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5988,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.1,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Variable Forrest Thing","authId":"","name":"Variable Forrest Thing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Variable Forrest Thing","authId":"","name":"Variable Forrest Thing","CNNId":"","myGameChains":null,"banStatus":null},"id":19493571,"name":"Warrior Omniverse Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Variable/Forrest/Thing/19493571.jpg","createDate":{"time":1359998759000,"minutes":25,"seconds":59,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Variable/Forrest/Thing/19493571.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2993,"difficulty":2.4931293911760424,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29343,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.090597,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Chad Witch","authId":"","name":"Grimy Chad Witch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Chad Witch","authId":"","name":"Grimy Chad Witch","CNNId":"","myGameChains":null,"banStatus":null},"id":19360728,"name":"Hyper Echo Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grimy/Chad/Witch/19360728.jpg","createDate":{"time":1357924536000,"minutes":15,"seconds":36,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grimy/Chad/Witch/19360728.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1007,"difficulty":2.0201442151453106,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":38744,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.081238,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Perilous Carlos Kazoo","authId":"","name":"Perilous Carlos Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Perilous Carlos Kazoo","authId":"","name":"Perilous Carlos Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":18349956,"name":"Racer Robot Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Perilous/Carlos/Kazoo/18349956.jpg","createDate":{"time":1351865767000,"minutes":16,"seconds":7,"hours":10,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Perilous/Carlos/Kazoo/18349956.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41247,"difficulty":2.267076335985673,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":114853,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.078333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Quentin Jupiter","authId":"","name":"King Quentin Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Quentin Jupiter","authId":"","name":"King Quentin Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":18345305,"name":"Space Hex Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Quentin/Jupiter/18345305.jpg","createDate":{"time":1351807634000,"minutes":7,"seconds":14,"hours":18,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Quentin/Jupiter/18345305.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":43,"difficulty":2.7503506069967805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17803,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.077332,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Benson Yoyo","authId":"","name":"Superior Benson Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Benson Yoyo","authId":"","name":"Superior Benson Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19861084,"name":"Giga Fire Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superior/Benson/Yoyo/19861084.jpg","createDate":{"time":1363957758000,"minutes":9,"seconds":18,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superior/Benson/Yoyo/19861084.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":852,"difficulty":2.631970222354801,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5617,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.073106,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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 = '8' 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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]