[{"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 = '7' 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":"Barbaric Luke Banshee","authId":"","name":"Barbaric Luke Banshee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Luke Banshee","authId":"","name":"Barbaric Luke Banshee","CNNId":"","myGameChains":null,"banStatus":null},"id":18392672,"name":"Hyper Search Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Barbaric/Luke/Banshee/18392672.jpg","createDate":{"time":1352125769000,"minutes":29,"seconds":29,"hours":9,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Barbaric/Luke/Banshee/18392672.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8422,"difficulty":1.8999708389965138,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":33053,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.002135,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Misty Serpent","authId":"","name":"Generous Misty Serpent","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Misty Serpent","authId":"","name":"Generous Misty Serpent","CNNId":"","myGameChains":null,"banStatus":null},"id":18351266,"name":"Omniverse Echo Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Generous/Misty/Serpent/18351266.jpg","createDate":{"time":1351876692000,"minutes":18,"seconds":12,"hours":13,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Generous/Misty/Serpent/18351266.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":118,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":444,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unlucky Rigby Glop","authId":"","name":"Unlucky Rigby Glop","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unlucky Rigby Glop","authId":"","name":"Unlucky Rigby Glop","CNNId":"","myGameChains":null,"banStatus":null},"id":18105130,"name":"Sonic Plasma Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unlucky/Rigby/Glop/18105130.jpg","createDate":{"time":1350074649000,"minutes":44,"seconds":9,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unlucky/Rigby/Glop/18105130.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":100,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":366,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Southern Kaleb Dwarf","authId":"","name":"Southern Kaleb Dwarf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Southern Kaleb Dwarf","authId":"","name":"Southern Kaleb Dwarf","CNNId":"","myGameChains":null,"banStatus":null},"id":18078911,"name":"Animo Patrol Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Southern/Kaleb/Dwarf/18078911.jpg","createDate":{"time":1349899053000,"minutes":57,"seconds":33,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Southern/Kaleb/Dwarf/18078911.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":120,"difficulty":1.25,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":380,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Drake Shadow","authId":"","name":"Honest Drake Shadow","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Drake Shadow","authId":"","name":"Honest Drake Shadow","CNNId":"","myGameChains":null,"banStatus":null},"id":18406427,"name":"Gear Star Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Honest/Drake/Shadow/18406427.jpg","createDate":{"time":1352246144000,"minutes":55,"seconds":44,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Honest/Drake/Shadow/18406427.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":252,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":459,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Luis Hydra","authId":"","name":"Comical Luis Hydra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Comical Luis Hydra","authId":"","name":"Comical Luis Hydra","CNNId":"","myGameChains":null,"banStatus":null},"id":18911728,"name":"Ambush Shock Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Comical/Luis/Hydra/18911728.jpg","createDate":{"time":1355124673000,"minutes":31,"seconds":13,"hours":2,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Comical/Luis/Hydra/18911728.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":563,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Izzy Bucket","authId":"","name":"Sturdy Izzy Bucket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Izzy Bucket","authId":"","name":"Sturdy Izzy Bucket","CNNId":"","myGameChains":null,"banStatus":null},"id":17793288,"name":"Plasma Charge Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Izzy/Bucket/17793288.jpg","createDate":{"time":1348718686000,"minutes":4,"seconds":46,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Izzy/Bucket/17793288.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":128,"difficulty":1.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":290,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reliable Jack Corduroy","authId":"","name":"Reliable Jack Corduroy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reliable Jack Corduroy","authId":"","name":"Reliable Jack Corduroy","CNNId":"","myGameChains":null,"banStatus":null},"id":19325386,"name":"Streak Steel Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reliable/Jack/Corduroy/19325386.jpg","createDate":{"time":1357417901000,"minutes":31,"seconds":41,"hours":15,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reliable/Jack/Corduroy/19325386.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":266,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":464,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Andre Hologram","authId":"","name":"Creative Andre Hologram","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Andre Hologram","authId":"","name":"Creative Andre Hologram","CNNId":"","myGameChains":null,"banStatus":null},"id":18427367,"name":"Universe Alien Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Andre/Hologram/18427367.jpg","createDate":{"time":1352497561000,"minutes":46,"seconds":1,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Andre/Hologram/18427367.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":160,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":453,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bright Andrew Atlas","authId":"","name":"Bright Andrew Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bright Andrew Atlas","authId":"","name":"Bright Andrew Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":18426930,"name":"Alien Burst Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bright/Andrew/Atlas/18426930.jpg","createDate":{"time":1352494876000,"minutes":1,"seconds":16,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bright/Andrew/Atlas/18426930.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":50,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":308,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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 = '7' 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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]