[{"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 = '12' 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":"Digital Donald Balloon","authId":"","name":"Digital Donald Balloon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Donald Balloon","authId":"","name":"Digital Donald Balloon","CNNId":"","myGameChains":null,"banStatus":null},"id":17810959,"name":"Plumber Siege Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Donald/Balloon/17810959.jpg","createDate":{"time":1348810847000,"minutes":40,"seconds":47,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Donald/Balloon/17810959.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5847,"difficulty":1.6477313530212003,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24201,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.836338,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Olivia Gazelle","authId":"","name":"Curious Olivia Gazelle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Olivia Gazelle","authId":"","name":"Curious Olivia Gazelle","CNNId":"","myGameChains":null,"banStatus":null},"id":19500596,"name":"Ultimate Adventure Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Olivia/Gazelle/19500596.jpg","createDate":{"time":1360166783000,"minutes":6,"seconds":23,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Olivia/Gazelle/19500596.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2843,"difficulty":2.21059206996707,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3099,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.832787,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Tony Javelin","authId":"","name":"Immortal Tony Javelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Immortal Tony Javelin","authId":"","name":"Immortal Tony Javelin","CNNId":"","myGameChains":null,"banStatus":null},"id":18078335,"name":"Solar Animo Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Immortal/Tony/Javelin/18078335.jpg","createDate":{"time":1349895880000,"minutes":4,"seconds":40,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Immortal/Tony/Javelin/18078335.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":138,"difficulty":2.7199999999999998,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2686,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.819048,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peculiar Jimmy Gator","authId":"","name":"Peculiar Jimmy Gator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peculiar Jimmy Gator","authId":"","name":"Peculiar Jimmy Gator","CNNId":"","myGameChains":null,"banStatus":null},"id":18429371,"name":"Quake Ultimate Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peculiar/Jimmy/Gator/18429371.jpg","createDate":{"time":1352506528000,"minutes":15,"seconds":28,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peculiar/Jimmy/Gator/18429371.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6096,"difficulty":2.1310382475541814,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10208,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.806225,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King David Spiral","authId":"","name":"King David Spiral","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King David Spiral","authId":"","name":"King David Spiral","CNNId":"","myGameChains":null,"banStatus":null},"id":19532768,"name":"Adventure Ambush Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/David/Spiral/19532768.jpg","createDate":{"time":1360708037000,"minutes":27,"seconds":17,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/David/Spiral/19532768.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2594,"difficulty":2.1806193806193805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4639,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.797578,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Lucius Pulsar","authId":"","name":"Glorious Lucius Pulsar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Lucius Pulsar","authId":"","name":"Glorious Lucius Pulsar","CNNId":"","myGameChains":null,"banStatus":null},"id":17582282,"name":"Fusion Galaxy Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Glorious/Lucius/Pulsar/17582282.jpg","createDate":{"time":1348248417000,"minutes":26,"seconds":57,"hours":13,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Glorious/Lucius/Pulsar/17582282.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":494,"difficulty":2.3664175705416115,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6285,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.797574,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Gladys Nanobot","authId":"","name":"Frugal Gladys Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frugal Gladys Nanobot","authId":"","name":"Frugal Gladys Nanobot","CNNId":"","myGameChains":null,"banStatus":null},"id":18409212,"name":"Beast Fury Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frugal/Gladys/Nanobot/18409212.jpg","createDate":{"time":1352281683000,"minutes":48,"seconds":3,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frugal/Gladys/Nanobot/18409212.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1600,"difficulty":2.358531746031746,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4787,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.790123,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Romeo Ape","authId":"","name":"Ironic Romeo Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironic Romeo Ape","authId":"","name":"Ironic Romeo Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":19402716,"name":"Force Storm Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironic/Romeo/Ape/19402716.jpg","createDate":{"time":1358547375000,"minutes":16,"seconds":15,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironic/Romeo/Ape/19402716.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1982,"difficulty":2.2950047348484848,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7999,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.770211,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Kaitlyn Rhyme","authId":"","name":"Normal Kaitlyn Rhyme","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Normal Kaitlyn Rhyme","authId":"","name":"Normal Kaitlyn Rhyme","CNNId":"","myGameChains":null,"banStatus":null},"id":17793381,"name":"Charge Hero Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Normal/Kaitlyn/Rhyme/17793381.jpg","createDate":{"time":1348719629000,"minutes":20,"seconds":29,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Normal/Kaitlyn/Rhyme/17793381.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":127,"difficulty":2.836743996743997,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.73998,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Billy Gator","authId":"","name":"Crazy Billy Gator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Billy Gator","authId":"","name":"Crazy Billy Gator","CNNId":"","myGameChains":null,"banStatus":null},"id":17756338,"name":"Adventure Rustbucket Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Billy/Gator/17756338.jpg","createDate":{"time":1348550451000,"minutes":20,"seconds":51,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Billy/Gator/17756338.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":191,"difficulty":1.6875,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5336,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.718367,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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 = '12' 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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]