[{"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 = '6' 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":"Loony Edd Ketchup","authId":"","name":"Loony Edd Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Edd Ketchup","authId":"","name":"Loony Edd Ketchup","CNNId":"","myGameChains":null,"banStatus":null},"id":18963088,"name":"Ben Patrol Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Edd/Ketchup/18963088.jpg","createDate":{"time":1355409370000,"minutes":36,"seconds":10,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Edd/Ketchup/18963088.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1399,"difficulty":1.5708947302697303,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2642,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.580745,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Carolyn Parsec","authId":"","name":"Cackling Carolyn Parsec","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Carolyn Parsec","authId":"","name":"Cackling Carolyn Parsec","CNNId":"","myGameChains":null,"banStatus":null},"id":19053112,"name":"Ultimate Adventure Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Carolyn/Parsec/19053112.jpg","createDate":{"time":1355741093000,"minutes":44,"seconds":53,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Carolyn/Parsec/19053112.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12077,"difficulty":2.499128563029519,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67424,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.579267,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cheerful Caden Camel","authId":"","name":"Cheerful Caden Camel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cheerful Caden Camel","authId":"","name":"Cheerful Caden Camel","CNNId":"","myGameChains":null,"banStatus":null},"id":19580299,"name":"Metal Rumble Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cheerful/Caden/Camel/19580299.jpg","createDate":{"time":1361472403000,"minutes":46,"seconds":43,"hours":13,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cheerful/Caden/Camel/19580299.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":613,"difficulty":2.128956228956229,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2130,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.578883,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Jake Macaroni","authId":"","name":"Robust Jake Macaroni","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Jake Macaroni","authId":"","name":"Robust Jake Macaroni","CNNId":"","myGameChains":null,"banStatus":null},"id":19027323,"name":"Solar Waterhazard Ben","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robust/Jake/Macaroni/19027323.jpg","createDate":{"time":1355659937000,"minutes":12,"seconds":17,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robust/Jake/Macaroni/19027323.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2056,"difficulty":2.43030303030303,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6053,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.571429,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Joyous Hayden Skater","authId":"","name":"Joyous Hayden Skater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Joyous Hayden Skater","authId":"","name":"Joyous Hayden Skater","CNNId":"","myGameChains":null,"banStatus":null},"id":18127619,"name":"Solar Vilgax Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Joyous/Hayden/Skater/18127619.jpg","createDate":{"time":1350158368000,"minutes":59,"seconds":28,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Joyous/Hayden/Skater/18127619.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1390,"difficulty":2.4919642857142854,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2050,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.567347,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Noble Jordan Phoenix","authId":"","name":"Noble Jordan Phoenix","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Noble Jordan Phoenix","authId":"","name":"Noble Jordan Phoenix","CNNId":"","myGameChains":null,"banStatus":null},"id":19186665,"name":"Universe Power Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Noble/Jordan/Phoenix/19186665.jpg","createDate":{"time":1356434410000,"minutes":20,"seconds":10,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Noble/Jordan/Phoenix/19186665.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":230,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":760,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.555556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Andy Tsunami","authId":"","name":"Edgy Andy Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Edgy Andy Tsunami","authId":"","name":"Edgy Andy Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"id":19053272,"name":"Robot Ambush Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Edgy/Andy/Tsunami/19053272.jpg","createDate":{"time":1355744056000,"minutes":34,"seconds":16,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Edgy/Andy/Tsunami/19053272.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":162,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":521,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.555556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Alex Moppet","authId":"","name":"Dandy Alex Moppet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Alex Moppet","authId":"","name":"Dandy Alex Moppet","CNNId":"","myGameChains":null,"banStatus":null},"id":19434172,"name":"Waterhazard Fury Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dandy/Alex/Moppet/19434172.jpg","createDate":{"time":1358973130000,"minutes":32,"seconds":10,"hours":15,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dandy/Alex/Moppet/19434172.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1600,"difficulty":1.6123520923520924,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5639,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.552381,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frantic Sapphire Foghorn","authId":"","name":"Frantic Sapphire Foghorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frantic Sapphire Foghorn","authId":"","name":"Frantic Sapphire Foghorn","CNNId":"","myGameChains":null,"banStatus":null},"id":17955914,"name":"Mega Alien Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frantic/Sapphire/Foghorn/17955914.jpg","createDate":{"time":1349364725000,"minutes":32,"seconds":5,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frantic/Sapphire/Foghorn/17955914.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22,"difficulty":2.447619047619048,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5120,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.542857,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Alvin Beast","authId":"","name":"Gruesome Alvin Beast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Alvin Beast","authId":"","name":"Gruesome Alvin Beast","CNNId":"","myGameChains":null,"banStatus":null},"id":18488369,"name":"Nova Galaxy Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Alvin/Beast/18488369.jpg","createDate":{"time":1353023635000,"minutes":53,"seconds":55,"hours":18,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Alvin/Beast/18488369.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":355,"difficulty":1.7999999999999998,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":613,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.541667,"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 = '6' 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"}}]