[{"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":"Grizzly Ethan Cutlass","authId":"","name":"Grizzly Ethan Cutlass","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Ethan Cutlass","authId":"","name":"Grizzly Ethan Cutlass","CNNId":"","myGameChains":null,"banStatus":null},"id":17545688,"name":"Rock Adventure Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Ethan/Cutlass/17545688.jpg","createDate":{"time":1348158939000,"minutes":35,"seconds":39,"hours":12,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Ethan/Cutlass/17545688.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":319880,"difficulty":1.7495845505652676,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":510256,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.832802,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Chloe Beast","authId":"","name":"Fabulous Chloe Beast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Chloe Beast","authId":"","name":"Fabulous Chloe Beast","CNNId":"","myGameChains":null,"banStatus":null},"id":17686633,"name":"Atomic Rampage Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Chloe/Beast/17686633.jpg","createDate":{"time":1348388554000,"minutes":22,"seconds":34,"hours":4,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Chloe/Beast/17686633.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":52729,"difficulty":2.345861678761609,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":600248,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.819759,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Jay Crash","authId":"","name":"Superior Jay Crash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Superior Jay Crash","authId":"","name":"Superior Jay Crash","CNNId":"","myGameChains":null,"banStatus":null},"id":19347448,"name":"Power Pulse Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Superior/Jay/Crash/19347448.jpg","createDate":{"time":1357680609000,"minutes":30,"seconds":9,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Superior/Jay/Crash/19347448.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17975,"difficulty":2.681148546993526,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":225390,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.794744,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Yorick Sunrise","authId":"","name":"Shady Yorick Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Yorick Sunrise","authId":"","name":"Shady Yorick Sunrise","CNNId":"","myGameChains":null,"banStatus":null},"id":17576270,"name":"Chill Crusher Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shady/Yorick/Sunrise/17576270.jpg","createDate":{"time":1348233052000,"minutes":10,"seconds":52,"hours":9,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shady/Yorick/Sunrise/17576270.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19129,"difficulty":2.262002376746776,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":444700,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.780046,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Juan Crater","authId":"","name":"Vast Juan Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Juan Crater","authId":"","name":"Vast Juan Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":18089161,"name":"Fusion Light Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Juan/Crater/18089161.jpg","createDate":{"time":1349979145000,"minutes":12,"seconds":25,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Juan/Crater/18089161.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4778,"difficulty":2.8891419993809166,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":587832,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.779246,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ruby Quarry","authId":"","name":"Soggy Ruby Quarry","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ruby Quarry","authId":"","name":"Soggy Ruby Quarry","CNNId":"","myGameChains":null,"banStatus":null},"id":17587516,"name":"Energy Doom Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Soggy/Ruby/Quarry/17587516.jpg","createDate":{"time":1348259131000,"minutes":25,"seconds":31,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Soggy/Ruby/Quarry/17587516.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":168566,"difficulty":2.6184245164594806,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":282334,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.777962,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Leonard Doodad","authId":"","name":"Jolly Leonard Doodad","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Leonard Doodad","authId":"","name":"Jolly Leonard Doodad","CNNId":"","myGameChains":null,"banStatus":null},"id":17583464,"name":"Hyper Alien Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Leonard/Doodad/17583464.jpg","createDate":{"time":1348251105000,"minutes":11,"seconds":45,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Leonard/Doodad/17583464.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16789,"difficulty":1.4303989978371536,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47343,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.753634,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Antonio Coconut","authId":"","name":"Galactic Antonio Coconut","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Antonio Coconut","authId":"","name":"Galactic Antonio Coconut","CNNId":"","myGameChains":null,"banStatus":null},"id":17810743,"name":"Ultimate Space Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Antonio/Coconut/17810743.jpg","createDate":{"time":1348808014000,"minutes":53,"seconds":34,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Antonio/Coconut/17810743.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29185,"difficulty":2.334061982515818,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54013,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.735613,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Othello Banshee","authId":"","name":"Zany Othello Banshee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Othello Banshee","authId":"","name":"Zany Othello Banshee","CNNId":"","myGameChains":null,"banStatus":null},"id":17944107,"name":"Ultimate Gravattack Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Othello/Banshee/17944107.jpg","createDate":{"time":1349282995000,"minutes":49,"seconds":55,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Othello/Banshee/17944107.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24201,"difficulty":2.1794915957247794,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44531,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.734252,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Homer Dolphin","authId":"","name":"Dashing Homer Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Homer Dolphin","authId":"","name":"Dashing Homer Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":17736826,"name":"Invasion Nano Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/Homer/Dolphin/17736826.jpg","createDate":{"time":1348463748000,"minutes":15,"seconds":48,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/Homer/Dolphin/17736826.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16654,"difficulty":2.2328147289601694,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":22511,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.720708,"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 = '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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]