[{"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 = '16' 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":"Sassy Marcia Yodel","authId":"","name":"Sassy Marcia Yodel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sassy Marcia Yodel","authId":"","name":"Sassy Marcia Yodel","CNNId":"","myGameChains":null,"banStatus":null},"id":19907254,"name":"Mission Plumber Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sassy/Marcia/Yodel/19907254.jpg","createDate":{"time":1364221769000,"minutes":29,"seconds":29,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sassy/Marcia/Yodel/19907254.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45626,"difficulty":1.732152178267444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47416,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.032195,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Trent Fang","authId":"","name":"Unknown Trent Fang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Trent Fang","authId":"","name":"Unknown Trent Fang","CNNId":"","myGameChains":null,"banStatus":null},"id":19691104,"name":"Ultimate Kickin' Hawk Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Trent/Fang/19691104.jpg","createDate":{"time":1363121109000,"minutes":45,"seconds":9,"hours":16,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Trent/Fang/19691104.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":78,"difficulty":1.2708333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":875,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.82,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Wally Goblin","authId":"","name":"Doctor Wally Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Wally Goblin","authId":"","name":"Doctor Wally Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":19831794,"name":"Mission Slam Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Wally/Goblin/19831794.jpg","createDate":{"time":1363716947000,"minutes":15,"seconds":47,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Wally/Goblin/19831794.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2158,"difficulty":1.7175956435320843,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14451,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.801127,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Squishy Harvey Giraffe","authId":"","name":"Squishy Harvey Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Squishy Harvey Giraffe","authId":"","name":"Squishy Harvey Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"id":19785384,"name":"Fury Warrior Giga","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Squishy/Harvey/Giraffe/19785384.jpg","createDate":{"time":1363489060000,"minutes":57,"seconds":40,"hours":22,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Squishy/Harvey/Giraffe/19785384.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1378,"difficulty":1.582170349233332,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":91446,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.724397,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Julius Yodel","authId":"","name":"Cackling Julius Yodel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Julius Yodel","authId":"","name":"Cackling Julius Yodel","CNNId":"","myGameChains":null,"banStatus":null},"id":19721427,"name":"Dark Space Pulse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Julius/Yodel/19721427.jpg","createDate":{"time":1363262137000,"minutes":55,"seconds":37,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Julius/Yodel/19721427.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":728,"difficulty":1.8,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2202,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.662946,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Ben Witch","authId":"","name":"Famous Ben Witch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Ben Witch","authId":"","name":"Famous Ben Witch","CNNId":"","myGameChains":null,"banStatus":null},"id":19721420,"name":"Kickin' Hawk Big Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Ben/Witch/19721420.jpg","createDate":{"time":1363262034000,"minutes":53,"seconds":54,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Ben/Witch/19721420.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":199,"difficulty":2.944444444444444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1890,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.613577,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Wesley Snake","authId":"","name":"Orange Wesley Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Wesley Snake","authId":"","name":"Orange Wesley Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":19967742,"name":"Adventure Danger Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Orange/Wesley/Snake/19967742.jpg","createDate":{"time":1364647985000,"minutes":53,"seconds":5,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Orange/Wesley/Snake/19967742.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":310,"difficulty":1.4166666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1031,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.608333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Cathy Goofball","authId":"","name":"Sporty Cathy Goofball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sporty Cathy Goofball","authId":"","name":"Sporty Cathy Goofball","CNNId":"","myGameChains":null,"banStatus":null},"id":19995387,"name":"Shock Earth Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sporty/Cathy/Goofball/19995387.jpg","createDate":{"time":1364838674000,"minutes":51,"seconds":14,"hours":13,"month":3,"timezoneOffset":240,"year":113,"day":1,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sporty/Cathy/Goofball/19995387.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":926,"difficulty":2.3500881834215166,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3559,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.607178,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Grover Sawtooth","authId":"","name":"Loyal Grover Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Grover Sawtooth","authId":"","name":"Loyal Grover Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"id":19816515,"name":"Ultra Streak Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Grover/Sawtooth/19816515.jpg","createDate":{"time":1363611824000,"minutes":3,"seconds":44,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Grover/Sawtooth/19816515.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":293,"difficulty":2.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1758,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.57551,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Wilford Moxie","authId":"","name":"Dashing Wilford Moxie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Wilford Moxie","authId":"","name":"Dashing Wilford Moxie","CNNId":"","myGameChains":null,"banStatus":null},"id":19707555,"name":"Energy Robot Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/Wilford/Moxie/19707555.jpg","createDate":{"time":1363196850000,"minutes":47,"seconds":30,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/Wilford/Moxie/19707555.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":819,"difficulty":2.421736238354991,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8039,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.560738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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 = '16' 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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]