[{"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 = '15' 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":"Robotic Brad Alien","authId":"","name":"Robotic Brad Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robotic Brad Alien","authId":"","name":"Robotic Brad Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":19666739,"name":"Search Giga Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robotic/Brad/Alien/19666739.jpg","createDate":{"time":1363030959000,"minutes":42,"seconds":39,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robotic/Brad/Alien/19666739.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":521,"difficulty":2.621212121212121,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1861,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.276429,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Natasha Mumbles","authId":"","name":"Gleeful Natasha Mumbles","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gleeful Natasha Mumbles","authId":"","name":"Gleeful Natasha Mumbles","CNNId":"","myGameChains":null,"banStatus":null},"id":19721186,"name":"Steel Ambush Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gleeful/Natasha/Mumbles/19721186.jpg","createDate":{"time":1363260127000,"minutes":22,"seconds":7,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gleeful/Natasha/Mumbles/19721186.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":459,"difficulty":2.4991714015151514,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1336,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.269344,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Nathan Ninja","authId":"","name":"Crazy Nathan Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Nathan Ninja","authId":"","name":"Crazy Nathan Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":19861042,"name":"Animo Warrior Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Nathan/Ninja/19861042.jpg","createDate":{"time":1363957308000,"minutes":1,"seconds":48,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Nathan/Ninja/19861042.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5263,"difficulty":2.497650240743779,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16514,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.268193,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Brian Particle","authId":"","name":"Galactic Brian Particle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Brian Particle","authId":"","name":"Galactic Brian Particle","CNNId":"","myGameChains":null,"banStatus":null},"id":19967744,"name":"Solar Adventure Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Brian/Particle/19967744.jpg","createDate":{"time":1364647988000,"minutes":53,"seconds":8,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Brian/Particle/19967744.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":494,"difficulty":2.3839285714285716,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1098,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.266667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Liam Avator","authId":"","name":"Baroness Liam Avator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Liam Avator","authId":"","name":"Baroness Liam Avator","CNNId":"","myGameChains":null,"banStatus":null},"id":19760103,"name":"Star Shock Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Liam/Avator/19760103.jpg","createDate":{"time":1363434926000,"minutes":55,"seconds":26,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Liam/Avator/19760103.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":111,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1891,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Sherman Fury","authId":"","name":"Prickly Sherman Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prickly Sherman Fury","authId":"","name":"Prickly Sherman Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":19967789,"name":"Defense Steel Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prickly/Sherman/Fury/19967789.jpg","createDate":{"time":1364648201000,"minutes":56,"seconds":41,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prickly/Sherman/Fury/19967789.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3614,"difficulty":2.4381778492772823,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25250,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.2388,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Charming Scooter Cyclone","authId":"","name":"Charming Scooter Cyclone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Charming Scooter Cyclone","authId":"","name":"Charming Scooter Cyclone","CNNId":"","myGameChains":null,"banStatus":null},"id":19967760,"name":"Adventure Defense Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Charming/Scooter/Cyclone/19967760.jpg","createDate":{"time":1364648061000,"minutes":54,"seconds":21,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Charming/Scooter/Cyclone/19967760.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":187,"difficulty":1.8333333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1401,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.238095,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Rosemary Thorax","authId":"","name":"Speedy Rosemary Thorax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Rosemary Thorax","authId":"","name":"Speedy Rosemary Thorax","CNNId":"","myGameChains":null,"banStatus":null},"id":19967781,"name":"Adventure Racer Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Rosemary/Thorax/19967781.jpg","createDate":{"time":1364648148000,"minutes":55,"seconds":48,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Rosemary/Thorax/19967781.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3516,"difficulty":1.5361782296650717,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5381,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.229161,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical David Calamari","authId":"","name":"Radical David Calamari","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical David Calamari","authId":"","name":"Radical David Calamari","CNNId":"","myGameChains":null,"banStatus":null},"id":19705155,"name":"Chase Pursuit Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radical/David/Calamari/19705155.jpg","createDate":{"time":1363186862000,"minutes":1,"seconds":2,"hours":11,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radical/David/Calamari/19705155.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":495,"difficulty":2.6674166792568075,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19204,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.20302,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Mason Droid","authId":"","name":"Western Mason Droid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Mason Droid","authId":"","name":"Western Mason Droid","CNNId":"","myGameChains":null,"banStatus":null},"id":19760079,"name":"Adventure Pulse Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Mason/Droid/19760079.jpg","createDate":{"time":1363434827000,"minutes":53,"seconds":47,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Mason/Droid/19760079.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3230,"difficulty":2.2107168357438045,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4846,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.20015,"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 = '15' 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"}}]