[{"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 = '12' 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":"Witty Ingrid Behemoth","authId":"","name":"Witty Ingrid Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Ingrid Behemoth","authId":"","name":"Witty Ingrid Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":19672520,"name":"Breaker Fury Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Witty/Ingrid/Behemoth/19672520.jpg","createDate":{"time":1363042407000,"minutes":53,"seconds":27,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Witty/Ingrid/Behemoth/19672520.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33384,"difficulty":2.11211094897686,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":66433,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.076915,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Donald Mutant","authId":"","name":"Unknown Donald Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Donald Mutant","authId":"","name":"Unknown Donald Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":17755995,"name":"Gear Attack Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Donald/Mutant/17755995.jpg","createDate":{"time":1348545622000,"minutes":0,"seconds":22,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Donald/Mutant/17755995.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":446,"difficulty":2.3750120250120252,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2752,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.074074,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Karl Pudding","authId":"","name":"Ultimate Karl Pudding","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Karl Pudding","authId":"","name":"Ultimate Karl Pudding","CNNId":"","myGameChains":null,"banStatus":null},"id":17774038,"name":"Beast Hero Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Karl/Pudding/17774038.jpg","createDate":{"time":1348632965000,"minutes":16,"seconds":5,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Karl/Pudding/17774038.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":246,"difficulty":2.8513137759480545,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":33771,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.073777,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Augustus Warrior","authId":"","name":"Admiral Augustus Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Augustus Warrior","authId":"","name":"Admiral Augustus Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":17957082,"name":"Gravattack Cosmic Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Augustus/Warrior/17957082.jpg","createDate":{"time":1349372716000,"minutes":45,"seconds":16,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Augustus/Warrior/17957082.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9222,"difficulty":1.7617497218058495,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15394,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.072872,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Leonardo Turtle","authId":"","name":"Fiery Leonardo Turtle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Leonardo Turtle","authId":"","name":"Fiery Leonardo Turtle","CNNId":"","myGameChains":null,"banStatus":null},"id":17423669,"name":"Stone Doom Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Leonardo/Turtle/17423669.jpg","createDate":{"time":1347894770000,"minutes":12,"seconds":50,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Leonardo/Turtle/17423669.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":318,"difficulty":2.2476070226070224,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3053,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.070984,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Savannah Chutney","authId":"","name":"Nomadic Savannah Chutney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Savannah Chutney","authId":"","name":"Nomadic Savannah Chutney","CNNId":"","myGameChains":null,"banStatus":null},"id":18409225,"name":"Plumber Target Solar","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nomadic/Savannah/Chutney/18409225.jpg","createDate":{"time":1352281923000,"minutes":52,"seconds":3,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nomadic/Savannah/Chutney/18409225.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8358,"difficulty":1.890613289636823,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20021,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.066467,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Alicia Moppet","authId":"","name":"Bold Alicia Moppet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Alicia Moppet","authId":"","name":"Bold Alicia Moppet","CNNId":"","myGameChains":null,"banStatus":null},"id":17813262,"name":"Razor Doom Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Alicia/Moppet/17813262.jpg","createDate":{"time":1348832145000,"minutes":35,"seconds":45,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Alicia/Moppet/17813262.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56770,"difficulty":2.530684436513643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63906,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.050985,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Marco Dogfish","authId":"","name":"Creative Marco Dogfish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Marco Dogfish","authId":"","name":"Creative Marco Dogfish","CNNId":"","myGameChains":null,"banStatus":null},"id":17556048,"name":"Universe Shock Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Marco/Dogfish/17556048.jpg","createDate":{"time":1348178954000,"minutes":9,"seconds":14,"hours":18,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Marco/Dogfish/17556048.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5331,"difficulty":2.7847663050459377,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":100899,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.050219,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Isaac Goblin","authId":"","name":"Regular Isaac Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Isaac Goblin","authId":"","name":"Regular Isaac Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17423005,"name":"Fusion Laser Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Isaac/Goblin/17423005.jpg","createDate":{"time":1347893665000,"minutes":54,"seconds":25,"hours":10,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Isaac/Goblin/17423005.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":786,"difficulty":2.2805555555555554,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2248,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.029464,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Jocelyn Maestro","authId":"","name":"Infinite Jocelyn Maestro","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Jocelyn Maestro","authId":"","name":"Infinite Jocelyn Maestro","CNNId":"","myGameChains":null,"banStatus":null},"id":17736715,"name":"Humungousaur Patrol Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infinite/Jocelyn/Maestro/17736715.jpg","createDate":{"time":1348461975000,"minutes":46,"seconds":15,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infinite/Jocelyn/Maestro/17736715.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1808,"difficulty":2.1007711651094003,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2654,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.025678,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"111","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 = '12' 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":"120","currentPageToDisplay":12,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]