[{"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 = '9' 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":"Jingling Benjamin Creature","authId":"","name":"Jingling Benjamin Creature","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jingling Benjamin Creature","authId":"","name":"Jingling Benjamin Creature","CNNId":"","myGameChains":null,"banStatus":null},"id":19566047,"name":"Energy Solar Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jingling/Benjamin/Creature/19566047.jpg","createDate":{"time":1361214604000,"minutes":10,"seconds":4,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jingling/Benjamin/Creature/19566047.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":356,"difficulty":1.84375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2802,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.979167,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Neutral Jose Scythe","authId":"","name":"Neutral Jose Scythe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Neutral Jose Scythe","authId":"","name":"Neutral Jose Scythe","CNNId":"","myGameChains":null,"banStatus":null},"id":18170191,"name":"Earth Nova Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Neutral/Jose/Scythe/18170191.jpg","createDate":{"time":1350361966000,"minutes":32,"seconds":46,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Neutral/Jose/Scythe/18170191.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":271,"difficulty":2.48,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1460,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.957823,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Horatio Forklift","authId":"","name":"Crazy Horatio Forklift","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Horatio Forklift","authId":"","name":"Crazy Horatio Forklift","CNNId":"","myGameChains":null,"banStatus":null},"id":17216550,"name":"Rampage Danger Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Horatio/Forklift/17216550.jpg","createDate":{"time":1342184485000,"minutes":1,"seconds":25,"hours":9,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Horatio/Forklift/17216550.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18398,"difficulty":2.247956111880799,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39026,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":11,"rating":3.946075,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Beowulf Skylark","authId":"","name":"Agile Beowulf Skylark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Beowulf Skylark","authId":"","name":"Agile Beowulf Skylark","CNNId":"","myGameChains":null,"banStatus":null},"id":18402535,"name":"Mission Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Agile/Beowulf/Skylark/18402535.jpg","createDate":{"time":1352223135000,"minutes":32,"seconds":15,"hours":12,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Agile/Beowulf/Skylark/18402535.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16440,"difficulty":1.3778283247217387,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54901,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.925814,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Sharon Dingo","authId":"","name":"Magical Sharon Dingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Sharon Dingo","authId":"","name":"Magical Sharon Dingo","CNNId":"","myGameChains":null,"banStatus":null},"id":17216312,"name":"Hero Pulse Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magical/Sharon/Dingo/17216312.jpg","createDate":{"time":1342176221000,"minutes":43,"seconds":41,"hours":6,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magical/Sharon/Dingo/17216312.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":95,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1026,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.92,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Keith Icicle","authId":"","name":"Extreme Keith Icicle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Keith Icicle","authId":"","name":"Extreme Keith Icicle","CNNId":"","myGameChains":null,"banStatus":null},"id":19489435,"name":"Beast Streak Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Keith/Icicle/19489435.jpg","createDate":{"time":1359918834000,"minutes":13,"seconds":54,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Keith/Icicle/19489435.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9669,"difficulty":1.2165114163122062,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12060,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.919504,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Ray Raptor","authId":"","name":"Stormy Ray Raptor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stormy Ray Raptor","authId":"","name":"Stormy Ray Raptor","CNNId":"","myGameChains":null,"banStatus":null},"id":19517386,"name":"Robot Danger Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stormy/Ray/Raptor/19517386.jpg","createDate":{"time":1360448381000,"minutes":19,"seconds":41,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stormy/Ray/Raptor/19517386.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":109,"difficulty":1.8472222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3634,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.919323,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Sid Rocket","authId":"","name":"Friendly Sid Rocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Sid Rocket","authId":"","name":"Friendly Sid Rocket","CNNId":"","myGameChains":null,"banStatus":null},"id":18127615,"name":"Water Adventure Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Sid/Rocket/18127615.jpg","createDate":{"time":1350158364000,"minutes":59,"seconds":24,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Sid/Rocket/18127615.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4450,"difficulty":2.0583568831497123,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":114353,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.910615,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Mike Samurai","authId":"","name":"Alien Mike Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Mike Samurai","authId":"","name":"Alien Mike Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":19505409,"name":"Defense Adventure Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Mike/Samurai/19505409.jpg","createDate":{"time":1360270377000,"minutes":52,"seconds":57,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Mike/Samurai/19505409.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":85,"difficulty":2.479166666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1271,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.888889,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Misty Zinger","authId":"","name":"Gruesome Misty Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Misty Zinger","authId":"","name":"Gruesome Misty Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":19221759,"name":"Atomic Robot Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Misty/Zinger/19221759.jpg","createDate":{"time":1356692767000,"minutes":6,"seconds":7,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Misty/Zinger/19221759.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":112,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":965,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.88,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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 = '9' 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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]