[{"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 = '3' 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":"Unknown Quinn Fox","authId":"","name":"Unknown Quinn Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Quinn Fox","authId":"","name":"Unknown Quinn Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":18351714,"name":"Big Quake Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Quinn/Fox/18351714.jpg","createDate":{"time":1351880721000,"minutes":25,"seconds":21,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Quinn/Fox/18351714.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":812,"difficulty":2.31305114638448,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1662,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.532143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Harry Fandango","authId":"","name":"Majestic Harry Fandango","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Harry Fandango","authId":"","name":"Majestic Harry Fandango","CNNId":"","myGameChains":null,"banStatus":null},"id":17552667,"name":"Ultimate Defense Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/Harry/Fandango/17552667.jpg","createDate":{"time":1348175271000,"minutes":7,"seconds":51,"hours":17,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/Harry/Fandango/17552667.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1229,"difficulty":1.85886998117319,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17193,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.519507,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Miguel Behemoth","authId":"","name":"Weird Miguel Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Weird Miguel Behemoth","authId":"","name":"Weird Miguel Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":19507680,"name":"Slam Rampage Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Weird/Miguel/Behemoth/19507680.jpg","createDate":{"time":1360324218000,"minutes":50,"seconds":18,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Weird/Miguel/Behemoth/19507680.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1247,"difficulty":2.492597871843028,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":30829,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.517776,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Tyler Clone","authId":"","name":"Splendid Tyler Clone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Tyler Clone","authId":"","name":"Splendid Tyler Clone","CNNId":"","myGameChains":null,"banStatus":null},"id":18426846,"name":"Battle Ben Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Splendid/Tyler/Clone/18426846.jpg","createDate":{"time":1352494339000,"minutes":52,"seconds":19,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Splendid/Tyler/Clone/18426846.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":180,"difficulty":2.738520927571147,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32600,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.508459,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Maya Whisper","authId":"","name":"Baroness Maya Whisper","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Maya Whisper","authId":"","name":"Baroness Maya Whisper","CNNId":"","myGameChains":null,"banStatus":null},"id":18207251,"name":"Robot Star Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Maya/Whisper/18207251.jpg","createDate":{"time":1350724848000,"minutes":20,"seconds":48,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Maya/Whisper/18207251.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":26,"difficulty":1.6666666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1400,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Magnus Ogre","authId":"","name":"Orange Magnus Ogre","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Orange Magnus Ogre","authId":"","name":"Orange Magnus Ogre","CNNId":"","myGameChains":null,"banStatus":null},"id":19606128,"name":"Titan Solar Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Orange/Magnus/Ogre/19606128.jpg","createDate":{"time":1361896079000,"minutes":27,"seconds":59,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Orange/Magnus/Ogre/19606128.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":274,"difficulty":1.425,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1770,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.498214,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Ivy Diamond","authId":"","name":"Agile Ivy Diamond","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Ivy Diamond","authId":"","name":"Agile Ivy Diamond","CNNId":"","myGameChains":null,"banStatus":null},"id":18351742,"name":"Alien Omniverse Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Agile/Ivy/Diamond/18351742.jpg","createDate":{"time":1351880945000,"minutes":29,"seconds":5,"hours":14,"month":10,"timezoneOffset":240,"year":112,"day":5,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Agile/Ivy/Diamond/18351742.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17004,"difficulty":2.2318480655278403,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":23900,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.48124,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Wesley Buffalo","authId":"","name":"Suave Wesley Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Wesley Buffalo","authId":"","name":"Suave Wesley Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":18930510,"name":"Chase Rocket Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Suave/Wesley/Buffalo/18930510.jpg","createDate":{"time":1355228944000,"minutes":29,"seconds":4,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Suave/Wesley/Buffalo/18930510.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1632,"difficulty":2.004749503968254,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3900,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.470202,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prince Charles Zinger","authId":"","name":"Prince Charles Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prince Charles Zinger","authId":"","name":"Prince Charles Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":18127773,"name":"Atomic Blaster Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prince/Charles/Zinger/18127773.jpg","createDate":{"time":1350158685000,"minutes":4,"seconds":45,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prince/Charles/Zinger/18127773.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":362,"difficulty":1.2627314814814814,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6298,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.448218,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Mya Seagull","authId":"","name":"Luminous Mya Seagull","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Mya Seagull","authId":"","name":"Luminous Mya Seagull","CNNId":"","myGameChains":null,"banStatus":null},"id":18491457,"name":"Pulse Atomic Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Luminous/Mya/Seagull/18491457.jpg","createDate":{"time":1353077266000,"minutes":47,"seconds":46,"hours":9,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Luminous/Mya/Seagull/18491457.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":75727,"difficulty":2.320749278302291,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":108229,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.44658,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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 = '3' 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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]