[{"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":"Strong Herbert Orbit","authId":"","name":"Strong Herbert Orbit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Herbert Orbit","authId":"","name":"Strong Herbert Orbit","CNNId":"","myGameChains":null,"banStatus":null},"id":19128790,"name":"Plumber Adventure Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Herbert/Orbit/19128790.jpg","createDate":{"time":1356197965000,"minutes":39,"seconds":25,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Herbert/Orbit/19128790.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4445,"difficulty":1.8099268996418088,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34610,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.805684,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Molly Dogfish","authId":"","name":"Friendly Molly Dogfish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Molly Dogfish","authId":"","name":"Friendly Molly Dogfish","CNNId":"","myGameChains":null,"banStatus":null},"id":18676376,"name":"Assault Blaster Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Molly/Dogfish/18676376.jpg","createDate":{"time":1354550303000,"minutes":58,"seconds":23,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Molly/Dogfish/18676376.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8287,"difficulty":2.1588596512493963,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12264,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.783832,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Wayne Bullfrog","authId":"","name":"Academic Wayne Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Wayne Bullfrog","authId":"","name":"Academic Wayne Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"id":18553166,"name":"Gear Chase Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Wayne/Bullfrog/18553166.jpg","createDate":{"time":1353606902000,"minutes":55,"seconds":2,"hours":12,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Wayne/Bullfrog/18553166.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10754,"difficulty":1.8776643090759282,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37192,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.779843,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hardy Matthew Atlas","authId":"","name":"Hardy Matthew Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hardy Matthew Atlas","authId":"","name":"Hardy Matthew Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":19436429,"name":"Star Titan Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hardy/Matthew/Atlas/19436429.jpg","createDate":{"time":1359014134000,"minutes":55,"seconds":34,"hours":2,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hardy/Matthew/Atlas/19436429.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24779,"difficulty":2.216862012649683,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37347,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.766662,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Pulse","authId":"","name":"Admiral Spike Pulse","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Pulse","authId":"","name":"Admiral Spike Pulse","CNNId":"","myGameChains":null,"banStatus":null},"id":19477936,"name":"Alien Patrol Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Spike/Pulse/19477936.jpg","createDate":{"time":1359761534000,"minutes":32,"seconds":14,"hours":18,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Spike/Pulse/19477936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":454,"difficulty":2.7674658605041427,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":90452,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.740439,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gross Preston Universe","authId":"","name":"Gross Preston Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gross Preston Universe","authId":"","name":"Gross Preston Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":19449813,"name":"Ben Droid Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gross/Preston/Universe/19449813.jpg","createDate":{"time":1359227053000,"minutes":4,"seconds":13,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gross/Preston/Universe/19449813.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28541,"difficulty":1.6509130656068762,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40438,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.737963,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shifty Cheyenne Acorn","authId":"","name":"Shifty Cheyenne Acorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shifty Cheyenne Acorn","authId":"","name":"Shifty Cheyenne Acorn","CNNId":"","myGameChains":null,"banStatus":null},"id":18528935,"name":"Crusher Danger Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shifty/Cheyenne/Acorn/18528935.jpg","createDate":{"time":1353442270000,"minutes":11,"seconds":10,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shifty/Cheyenne/Acorn/18528935.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3473,"difficulty":1.8568571698691028,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18734,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.722464,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Katelyn Howler","authId":"","name":"Fiery Katelyn Howler","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Katelyn Howler","authId":"","name":"Fiery Katelyn Howler","CNNId":"","myGameChains":null,"banStatus":null},"id":19440951,"name":"Ben Assault BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Katelyn/Howler/19440951.jpg","createDate":{"time":1359113404000,"minutes":30,"seconds":4,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Katelyn/Howler/19440951.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4367,"difficulty":1.6338635610197503,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":68078,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.719122,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Anthony Karate","authId":"","name":"King Anthony Karate","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Anthony Karate","authId":"","name":"King Anthony Karate","CNNId":"","myGameChains":null,"banStatus":null},"id":19128786,"name":"Shock Racer Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Anthony/Karate/19128786.jpg","createDate":{"time":1356197959000,"minutes":39,"seconds":19,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Anthony/Karate/19128786.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14602,"difficulty":2.1535312336192667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19544,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.718051,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Leonardo Buckaroo","authId":"","name":"Grim Leonardo Buckaroo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grim Leonardo Buckaroo","authId":"","name":"Grim Leonardo Buckaroo","CNNId":"","myGameChains":null,"banStatus":null},"id":18701791,"name":"Alien Plasma Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grim/Leonardo/Buckaroo/18701791.jpg","createDate":{"time":1354641492000,"minutes":18,"seconds":12,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grim/Leonardo/Buckaroo/18701791.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26774,"difficulty":2.726432838131782,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":123394,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.692256,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]