[{"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 = '10' 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":"Obvious Alan Jingles","authId":"","name":"Obvious Alan Jingles","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Obvious Alan Jingles","authId":"","name":"Obvious Alan Jingles","CNNId":"","myGameChains":null,"banStatus":null},"id":18482029,"name":"Danger Star Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Obvious/Alan/Jingles/18482029.jpg","createDate":{"time":1352932809000,"minutes":40,"seconds":9,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Obvious/Alan/Jingles/18482029.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22296,"difficulty":1.7436390548322869,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78983,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.198436,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Squishy Juno Squeegee","authId":"","name":"Squishy Juno Squeegee","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Squishy Juno Squeegee","authId":"","name":"Squishy Juno Squeegee","CNNId":"","myGameChains":null,"banStatus":null},"id":19489425,"name":"Solar Adventure Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Squishy/Juno/Squeegee/19489425.jpg","createDate":{"time":1359918685000,"minutes":11,"seconds":25,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Squishy/Juno/Squeegee/19489425.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":191,"difficulty":2.4074074074074074,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4324,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.16,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Bella Jalapeno","authId":"","name":"Stinky Bella Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Bella Jalapeno","authId":"","name":"Stinky Bella Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"id":19500592,"name":"Big Chill Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stinky/Bella/Jalapeno/19500592.jpg","createDate":{"time":1360166672000,"minutes":4,"seconds":32,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stinky/Bella/Jalapeno/19500592.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":993,"difficulty":2.811357812644362,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5117,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.094129,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Kara Cumulus","authId":"","name":"Smooth Kara Cumulus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Kara Cumulus","authId":"","name":"Smooth Kara Cumulus","CNNId":"","myGameChains":null,"banStatus":null},"id":19536422,"name":"Plasma Target Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smooth/Kara/Cumulus/19536422.jpg","createDate":{"time":1360783157000,"minutes":19,"seconds":17,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smooth/Kara/Cumulus/19536422.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17215,"difficulty":1.6333981355018,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":29358,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.093694,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Baron Ingrid Steam","authId":"","name":"Baron Ingrid Steam","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Baron Ingrid Steam","authId":"","name":"Baron Ingrid Steam","CNNId":"","myGameChains":null,"banStatus":null},"id":17622937,"name":"Stone Ultra Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Baron/Ingrid/Steam/17622937.jpg","createDate":{"time":1348316029000,"minutes":13,"seconds":49,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Baron/Ingrid/Steam/17622937.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3014,"difficulty":1.8399199137916467,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6906,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.026318,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Garrett Tiger","authId":"","name":"Fiery Garrett Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Garrett Tiger","authId":"","name":"Fiery Garrett Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":18488389,"name":"Light Robot Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Garrett/Tiger/18488389.jpg","createDate":{"time":1353023736000,"minutes":55,"seconds":36,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Garrett/Tiger/18488389.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2733,"difficulty":2.3823039215686275,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4952,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":1.94426,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Forrest Warrior","authId":"","name":"Ancient Forrest Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Forrest Warrior","authId":"","name":"Ancient Forrest Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":17793444,"name":"Dark Razor Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Forrest/Warrior/17793444.jpg","createDate":{"time":1348720672000,"minutes":37,"seconds":52,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Forrest/Warrior/17793444.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1989,"difficulty":2.655960111317254,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3854,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.881307,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Slimy Samuel Ghost","authId":"","name":"Slimy Samuel Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Slimy Samuel Ghost","authId":"","name":"Slimy Samuel Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":18206507,"name":"Magno Laser Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Slimy/Samuel/Ghost/18206507.jpg","createDate":{"time":1350717028000,"minutes":10,"seconds":28,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Slimy/Samuel/Ghost/18206507.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25420,"difficulty":1.5573049000987378,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":35844,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.870663,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unusual Madelyn Polka","authId":"","name":"Unusual Madelyn Polka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unusual Madelyn Polka","authId":"","name":"Unusual Madelyn Polka","CNNId":"","myGameChains":null,"banStatus":null},"id":19626927,"name":"Metal Adventure Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unusual/Madelyn/Polka/19626927.jpg","createDate":{"time":1362323224000,"minutes":7,"seconds":4,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unusual/Madelyn/Polka/19626927.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14172,"difficulty":1.2107587047474542,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36272,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.668718,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Scooby Blizzard","authId":"","name":"Colonel Scooby Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Scooby Blizzard","authId":"","name":"Colonel Scooby Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":18249248,"name":"Whirlwind Cosmic Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Scooby/Blizzard/18249248.jpg","createDate":{"time":1351025386000,"minutes":49,"seconds":46,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Scooby/Blizzard/18249248.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":95736,"difficulty":1.1775667805485577,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":104608,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":1.527679,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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 = '10' 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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]