[{"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":"Galactic Jordan Gargoyle","authId":"","name":"Galactic Jordan Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Jordan Gargoyle","authId":"","name":"Galactic Jordan Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"id":18071225,"name":"Power Pulse Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Jordan/Gargoyle/18071225.jpg","createDate":{"time":1349827114000,"minutes":58,"seconds":34,"hours":19,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Jordan/Gargoyle/18071225.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33691,"difficulty":2.747086972358474,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57623,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":2.565092,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gallant Mac Bullfrog","authId":"","name":"Gallant Mac Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gallant Mac Bullfrog","authId":"","name":"Gallant Mac Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"id":19027827,"name":"Fire Attack Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gallant/Mac/Bullfrog/19027827.jpg","createDate":{"time":1355662659000,"minutes":57,"seconds":39,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gallant/Mac/Bullfrog/19027827.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":613,"difficulty":2.7308701714951713,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4112,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.547062,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stubborn Noel Giraffe","authId":"","name":"Stubborn Noel Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stubborn Noel Giraffe","authId":"","name":"Stubborn Noel Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"id":19278981,"name":"Rock Spidermonkey Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stubborn/Noel/Giraffe/19278981.jpg","createDate":{"time":1357033938000,"minutes":52,"seconds":18,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stubborn/Noel/Giraffe/19278981.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33147,"difficulty":2.515071118879844,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":68415,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.517798,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Salvador Bronco","authId":"","name":"Wacky Salvador Bronco","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Salvador Bronco","authId":"","name":"Wacky Salvador Bronco","CNNId":"","myGameChains":null,"banStatus":null},"id":19589168,"name":"Siege Search Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Salvador/Bronco/19589168.jpg","createDate":{"time":1361624167000,"minutes":56,"seconds":7,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Salvador/Bronco/19589168.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":97,"difficulty":2.9,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1089,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.511111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vibrant Jenn Castle","authId":"","name":"Vibrant Jenn Castle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vibrant Jenn Castle","authId":"","name":"Vibrant Jenn Castle","CNNId":"","myGameChains":null,"banStatus":null},"id":19816559,"name":"Big Adventure Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vibrant/Jenn/Castle/19816559.jpg","createDate":{"time":1363612140000,"minutes":9,"seconds":0,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vibrant/Jenn/Castle/19816559.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1454,"difficulty":2.0142601177940165,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8058,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.50895,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Rigby Blizzard","authId":"","name":"Silly Rigby Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Rigby Blizzard","authId":"","name":"Silly Rigby Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":18105750,"name":"Quake Magno Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Rigby/Blizzard/18105750.jpg","createDate":{"time":1350076488000,"minutes":14,"seconds":48,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Rigby/Blizzard/18105750.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":321,"difficulty":1.6082644628099174,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1998,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.427381,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Amber Zeppelin","authId":"","name":"Grouchy Amber Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Amber Zeppelin","authId":"","name":"Grouchy Amber Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"id":19549299,"name":"Chase Attack Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grouchy/Amber/Zeppelin/19549299.jpg","createDate":{"time":1361017923000,"minutes":32,"seconds":3,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grouchy/Amber/Zeppelin/19549299.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":767,"difficulty":2.0998579336040635,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6540,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.411462,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Adam Aardvark","authId":"","name":"Prolific Adam Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Adam Aardvark","authId":"","name":"Prolific Adam Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":17681366,"name":"Nitro Burst Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prolific/Adam/Aardvark/17681366.jpg","createDate":{"time":1348369120000,"minutes":58,"seconds":40,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prolific/Adam/Aardvark/17681366.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35356,"difficulty":2.274495013851522,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82972,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.407227,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eastern Clay Anvil","authId":"","name":"Eastern Clay Anvil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eastern Clay Anvil","authId":"","name":"Eastern Clay Anvil","CNNId":"","myGameChains":null,"banStatus":null},"id":18207273,"name":"Titan Shock Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eastern/Clay/Anvil/18207273.jpg","createDate":{"time":1350725228000,"minutes":27,"seconds":8,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eastern/Clay/Anvil/18207273.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3080,"difficulty":1.946368405647343,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5217,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.401701,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kooky Kaleb Calypso","authId":"","name":"Kooky Kaleb Calypso","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kooky Kaleb Calypso","authId":"","name":"Kooky Kaleb Calypso","CNNId":"","myGameChains":null,"banStatus":null},"id":17208653,"name":"Turbo Adventure Echo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kooky/Kaleb/Calypso/17208653.jpg","createDate":{"time":1341968720000,"minutes":5,"seconds":20,"hours":21,"month":6,"timezoneOffset":240,"year":112,"day":2,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kooky/Kaleb/Calypso/17208653.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2124,"difficulty":2.333615304699676,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51117,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":21,"rating":2.396842,"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 = '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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]