[{"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 = '13' 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":"Keen Caissa Gumdrop","authId":"","name":"Keen Caissa Gumdrop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Keen Caissa Gumdrop","authId":"","name":"Keen Caissa Gumdrop","CNNId":"","myGameChains":null,"banStatus":null},"id":18748442,"name":"Power Metal Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Keen/Caissa/Gumdrop/18748442.jpg","createDate":{"time":1354790377000,"minutes":39,"seconds":37,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Keen/Caissa/Gumdrop/18748442.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":104612,"difficulty":1.2798809691842885,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":487674,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.157986,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Fred Cobweb","authId":"","name":"Hectic Fred Cobweb","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Fred Cobweb","authId":"","name":"Hectic Fred Cobweb","CNNId":"","myGameChains":null,"banStatus":null},"id":19319692,"name":"Rustbucket Burst Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hectic/Fred/Cobweb/19319692.jpg","createDate":{"time":1357378784000,"minutes":39,"seconds":44,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hectic/Fred/Cobweb/19319692.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7116,"difficulty":2.6868319007590697,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":38929,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.151927,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Volcanic Heather Shuriken","authId":"","name":"Volcanic Heather Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Volcanic Heather Shuriken","authId":"","name":"Volcanic Heather Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"id":19401342,"name":"Nano Turbo Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Volcanic/Heather/Shuriken/19401342.jpg","createDate":{"time":1358531609000,"minutes":53,"seconds":29,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Volcanic/Heather/Shuriken/19401342.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9731,"difficulty":1.6969259016389369,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":48609,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.121056,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Ray Quark","authId":"","name":"Hearty Ray Quark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Ray Quark","authId":"","name":"Hearty Ray Quark","CNNId":"","myGameChains":null,"banStatus":null},"id":18640571,"name":"Solar Pulse Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hearty/Ray/Quark/18640571.jpg","createDate":{"time":1354305462000,"minutes":57,"seconds":42,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hearty/Ray/Quark/18640571.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7953,"difficulty":2.387315189109239,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40631,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.117793,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Emmett Blammo","authId":"","name":"Epic Emmett Blammo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Emmett Blammo","authId":"","name":"Epic Emmett Blammo","CNNId":"","myGameChains":null,"banStatus":null},"id":19547042,"name":"Mission Adventure Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Emmett/Blammo/19547042.jpg","createDate":{"time":1360976189000,"minutes":56,"seconds":29,"hours":19,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Emmett/Blammo/19547042.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8770,"difficulty":2.3066806699629154,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40502,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.100909,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Arthur Apple","authId":"","name":"Atomic Arthur Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Arthur Apple","authId":"","name":"Atomic Arthur Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":19606538,"name":"Streak Plumber Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Arthur/Apple/19606538.jpg","createDate":{"time":1361904110000,"minutes":41,"seconds":50,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Arthur/Apple/19606538.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1845,"difficulty":1.6702929239736486,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":30099,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.088256,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Rachel Aviator","authId":"","name":"Robust Rachel Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Rachel Aviator","authId":"","name":"Robust Rachel Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":18983056,"name":"Fury Sonic Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robust/Rachel/Aviator/18983056.jpg","createDate":{"time":1355519192000,"minutes":6,"seconds":32,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robust/Rachel/Aviator/18983056.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45466,"difficulty":2.5400726215824805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":155913,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.07398,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Pleasant Morgan Rebel","authId":"","name":"Pleasant Morgan Rebel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pleasant Morgan Rebel","authId":"","name":"Pleasant Morgan Rebel","CNNId":"","myGameChains":null,"banStatus":null},"id":18707537,"name":"Defense Mega Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pleasant/Morgan/Rebel/18707537.jpg","createDate":{"time":1354658353000,"minutes":59,"seconds":13,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pleasant/Morgan/Rebel/18707537.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4080,"difficulty":2.427510331102955,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18535,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.051994,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Buster Mercury","authId":"","name":"Captain Buster Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Buster Mercury","authId":"","name":"Captain Buster Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":19025893,"name":"Attack Universe Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Buster/Mercury/19025893.jpg","createDate":{"time":1355644669000,"minutes":57,"seconds":49,"hours":2,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Buster/Mercury/19025893.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27430,"difficulty":1.6211402010083318,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78946,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.045029,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spicy Cassidy Baloney","authId":"","name":"Spicy Cassidy Baloney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spicy Cassidy Baloney","authId":"","name":"Spicy Cassidy Baloney","CNNId":"","myGameChains":null,"banStatus":null},"id":19601253,"name":"Pulse Adventure Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spicy/Cassidy/Baloney/19601253.jpg","createDate":{"time":1361753884000,"minutes":58,"seconds":4,"hours":19,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spicy/Cassidy/Baloney/19601253.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9077,"difficulty":1.160674211550494,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29422,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.030783,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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 = '13' 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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]