[{"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 = '1' 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":"Sleepy Misty Viking","authId":"","name":"Sleepy Misty Viking","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Misty Viking","authId":"","name":"Sleepy Misty Viking","CNNId":"","myGameChains":null,"banStatus":null},"id":19637503,"name":"Earth Razor Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleepy/Misty/Viking/19637503.jpg","createDate":{"time":1362585159000,"minutes":52,"seconds":39,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleepy/Misty/Viking/19637503.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8349,"difficulty":2.12732936809231,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45623,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.567227,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Eugene Anvil","authId":"","name":"Crispy Eugene Anvil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Eugene Anvil","authId":"","name":"Crispy Eugene Anvil","CNNId":"","myGameChains":null,"banStatus":null},"id":18224034,"name":"Space Alien Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crispy/Eugene/Anvil/18224034.jpg","createDate":{"time":1350804233000,"minutes":23,"seconds":53,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":0,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crispy/Eugene/Anvil/18224034.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6145,"difficulty":1.4805570548133364,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":86726,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.540324,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rational Whit Mummy","authId":"","name":"Rational Whit Mummy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rational Whit Mummy","authId":"","name":"Rational Whit Mummy","CNNId":"","myGameChains":null,"banStatus":null},"id":17530621,"name":"Invasion Racer Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rational/Whit/Mummy/17530621.jpg","createDate":{"time":1348100938000,"minutes":28,"seconds":58,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rational/Whit/Mummy/17530621.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1660,"difficulty":2.7819217664043725,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13107,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.52016,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Tony Kayak","authId":"","name":"Ghastly Tony Kayak","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Tony Kayak","authId":"","name":"Ghastly Tony Kayak","CNNId":"","myGameChains":null,"banStatus":null},"id":17813285,"name":"Fire Champion Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghastly/Tony/Kayak/17813285.jpg","createDate":{"time":1348832259000,"minutes":37,"seconds":39,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghastly/Tony/Kayak/17813285.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":744,"difficulty":1.6255411255411256,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1556,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.494047,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Willard Mustang","authId":"","name":"Organic Willard Mustang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Willard Mustang","authId":"","name":"Organic Willard Mustang","CNNId":"","myGameChains":null,"banStatus":null},"id":19279659,"name":"Adventure Light Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Organic/Willard/Mustang/19279659.jpg","createDate":{"time":1357043372000,"minutes":29,"seconds":32,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Organic/Willard/Mustang/19279659.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1805,"difficulty":2.5783761588445877,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18295,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.442318,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Mia Gong","authId":"","name":"Prolific Mia Gong","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Mia Gong","authId":"","name":"Prolific Mia Gong","CNNId":"","myGameChains":null,"banStatus":null},"id":17216107,"name":"Quake Mission Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prolific/Mia/Gong/17216107.jpg","createDate":{"time":1342163752000,"minutes":15,"seconds":52,"hours":3,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prolific/Mia/Gong/17216107.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":289,"difficulty":1.88,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1205,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.4375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sinister Geoff Jigsaw","authId":"","name":"Sinister Geoff Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sinister Geoff Jigsaw","authId":"","name":"Sinister Geoff Jigsaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18498040,"name":"Energy Turbo Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sinister/Geoff/Jigsaw/18498040.jpg","createDate":{"time":1353148038000,"minutes":27,"seconds":18,"hours":5,"month":10,"timezoneOffset":300,"year":112,"day":6,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sinister/Geoff/Jigsaw/18498040.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":798,"difficulty":2.7788073277925753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16256,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.423106,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy David Crash","authId":"","name":"Zippy David Crash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy David Crash","authId":"","name":"Zippy David Crash","CNNId":"","myGameChains":null,"banStatus":null},"id":19602823,"name":"Danger Swampfire Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zippy/David/Crash/19602823.jpg","createDate":{"time":1361806084000,"minutes":28,"seconds":4,"hours":10,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zippy/David/Crash/19602823.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5003,"difficulty":2.490085578037108,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":31997,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.40245,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Alex Plasma","authId":"","name":"Academic Alex Plasma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Alex Plasma","authId":"","name":"Academic Alex Plasma","CNNId":"","myGameChains":null,"banStatus":null},"id":19206818,"name":"Adventure Energy Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Alex/Plasma/19206818.jpg","createDate":{"time":1356592012000,"minutes":6,"seconds":52,"hours":2,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Alex/Plasma/19206818.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4510,"difficulty":2.2028267628799605,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":123895,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.343725,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spirited Earl Galoot","authId":"","name":"Spirited Earl Galoot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spirited Earl Galoot","authId":"","name":"Spirited Earl Galoot","CNNId":"","myGameChains":null,"banStatus":null},"id":19461306,"name":"Ultimate Swampfire Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spirited/Earl/Galoot/19461306.jpg","createDate":{"time":1359369544000,"minutes":39,"seconds":4,"hours":5,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spirited/Earl/Galoot/19461306.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8243,"difficulty":1.466099994395445,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82978,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.23386,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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 = '1' 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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]