[{"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 = '1' 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":"Sloppy Rufus Glitch","authId":"","name":"Sloppy Rufus Glitch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sloppy Rufus Glitch","authId":"","name":"Sloppy Rufus Glitch","CNNId":"","myGameChains":null,"banStatus":null},"id":18613779,"name":"Swampfire Turbo Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sloppy/Rufus/Glitch/18613779.jpg","createDate":{"time":1353966630000,"minutes":50,"seconds":30,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sloppy/Rufus/Glitch/18613779.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":49958,"difficulty":2.8049778670210825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":337648,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.870271,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Alan Giblets","authId":"","name":"Shy Alan Giblets","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Alan Giblets","authId":"","name":"Shy Alan Giblets","CNNId":"","myGameChains":null,"banStatus":null},"id":17736849,"name":"Atomic Spike Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Alan/Giblets/17736849.jpg","createDate":{"time":1348464013000,"minutes":20,"seconds":13,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Alan/Giblets/17736849.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":67375,"difficulty":2.4824441987455317,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":631526,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.861707,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Zelda Nucleus","authId":"","name":"Elite Zelda Nucleus","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Zelda Nucleus","authId":"","name":"Elite Zelda Nucleus","CNNId":"","myGameChains":null,"banStatus":null},"id":19559939,"name":"Alien Alien Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Zelda/Nucleus/19559939.jpg","createDate":{"time":1361132241000,"minutes":17,"seconds":21,"hours":15,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Zelda/Nucleus/19559939.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11801,"difficulty":2.495934203922735,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51929,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.81375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Heather Pelican","authId":"","name":"Shaggy Heather Pelican","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Heather Pelican","authId":"","name":"Shaggy Heather Pelican","CNNId":"","myGameChains":null,"banStatus":null},"id":19364347,"name":"Solar Swampfire Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Heather/Pelican/19364347.jpg","createDate":{"time":1357961918000,"minutes":38,"seconds":38,"hours":22,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Heather/Pelican/19364347.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8519,"difficulty":2.42220241232893,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":106642,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.793927,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Krystal Shock","authId":"","name":"King Krystal Shock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Krystal Shock","authId":"","name":"King Krystal Shock","CNNId":"","myGameChains":null,"banStatus":null},"id":19929696,"name":"Pulse Energy Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Krystal/Shock/19929696.jpg","createDate":{"time":1364396389000,"minutes":59,"seconds":49,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Krystal/Shock/19929696.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5105,"difficulty":2.7773209381381214,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":76885,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.789054,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Leon Nebula","authId":"","name":"Solar Leon Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Leon Nebula","authId":"","name":"Solar Leon Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":17813304,"name":"Blaster Fire Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solar/Leon/Nebula/17813304.jpg","createDate":{"time":1348832360000,"minutes":39,"seconds":20,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solar/Leon/Nebula/17813304.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":39721,"difficulty":2.72013089548523,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":173924,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.782224,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Hercules Sword","authId":"","name":"Abstract Hercules Sword","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Hercules Sword","authId":"","name":"Abstract Hercules Sword","CNNId":"","myGameChains":null,"banStatus":null},"id":19089079,"name":"Mission Chill Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abstract/Hercules/Sword/19089079.jpg","createDate":{"time":1355982744000,"minutes":52,"seconds":24,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abstract/Hercules/Sword/19089079.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10943,"difficulty":2.560175364783734,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":145265,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.776297,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Waldo Javelin","authId":"","name":"Leaping Waldo Javelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Waldo Javelin","authId":"","name":"Leaping Waldo Javelin","CNNId":"","myGameChains":null,"banStatus":null},"id":18003879,"name":"Storm Light Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Leaping/Waldo/Javelin/18003879.jpg","createDate":{"time":1349552385000,"minutes":39,"seconds":45,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Leaping/Waldo/Javelin/18003879.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":145,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1323,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.75,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bogus Jay Fury","authId":"","name":"Bogus Jay Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bogus Jay Fury","authId":"","name":"Bogus Jay Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":18479989,"name":"Racer Alien Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bogus/Jay/Fury/18479989.jpg","createDate":{"time":1352911304000,"minutes":41,"seconds":44,"hours":11,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bogus/Jay/Fury/18479989.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6581,"difficulty":2.2945934789452216,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":112017,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.749287,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Doc Aviator","authId":"","name":"Zany Doc Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Doc Aviator","authId":"","name":"Zany Doc Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":18707662,"name":"Ben Omniverse Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Doc/Aviator/18707662.jpg","createDate":{"time":1354658520000,"minutes":2,"seconds":0,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Doc/Aviator/18707662.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2987,"difficulty":2.4977797686453527,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26997,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.748275,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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 = '1' 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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]