[{"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 = '16' 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":"Brawny Milo Snowball","authId":"","name":"Brawny Milo Snowball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Milo Snowball","authId":"","name":"Brawny Milo Snowball","CNNId":"","myGameChains":null,"banStatus":null},"id":19691140,"name":"Ultra Universe Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brawny/Milo/Snowball/19691140.jpg","createDate":{"time":1363121182000,"minutes":46,"seconds":22,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brawny/Milo/Snowball/19691140.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5902,"difficulty":2.593667814803234,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17247,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.825163,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Otis Confetti","authId":"","name":"Shy Otis Confetti","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Otis Confetti","authId":"","name":"Shy Otis Confetti","CNNId":"","myGameChains":null,"banStatus":null},"id":19681241,"name":"Rescue Pulse Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Otis/Confetti/19681241.jpg","createDate":{"time":1363085306000,"minutes":48,"seconds":26,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Otis/Confetti/19681241.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":496,"difficulty":2.830856513728486,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4917,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.824783,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Profound Alvin Nanobot","authId":"","name":"Profound Alvin Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Profound Alvin Nanobot","authId":"","name":"Profound Alvin Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"id":19677688,"name":"Challenge Plasma Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Profound/Alvin/Nanobot/19677688.jpg","createDate":{"time":1363051887000,"minutes":31,"seconds":27,"hours":21,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Profound/Alvin/Nanobot/19677688.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":290,"difficulty":2.844500720168284,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3178,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.824654,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Kathryn Tornado","authId":"","name":"Edgy Kathryn Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Kathryn Tornado","authId":"","name":"Edgy Kathryn Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19690470,"name":"Animo Hex Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Kathryn/Tornado/19690470.jpg","createDate":{"time":1363119922000,"minutes":25,"seconds":22,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Kathryn/Tornado/19690470.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2065,"difficulty":1.673228941025797,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3226,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.822043,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Aaron Jamboree","authId":"","name":"Amazing Aaron Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amazing Aaron Jamboree","authId":"","name":"Amazing Aaron Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":19668445,"name":"Burst Kickin' Hawk Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amazing/Aaron/Jamboree/19668445.jpg","createDate":{"time":1363034822000,"minutes":47,"seconds":2,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amazing/Aaron/Jamboree/19668445.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":169,"difficulty":2.766165004078047,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4599,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.820734,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Brooke Presto","authId":"","name":"King Brooke Presto","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Brooke Presto","authId":"","name":"King Brooke Presto","CNNId":"","myGameChains":null,"banStatus":null},"id":19721435,"name":"Thunder Robot Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Brooke/Presto/19721435.jpg","createDate":{"time":1363262207000,"minutes":56,"seconds":47,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Brooke/Presto/19721435.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1527,"difficulty":2.913230465375534,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4717,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.819811,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Bryan Jupiter","authId":"","name":"Abnormal Bryan Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Bryan Jupiter","authId":"","name":"Abnormal Bryan Jupiter","CNNId":"","myGameChains":null,"banStatus":null},"id":19665956,"name":"Assault Ambush Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abnormal/Bryan/Jupiter/19665956.jpg","createDate":{"time":1363028832000,"minutes":7,"seconds":12,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abnormal/Bryan/Jupiter/19665956.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":446,"difficulty":1.7967432786511734,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4579,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.817761,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Adorable Goliath Paradox","authId":"","name":"Adorable Goliath Paradox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Adorable Goliath Paradox","authId":"","name":"Adorable Goliath Paradox","CNNId":"","myGameChains":null,"banStatus":null},"id":19680924,"name":"Hero Echo Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Adorable/Goliath/Paradox/19680924.jpg","createDate":{"time":1363081251000,"minutes":40,"seconds":51,"hours":5,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Adorable/Goliath/Paradox/19680924.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":510,"difficulty":1.87332574506262,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25094,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.815617,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Collin Umbrella","authId":"","name":"Bouncing Collin Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Collin Umbrella","authId":"","name":"Bouncing Collin Umbrella","CNNId":"","myGameChains":null,"banStatus":null},"id":19721173,"name":"Adventure Atomic Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Collin/Umbrella/19721173.jpg","createDate":{"time":1363260051000,"minutes":20,"seconds":51,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Collin/Umbrella/19721173.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":281,"difficulty":2.7881118881118883,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3179,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.815033,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Helga Quack","authId":"","name":"Nifty Helga Quack","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Helga Quack","authId":"","name":"Nifty Helga Quack","CNNId":"","myGameChains":null,"banStatus":null},"id":19707519,"name":"Ambush Breaker Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Helga/Quack/19707519.jpg","createDate":{"time":1363196690000,"minutes":44,"seconds":50,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Helga/Quack/19707519.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":788,"difficulty":2.516608200024811,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11630,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.812849,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"11","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 = '16' 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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]