[{"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 = '13' 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":"Silent Bubba Camel","authId":"","name":"Silent Bubba Camel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silent Bubba Camel","authId":"","name":"Silent Bubba Camel","CNNId":"","myGameChains":null,"banStatus":null},"id":19027961,"name":"Adventure Giga Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silent/Bubba/Camel/19027961.jpg","createDate":{"time":1355663395000,"minutes":9,"seconds":55,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silent/Bubba/Camel/19027961.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2597,"difficulty":1.8541263430333226,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11804,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.308633,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Gregory Platypus","authId":"","name":"Fabulous Gregory Platypus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Gregory Platypus","authId":"","name":"Fabulous Gregory Platypus","CNNId":"","myGameChains":null,"banStatus":null},"id":18520944,"name":"Steel Cosmic Hex","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Gregory/Platypus/18520944.jpg","createDate":{"time":1353352682000,"minutes":18,"seconds":2,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Gregory/Platypus/18520944.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3290,"difficulty":2.5414194614256345,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12099,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.239253,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shifty Dwayne Dragoon","authId":"","name":"Shifty Dwayne Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shifty Dwayne Dragoon","authId":"","name":"Shifty Dwayne Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":18749983,"name":"Power Ultra Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shifty/Dwayne/Dragoon/18749983.jpg","createDate":{"time":1354799932000,"minutes":18,"seconds":52,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shifty/Dwayne/Dragoon/18749983.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1542,"difficulty":2.6685997596532847,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":14100,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.21533,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bashful Hailey Beeswax","authId":"","name":"Bashful Hailey Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bashful Hailey Beeswax","authId":"","name":"Bashful Hailey Beeswax","CNNId":"","myGameChains":null,"banStatus":null},"id":19122368,"name":"Ultra Escape Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bashful/Hailey/Beeswax/19122368.jpg","createDate":{"time":1356178825000,"minutes":20,"seconds":25,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bashful/Hailey/Beeswax/19122368.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17809,"difficulty":1.5017928483961602,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45606,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.155439,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dazzling Angel Bamboo","authId":"","name":"Dazzling Angel Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dazzling Angel Bamboo","authId":"","name":"Dazzling Angel Bamboo","CNNId":"","myGameChains":null,"banStatus":null},"id":19620568,"name":"Shadow Fusion Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dazzling/Angel/Bamboo/19620568.jpg","createDate":{"time":1362239371000,"minutes":49,"seconds":31,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dazzling/Angel/Bamboo/19620568.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10586,"difficulty":2.191709010406785,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18536,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.132382,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Egbert Enigma","authId":"","name":"Elite Egbert Enigma","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Egbert Enigma","authId":"","name":"Elite Egbert Enigma","CNNId":"","myGameChains":null,"banStatus":null},"id":19025477,"name":"Charge Lightning Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Egbert/Enigma/19025477.jpg","createDate":{"time":1355639528000,"minutes":32,"seconds":8,"hours":1,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Egbert/Enigma/19025477.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20871,"difficulty":1.9578320239650004,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74935,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.092426,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Hugo Avator","authId":"","name":"Baroness Hugo Avator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baroness Hugo Avator","authId":"","name":"Baroness Hugo Avator","CNNId":"","myGameChains":null,"banStatus":null},"id":18963106,"name":"Storm Rock Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baroness/Hugo/Avator/18963106.jpg","createDate":{"time":1355409457000,"minutes":37,"seconds":37,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baroness/Hugo/Avator/18963106.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3346,"difficulty":1.5441877145902547,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15702,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.992715,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Lloyd Turbo","authId":"","name":"Captain Lloyd Turbo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Captain Lloyd Turbo","authId":"","name":"Captain Lloyd Turbo","CNNId":"","myGameChains":null,"banStatus":null},"id":18521582,"name":"Galaxy Battle Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Captain/Lloyd/Turbo/18521582.jpg","createDate":{"time":1353358602000,"minutes":56,"seconds":42,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Captain/Lloyd/Turbo/18521582.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17141,"difficulty":2.4886934934921965,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24682,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.968222,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Bryan Bolt","authId":"","name":"Loud Bryan Bolt","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loud Bryan Bolt","authId":"","name":"Loud Bryan Bolt","CNNId":"","myGameChains":null,"banStatus":null},"id":19589947,"name":"Alien Pursuit Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loud/Bryan/Bolt/19589947.jpg","createDate":{"time":1361632311000,"minutes":11,"seconds":51,"hours":10,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loud/Bryan/Bolt/19589947.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8384,"difficulty":2.172983313668111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15867,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.928416,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Keith Panda","authId":"","name":"Doctor Keith Panda","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Keith Panda","authId":"","name":"Doctor Keith Panda","CNNId":"","myGameChains":null,"banStatus":null},"id":19544595,"name":"Search Ultimate Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Keith/Panda/19544595.jpg","createDate":{"time":1360947762000,"minutes":2,"seconds":42,"hours":12,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Keith/Panda/19544595.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2536,"difficulty":1.9587159777475343,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47155,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.904511,"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 = '13' 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"}}]