[{"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 = '5' 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":"Super Kenneth Bramble","authId":"","name":"Super Kenneth Bramble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Kenneth Bramble","authId":"","name":"Super Kenneth Bramble","CNNId":"","myGameChains":null,"banStatus":null},"id":19549100,"name":"Battle Brainstorm Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Kenneth/Bramble/19549100.jpg","createDate":{"time":1361013774000,"minutes":22,"seconds":54,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Kenneth/Bramble/19549100.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11910,"difficulty":1.3546454427935883,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18488,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.746739,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Clyde Smidgen","authId":"","name":"Earnest Clyde Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Clyde Smidgen","authId":"","name":"Earnest Clyde Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"id":19342072,"name":"Beast Robot Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Clyde/Smidgen/19342072.jpg","createDate":{"time":1357586137000,"minutes":15,"seconds":37,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Clyde/Smidgen/19342072.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34582,"difficulty":1.7474010351035159,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":110220,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.713794,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Hailey Mercury","authId":"","name":"Artful Hailey Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Hailey Mercury","authId":"","name":"Artful Hailey Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":18287530,"name":"Streak Atomic Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artful/Hailey/Mercury/18287530.jpg","createDate":{"time":1351358025000,"minutes":13,"seconds":45,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artful/Hailey/Mercury/18287530.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":921,"difficulty":2.495734126984127,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1370,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.705195,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Carlos Ghost","authId":"","name":"Vigilant Carlos Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Carlos Ghost","authId":"","name":"Vigilant Carlos Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":18247522,"name":"Giga Danger Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Carlos/Ghost/18247522.jpg","createDate":{"time":1351006839000,"minutes":40,"seconds":39,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Carlos/Ghost/18247522.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1612,"difficulty":1.3063247863247864,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5584,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.699634,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Duchess Minerva Warthog","authId":"","name":"Duchess Minerva Warthog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Duchess Minerva Warthog","authId":"","name":"Duchess Minerva Warthog","CNNId":"","myGameChains":null,"banStatus":null},"id":19874603,"name":"Pursuit Ben Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Duchess/Minerva/Warthog/19874603.jpg","createDate":{"time":1364044935000,"minutes":22,"seconds":15,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Duchess/Minerva/Warthog/19874603.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":753,"difficulty":1.8737244897959182,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4444,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.66639,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Noble Jared Skunk","authId":"","name":"Noble Jared Skunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Noble Jared Skunk","authId":"","name":"Noble Jared Skunk","CNNId":"","myGameChains":null,"banStatus":null},"id":19208093,"name":"Siege Shadow Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Noble/Jared/Skunk/19208093.jpg","createDate":{"time":1356610559000,"minutes":15,"seconds":59,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Noble/Jared/Skunk/19208093.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79050,"difficulty":1.630649473550222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":98100,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.656157,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Aaliyah Lavender","authId":"","name":"Amazing Aaliyah Lavender","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Aaliyah Lavender","authId":"","name":"Amazing Aaliyah Lavender","CNNId":"","myGameChains":null,"banStatus":null},"id":19634263,"name":"Adventure Adventure Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Aaliyah/Lavender/19634263.jpg","createDate":{"time":1362468257000,"minutes":24,"seconds":17,"hours":2,"month":2,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Aaliyah/Lavender/19634263.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5379,"difficulty":1.5816121090711504,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19905,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.625804,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly David Starfish","authId":"","name":"Silly David Starfish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly David Starfish","authId":"","name":"Silly David Starfish","CNNId":"","myGameChains":null,"banStatus":null},"id":18783565,"name":"Lightning Lightning Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/David/Starfish/18783565.jpg","createDate":{"time":1354913046000,"minutes":44,"seconds":6,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/David/Starfish/18783565.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":80,"difficulty":2.7916666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1052,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.6,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Yucky Rapunzel Ketchup","authId":"","name":"Yucky Rapunzel Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Yucky Rapunzel Ketchup","authId":"","name":"Yucky Rapunzel Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":18640862,"name":"Search Rescue Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Yucky/Rapunzel/Ketchup/18640862.jpg","createDate":{"time":1354307566000,"minutes":32,"seconds":46,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Yucky/Rapunzel/Ketchup/18640862.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":104,"difficulty":2.7277777777777774,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1794,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.583333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Ludwig Iceberg","authId":"","name":"Ultimate Ludwig Iceberg","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Ludwig Iceberg","authId":"","name":"Ultimate Ludwig Iceberg","CNNId":"","myGameChains":null,"banStatus":null},"id":18101296,"name":"Spike Doom Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Ludwig/Iceberg/18101296.jpg","createDate":{"time":1350057477000,"minutes":57,"seconds":57,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Ludwig/Iceberg/18101296.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":864,"difficulty":2.776312013154059,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":116262,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.530175,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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 = '5' 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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]