[{"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 = '8' 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":"Count Omar Hologram","authId":"","name":"Count Omar Hologram","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Omar Hologram","authId":"","name":"Count Omar Hologram","CNNId":"","myGameChains":null,"banStatus":null},"id":19660958,"name":"Techno Charge Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Count/Omar/Hologram/19660958.jpg","createDate":{"time":1363007211000,"minutes":6,"seconds":51,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Count/Omar/Hologram/19660958.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":230,"difficulty":2.6834656084656086,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1752,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.629509,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Adrian Twilight","authId":"","name":"Honest Adrian Twilight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Adrian Twilight","authId":"","name":"Honest Adrian Twilight","CNNId":"","myGameChains":null,"banStatus":null},"id":19053521,"name":"Champion Battle Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Honest/Adrian/Twilight/19053521.jpg","createDate":{"time":1355746731000,"minutes":18,"seconds":51,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Honest/Adrian/Twilight/19053521.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9466,"difficulty":1.776408963568896,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":11740,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.628518,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Rex Windmill","authId":"","name":"Cackling Rex Windmill","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Rex Windmill","authId":"","name":"Cackling Rex Windmill","CNNId":"","myGameChains":null,"banStatus":null},"id":18783631,"name":"Challenge Sonic Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Rex/Windmill/18783631.jpg","createDate":{"time":1354913174000,"minutes":46,"seconds":14,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Rex/Windmill/18783631.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1713,"difficulty":2.3605920005920003,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3359,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.627503,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Alfonso Turbo","authId":"","name":"Vast Alfonso Turbo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Alfonso Turbo","authId":"","name":"Vast Alfonso Turbo","CNNId":"","myGameChains":null,"banStatus":null},"id":18170562,"name":"Hero Adventure Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Alfonso/Turbo/18170562.jpg","createDate":{"time":1350376961000,"minutes":42,"seconds":41,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Alfonso/Turbo/18170562.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":61,"difficulty":2.729910714285714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2858,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.619643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elastic Austin Rocket","authId":"","name":"Elastic Austin Rocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elastic Austin Rocket","authId":"","name":"Elastic Austin Rocket","CNNId":"","myGameChains":null,"banStatus":null},"id":18641187,"name":"Iron Ben Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elastic/Austin/Rocket/18641187.jpg","createDate":{"time":1354309607000,"minutes":6,"seconds":47,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elastic/Austin/Rocket/18641187.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":275,"difficulty":1.875,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3024,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.619048,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Ben Yoyo","authId":"","name":"Bumbling Ben Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Ben Yoyo","authId":"","name":"Bumbling Ben Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":19760170,"name":"Nova Nitro Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bumbling/Ben/Yoyo/19760170.jpg","createDate":{"time":1363435197000,"minutes":59,"seconds":57,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bumbling/Ben/Yoyo/19760170.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15553,"difficulty":2.528103370563701,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19142,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.61735,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Chip Renegade","authId":"","name":"Radical Chip Renegade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Chip Renegade","authId":"","name":"Radical Chip Renegade","CNNId":"","myGameChains":null,"banStatus":null},"id":18076406,"name":"Metal Plasma Cannonbolt","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radical/Chip/Renegade/18076406.jpg","createDate":{"time":1349882064000,"minutes":14,"seconds":24,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radical/Chip/Renegade/18076406.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5015,"difficulty":2.8098063013969092,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":86609,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.60846,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Vince Tugboat","authId":"","name":"Reckless Vince Tugboat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Vince Tugboat","authId":"","name":"Reckless Vince Tugboat","CNNId":"","myGameChains":null,"banStatus":null},"id":18783669,"name":"Droid Robot Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Vince/Tugboat/18783669.jpg","createDate":{"time":1354913257000,"minutes":47,"seconds":37,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Vince/Tugboat/18783669.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1457,"difficulty":1.7722222222222221,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2360,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.603175,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Angelina Baboon","authId":"","name":"Blustery Angelina Baboon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Angelina Baboon","authId":"","name":"Blustery Angelina Baboon","CNNId":"","myGameChains":null,"banStatus":null},"id":17622902,"name":"Solar Target Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blustery/Angelina/Baboon/17622902.jpg","createDate":{"time":1348315980000,"minutes":13,"seconds":0,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blustery/Angelina/Baboon/17622902.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2704,"difficulty":1.4865997929374708,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5539,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.597376,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Brittney Cipher","authId":"","name":"King Brittney Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Brittney Cipher","authId":"","name":"King Brittney Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":18280936,"name":"Champion Space Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Brittney/Cipher/18280936.jpg","createDate":{"time":1351320914000,"minutes":55,"seconds":14,"hours":2,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Brittney/Cipher/18280936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36402,"difficulty":2.4983622327320805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72218,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.597259,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"31","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 = '8' 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":"40","currentPageToDisplay":4,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]