[{"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":"Speedy Robert Tractor","authId":"","name":"Speedy Robert Tractor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Robert Tractor","authId":"","name":"Speedy Robert Tractor","CNNId":"","myGameChains":null,"banStatus":null},"id":19874564,"name":"Spark Spark Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Robert/Tractor/19874564.jpg","createDate":{"time":1364044751000,"minutes":19,"seconds":11,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Robert/Tractor/19874564.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":420,"difficulty":2.4583333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":900,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.952381,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Exciting Courtney Foghorn","authId":"","name":"Exciting Courtney Foghorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Exciting Courtney Foghorn","authId":"","name":"Exciting Courtney Foghorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19707317,"name":"Adventure Rocket Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Exciting/Courtney/Foghorn/19707317.jpg","createDate":{"time":1363196006000,"minutes":33,"seconds":26,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Exciting/Courtney/Foghorn/19707317.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":273,"difficulty":2.6186750625294266,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9528,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.948736,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spicy Ethan Rumble","authId":"","name":"Spicy Ethan Rumble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spicy Ethan Rumble","authId":"","name":"Spicy Ethan Rumble","CNNId":"","myGameChains":null,"banStatus":null},"id":19707506,"name":"Rampage Racer Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spicy/Ethan/Rumble/19707506.jpg","createDate":{"time":1363196644000,"minutes":44,"seconds":4,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spicy/Ethan/Rumble/19707506.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":737,"difficulty":2.353163618388532,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":998,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.940318,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Biff Cobweb","authId":"","name":"Chilly Biff Cobweb","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Chilly Biff Cobweb","authId":"","name":"Chilly Biff Cobweb","CNNId":"","myGameChains":null,"banStatus":null},"id":19874549,"name":"Earth Echo Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Chilly/Biff/Cobweb/19874549.jpg","createDate":{"time":1364044700000,"minutes":18,"seconds":20,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Chilly/Biff/Cobweb/19874549.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":127,"difficulty":2.7916666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":936,"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":"Ironclad Genghis Plankton","authId":"","name":"Ironclad Genghis Plankton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Genghis Plankton","authId":"","name":"Ironclad Genghis Plankton","CNNId":"","myGameChains":null,"banStatus":null},"id":19760157,"name":"Hyper Adventure Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironclad/Genghis/Plankton/19760157.jpg","createDate":{"time":1363435122000,"minutes":58,"seconds":42,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironclad/Genghis/Plankton/19760157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2122,"difficulty":1.4298425173038176,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9381,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.833791,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Egbert Donkey","authId":"","name":"Extreme Egbert Donkey","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Egbert Donkey","authId":"","name":"Extreme Egbert Donkey","CNNId":"","myGameChains":null,"banStatus":null},"id":19861063,"name":"Alien Thunder Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Egbert/Donkey/19861063.jpg","createDate":{"time":1363957503000,"minutes":5,"seconds":3,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Egbert/Donkey/19861063.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":553,"difficulty":2.3222222222222224,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":963,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.833333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Karl Fossil","authId":"","name":"Famous Karl Fossil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Karl Fossil","authId":"","name":"Famous Karl Fossil","CNNId":"","myGameChains":null,"banStatus":null},"id":19721433,"name":"Kickin' Hawk Adventure Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Karl/Fossil/19721433.jpg","createDate":{"time":1363262192000,"minutes":56,"seconds":32,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Karl/Fossil/19721433.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1148,"difficulty":1.5866666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1258,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.816667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dizzy Gus Gorgon","authId":"","name":"Dizzy Gus Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dizzy Gus Gorgon","authId":"","name":"Dizzy Gus Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"id":19662312,"name":"Big Rescue Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dizzy/Gus/Gorgon/19662312.jpg","createDate":{"time":1363017184000,"minutes":53,"seconds":4,"hours":11,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dizzy/Gus/Gorgon/19662312.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6943,"difficulty":2.106349503002343,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16942,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.789372,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Able Orville Orchid","authId":"","name":"Able Orville Orchid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Able Orville Orchid","authId":"","name":"Able Orville Orchid","CNNId":"","myGameChains":null,"banStatus":null},"id":19721346,"name":"Magno Laser Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Able/Orville/Orchid/19721346.jpg","createDate":{"time":1363261461000,"minutes":44,"seconds":21,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Able/Orville/Orchid/19721346.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":675,"difficulty":1.5769230769230769,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":886,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.775397,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Melodic Pam Rhombus","authId":"","name":"Melodic Pam Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Melodic Pam Rhombus","authId":"","name":"Melodic Pam Rhombus","CNNId":"","myGameChains":null,"banStatus":null},"id":19831782,"name":"Drone Hyper Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Melodic/Pam/Rhombus/19831782.jpg","createDate":{"time":1363716859000,"minutes":14,"seconds":19,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Melodic/Pam/Rhombus/19831782.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4241,"difficulty":2.2483072299204103,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12936,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.748829,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]