[{"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":"Groovy Victoria Fizz","authId":"","name":"Groovy Victoria Fizz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Victoria Fizz","authId":"","name":"Groovy Victoria Fizz","CNNId":"","myGameChains":null,"banStatus":null},"id":19638292,"name":"Racer Hero Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Victoria/Fizz/19638292.jpg","createDate":{"time":1362601572000,"minutes":26,"seconds":12,"hours":15,"month":2,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Victoria/Fizz/19638292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4049,"difficulty":1.990047283611278,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29450,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.868829,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Ned Apple","authId":"","name":"Abnormal Ned Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abnormal Ned Apple","authId":"","name":"Abnormal Ned Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":18911932,"name":"Champion Power Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abnormal/Ned/Apple/18911932.jpg","createDate":{"time":1355129772000,"minutes":56,"seconds":12,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abnormal/Ned/Apple/18911932.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":746,"difficulty":1.5625,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1552,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.861111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Justin Zinger","authId":"","name":"Valiant Justin Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Valiant Justin Zinger","authId":"","name":"Valiant Justin Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":19186707,"name":"Big Adventure Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Valiant/Justin/Zinger/19186707.jpg","createDate":{"time":1356435093000,"minutes":31,"seconds":33,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Valiant/Justin/Zinger/19186707.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":326,"difficulty":2.4393939393939394,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3095,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.798701,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mellow Roy Waffle","authId":"","name":"Mellow Roy Waffle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mellow Roy Waffle","authId":"","name":"Mellow Roy Waffle","CNNId":"","myGameChains":null,"banStatus":null},"id":17952821,"name":"Doom Warp Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mellow/Roy/Waffle/17952821.jpg","createDate":{"time":1349323269000,"minutes":1,"seconds":9,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mellow/Roy/Waffle/17952821.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":59430,"difficulty":2.356363466583897,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":228868,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.750058,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Greg Lime","authId":"","name":"Athletic Greg Lime","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Greg Lime","authId":"","name":"Athletic Greg Lime","CNNId":"","myGameChains":null,"banStatus":null},"id":19568598,"name":"Ultimate Charge Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Greg/Lime/19568598.jpg","createDate":{"time":1361237723000,"minutes":35,"seconds":23,"hours":20,"month":1,"timezoneOffset":300,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Greg/Lime/19568598.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":795,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":993,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.74,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Billy Sizzle","authId":"","name":"Hefty Billy Sizzle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hefty Billy Sizzle","authId":"","name":"Hefty Billy Sizzle","CNNId":"","myGameChains":null,"banStatus":null},"id":18287704,"name":"Clash Echo Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hefty/Billy/Sizzle/18287704.jpg","createDate":{"time":1351358711000,"minutes":25,"seconds":11,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hefty/Billy/Sizzle/18287704.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6148,"difficulty":1.3529242324661264,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14659,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.71666,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Aiden Manatee","authId":"","name":"Cartoony Aiden Manatee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Aiden Manatee","authId":"","name":"Cartoony Aiden Manatee","CNNId":"","myGameChains":null,"banStatus":null},"id":19342263,"name":"Spike Defense Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cartoony/Aiden/Manatee/19342263.jpg","createDate":{"time":1357588600000,"minutes":56,"seconds":40,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cartoony/Aiden/Manatee/19342263.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1287,"difficulty":2.4591324765200198,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5390,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.70081,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Pierre Whale","authId":"","name":"Ironic Pierre Whale","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Pierre Whale","authId":"","name":"Ironic Pierre Whale","CNNId":"","myGameChains":null,"banStatus":null},"id":18247616,"name":"Adventure Streak Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironic/Pierre/Whale/18247616.jpg","createDate":{"time":1351008333000,"minutes":5,"seconds":33,"hours":12,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironic/Pierre/Whale/18247616.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3820,"difficulty":1.4165122398229142,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6963,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.662126,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gnarly Roy Toenail","authId":"","name":"Gnarly Roy Toenail","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gnarly Roy Toenail","authId":"","name":"Gnarly Roy Toenail","CNNId":"","myGameChains":null,"banStatus":null},"id":18098344,"name":"Plasma Assault Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gnarly/Roy/Toenail/18098344.jpg","createDate":{"time":1350037574000,"minutes":26,"seconds":14,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gnarly/Roy/Toenail/18098344.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":446,"difficulty":1.6630208333333334,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2683,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.644379,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Gabe Dingbat","authId":"","name":"Roaring Gabe Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Gabe Dingbat","authId":"","name":"Roaring Gabe Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"id":19413731,"name":"Star Fury Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Roaring/Gabe/Dingbat/19413731.jpg","createDate":{"time":1358684119000,"minutes":15,"seconds":19,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Roaring/Gabe/Dingbat/19413731.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2122,"difficulty":2.8066950690021213,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8989,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.636058,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]