[{"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 = '6' 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":"Husky Michael Zombie","authId":"","name":"Husky Michael Zombie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Husky Michael Zombie","authId":"","name":"Husky Michael Zombie","CNNId":"","myGameChains":null,"banStatus":null},"id":19721040,"name":"Escape Warrior Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Husky/Michael/Zombie/19721040.jpg","createDate":{"time":1363258738000,"minutes":58,"seconds":58,"hours":6,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Husky/Michael/Zombie/19721040.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":691,"difficulty":1.471137685843568,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":770,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.793239,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Pearl Wolf","authId":"","name":"Normal Pearl Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Pearl Wolf","authId":"","name":"Normal Pearl Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":18256777,"name":"Earth Nitro Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Normal/Pearl/Wolf/18256777.jpg","createDate":{"time":1351114492000,"minutes":34,"seconds":52,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Normal/Pearl/Wolf/18256777.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1857,"difficulty":1.2209609354275834,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3793,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.770001,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Lloyd Whale","authId":"","name":"Ironic Lloyd Whale","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Lloyd Whale","authId":"","name":"Ironic Lloyd Whale","CNNId":"","myGameChains":null,"banStatus":null},"id":17216430,"name":"Warp Waterhazard Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironic/Lloyd/Whale/17216430.jpg","createDate":{"time":1342181077000,"minutes":4,"seconds":37,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironic/Lloyd/Whale/17216430.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":716,"difficulty":1.2068027210884353,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":869,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.620408,"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":18207257,"name":"Quake Ultimate Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eastern/Clay/Anvil/18207257.jpg","createDate":{"time":1350725006000,"minutes":23,"seconds":26,"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/18207257.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":726,"difficulty":1.462962962962963,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1157,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.583333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sluggish Jim Orchid","authId":"","name":"Sluggish Jim Orchid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sluggish Jim Orchid","authId":"","name":"Sluggish Jim Orchid","CNNId":"","myGameChains":null,"banStatus":null},"id":18260397,"name":"Earth Ultimate Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sluggish/Jim/Orchid/18260397.jpg","createDate":{"time":1351155748000,"minutes":2,"seconds":28,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sluggish/Jim/Orchid/18260397.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":417,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":558,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Mark Hacksaw","authId":"","name":"Dormant Mark Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dormant Mark Hacksaw","authId":"","name":"Dormant Mark Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18983227,"name":"Dark Challenge Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dormant/Mark/Hacksaw/18983227.jpg","createDate":{"time":1355519765000,"minutes":16,"seconds":5,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dormant/Mark/Hacksaw/18983227.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":157,"difficulty":1.4444444444444444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1173,"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":"Regular Misty Baboon","authId":"","name":"Regular Misty Baboon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Misty Baboon","authId":"","name":"Regular Misty Baboon","CNNId":"","myGameChains":null,"banStatus":null},"id":18079273,"name":"Pulse Water Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Misty/Baboon/18079273.jpg","createDate":{"time":1349900593000,"minutes":23,"seconds":13,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Misty/Baboon/18079273.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7341,"difficulty":1.1537775149104739,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9334,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.441098,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Daniel Blast","authId":"","name":"Loud Daniel Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Daniel Blast","authId":"","name":"Loud Daniel Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":19874105,"name":"Dark Charge Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Daniel/Blast/19874105.jpg","createDate":{"time":1364042711000,"minutes":45,"seconds":11,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Daniel/Blast/19874105.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":57,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":442,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Misty Serpent","authId":"","name":"Generous Misty Serpent","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Generous Misty Serpent","authId":"","name":"Generous Misty Serpent","CNNId":"","myGameChains":null,"banStatus":null},"id":18351206,"name":"Shadow Storm Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Generous/Misty/Serpent/18351206.jpg","createDate":{"time":1351876161000,"minutes":9,"seconds":21,"hours":13,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Generous/Misty/Serpent/18351206.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":178,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":435,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Phil Turbo","authId":"","name":"Ultimate Phil Turbo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Phil Turbo","authId":"","name":"Ultimate Phil Turbo","CNNId":"","myGameChains":null,"banStatus":null},"id":17942564,"name":"Nitro Quake Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Phil/Turbo/17942564.jpg","createDate":{"time":1349271050000,"minutes":30,"seconds":50,"hours":9,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Phil/Turbo/17942564.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":418,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"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 = '6' 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"}}]