[{"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 = '14' 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":"Elite David Scythe","authId":"","name":"Elite David Scythe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite David Scythe","authId":"","name":"Elite David Scythe","CNNId":"","myGameChains":null,"banStatus":null},"id":18521222,"name":"Blaster Nano Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/David/Scythe/18521222.jpg","createDate":{"time":1353355506000,"minutes":5,"seconds":6,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/David/Scythe/18521222.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2423,"difficulty":2.438709941947794,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10662,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.521393,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Roy Fireball","authId":"","name":"Majestic Roy Fireball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Roy Fireball","authId":"","name":"Majestic Roy Fireball","CNNId":"","myGameChains":null,"banStatus":null},"id":19967798,"name":"Atomic Humungousaur Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/Roy/Fireball/19967798.jpg","createDate":{"time":1364648240000,"minutes":57,"seconds":20,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/Roy/Fireball/19967798.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":920,"difficulty":2.8643769121236833,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16540,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.510135,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Luis Mallard","authId":"","name":"Orange Luis Mallard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Luis Mallard","authId":"","name":"Orange Luis Mallard","CNNId":"","myGameChains":null,"banStatus":null},"id":18557221,"name":"Alien Attack Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Orange/Luis/Mallard/18557221.jpg","createDate":{"time":1353622386000,"minutes":13,"seconds":6,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Orange/Luis/Mallard/18557221.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":72,"difficulty":2.3886760875498676,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15400,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.508088,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Joshua Whale","authId":"","name":"Groovy Joshua Whale","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Joshua Whale","authId":"","name":"Groovy Joshua Whale","CNNId":"","myGameChains":null,"banStatus":null},"id":18633719,"name":"Siege Shock Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Joshua/Whale/18633719.jpg","createDate":{"time":1354223918000,"minutes":18,"seconds":38,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Joshua/Whale/18633719.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38556,"difficulty":2.1253916421642782,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":64497,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.494962,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Funny Finn Bronco","authId":"","name":"Funny Finn Bronco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Funny Finn Bronco","authId":"","name":"Funny Finn Bronco","CNNId":"","myGameChains":null,"banStatus":null},"id":19939708,"name":"Dark Bloxx Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Funny/Finn/Bronco/19939708.jpg","createDate":{"time":1364475205000,"minutes":53,"seconds":25,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Funny/Finn/Bronco/19939708.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":348,"difficulty":2.861696507436135,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16390,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.491037,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Shawn Spatula","authId":"","name":"Colonel Shawn Spatula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Shawn Spatula","authId":"","name":"Colonel Shawn Spatula","CNNId":"","myGameChains":null,"banStatus":null},"id":19412748,"name":"Titan Star Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Shawn/Spatula/19412748.jpg","createDate":{"time":1358659177000,"minutes":19,"seconds":37,"hours":0,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Shawn/Spatula/19412748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6037,"difficulty":2.484698269813077,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34990,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.488568,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Uncommon Audrey Dinosaur","authId":"","name":"Uncommon Audrey Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Uncommon Audrey Dinosaur","authId":"","name":"Uncommon Audrey Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19222536,"name":"Turbo Rustbucket Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Uncommon/Audrey/Dinosaur/19222536.jpg","createDate":{"time":1356700047000,"minutes":7,"seconds":27,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Uncommon/Audrey/Dinosaur/19222536.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1971,"difficulty":1.525189096617668,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14812,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.487831,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jake Crowbar","authId":"","name":"Electric Jake Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jake Crowbar","authId":"","name":"Electric Jake Crowbar","CNNId":"","myGameChains":null,"banStatus":null},"id":18783685,"name":"Smash Plasma Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Jake/Crowbar/18783685.jpg","createDate":{"time":1354913280000,"minutes":48,"seconds":0,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Jake/Crowbar/18783685.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":869,"difficulty":2.4676157628332955,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11361,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.483886,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Rocky Tiger","authId":"","name":"Splendid Rocky Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Rocky Tiger","authId":"","name":"Splendid Rocky Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19545470,"name":"Adventure Stone Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Splendid/Rocky/Tiger/19545470.jpg","createDate":{"time":1360962020000,"minutes":0,"seconds":20,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Splendid/Rocky/Tiger/19545470.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3030,"difficulty":2.7433116546899377,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":58538,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.470943,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Steel","authId":"","name":"Admiral Spike Steel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Steel","authId":"","name":"Admiral Spike Steel","CNNId":"","myGameChains":null,"banStatus":null},"id":18638032,"name":"Steel Echo Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Spike/Steel/18638032.jpg","createDate":{"time":1354277358000,"minutes":9,"seconds":18,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Spike/Steel/18638032.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45384,"difficulty":1.7756996601589354,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":53024,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.470913,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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 = '14' 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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]