[{"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 = '9' 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":"Super Angelica Seesaw","authId":"","name":"Super Angelica Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Angelica Seesaw","authId":"","name":"Super Angelica Seesaw","CNNId":"","myGameChains":null,"banStatus":null},"id":17648631,"name":"Adventure Stone Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Angelica/Seesaw/17648631.jpg","createDate":{"time":1348337430000,"minutes":10,"seconds":30,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Angelica/Seesaw/17648631.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24,"difficulty":1.5555555555555556,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":851,"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":"Dizzy Charles Thorax","authId":"","name":"Dizzy Charles Thorax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dizzy Charles Thorax","authId":"","name":"Dizzy Charles Thorax","CNNId":"","myGameChains":null,"banStatus":null},"id":19640149,"name":"Iron Hyper Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dizzy/Charles/Thorax/19640149.jpg","createDate":{"time":1362659730000,"minutes":35,"seconds":30,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dizzy/Charles/Thorax/19640149.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":394,"difficulty":2.6666666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2185,"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":"Lunar Rolf Acorn","authId":"","name":"Lunar Rolf Acorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lunar Rolf Acorn","authId":"","name":"Lunar Rolf Acorn","CNNId":"","myGameChains":null,"banStatus":null},"id":19347060,"name":"Adventure Magno Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lunar/Rolf/Acorn/19347060.jpg","createDate":{"time":1357676552000,"minutes":22,"seconds":32,"hours":15,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lunar/Rolf/Acorn/19347060.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":133,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1004,"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":"Absurd Rex Aviator","authId":"","name":"Absurd Rex Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Absurd Rex Aviator","authId":"","name":"Absurd Rex Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":19660174,"name":"Animo Star Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Absurd/Rex/Aviator/19660174.jpg","createDate":{"time":1362970945000,"minutes":2,"seconds":25,"hours":23,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Absurd/Rex/Aviator/19660174.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38838,"difficulty":1.6013658432773834,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":64535,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.972951,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Dawn Kungfu","authId":"","name":"Reckless Dawn Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Dawn Kungfu","authId":"","name":"Reckless Dawn Kungfu","CNNId":"","myGameChains":null,"banStatus":null},"id":19526882,"name":"Universe Omniverse Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Dawn/Kungfu/19526882.jpg","createDate":{"time":1360586572000,"minutes":42,"seconds":52,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Dawn/Kungfu/19526882.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":561,"difficulty":1.35625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2517,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.970068,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Ashton Scorpion","authId":"","name":"Nimble Ashton Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Ashton Scorpion","authId":"","name":"Nimble Ashton Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"id":18005064,"name":"Defense Ben Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nimble/Ashton/Scorpion/18005064.jpg","createDate":{"time":1349554591000,"minutes":16,"seconds":31,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nimble/Ashton/Scorpion/18005064.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16161,"difficulty":1.2588782086976344,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18453,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.95454,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tacky Hercules Bison","authId":"","name":"Tacky Hercules Bison","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tacky Hercules Bison","authId":"","name":"Tacky Hercules Bison","CNNId":"","myGameChains":null,"banStatus":null},"id":17793451,"name":"Attack Escape Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tacky/Hercules/Bison/17793451.jpg","createDate":{"time":1348720739000,"minutes":38,"seconds":59,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tacky/Hercules/Bison/17793451.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":580,"difficulty":2.5986394557823127,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4540,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.92,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gentle Wolfgang Gumshoe","authId":"","name":"Gentle Wolfgang Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gentle Wolfgang Gumshoe","authId":"","name":"Gentle Wolfgang Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":18260557,"name":"Charge Alien Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gentle/Wolfgang/Gumshoe/18260557.jpg","createDate":{"time":1351158022000,"minutes":40,"seconds":22,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gentle/Wolfgang/Gumshoe/18260557.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4439,"difficulty":2.256028394825436,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39633,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.889964,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Brittney Bingo","authId":"","name":"Odd Brittney Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Odd Brittney Bingo","authId":"","name":"Odd Brittney Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":18127715,"name":"Adventure Storm Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Odd/Brittney/Bingo/18127715.jpg","createDate":{"time":1350158583000,"minutes":3,"seconds":3,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Odd/Brittney/Bingo/18127715.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":186,"difficulty":1.6280555555555556,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2373,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.88,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Courtney Basilisk","authId":"","name":"Sharp Courtney Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Courtney Basilisk","authId":"","name":"Sharp Courtney Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":18705575,"name":"Dark Universe Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sharp/Courtney/Basilisk/18705575.jpg","createDate":{"time":1354654819000,"minutes":0,"seconds":19,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sharp/Courtney/Basilisk/18705575.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44851,"difficulty":1.7116559302391008,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78823,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.802725,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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 = '9' 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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]