[{"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":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"id":17216408,"name":"Adventure Fire Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vague/Avery/Parallax/17216408.jpg","createDate":{"time":1342180168000,"minutes":49,"seconds":28,"hours":7,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vague/Avery/Parallax/17216408.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":539,"difficulty":1.32,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1736,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.125,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Kyle Bramble","authId":"","name":"Abstract Kyle Bramble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Kyle Bramble","authId":"","name":"Abstract Kyle Bramble","CNNId":"","myGameChains":null,"banStatus":null},"id":17232574,"name":"Giga Rampage Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abstract/Kyle/Bramble/17232574.jpg","createDate":{"time":1342532772000,"minutes":46,"seconds":12,"hours":9,"month":6,"timezoneOffset":240,"year":112,"day":2,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abstract/Kyle/Bramble/17232574.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":744,"difficulty":1.6427798392084108,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4703,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.12292,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Patricia Fossil","authId":"","name":"Putrid Patricia Fossil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Putrid Patricia Fossil","authId":"","name":"Putrid Patricia Fossil","CNNId":"","myGameChains":null,"banStatus":null},"id":18249978,"name":"Robot Burst Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Putrid/Patricia/Fossil/18249978.jpg","createDate":{"time":1351030541000,"minutes":15,"seconds":41,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Putrid/Patricia/Fossil/18249978.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":55764,"difficulty":1.4460931686109932,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":106242,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.107148,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Chris Rumble","authId":"","name":"Massive Chris Rumble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Chris Rumble","authId":"","name":"Massive Chris Rumble","CNNId":"","myGameChains":null,"banStatus":null},"id":19721422,"name":"Hero Burst Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Massive/Chris/Rumble/19721422.jpg","createDate":{"time":1363262046000,"minutes":54,"seconds":6,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Massive/Chris/Rumble/19721422.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":185,"difficulty":1.4363636363636365,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1970,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.093939,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Mac Raptor","authId":"","name":"Hyper Mac Raptor","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Mac Raptor","authId":"","name":"Hyper Mac Raptor","CNNId":"","myGameChains":null,"banStatus":null},"id":19831736,"name":"Hex Omniverse Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hyper/Mac/Raptor/19831736.jpg","createDate":{"time":1363716551000,"minutes":9,"seconds":11,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hyper/Mac/Raptor/19831736.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":541,"difficulty":2.124786324786325,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":827,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.080651,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy Lloyd Squawk","authId":"","name":"Loopy Lloyd Squawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loopy Lloyd Squawk","authId":"","name":"Loopy Lloyd Squawk","CNNId":"","myGameChains":null,"banStatus":null},"id":18104600,"name":"Ultimate Plumber Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loopy/Lloyd/Squawk/18104600.jpg","createDate":{"time":1350072880000,"minutes":14,"seconds":40,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loopy/Lloyd/Squawk/18104600.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":263,"difficulty":2.4,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":920,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.07483,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stylish Freddy Slurp","authId":"","name":"Stylish Freddy Slurp","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stylish Freddy Slurp","authId":"","name":"Stylish Freddy Slurp","CNNId":"","myGameChains":null,"banStatus":null},"id":18613826,"name":"Streak Assault Danger","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stylish/Freddy/Slurp/18613826.jpg","createDate":{"time":1353966938000,"minutes":55,"seconds":38,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stylish/Freddy/Slurp/18613826.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":407,"difficulty":2.354166666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1752,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.0625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Tom Basilisk","authId":"","name":"Regular Tom Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Tom Basilisk","authId":"","name":"Regular Tom Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":19967722,"name":"Water Fusion Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Tom/Basilisk/19967722.jpg","createDate":{"time":1364647933000,"minutes":52,"seconds":13,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Tom/Basilisk/19967722.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":70,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":548,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vague Avery Parallax","authId":"","name":"Vague Avery Parallax","CNNId":"","myGameChains":null,"banStatus":null},"id":17216454,"name":"Quake Earth Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vague/Avery/Parallax/17216454.jpg","createDate":{"time":1342181655000,"minutes":14,"seconds":15,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vague/Avery/Parallax/17216454.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":700,"difficulty":1.4,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1767,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Destiny Ostrich","authId":"","name":"Peppy Destiny Ostrich","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peppy Destiny Ostrich","authId":"","name":"Peppy Destiny Ostrich","CNNId":"","myGameChains":null,"banStatus":null},"id":19475451,"name":"Adventure Fire Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peppy/Destiny/Ostrich/19475451.jpg","createDate":{"time":1359721675000,"minutes":27,"seconds":55,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peppy/Destiny/Ostrich/19475451.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":112,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":728,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"141","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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]