[{"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 = '11' 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":"Northern Zachary Zinger","authId":"","name":"Northern Zachary Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Northern Zachary Zinger","authId":"","name":"Northern Zachary Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":18127817,"name":"Adventure Echo Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Northern/Zachary/Zinger/18127817.jpg","createDate":{"time":1350158790000,"minutes":6,"seconds":30,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Northern/Zachary/Zinger/18127817.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6096,"difficulty":2.321387915616623,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29796,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.291957,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Buffy Diamond","authId":"","name":"Orange Buffy Diamond","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Buffy Diamond","authId":"","name":"Orange Buffy Diamond","CNNId":"","myGameChains":null,"banStatus":null},"id":17687011,"name":"Power Gear Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Orange/Buffy/Diamond/17687011.jpg","createDate":{"time":1348390240000,"minutes":50,"seconds":40,"hours":4,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Orange/Buffy/Diamond/17687011.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1194,"difficulty":2.564517675526478,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":28110,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.285176,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Arianna Plankton","authId":"","name":"Solar Arianna Plankton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Arianna Plankton","authId":"","name":"Solar Arianna Plankton","CNNId":"","myGameChains":null,"banStatus":null},"id":18070930,"name":"Warp Light Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solar/Arianna/Plankton/18070930.jpg","createDate":{"time":1349826326000,"minutes":45,"seconds":26,"hours":19,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solar/Arianna/Plankton/18070930.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3575,"difficulty":1.817581686733995,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":52368,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.284204,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Brayden Noodle","authId":"","name":"Sparkly Brayden Noodle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Brayden Noodle","authId":"","name":"Sparkly Brayden Noodle","CNNId":"","myGameChains":null,"banStatus":null},"id":17423329,"name":"Fire Plasma Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sparkly/Brayden/Noodle/17423329.jpg","createDate":{"time":1347894123000,"minutes":2,"seconds":3,"hours":11,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sparkly/Brayden/Noodle/17423329.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":135635,"difficulty":1.4097058484607894,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":216095,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.281485,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Chad Cumulus","authId":"","name":"Colonel Chad Cumulus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Chad Cumulus","authId":"","name":"Colonel Chad Cumulus","CNNId":"","myGameChains":null,"banStatus":null},"id":18107139,"name":"Shock Warrior Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Chad/Cumulus/18107139.jpg","createDate":{"time":1350080348000,"minutes":19,"seconds":8,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Chad/Cumulus/18107139.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6306,"difficulty":2.512967713208599,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34715,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.267239,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Chrissie Paprika","authId":"","name":"Itchy Chrissie Paprika","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Itchy Chrissie Paprika","authId":"","name":"Itchy Chrissie Paprika","CNNId":"","myGameChains":null,"banStatus":null},"id":19402626,"name":"Plumber Mission Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Itchy/Chrissie/Paprika/19402626.jpg","createDate":{"time":1358546442000,"minutes":0,"seconds":42,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Itchy/Chrissie/Paprika/19402626.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26517,"difficulty":2.4548332374431383,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":28619,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.261625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Medusa Narwhal","authId":"","name":"Sharp Medusa Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sharp Medusa Narwhal","authId":"","name":"Sharp Medusa Narwhal","CNNId":"","myGameChains":null,"banStatus":null},"id":18676241,"name":"Fire Whirlwind Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sharp/Medusa/Narwhal/18676241.jpg","createDate":{"time":1354549745000,"minutes":49,"seconds":5,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sharp/Medusa/Narwhal/18676241.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1592,"difficulty":2.629769160428806,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":105980,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.235374,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Messy Dawn Gazebo","authId":"","name":"Messy Dawn Gazebo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Messy Dawn Gazebo","authId":"","name":"Messy Dawn Gazebo","CNNId":"","myGameChains":null,"banStatus":null},"id":19602341,"name":"Ambush Nova Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Messy/Dawn/Gazebo/19602341.jpg","createDate":{"time":1361794050000,"minutes":7,"seconds":30,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Messy/Dawn/Gazebo/19602341.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3565,"difficulty":2.0751929796076665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39261,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.219859,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Bradley Gamer","authId":"","name":"Academic Bradley Gamer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Bradley Gamer","authId":"","name":"Academic Bradley Gamer","CNNId":"","myGameChains":null,"banStatus":null},"id":18346820,"name":"Power Feedback Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Bradley/Gamer/18346820.jpg","createDate":{"time":1351817116000,"minutes":45,"seconds":16,"hours":20,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Bradley/Gamer/18346820.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28908,"difficulty":1.6490758354016917,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":141318,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.216269,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Zeb Zigzag","authId":"","name":"Robust Zeb Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Zeb Zigzag","authId":"","name":"Robust Zeb Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"id":18407865,"name":"Rumble Stone Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robust/Zeb/Zigzag/18407865.jpg","createDate":{"time":1352253962000,"minutes":6,"seconds":2,"hours":21,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robust/Zeb/Zigzag/18407865.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10805,"difficulty":2.330967122331682,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":114783,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.210279,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"101","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 = '11' 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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]