[{"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 = '14' 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":"Extreme Rich Tuxedo","authId":"","name":"Extreme Rich Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Rich Tuxedo","authId":"","name":"Extreme Rich Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"id":18707556,"name":"Burst Mega Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Rich/Tuxedo/18707556.jpg","createDate":{"time":1354658390000,"minutes":59,"seconds":50,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Rich/Tuxedo/18707556.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6764,"difficulty":2.3763902396297407,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15649,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.555579,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Cory Dinosaur","authId":"","name":"Super Cory Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Cory Dinosaur","authId":"","name":"Super Cory Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":18521135,"name":"Smash Chill Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Cory/Dinosaur/18521135.jpg","createDate":{"time":1353354725000,"minutes":52,"seconds":5,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Cory/Dinosaur/18521135.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3028,"difficulty":2.1302189007789907,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10477,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.553246,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic CJ Bongo","authId":"","name":"Majestic CJ Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic CJ Bongo","authId":"","name":"Majestic CJ Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":18521384,"name":"Attack Bloxx Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/CJ/Bongo/18521384.jpg","createDate":{"time":1353356762000,"minutes":26,"seconds":2,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/CJ/Bongo/18521384.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1103,"difficulty":2.284221148335981,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12106,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.541283,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Molly Sparkle","authId":"","name":"Cartoony Molly Sparkle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cartoony Molly Sparkle","authId":"","name":"Cartoony Molly Sparkle","CNNId":"","myGameChains":null,"banStatus":null},"id":19489439,"name":"Doom Dark Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cartoony/Molly/Sparkle/19489439.jpg","createDate":{"time":1359918850000,"minutes":14,"seconds":10,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cartoony/Molly/Sparkle/19489439.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1494,"difficulty":1.6592270166303533,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26595,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.539035,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Marcia Tiptoe","authId":"","name":"Cackling Marcia Tiptoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Marcia Tiptoe","authId":"","name":"Cackling Marcia Tiptoe","CNNId":"","myGameChains":null,"banStatus":null},"id":19465350,"name":"Thunder Clash Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Marcia/Tiptoe/19465350.jpg","createDate":{"time":1359468604000,"minutes":10,"seconds":4,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Marcia/Tiptoe/19465350.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3490,"difficulty":2.8295064634847824,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74873,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.535825,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Collin Dolphin","authId":"","name":"Curious Collin Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Collin Dolphin","authId":"","name":"Curious Collin Dolphin","CNNId":"","myGameChains":null,"banStatus":null},"id":19446277,"name":"Omniverse Space Robot","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Collin/Dolphin/19446277.jpg","createDate":{"time":1359190228000,"minutes":50,"seconds":28,"hours":3,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Collin/Dolphin/19446277.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1018,"difficulty":1.7592472342472343,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10404,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.53287,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Dexter Amethyst","authId":"","name":"Fizzy Dexter Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fizzy Dexter Amethyst","authId":"","name":"Fizzy Dexter Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"id":18870601,"name":"Warrior Adventure Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fizzy/Dexter/Amethyst/18870601.jpg","createDate":{"time":1355061974000,"minutes":6,"seconds":14,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fizzy/Dexter/Amethyst/18870601.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":55199,"difficulty":2.402946318852181,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":216235,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.529488,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Blake Rhino","authId":"","name":"Hyper Blake Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Blake Rhino","authId":"","name":"Hyper Blake Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":18520745,"name":"Bloxx Iron Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hyper/Blake/Rhino/18520745.jpg","createDate":{"time":1353349938000,"minutes":32,"seconds":18,"hours":13,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hyper/Blake/Rhino/18520745.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":115,"difficulty":2.7024228953288016,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18326,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.527691,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Maggie Spider","authId":"","name":"Ultimate Maggie Spider","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Maggie Spider","authId":"","name":"Ultimate Maggie Spider","CNNId":"","myGameChains":null,"banStatus":null},"id":18521580,"name":"Challenge Rampage Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Maggie/Spider/18521580.jpg","createDate":{"time":1353358598000,"minutes":56,"seconds":38,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Maggie/Spider/18521580.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3014,"difficulty":2.7006139380076575,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":60162,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.526184,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Kylie Vulture","authId":"","name":"Mumbling Kylie Vulture","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Kylie Vulture","authId":"","name":"Mumbling Kylie Vulture","CNNId":"","myGameChains":null,"banStatus":null},"id":18749924,"name":"Atomic Universe Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mumbling/Kylie/Vulture/18749924.jpg","createDate":{"time":1354799746000,"minutes":15,"seconds":46,"hours":8,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mumbling/Kylie/Vulture/18749924.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":617,"difficulty":2.959417190950267,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26021,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.521869,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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 = '14' 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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]