[{"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 = '4' 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":"Evil Aiden Confetti","authId":"","name":"Evil Aiden Confetti","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Aiden Confetti","authId":"","name":"Evil Aiden Confetti","CNNId":"","myGameChains":null,"banStatus":null},"id":19342257,"name":"Droid Spidermonkey Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Aiden/Confetti/19342257.jpg","createDate":{"time":1357588386000,"minutes":53,"seconds":6,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Aiden/Confetti/19342257.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":811,"difficulty":1.4277777777777778,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1367,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.88,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Colton Bingo","authId":"","name":"Active Colton Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Colton Bingo","authId":"","name":"Active Colton Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":19605702,"name":"Beast Ultimate Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Colton/Bingo/19605702.jpg","createDate":{"time":1361882997000,"minutes":49,"seconds":57,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Colton/Bingo/19605702.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12451,"difficulty":1.596114745188263,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13326,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.806271,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Skylar Worm","authId":"","name":"Athletic Skylar Worm","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Skylar Worm","authId":"","name":"Athletic Skylar Worm","CNNId":"","myGameChains":null,"banStatus":null},"id":18239551,"name":"Water Beast Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Skylar/Worm/18239551.jpg","createDate":{"time":1350915187000,"minutes":13,"seconds":7,"hours":10,"month":9,"timezoneOffset":240,"year":112,"day":1,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Skylar/Worm/18239551.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25561,"difficulty":1.2177320410021129,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39122,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.747085,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Melodic William Macaw","authId":"","name":"Melodic William Macaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Melodic William Macaw","authId":"","name":"Melodic William Macaw","CNNId":"","myGameChains":null,"banStatus":null},"id":19527384,"name":"Rustbucket Smash Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Melodic/William/Macaw/19527384.jpg","createDate":{"time":1360597346000,"minutes":42,"seconds":26,"hours":10,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Melodic/William/Macaw/19527384.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2073,"difficulty":1.5872653233449725,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2701,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.731507,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scurvy Carlos Mastodon","authId":"","name":"Scurvy Carlos Mastodon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scurvy Carlos Mastodon","authId":"","name":"Scurvy Carlos Mastodon","CNNId":"","myGameChains":null,"banStatus":null},"id":19638658,"name":"Mega Adventure Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scurvy/Carlos/Mastodon/19638658.jpg","createDate":{"time":1362607267000,"minutes":1,"seconds":7,"hours":17,"month":2,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scurvy/Carlos/Mastodon/19638658.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1334,"difficulty":1.2925724153297684,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3502,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.637478,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Quack","authId":"","name":"Spectral Quack","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Quack","authId":"","name":"Spectral Quack","CNNId":"","myGameChains":null,"banStatus":null},"id":19620245,"name":"Mission Search Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spectral/Quack/19620245.jpg","createDate":{"time":1362236139000,"minutes":55,"seconds":39,"hours":9,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spectral/Quack/19620245.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2911,"difficulty":1.4393604788125145,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26319,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.607466,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Angela Cinnamon","authId":"","name":"Creepy Angela Cinnamon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Angela Cinnamon","authId":"","name":"Creepy Angela Cinnamon","CNNId":"","myGameChains":null,"banStatus":null},"id":17942888,"name":"Clash Rescue Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creepy/Angela/Cinnamon/17942888.jpg","createDate":{"time":1349273588000,"minutes":13,"seconds":8,"hours":10,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creepy/Angela/Cinnamon/17942888.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":83026,"difficulty":1.2651266364388891,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":145304,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":1.515207,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Ethan Cutlass","authId":"","name":"Grizzly Ethan Cutlass","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grizzly Ethan Cutlass","authId":"","name":"Grizzly Ethan Cutlass","CNNId":"","myGameChains":null,"banStatus":null},"id":17546117,"name":"Battle Nano Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grizzly/Ethan/Cutlass/17546117.jpg","createDate":{"time":1348160215000,"minutes":56,"seconds":55,"hours":12,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grizzly/Ethan/Cutlass/17546117.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":223,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1041,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.444444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Surreal Drew Wolf","authId":"","name":"Surreal Drew Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Surreal Drew Wolf","authId":"","name":"Surreal Drew Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":18256788,"name":"Charge Warp Nitro","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Surreal/Drew/Wolf/18256788.jpg","createDate":{"time":1351114612000,"minutes":36,"seconds":52,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Surreal/Drew/Wolf/18256788.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1446,"difficulty":1.3776818419675563,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1694,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.349829,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Gary Monster","authId":"","name":"Friendly Gary Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Gary Monster","authId":"","name":"Friendly Gary Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":18107108,"name":"Titan Shock Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Gary/Monster/18107108.jpg","createDate":{"time":1350080249000,"minutes":17,"seconds":29,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Gary/Monster/18107108.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3261,"difficulty":2.6200197301756347,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5256,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":1.223871,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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 = '4' 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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]