[{"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":"Gorgeous Lester Pinball","authId":"","name":"Gorgeous Lester Pinball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Lester Pinball","authId":"","name":"Gorgeous Lester Pinball","CNNId":"","myGameChains":null,"banStatus":null},"id":19421414,"name":"Power Charge Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gorgeous/Lester/Pinball/19421414.jpg","createDate":{"time":1358775407000,"minutes":36,"seconds":47,"hours":8,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gorgeous/Lester/Pinball/19421414.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":355,"difficulty":2.92,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2533,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.48,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Beatrice Squish","authId":"","name":"Elite Beatrice Squish","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Beatrice Squish","authId":"","name":"Elite Beatrice Squish","CNNId":"","myGameChains":null,"banStatus":null},"id":19330833,"name":"Mega Galaxy Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Beatrice/Squish/19330833.jpg","createDate":{"time":1357462699000,"minutes":58,"seconds":19,"hours":3,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Beatrice/Squish/19330833.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8501,"difficulty":2.616402657433876,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37783,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.467501,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rugged Ace Larva","authId":"","name":"Rugged Ace Larva","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rugged Ace Larva","authId":"","name":"Rugged Ace Larva","CNNId":"","myGameChains":null,"banStatus":null},"id":19589180,"name":"Search Nitro Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rugged/Ace/Larva/19589180.jpg","createDate":{"time":1361624272000,"minutes":57,"seconds":52,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rugged/Ace/Larva/19589180.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1162,"difficulty":2.711111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2594,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.455467,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Jimbo Splat","authId":"","name":"Agile Jimbo Splat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Jimbo Splat","authId":"","name":"Agile Jimbo Splat","CNNId":"","myGameChains":null,"banStatus":null},"id":18131413,"name":"Mega Alien Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Agile/Jimbo/Splat/18131413.jpg","createDate":{"time":1350167219000,"minutes":26,"seconds":59,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Agile/Jimbo/Splat/18131413.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":43,"difficulty":2.8295603206317494,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1912,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.452339,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Caleb Sword","authId":"","name":"Strong Caleb Sword","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Caleb Sword","authId":"","name":"Strong Caleb Sword","CNNId":"","myGameChains":null,"banStatus":null},"id":17954193,"name":"Defense Light Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Caleb/Sword/17954193.jpg","createDate":{"time":1349349754000,"minutes":22,"seconds":34,"hours":7,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Caleb/Sword/17954193.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48,"difficulty":2.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1183,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.444444,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Nicolas","authId":"","name":"Vast Nicolas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Nicolas","authId":"","name":"Vast Nicolas","CNNId":"","myGameChains":null,"banStatus":null},"id":18427396,"name":"Robot Ben Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Nicolas/18427396.jpg","createDate":{"time":1352497670000,"minutes":47,"seconds":50,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Nicolas/18427396.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":78,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":487,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.44,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Dominic Earwig","authId":"","name":"Evil Dominic Earwig","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Dominic Earwig","authId":"","name":"Evil Dominic Earwig","CNNId":"","myGameChains":null,"banStatus":null},"id":18749836,"name":"Rush Adventure Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Dominic/Earwig/18749836.jpg","createDate":{"time":1354799286000,"minutes":8,"seconds":6,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Dominic/Earwig/18749836.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2607,"difficulty":1.7993706554445323,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7187,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.435954,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Aaliyah Anvil","authId":"","name":"Aromatic Aaliyah Anvil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Aaliyah Anvil","authId":"","name":"Aromatic Aaliyah Anvil","CNNId":"","myGameChains":null,"banStatus":null},"id":19128784,"name":"Cosmic Solar Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aromatic/Aaliyah/Anvil/19128784.jpg","createDate":{"time":1356197955000,"minutes":39,"seconds":15,"hours":12,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aromatic/Aaliyah/Anvil/19128784.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":453,"difficulty":2.2466927658013645,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10024,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.424589,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Snappy Reuben Rascal","authId":"","name":"Snappy Reuben Rascal","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Snappy Reuben Rascal","authId":"","name":"Snappy Reuben Rascal","CNNId":"","myGameChains":null,"banStatus":null},"id":19632149,"name":"Warrior Laser Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Snappy/Reuben/Rascal/19632149.jpg","createDate":{"time":1362410010000,"minutes":13,"seconds":30,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Snappy/Reuben/Rascal/19632149.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1788,"difficulty":2.4655280891494127,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3802,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.419495,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Jake Hawk","authId":"","name":"Brisk Jake Hawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Jake Hawk","authId":"","name":"Brisk Jake Hawk","CNNId":"","myGameChains":null,"banStatus":null},"id":19489429,"name":"Storm Nano Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Jake/Hawk/19489429.jpg","createDate":{"time":1359918774000,"minutes":12,"seconds":54,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Jake/Hawk/19489429.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":243,"difficulty":2.6434525753181872,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13091,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.414649,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"51","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":"60","currentPageToDisplay":6,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]