[{"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 = '10' 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":"Gigantic Paula Gullet","authId":"","name":"Gigantic Paula Gullet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Paula Gullet","authId":"","name":"Gigantic Paula Gullet","CNNId":"","myGameChains":null,"banStatus":null},"id":19391568,"name":"Hex Storm Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Paula/Gullet/19391568.jpg","createDate":{"time":1358337871000,"minutes":4,"seconds":31,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Paula/Gullet/19391568.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":328,"difficulty":2.8249999999999997,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6392,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.585983,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Cynthia Nebula","authId":"","name":"Silly Cynthia Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Cynthia Nebula","authId":"","name":"Silly Cynthia Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":19838177,"name":"Ultimate Echo Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Cynthia/Nebula/19838177.jpg","createDate":{"time":1363748683000,"minutes":4,"seconds":43,"hours":23,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Cynthia/Nebula/19838177.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38405,"difficulty":2.468818905145782,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54154,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.541585,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Pleasant Biff Burst","authId":"","name":"Pleasant Biff Burst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Pleasant Biff Burst","authId":"","name":"Pleasant Biff Burst","CNNId":"","myGameChains":null,"banStatus":null},"id":19198296,"name":"Assault Atomic Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Pleasant/Biff/Burst/19198296.jpg","createDate":{"time":1356539996000,"minutes":39,"seconds":56,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Pleasant/Biff/Burst/19198296.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2132,"difficulty":1.8943418537983756,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11281,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.532126,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Ernie Fathom","authId":"","name":"Brisk Ernie Fathom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Ernie Fathom","authId":"","name":"Brisk Ernie Fathom","CNNId":"","myGameChains":null,"banStatus":null},"id":18613837,"name":"Search Ben Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Ernie/Fathom/18613837.jpg","createDate":{"time":1353967004000,"minutes":56,"seconds":44,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Ernie/Fathom/18613837.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5634,"difficulty":2.4808193182806186,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8382,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.483453,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Curtis Galaxy","authId":"","name":"Bold Curtis Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Curtis Galaxy","authId":"","name":"Bold Curtis Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"id":18415985,"name":"Energy Escape Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Curtis/Galaxy/18415985.jpg","createDate":{"time":1352376149000,"minutes":2,"seconds":29,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Curtis/Galaxy/18415985.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44662,"difficulty":1.3039323366775182,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57581,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.470455,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Yolanda Nonsense","authId":"","name":"Prolific Yolanda Nonsense","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Yolanda Nonsense","authId":"","name":"Prolific Yolanda Nonsense","CNNId":"","myGameChains":null,"banStatus":null},"id":19461420,"name":"Force Shadow Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prolific/Yolanda/Nonsense/19461420.jpg","createDate":{"time":1359375067000,"minutes":11,"seconds":7,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prolific/Yolanda/Nonsense/19461420.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1487,"difficulty":2.0693877551020408,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4648,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.4375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Wyatt Grouch","authId":"","name":"Acoustic Wyatt Grouch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Wyatt Grouch","authId":"","name":"Acoustic Wyatt Grouch","CNNId":"","myGameChains":null,"banStatus":null},"id":19222508,"name":"Escape Assault Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Acoustic/Wyatt/Grouch/19222508.jpg","createDate":{"time":1356699817000,"minutes":3,"seconds":37,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Acoustic/Wyatt/Grouch/19222508.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1593,"difficulty":2.10727367870225,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8943,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.417934,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Leo Mantis","authId":"","name":"Magnetic Leo Mantis","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Leo Mantis","authId":"","name":"Magnetic Leo Mantis","CNNId":"","myGameChains":null,"banStatus":null},"id":19854057,"name":"Gear Pulse Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Leo/Mantis/19854057.jpg","createDate":{"time":1363898515000,"minutes":41,"seconds":55,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Leo/Mantis/19854057.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19849,"difficulty":2.677856964275691,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57977,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.410434,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Chase Glacier","authId":"","name":"Solar Chase Glacier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Chase Glacier","authId":"","name":"Solar Chase Glacier","CNNId":"","myGameChains":null,"banStatus":null},"id":18107122,"name":"Fusion Cosmic Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solar/Chase/Glacier/18107122.jpg","createDate":{"time":1350080298000,"minutes":18,"seconds":18,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solar/Chase/Glacier/18107122.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":597,"difficulty":2.895876259157509,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8813,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.397835,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eloquent Collin Apple","authId":"","name":"Eloquent Collin Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eloquent Collin Apple","authId":"","name":"Eloquent Collin Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":17587753,"name":"Droid Gear Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eloquent/Collin/Apple/17587753.jpg","createDate":{"time":1348259395000,"minutes":29,"seconds":55,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eloquent/Collin/Apple/17587753.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4191,"difficulty":2.7391599833736855,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":46143,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.385366,"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 = '10' 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"}}]