[{"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 = '2' 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":"Juggling Paul Photon","authId":"","name":"Juggling Paul Photon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Juggling Paul Photon","authId":"","name":"Juggling Paul Photon","CNNId":"","myGameChains":null,"banStatus":null},"id":19222465,"name":"Challenge Animo Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Juggling/Paul/Photon/19222465.jpg","createDate":{"time":1356699532000,"minutes":58,"seconds":52,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Juggling/Paul/Photon/19222465.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1317,"difficulty":2.6497424010930395,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12689,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.47997,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Scooter","authId":"","name":"Rowdy Scooter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Scooter","authId":"","name":"Rowdy Scooter","CNNId":"","myGameChains":null,"banStatus":null},"id":19053016,"name":"Mission Warrior BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rowdy/Scooter/19053016.jpg","createDate":{"time":1355739666000,"minutes":21,"seconds":6,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rowdy/Scooter/19053016.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":372,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1656,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.479167,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quantum Lucius Avocado","authId":"","name":"Quantum Lucius Avocado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quantum Lucius Avocado","authId":"","name":"Quantum Lucius Avocado","CNNId":"","myGameChains":null,"banStatus":null},"id":17793302,"name":"Hyper Sonic Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quantum/Lucius/Avocado/17793302.jpg","createDate":{"time":1348718851000,"minutes":7,"seconds":31,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quantum/Lucius/Avocado/17793302.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2685,"difficulty":2.7004273504273506,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6098,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.469886,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Buster Acorn","authId":"","name":"Crafty Buster Acorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Buster Acorn","authId":"","name":"Crafty Buster Acorn","CNNId":"","myGameChains":null,"banStatus":null},"id":17756353,"name":"Galaxy Mega Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Buster/Acorn/17756353.jpg","createDate":{"time":1348550775000,"minutes":26,"seconds":15,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Buster/Acorn/17756353.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1808,"difficulty":1.898554215122904,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24434,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.469181,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":19053291,"name":"Droid Plasma Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Edd/Atlas/19053291.jpg","createDate":{"time":1355744465000,"minutes":41,"seconds":5,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Edd/Atlas/19053291.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":296,"difficulty":2.8472222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5542,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.462222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Vern Cactus","authId":"","name":"Extreme Vern Cactus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Vern Cactus","authId":"","name":"Extreme Vern Cactus","CNNId":"","myGameChains":null,"banStatus":null},"id":17793395,"name":"Techno Quake Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Vern/Cactus/17793395.jpg","createDate":{"time":1348719732000,"minutes":22,"seconds":12,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Vern/Cactus/17793395.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5167,"difficulty":2.2203170434774084,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14731,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.442447,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Albert Cookie","authId":"","name":"Singular Albert Cookie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Albert Cookie","authId":"","name":"Singular Albert Cookie","CNNId":"","myGameChains":null,"banStatus":null},"id":18782810,"name":"Stone Alien Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Singular/Albert/Cookie/18782810.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":"Singular/Albert/Cookie/18782810.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":843,"difficulty":2.6426573426573428,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3434,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.441791,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Cindy Varmint","authId":"","name":"Grim Cindy Varmint","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Cindy Varmint","authId":"","name":"Grim Cindy Varmint","CNNId":"","myGameChains":null,"banStatus":null},"id":18004974,"name":"Charge Doom Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grim/Cindy/Varmint/18004974.jpg","createDate":{"time":1349554470000,"minutes":14,"seconds":30,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grim/Cindy/Varmint/18004974.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":270,"difficulty":2.15625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1722,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.427778,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Dennis Dinosaur","authId":"","name":"Dubious Dennis Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dubious Dennis Dinosaur","authId":"","name":"Dubious Dennis Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19505390,"name":"Iron Big Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dubious/Dennis/Dinosaur/19505390.jpg","createDate":{"time":1360270023000,"minutes":47,"seconds":3,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dubious/Dennis/Dinosaur/19505390.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":487,"difficulty":2.2839506172839505,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5712,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.42,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Tyler Sphinx","authId":"","name":"Weird Tyler Sphinx","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Tyler Sphinx","authId":"","name":"Weird Tyler Sphinx","CNNId":"","myGameChains":null,"banStatus":null},"id":19128742,"name":"Target Charge Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Weird/Tyler/Sphinx/19128742.jpg","createDate":{"time":1356197896000,"minutes":38,"seconds":16,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Weird/Tyler/Sphinx/19128742.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2237,"difficulty":1.204004329004329,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2836,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.415344,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"41","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 = '2' 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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]