[{"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 = '14' 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":"Captain Samuel Scorpion","authId":"","name":"Captain Samuel Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Samuel Scorpion","authId":"","name":"Captain Samuel Scorpion","CNNId":"","myGameChains":null,"banStatus":null},"id":19264837,"name":"Razor Battle Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Samuel/Scorpion/19264837.jpg","createDate":{"time":1356955359000,"minutes":2,"seconds":39,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Samuel/Scorpion/19264837.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7648,"difficulty":1.5572368428286891,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11861,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.038259,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stubborn James Otter","authId":"","name":"Stubborn James Otter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stubborn James Otter","authId":"","name":"Stubborn James Otter","CNNId":"","myGameChains":null,"banStatus":null},"id":19120318,"name":"Ultra Hex Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stubborn/James/Otter/19120318.jpg","createDate":{"time":1356154036000,"minutes":27,"seconds":16,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stubborn/James/Otter/19120318.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23440,"difficulty":1.5130017035074483,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":275045,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.982787,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Ilana Fuzz","authId":"","name":"Massive Ilana Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Ilana Fuzz","authId":"","name":"Massive Ilana Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"id":19471985,"name":"Earth Nova Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Massive/Ilana/Fuzz/19471985.jpg","createDate":{"time":1359631316000,"minutes":21,"seconds":56,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Massive/Ilana/Fuzz/19471985.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4062,"difficulty":1.5030841327214177,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47778,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.883838,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Dave Jungle","authId":"","name":"Electric Dave Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Dave Jungle","authId":"","name":"Electric Dave Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":18930539,"name":"Shadow Laser Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Dave/Jungle/18930539.jpg","createDate":{"time":1355229080000,"minutes":31,"seconds":20,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Dave/Jungle/18930539.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1941,"difficulty":2.2909898006983713,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26069,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.862058,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Vivian Mustard","authId":"","name":"Amusing Vivian Mustard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Amusing Vivian Mustard","authId":"","name":"Amusing Vivian Mustard","CNNId":"","myGameChains":null,"banStatus":null},"id":18995548,"name":"Smash Rock Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Amusing/Vivian/Mustard/18995548.jpg","createDate":{"time":1355561971000,"minutes":59,"seconds":31,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Amusing/Vivian/Mustard/18995548.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3923,"difficulty":1.7695865682808016,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19536,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.811019,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Gianna Mutant","authId":"","name":"Duke Gianna Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Duke Gianna Mutant","authId":"","name":"Duke Gianna Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":19523883,"name":"Chill Lightning Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Duke/Gianna/Mutant/19523883.jpg","createDate":{"time":1360525802000,"minutes":50,"seconds":2,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Duke/Gianna/Mutant/19523883.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3254,"difficulty":1.8296804360427064,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51308,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.808134,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Oliver Calamari","authId":"","name":"Sergeant Oliver Calamari","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Oliver Calamari","authId":"","name":"Sergeant Oliver Calamari","CNNId":"","myGameChains":null,"banStatus":null},"id":19588423,"name":"Mega Laser Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sergeant/Oliver/Calamari/19588423.jpg","createDate":{"time":1361603622000,"minutes":13,"seconds":42,"hours":2,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sergeant/Oliver/Calamari/19588423.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12250,"difficulty":1.1414412989830622,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14492,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.800738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Austin Fritter","authId":"","name":"Wild Austin Fritter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wild Austin Fritter","authId":"","name":"Wild Austin Fritter","CNNId":"","myGameChains":null,"banStatus":null},"id":19938586,"name":"Attack Drone Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wild/Austin/Fritter/19938586.jpg","createDate":{"time":1364459993000,"minutes":39,"seconds":53,"hours":4,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wild/Austin/Fritter/19938586.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24571,"difficulty":2.3595056391809934,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":100779,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.733662,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Spike Snowball","authId":"","name":"Shiny Spike Snowball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Spike Snowball","authId":"","name":"Shiny Spike Snowball","CNNId":"","myGameChains":null,"banStatus":null},"id":19123690,"name":"Blaster Magno Solar","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Spike/Snowball/19123690.jpg","createDate":{"time":1356185738000,"minutes":15,"seconds":38,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Spike/Snowball/19123690.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14491,"difficulty":2.0341221164065213,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":71637,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.708732,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Cassidy Creature","authId":"","name":"Gigantic Cassidy Creature","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Cassidy Creature","authId":"","name":"Gigantic Cassidy Creature","CNNId":"","myGameChains":null,"banStatus":null},"id":18556115,"name":"Razor Bloxx Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Cassidy/Creature/18556115.jpg","createDate":{"time":1353617669000,"minutes":54,"seconds":29,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Cassidy/Creature/18556115.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":86174,"difficulty":1.285845892042825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":179584,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.606513,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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 = '14' 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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]