[{"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 = '9' 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":"Ultimate Leonardo Frost","authId":"","name":"Ultimate Leonardo Frost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Leonardo Frost","authId":"","name":"Ultimate Leonardo Frost","CNNId":"","myGameChains":null,"banStatus":null},"id":19520608,"name":"Echo Echo Smash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Leonardo/Frost/19520608.jpg","createDate":{"time":1360495495000,"minutes":24,"seconds":55,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Leonardo/Frost/19520608.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":80,"difficulty":1.4166666666666667,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":907,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.125,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Brent Gulch","authId":"","name":"Bumbling Brent Gulch","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bumbling Brent Gulch","authId":"","name":"Bumbling Brent Gulch","CNNId":"","myGameChains":null,"banStatus":null},"id":17530623,"name":"Universe Mission Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bumbling/Brent/Gulch/17530623.jpg","createDate":{"time":1348100941000,"minutes":29,"seconds":1,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bumbling/Brent/Gulch/17530623.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":890,"difficulty":2.5362484022179603,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16619,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.122044,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Ben Robot","authId":"","name":"Active Ben Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Ben Robot","authId":"","name":"Active Ben Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":17216512,"name":"Energy Plumber Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Ben/Robot/17216512.jpg","createDate":{"time":1342183159000,"minutes":39,"seconds":19,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Ben/Robot/17216512.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2082,"difficulty":2.3095117845117845,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2359,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.12,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rational Madison Virtuoso","authId":"","name":"Rational Madison Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rational Madison Virtuoso","authId":"","name":"Rational Madison Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"id":18427461,"name":"Battle Beast Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rational/Madison/Virtuoso/18427461.jpg","createDate":{"time":1352498020000,"minutes":53,"seconds":40,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rational/Madison/Virtuoso/18427461.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3201,"difficulty":2.2006547846524915,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":12981,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.113737,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Aidan Giraffe","authId":"","name":"Bold Aidan Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Aidan Giraffe","authId":"","name":"Bold Aidan Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"id":19517403,"name":"Iron Cosmic Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Aidan/Giraffe/19517403.jpg","createDate":{"time":1360448588000,"minutes":23,"seconds":8,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Aidan/Giraffe/19517403.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":859,"difficulty":2.4608962466105324,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10418,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.113685,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Brooklyn Diamond","authId":"","name":"Genuine Brooklyn Diamond","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Brooklyn Diamond","authId":"","name":"Genuine Brooklyn Diamond","CNNId":"","myGameChains":null,"banStatus":null},"id":17582240,"name":"Magno Adventure Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Genuine/Brooklyn/Diamond/17582240.jpg","createDate":{"time":1348248296000,"minutes":24,"seconds":56,"hours":13,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Genuine/Brooklyn/Diamond/17582240.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":55,"difficulty":2.66,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1960,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Nathan Penguin","authId":"","name":"Artful Nathan Penguin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Nathan Penguin","authId":"","name":"Artful Nathan Penguin","CNNId":"","myGameChains":null,"banStatus":null},"id":18707441,"name":"Echo Echo Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artful/Nathan/Penguin/18707441.jpg","createDate":{"time":1354658159000,"minutes":55,"seconds":59,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artful/Nathan/Penguin/18707441.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":177,"difficulty":1.4444444444444444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":984,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.104167,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Abigail Elf","authId":"","name":"Crafty Abigail Elf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Abigail Elf","authId":"","name":"Crafty Abigail Elf","CNNId":"","myGameChains":null,"banStatus":null},"id":17793329,"name":"Echo Echo Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Abigail/Elf/17793329.jpg","createDate":{"time":1348719041000,"minutes":10,"seconds":41,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Abigail/Elf/17793329.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23991,"difficulty":2.4337818264502102,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":236568,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":4.100148,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jay Stampede","authId":"","name":"Electric Jay Stampede","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jay Stampede","authId":"","name":"Electric Jay Stampede","CNNId":"","myGameChains":null,"banStatus":null},"id":18783231,"name":"Echo Warrior Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Jay/Stampede/18783231.jpg","createDate":{"time":1354912398000,"minutes":33,"seconds":18,"hours":15,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Jay/Stampede/18783231.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":215,"difficulty":2.5458553791887124,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":773,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.093809,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Calvin Atlas","authId":"","name":"Sleepy Calvin Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Calvin Atlas","authId":"","name":"Sleepy Calvin Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":18911951,"name":"Universe Whirlwind Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleepy/Calvin/Atlas/18911951.jpg","createDate":{"time":1355130014000,"minutes":0,"seconds":14,"hours":4,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleepy/Calvin/Atlas/18911951.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7180,"difficulty":2.4069146560153594,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17564,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.084612,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"91","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 = '9' 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":"100","currentPageToDisplay":10,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]