[{"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 = '4' 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":"Icy Buster Bronco","authId":"","name":"Icy Buster Bronco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Buster Bronco","authId":"","name":"Icy Buster Bronco","CNNId":"","myGameChains":null,"banStatus":null},"id":17956216,"name":"Hex Vilgax Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Buster/Bronco/17956216.jpg","createDate":{"time":1349366517000,"minutes":1,"seconds":57,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Buster/Bronco/17956216.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1532,"difficulty":1.6757409502262444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3752,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.577647,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Russell Blizzard","authId":"","name":"Elite Russell Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Russell Blizzard","authId":"","name":"Elite Russell Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":18170597,"name":"Mission Rock Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Russell/Blizzard/18170597.jpg","createDate":{"time":1350377660000,"minutes":54,"seconds":20,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Russell/Blizzard/18170597.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":236,"difficulty":2.5414462081128746,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5524,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.57672,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Snappy Nathan Pinball","authId":"","name":"Snappy Nathan Pinball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Snappy Nathan Pinball","authId":"","name":"Snappy Nathan Pinball","CNNId":"","myGameChains":null,"banStatus":null},"id":17587749,"name":"Spidermonkey Alien Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Snappy/Nathan/Pinball/17587749.jpg","createDate":{"time":1348259389000,"minutes":29,"seconds":49,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Snappy/Nathan/Pinball/17587749.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4304,"difficulty":2.405830379862343,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17210,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.57668,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Tristan Platypus","authId":"","name":"Superb Tristan Platypus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superb Tristan Platypus","authId":"","name":"Superb Tristan Platypus","CNNId":"","myGameChains":null,"banStatus":null},"id":18409238,"name":"Rampage Space Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superb/Tristan/Platypus/18409238.jpg","createDate":{"time":1352282264000,"minutes":57,"seconds":44,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superb/Tristan/Platypus/18409238.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10513,"difficulty":1.539323418088433,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17245,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.576557,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Robby Bullfrog","authId":"","name":"Reckless Robby Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Robby Bullfrog","authId":"","name":"Reckless Robby Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"id":18106428,"name":"Ultra Hyper Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Robby/Bullfrog/18106428.jpg","createDate":{"time":1350078312000,"minutes":45,"seconds":12,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Robby/Bullfrog/18106428.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":99,"difficulty":2.640357142857143,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1778,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.568398,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Rex Fox","authId":"","name":"Vigilant Rex Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Rex Fox","authId":"","name":"Vigilant Rex Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":17212383,"name":"Spidermonkey Energy Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Rex/Fox/17212383.jpg","createDate":{"time":1342095704000,"minutes":21,"seconds":44,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Rex/Fox/17212383.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153620,"difficulty":2.463828743028753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1208962,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":203,"rating":4.564564,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Omar Tarragon","authId":"","name":"Epic Omar Tarragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Omar Tarragon","authId":"","name":"Epic Omar Tarragon","CNNId":"","myGameChains":null,"banStatus":null},"id":17736834,"name":"Streak Atomic Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Omar/Tarragon/17736834.jpg","createDate":{"time":1348463806000,"minutes":16,"seconds":46,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Omar/Tarragon/17736834.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2123,"difficulty":1.823406083519505,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11695,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.563248,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Rolf Aardvark","authId":"","name":"Ironclad Rolf Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Rolf Aardvark","authId":"","name":"Ironclad Rolf Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":19169100,"name":"Danger Adventure Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironclad/Rolf/Aardvark/19169100.jpg","createDate":{"time":1356349355000,"minutes":42,"seconds":35,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironclad/Rolf/Aardvark/19169100.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12339,"difficulty":2.5964416866929296,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50865,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.562909,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Lloyd Kungfu","authId":"","name":"Cute Lloyd Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Lloyd Kungfu","authId":"","name":"Cute Lloyd Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":19861090,"name":"Nitro Burst Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cute/Lloyd/Kungfu/19861090.jpg","createDate":{"time":1363957790000,"minutes":9,"seconds":50,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cute/Lloyd/Kungfu/19861090.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":145,"difficulty":2.571019973801257,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12353,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.562636,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Achilles Llama","authId":"","name":"Smelly Achilles Llama","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Achilles Llama","authId":"","name":"Smelly Achilles Llama","CNNId":"","myGameChains":null,"banStatus":null},"id":17957016,"name":"Patrol Hex Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smelly/Achilles/Llama/17957016.jpg","createDate":{"time":1349372188000,"minutes":36,"seconds":28,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smelly/Achilles/Llama/17957016.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1025,"difficulty":2.1944509208439817,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16301,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.551507,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"31","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 = '4' 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":"40","currentPageToDisplay":4,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]