[{"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":"Grizzly Rocky Burst","authId":"","name":"Grizzly Rocky Burst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Rocky Burst","authId":"","name":"Grizzly Rocky Burst","CNNId":"","myGameChains":null,"banStatus":null},"id":18287708,"name":"Omniverse Adventure Humungousaur","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Rocky/Burst/18287708.jpg","createDate":{"time":1351358723000,"minutes":25,"seconds":23,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Rocky/Burst/18287708.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2376,"difficulty":2.196910957666401,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20128,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.341035,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quantum Benson Samurai","authId":"","name":"Quantum Benson Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quantum Benson Samurai","authId":"","name":"Quantum Benson Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":19806822,"name":"Rumble Clash Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quantum/Benson/Samurai/19806822.jpg","createDate":{"time":1363555468000,"minutes":24,"seconds":28,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quantum/Benson/Samurai/19806822.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1367,"difficulty":2.253541021671827,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5045,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.309228,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Emperor Kaitlin Hiccup","authId":"","name":"Emperor Kaitlin Hiccup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Emperor Kaitlin Hiccup","authId":"","name":"Emperor Kaitlin Hiccup","CNNId":"","myGameChains":null,"banStatus":null},"id":18707571,"name":"Gear Warp Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Emperor/Kaitlin/Hiccup/18707571.jpg","createDate":{"time":1354658399000,"minutes":59,"seconds":59,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Emperor/Kaitlin/Hiccup/18707571.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":227,"difficulty":2.888888888888889,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1692,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spicy Bella Universe","authId":"","name":"Spicy Bella Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spicy Bella Universe","authId":"","name":"Spicy Bella Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":19391557,"name":"Slam Shock Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spicy/Bella/Universe/19391557.jpg","createDate":{"time":1358337457000,"minutes":57,"seconds":37,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spicy/Bella/Universe/19391557.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":337,"difficulty":2.6666666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2706,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ticklish Arthur Mallard","authId":"","name":"Ticklish Arthur Mallard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ticklish Arthur Mallard","authId":"","name":"Ticklish Arthur Mallard","CNNId":"","myGameChains":null,"banStatus":null},"id":19604050,"name":"Shock Swampfire Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ticklish/Arthur/Mallard/19604050.jpg","createDate":{"time":1361831326000,"minutes":28,"seconds":46,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ticklish/Arthur/Mallard/19604050.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":205,"difficulty":2.6834656084656086,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4276,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.298148,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Sterling Hacksaw","authId":"","name":"Graceful Sterling Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Sterling Hacksaw","authId":"","name":"Graceful Sterling Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"id":17208923,"name":"Swampfire Energy Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Graceful/Sterling/Hacksaw/17208923.jpg","createDate":{"time":1341975510000,"minutes":58,"seconds":30,"hours":22,"month":6,"timezoneOffset":240,"year":112,"day":2,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Graceful/Sterling/Hacksaw/17208923.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4684,"difficulty":1.7784016443379171,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45194,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":17,"rating":4.296809,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Naomi Lard","authId":"","name":"Strong Naomi Lard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Naomi Lard","authId":"","name":"Strong Naomi Lard","CNNId":"","myGameChains":null,"banStatus":null},"id":17585372,"name":"Swampfire Razor Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Naomi/Lard/17585372.jpg","createDate":{"time":1348256169000,"minutes":36,"seconds":9,"hours":15,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Naomi/Lard/17585372.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":371,"difficulty":1.875,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1234,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.293333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Ray Spider","authId":"","name":"Mystic Ray Spider","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mystic Ray Spider","authId":"","name":"Mystic Ray Spider","CNNId":"","myGameChains":null,"banStatus":null},"id":19603642,"name":"Robot Smash Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mystic/Ray/Spider/19603642.jpg","createDate":{"time":1361823405000,"minutes":16,"seconds":45,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mystic/Ray/Spider/19603642.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3132,"difficulty":2.1955606436438444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32843,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.288512,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Miranda Jamboree","authId":"","name":"Towering Miranda Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Miranda Jamboree","authId":"","name":"Towering Miranda Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":19402727,"name":"Spike Shadow Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Miranda/Jamboree/19402727.jpg","createDate":{"time":1358547410000,"minutes":16,"seconds":50,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Miranda/Jamboree/19402727.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7408,"difficulty":2.318960868004091,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11566,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.28513,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Heidi Fez","authId":"","name":"Dormant Heidi Fez","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Heidi Fez","authId":"","name":"Dormant Heidi Fez","CNNId":"","myGameChains":null,"banStatus":null},"id":19537276,"name":"Mission Galaxy Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dormant/Heidi/Fez/19537276.jpg","createDate":{"time":1360794405000,"minutes":26,"seconds":45,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dormant/Heidi/Fez/19537276.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":856,"difficulty":2.5210884353741494,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2523,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.283951,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"61","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":"70","currentPageToDisplay":7,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]