[{"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 = '1' 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":"Gigantic Benton Concrete","authId":"","name":"Gigantic Benton Concrete","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Benton Concrete","authId":"","name":"Gigantic Benton Concrete","CNNId":"","myGameChains":null,"banStatus":null},"id":19573513,"name":"Drone Iron Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Benton/Concrete/19573513.jpg","createDate":{"time":1361326718000,"minutes":18,"seconds":38,"hours":21,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Benton/Concrete/19573513.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19096,"difficulty":2.376729318066217,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59361,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.830276,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unlucky Karen Cinnamon","authId":"","name":"Unlucky Karen Cinnamon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unlucky Karen Cinnamon","authId":"","name":"Unlucky Karen Cinnamon","CNNId":"","myGameChains":null,"banStatus":null},"id":19840915,"name":"Shock Adventure Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unlucky/Karen/Cinnamon/19840915.jpg","createDate":{"time":1363789075000,"minutes":17,"seconds":55,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unlucky/Karen/Cinnamon/19840915.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2657,"difficulty":2.260760296984332,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13109,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.830077,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Snappy Lancelot Thud","authId":"","name":"Snappy Lancelot Thud","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Snappy Lancelot Thud","authId":"","name":"Snappy Lancelot Thud","CNNId":"","myGameChains":null,"banStatus":null},"id":17209276,"name":"Light Battle Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Snappy/Lancelot/Thud/17209276.jpg","createDate":{"time":1341991942000,"minutes":32,"seconds":22,"hours":3,"month":6,"timezoneOffset":240,"year":112,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Snappy/Lancelot/Thud/17209276.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":216,"difficulty":2.6108843537414965,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4558,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.813889,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Anthony Karate","authId":"","name":"King Anthony Karate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Anthony Karate","authId":"","name":"King Anthony Karate","CNNId":"","myGameChains":null,"banStatus":null},"id":19331312,"name":"Hex Gear Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Anthony/Karate/19331312.jpg","createDate":{"time":1357472752000,"minutes":45,"seconds":52,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Anthony/Karate/19331312.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1360,"difficulty":2.7469135802469133,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1814,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.779911,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Justin Rocket","authId":"","name":"Grand Justin Rocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grand Justin Rocket","authId":"","name":"Grand Justin Rocket","CNNId":"","myGameChains":null,"banStatus":null},"id":19446306,"name":"Adventure Swampfire Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grand/Justin/Rocket/19446306.jpg","createDate":{"time":1359190854000,"minutes":0,"seconds":54,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grand/Justin/Rocket/19446306.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2134,"difficulty":1.560875894435677,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8422,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.76332,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Restless Ace","authId":"","name":"Restless Ace","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Restless Ace","authId":"","name":"Restless Ace","CNNId":"","myGameChains":null,"banStatus":null},"id":19619657,"name":"Ultimate Cosmic Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Restless/Ace/19619657.jpg","createDate":{"time":1362228945000,"minutes":55,"seconds":45,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Restless/Ace/19619657.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1806,"difficulty":1.5992841770335378,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5243,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.732252,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Scooby Riddle","authId":"","name":"Magical Scooby Riddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Scooby Riddle","authId":"","name":"Magical Scooby Riddle","CNNId":"","myGameChains":null,"banStatus":null},"id":19364378,"name":"Danger Search Whirlwind","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magical/Scooby/Riddle/19364378.jpg","createDate":{"time":1357962355000,"minutes":45,"seconds":55,"hours":22,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magical/Scooby/Riddle/19364378.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6682,"difficulty":1.8001377206833442,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15196,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.698988,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Noisy Jeff Fez","authId":"","name":"Noisy Jeff Fez","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Noisy Jeff Fez","authId":"","name":"Noisy Jeff Fez","CNNId":"","myGameChains":null,"banStatus":null},"id":18003890,"name":"Steel Ultra Water","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Noisy/Jeff/Fez/18003890.jpg","createDate":{"time":1349552409000,"minutes":40,"seconds":9,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Noisy/Jeff/Fez/18003890.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":534,"difficulty":2.7777777777777777,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2425,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.671958,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ryan Bongo","authId":"","name":"Soggy Ryan Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ryan Bongo","authId":"","name":"Soggy Ryan Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":17804728,"name":"Swampfire Fire Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Soggy/Ryan/Bongo/17804728.jpg","createDate":{"time":1348786216000,"minutes":50,"seconds":16,"hours":18,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Soggy/Ryan/Bongo/17804728.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14290,"difficulty":1.9325021167548364,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":93009,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.653675,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Sherri Troll","authId":"","name":"Graceful Sherri Troll","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Sherri Troll","authId":"","name":"Graceful Sherri Troll","CNNId":"","myGameChains":null,"banStatus":null},"id":19545966,"name":"Robot Doom Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Graceful/Sherri/Troll/19545966.jpg","createDate":{"time":1360967040000,"minutes":24,"seconds":0,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Graceful/Sherri/Troll/19545966.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2787,"difficulty":1.7332710173752484,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4996,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.57993,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"121","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 = '1' 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":"130","currentPageToDisplay":13,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]