[{"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 = '3' 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":"Gross Latoya Yak","authId":"","name":"Gross Latoya Yak","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gross Latoya Yak","authId":"","name":"Gross Latoya Yak","CNNId":"","myGameChains":null,"banStatus":null},"id":17216502,"name":"Adventure Pulse Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gross/Latoya/Yak/17216502.jpg","createDate":{"time":1342182956000,"minutes":35,"seconds":56,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gross/Latoya/Yak/17216502.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13951,"difficulty":2.4210746122453344,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":64389,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.835867,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Diagonal John Gong","authId":"","name":"Diagonal John Gong","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Diagonal John Gong","authId":"","name":"Diagonal John Gong","CNNId":"","myGameChains":null,"banStatus":null},"id":19301976,"name":"Ben Crusher Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Diagonal/John/Gong/19301976.jpg","createDate":{"time":1357214437000,"minutes":0,"seconds":37,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Diagonal/John/Gong/19301976.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14714,"difficulty":2.765989337592283,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":33705,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.782613,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Albert Amethyst","authId":"","name":"Bouncing Albert Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Albert Amethyst","authId":"","name":"Bouncing Albert Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"id":19574750,"name":"Echo Adventure Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Albert/Amethyst/19574750.jpg","createDate":{"time":1361369013000,"minutes":3,"seconds":33,"hours":9,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Albert/Amethyst/19574750.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":874,"difficulty":2.0847650366340633,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14251,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.750594,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Fassy Yoyo","authId":"","name":"Shaggy Fassy Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Fassy Yoyo","authId":"","name":"Shaggy Fassy Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19222439,"name":"Light Quake Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Fassy/Yoyo/19222439.jpg","createDate":{"time":1356699383000,"minutes":56,"seconds":23,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Fassy/Yoyo/19222439.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4131,"difficulty":2.251018991753419,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27564,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.748887,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jay Stampede","authId":"","name":"Electric Jay Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jay Stampede","authId":"","name":"Electric Jay Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":18783703,"name":"Jetray Energy Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Jay/Stampede/18783703.jpg","createDate":{"time":1354913309000,"minutes":48,"seconds":29,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Jay/Stampede/18783703.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5706,"difficulty":2.8936375697497283,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":85497,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.731057,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Arianna Varmint","authId":"","name":"Sly Arianna Varmint","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Arianna Varmint","authId":"","name":"Sly Arianna Varmint","CNNId":"","myGameChains":null,"banStatus":null},"id":19906807,"name":"Earth Invasion Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sly/Arianna/Varmint/19906807.jpg","createDate":{"time":1364218965000,"minutes":42,"seconds":45,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sly/Arianna/Varmint/19906807.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1061,"difficulty":2.3834971270156453,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4419,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.728361,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Jack Golem","authId":"","name":"Evil Jack Golem","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Jack Golem","authId":"","name":"Evil Jack Golem","CNNId":"","myGameChains":null,"banStatus":null},"id":19838146,"name":"Alien Warp Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Jack/Golem/19838146.jpg","createDate":{"time":1363748447000,"minutes":0,"seconds":47,"hours":23,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Jack/Golem/19838146.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33504,"difficulty":2.7501132254875293,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":100202,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.728328,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valorous Wallace Quarry","authId":"","name":"Valorous Wallace Quarry","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valorous Wallace Quarry","authId":"","name":"Valorous Wallace Quarry","CNNId":"","myGameChains":null,"banStatus":null},"id":19874582,"name":"Racer Omniverse Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valorous/Wallace/Quarry/19874582.jpg","createDate":{"time":1364044850000,"minutes":20,"seconds":50,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valorous/Wallace/Quarry/19874582.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":348,"difficulty":2.7287414965986394,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4373,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.722818,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Mikayla Ogre","authId":"","name":"Ancient Mikayla Ogre","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Mikayla Ogre","authId":"","name":"Ancient Mikayla Ogre","CNNId":"","myGameChains":null,"banStatus":null},"id":19611931,"name":"Target Racer Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Mikayla/Ogre/19611931.jpg","createDate":{"time":1362054006000,"minutes":20,"seconds":6,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Mikayla/Ogre/19611931.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1029,"difficulty":2.553152881204106,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13161,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.719338,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quiet Douglas Turnip","authId":"","name":"Quiet Douglas Turnip","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quiet Douglas Turnip","authId":"","name":"Quiet Douglas Turnip","CNNId":"","myGameChains":null,"banStatus":null},"id":17813279,"name":"Omniverse Laser Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quiet/Douglas/Turnip/17813279.jpg","createDate":{"time":1348832231000,"minutes":37,"seconds":11,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quiet/Douglas/Turnip/17813279.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2459,"difficulty":2.7471017631856944,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13458,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.716014,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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 = '3' 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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]