[{"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 = '6' 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":"Sleek Kevin Doodle","authId":"","name":"Sleek Kevin Doodle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleek Kevin Doodle","authId":"","name":"Sleek Kevin Doodle","CNNId":"","myGameChains":null,"banStatus":null},"id":19387135,"name":"Rescue Mega Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleek/Kevin/Doodle/19387135.jpg","createDate":{"time":1358252084000,"minutes":14,"seconds":44,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleek/Kevin/Doodle/19387135.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":929,"difficulty":1.6071652398440732,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5004,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.41072,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Chris Dolphin","authId":"","name":"Strong Chris Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Chris Dolphin","authId":"","name":"Strong Chris Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":18429325,"name":"Laser Rush Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Chris/Dolphin/18429325.jpg","createDate":{"time":1352506374000,"minutes":12,"seconds":54,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Chris/Dolphin/18429325.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":163,"difficulty":1.5208333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":728,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.395833,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Hank Squish","authId":"","name":"Western Hank Squish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Western Hank Squish","authId":"","name":"Western Hank Squish","CNNId":"","myGameChains":null,"banStatus":null},"id":18260522,"name":"Shock Burst Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Western/Hank/Squish/18260522.jpg","createDate":{"time":1351157465000,"minutes":31,"seconds":5,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Western/Hank/Squish/18260522.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4039,"difficulty":1.2762886538335279,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25224,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.391308,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Bryan Dingo","authId":"","name":"Magnetic Bryan Dingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Bryan Dingo","authId":"","name":"Magnetic Bryan Dingo","CNNId":"","myGameChains":null,"banStatus":null},"id":18427490,"name":"Universe Fusion Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Bryan/Dingo/18427490.jpg","createDate":{"time":1352498259000,"minutes":57,"seconds":39,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Bryan/Dingo/18427490.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2610,"difficulty":1.333994697156849,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12555,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.379802,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble Hazel Deadbolt","authId":"","name":"Humble Hazel Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Humble Hazel Deadbolt","authId":"","name":"Humble Hazel Deadbolt","CNNId":"","myGameChains":null,"banStatus":null},"id":18488356,"name":"Fire Giga Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Humble/Hazel/Deadbolt/18488356.jpg","createDate":{"time":1353023544000,"minutes":52,"seconds":24,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Humble/Hazel/Deadbolt/18488356.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":117,"difficulty":2.8,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":850,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.316667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baron Reginald Chaos","authId":"","name":"Baron Reginald Chaos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baron Reginald Chaos","authId":"","name":"Baron Reginald Chaos","CNNId":"","myGameChains":null,"banStatus":null},"id":18641367,"name":"Invasion Rocket Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baron/Reginald/Chaos/18641367.jpg","createDate":{"time":1354310486000,"minutes":21,"seconds":26,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baron/Reginald/Chaos/18641367.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":978,"difficulty":2.738226059654631,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9940,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.269016,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wily Rick Castle","authId":"","name":"Wily Rick Castle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wily Rick Castle","authId":"","name":"Wily Rick Castle","CNNId":"","myGameChains":null,"banStatus":null},"id":18105629,"name":"Alien Attack Waterhazard","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wily/Rick/Castle/18105629.jpg","createDate":{"time":1350076192000,"minutes":9,"seconds":52,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wily/Rick/Castle/18105629.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":104,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":407,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Bruce Monster","authId":"","name":"Toxic Bruce Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Toxic Bruce Monster","authId":"","name":"Toxic Bruce Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":18004852,"name":"Iron Force Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Toxic/Bruce/Monster/18004852.jpg","createDate":{"time":1349554254000,"minutes":10,"seconds":54,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Toxic/Bruce/Monster/18004852.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":213,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":683,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Leonardo Wolf","authId":"","name":"Quirky Leonardo Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Leonardo Wolf","authId":"","name":"Quirky Leonardo Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":18170558,"name":"Hyper Burst Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Leonardo/Wolf/18170558.jpg","createDate":{"time":1350376862000,"minutes":41,"seconds":2,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Leonardo/Wolf/18170558.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":470,"difficulty":1.2083333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1191,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.208333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Ryan Rhino","authId":"","name":"Venomous Ryan Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Venomous Ryan Rhino","authId":"","name":"Venomous Ryan Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":17216402,"name":"Shadow Metal Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Venomous/Ryan/Rhino/17216402.jpg","createDate":{"time":1342179583000,"minutes":39,"seconds":43,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Venomous/Ryan/Rhino/17216402.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":435,"difficulty":1.08,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":801,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.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 = '6' 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"}}]