[{"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 = '11' 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":"Messy Franklin Elf","authId":"","name":"Messy Franklin Elf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Messy Franklin Elf","authId":"","name":"Messy Franklin Elf","CNNId":"","myGameChains":null,"banStatus":null},"id":18635940,"name":"Assault Hyper Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Messy/Franklin/Elf/18635940.jpg","createDate":{"time":1354239204000,"minutes":33,"seconds":24,"hours":20,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Messy/Franklin/Elf/18635940.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17740,"difficulty":2.224639495707511,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":88607,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.890964,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Ace","authId":"","name":"Aquatic Ace","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Ace","authId":"","name":"Aquatic Ace","CNNId":"","myGameChains":null,"banStatus":null},"id":17552669,"name":"Chill Pursuit Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aquatic/Ace/17552669.jpg","createDate":{"time":1348175278000,"minutes":7,"seconds":58,"hours":17,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aquatic/Ace/17552669.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20251,"difficulty":1.4615650504359048,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34142,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.87536,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baffling Hugo Buffalo","authId":"","name":"Baffling Hugo Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baffling Hugo Buffalo","authId":"","name":"Baffling Hugo Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":17756432,"name":"Atomic Feedback Feedback","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baffling/Hugo/Buffalo/17756432.jpg","createDate":{"time":1348551999000,"minutes":46,"seconds":39,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baffling/Hugo/Buffalo/17756432.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12059,"difficulty":1.6154022483688004,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32243,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.846243,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Major Roscoe Tornado","authId":"","name":"Major Roscoe Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Major Roscoe Tornado","authId":"","name":"Major Roscoe Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19530778,"name":"Spike Nova Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Major/Roscoe/Tornado/19530778.jpg","createDate":{"time":1360673686000,"minutes":54,"seconds":46,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Major/Roscoe/Tornado/19530778.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8917,"difficulty":1.8424306705540814,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":42525,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.826476,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Wesley Klunk","authId":"","name":"Musical Wesley Klunk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Wesley Klunk","authId":"","name":"Musical Wesley Klunk","CNNId":"","myGameChains":null,"banStatus":null},"id":18418217,"name":"Force Chill Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Musical/Wesley/Klunk/18418217.jpg","createDate":{"time":1352404705000,"minutes":58,"seconds":25,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Musical/Wesley/Klunk/18418217.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22474,"difficulty":1.3366737311573078,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":229601,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.814446,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Adrian Cartoon","authId":"","name":"Unknown Adrian Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unknown Adrian Cartoon","authId":"","name":"Unknown Adrian Cartoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19330650,"name":"Siege Rock Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unknown/Adrian/Cartoon/19330650.jpg","createDate":{"time":1357458733000,"minutes":52,"seconds":13,"hours":2,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unknown/Adrian/Cartoon/19330650.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6464,"difficulty":2.474755032680056,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61210,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.814238,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active George Behemoth","authId":"","name":"Active George Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active George Behemoth","authId":"","name":"Active George Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":18260514,"name":"Giga Laser Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/George/Behemoth/18260514.jpg","createDate":{"time":1351157385000,"minutes":29,"seconds":45,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/George/Behemoth/18260514.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6013,"difficulty":1.229625707367825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27265,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.785812,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Mac Vermin","authId":"","name":"Vigilant Mac Vermin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Mac Vermin","authId":"","name":"Vigilant Mac Vermin","CNNId":"","myGameChains":null,"banStatus":null},"id":19605638,"name":"Rumble Light Water","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Mac/Vermin/19605638.jpg","createDate":{"time":1361881632000,"minutes":27,"seconds":12,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Mac/Vermin/19605638.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6365,"difficulty":1.6800164949799448,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":27318,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.773718,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Buster Pizza","authId":"","name":"Nimble Buster Pizza","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nimble Buster Pizza","authId":"","name":"Nimble Buster Pizza","CNNId":"","myGameChains":null,"banStatus":null},"id":19361951,"name":"Echo Metal Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nimble/Buster/Pizza/19361951.jpg","createDate":{"time":1357940261000,"minutes":37,"seconds":41,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nimble/Buster/Pizza/19361951.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7110,"difficulty":1.6652287213234245,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61906,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.731283,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Ava Magician","authId":"","name":"Elite Ava Magician","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Ava Magician","authId":"","name":"Elite Ava Magician","CNNId":"","myGameChains":null,"banStatus":null},"id":18247545,"name":"Pulse Force Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Ava/Magician/18247545.jpg","createDate":{"time":1351007453000,"minutes":50,"seconds":53,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Ava/Magician/18247545.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3743,"difficulty":2.0136271125381233,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19658,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.730204,"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 = '11' 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"}}]