[{"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":"Crazy Jasper Vortex","authId":"","name":"Crazy Jasper Vortex","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crazy Jasper Vortex","authId":"","name":"Crazy Jasper Vortex","CNNId":"","myGameChains":null,"banStatus":null},"id":18532334,"name":"Hero Alien Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crazy/Jasper/Vortex/18532334.jpg","createDate":{"time":1353459302000,"minutes":55,"seconds":2,"hours":19,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crazy/Jasper/Vortex/18532334.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11175,"difficulty":1.8111357666005876,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37841,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.26908,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Thor Oink","authId":"","name":"Awesome Thor Oink","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Thor Oink","authId":"","name":"Awesome Thor Oink","CNNId":"","myGameChains":null,"banStatus":null},"id":19572751,"name":"Steel Power Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Thor/Oink/19572751.jpg","createDate":{"time":1361318696000,"minutes":4,"seconds":56,"hours":19,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Thor/Oink/19572751.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17622,"difficulty":2.249688796228325,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24835,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.104823,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Harry Basilisk","authId":"","name":"Blue Harry Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blue Harry Basilisk","authId":"","name":"Blue Harry Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":18069825,"name":"Mega Atomic Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blue/Harry/Basilisk/18069825.jpg","createDate":{"time":1349822468000,"minutes":41,"seconds":8,"hours":18,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blue/Harry/Basilisk/18069825.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":50859,"difficulty":1.2684811206559978,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74456,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.013402,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ray Universe","authId":"","name":"Soggy Ray Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Soggy Ray Universe","authId":"","name":"Soggy Ray Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":18260512,"name":"Nitro Turbo Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Soggy/Ray/Universe/18260512.jpg","createDate":{"time":1351157310000,"minutes":28,"seconds":30,"hours":5,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Soggy/Ray/Universe/18260512.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5581,"difficulty":1.7247003743880345,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6375,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.973961,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Kate Comet","authId":"","name":"Haunted Kate Comet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Kate Comet","authId":"","name":"Haunted Kate Comet","CNNId":"","myGameChains":null,"banStatus":null},"id":19264736,"name":"Sonic Stone Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Haunted/Kate/Comet/19264736.jpg","createDate":{"time":1356954021000,"minutes":40,"seconds":21,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Haunted/Kate/Comet/19264736.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":636,"difficulty":1.4321809143237714,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3930,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.969712,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Melodic Kaitlin Sawtooth","authId":"","name":"Melodic Kaitlin Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Melodic Kaitlin Sawtooth","authId":"","name":"Melodic Kaitlin Sawtooth","CNNId":"","myGameChains":null,"banStatus":null},"id":18170176,"name":"Cannonbolt Big Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Melodic/Kaitlin/Sawtooth/18170176.jpg","createDate":{"time":1350361431000,"minutes":23,"seconds":51,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Melodic/Kaitlin/Sawtooth/18170176.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":90,"difficulty":2.611111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.96,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fragrant Rocky Flamingo","authId":"","name":"Fragrant Rocky Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fragrant Rocky Flamingo","authId":"","name":"Fragrant Rocky Flamingo","CNNId":"","myGameChains":null,"banStatus":null},"id":18930520,"name":"Fury Fury Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fragrant/Rocky/Flamingo/18930520.jpg","createDate":{"time":1355228990000,"minutes":29,"seconds":50,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fragrant/Rocky/Flamingo/18930520.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9063,"difficulty":1.2097703247616733,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10214,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.941099,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Robby Kazoo","authId":"","name":"Sparkly Robby Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Robby Kazoo","authId":"","name":"Sparkly Robby Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19589182,"name":"Cannonbolt Blaster Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sparkly/Robby/Kazoo/19589182.jpg","createDate":{"time":1361624319000,"minutes":58,"seconds":39,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sparkly/Robby/Kazoo/19589182.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":787,"difficulty":2.304273504273504,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4776,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.872422,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Veronica Cobweb","authId":"","name":"Gigantic Veronica Cobweb","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Veronica Cobweb","authId":"","name":"Gigantic Veronica Cobweb","CNNId":"","myGameChains":null,"banStatus":null},"id":18783691,"name":"Warp Adventure Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Veronica/Cobweb/18783691.jpg","createDate":{"time":1354913294000,"minutes":48,"seconds":14,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Veronica/Cobweb/18783691.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28213,"difficulty":1.5090516779244658,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":34279,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.858722,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Rufus Calliope","authId":"","name":"Haunted Rufus Calliope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Haunted Rufus Calliope","authId":"","name":"Haunted Rufus Calliope","CNNId":"","myGameChains":null,"banStatus":null},"id":18345287,"name":"Doom Gear Nitro","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Haunted/Rufus/Calliope/18345287.jpg","createDate":{"time":1351807451000,"minutes":4,"seconds":11,"hours":18,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Haunted/Rufus/Calliope/18345287.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1675,"difficulty":2.197530864197531,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1999,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.85034,"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 = '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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]