[{"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":"General Jamie Frog","authId":"","name":"General Jamie Frog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Jamie Frog","authId":"","name":"General Jamie Frog","CNNId":"","myGameChains":null,"banStatus":null},"id":17687147,"name":"Dark Adventure Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Jamie/Frog/17687147.jpg","createDate":{"time":1348390807000,"minutes":0,"seconds":7,"hours":5,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Jamie/Frog/17687147.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3634,"difficulty":1.4222945154393118,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6525,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.280714,"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":18170155,"name":"Light Light Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Leonardo/Wolf/18170155.jpg","createDate":{"time":1350360991000,"minutes":16,"seconds":31,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Leonardo/Wolf/18170155.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2639,"difficulty":2.456418544710129,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10459,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.273671,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Layla Magician","authId":"","name":"Obscure Layla Magician","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obscure Layla Magician","authId":"","name":"Obscure Layla Magician","CNNId":"","myGameChains":null,"banStatus":null},"id":19629654,"name":"Adventure Escape Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obscure/Layla/Magician/19629654.jpg","createDate":{"time":1362345330000,"minutes":15,"seconds":30,"hours":16,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obscure/Layla/Magician/19629654.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":560,"difficulty":2.52,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2009,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.268027,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Devon Ladybug","authId":"","name":"Shy Devon Ladybug","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Devon Ladybug","authId":"","name":"Shy Devon Ladybug","CNNId":"","myGameChains":null,"banStatus":null},"id":17543830,"name":"Adventure Patrol Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Devon/Ladybug/17543830.jpg","createDate":{"time":1348153794000,"minutes":9,"seconds":54,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Devon/Ladybug/17543830.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":984,"difficulty":2.6262896825396824,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4094,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.267161,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Herman Reptile","authId":"","name":"Regal Herman Reptile","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Herman Reptile","authId":"","name":"Regal Herman Reptile","CNNId":"","myGameChains":null,"banStatus":null},"id":17560405,"name":"Ultimate Shock Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regal/Herman/Reptile/17560405.jpg","createDate":{"time":1348183614000,"minutes":26,"seconds":54,"hours":19,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regal/Herman/Reptile/17560405.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":416,"difficulty":2.5869940724220237,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5484,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.250149,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Dustin Gorgon","authId":"","name":"Fabulous Dustin Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Dustin Gorgon","authId":"","name":"Fabulous Dustin Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"id":17547963,"name":"Ben Gravattack Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Dustin/Gorgon/17547963.jpg","createDate":{"time":1348166142000,"minutes":35,"seconds":42,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Dustin/Gorgon/17547963.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1806,"difficulty":2.5178486106653524,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2891,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.240197,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Herbert Chutney","authId":"","name":"Strong Herbert Chutney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Herbert Chutney","authId":"","name":"Strong Herbert Chutney","CNNId":"","myGameChains":null,"banStatus":null},"id":17736796,"name":"Iron Stone Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Herbert/Chutney/17736796.jpg","createDate":{"time":1348463146000,"minutes":5,"seconds":46,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Herbert/Chutney/17736796.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":267,"difficulty":1.1224489795918369,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2100,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.238095,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Bert Turtle","authId":"","name":"Sleepy Bert Turtle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Bert Turtle","authId":"","name":"Sleepy Bert Turtle","CNNId":"","myGameChains":null,"banStatus":null},"id":19609553,"name":"Battle Gear Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleepy/Bert/Turtle/19609553.jpg","createDate":{"time":1361989211000,"minutes":20,"seconds":11,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleepy/Bert/Turtle/19609553.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":412,"difficulty":2.2852362635644368,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4752,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.234976,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Tex Gorilla","authId":"","name":"Kinetic Tex Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Tex Gorilla","authId":"","name":"Kinetic Tex Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":17806797,"name":"Clash Power Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Tex/Gorilla/17806797.jpg","createDate":{"time":1348790467000,"minutes":1,"seconds":7,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Tex/Gorilla/17806797.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":31148,"difficulty":1.9858111329763342,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":99593,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.234372,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immense Vanessa Coconut","authId":"","name":"Immense Vanessa Coconut","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immense Vanessa Coconut","authId":"","name":"Immense Vanessa Coconut","CNNId":"","myGameChains":null,"banStatus":null},"id":17423664,"name":"Energy Razor Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immense/Vanessa/Coconut/17423664.jpg","createDate":{"time":1347894759000,"minutes":12,"seconds":39,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immense/Vanessa/Coconut/17423664.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":893,"difficulty":2.4816738816738817,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5349,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.216111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","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":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]