[{"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 = '4' 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":"Groovy Gregory Porridge","authId":"","name":"Groovy Gregory Porridge","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Gregory Porridge","authId":"","name":"Groovy Gregory Porridge","CNNId":"","myGameChains":null,"banStatus":null},"id":19520547,"name":"Adventure Alien Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Gregory/Porridge/19520547.jpg","createDate":{"time":1360494519000,"minutes":8,"seconds":39,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Gregory/Porridge/19520547.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5266,"difficulty":2.0260557937876094,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":26375,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.426963,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bashful Logan Badger","authId":"","name":"Bashful Logan Badger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bashful Logan Badger","authId":"","name":"Bashful Logan Badger","CNNId":"","myGameChains":null,"banStatus":null},"id":19861092,"name":"Alien Fury Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bashful/Logan/Badger/19861092.jpg","createDate":{"time":1363957797000,"minutes":9,"seconds":57,"hours":9,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bashful/Logan/Badger/19861092.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3891,"difficulty":2.5956028499079515,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8738,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.422781,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Pete Otter","authId":"","name":"Speedy Pete Otter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Pete Otter","authId":"","name":"Speedy Pete Otter","CNNId":"","myGameChains":null,"banStatus":null},"id":18427463,"name":"Quake Whirlwind Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Pete/Otter/18427463.jpg","createDate":{"time":1352498021000,"minutes":53,"seconds":41,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Pete/Otter/18427463.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1847,"difficulty":2.006021756021756,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3983,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.421633,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Zachary Safari","authId":"","name":"Creative Zachary Safari","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Zachary Safari","authId":"","name":"Creative Zachary Safari","CNNId":"","myGameChains":null,"banStatus":null},"id":19641131,"name":"Water Hex Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Zachary/Safari/19641131.jpg","createDate":{"time":1362684477000,"minutes":27,"seconds":57,"hours":14,"month":2,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Zachary/Safari/19641131.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13576,"difficulty":1.2569965640764988,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":53094,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.416017,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Cameron Badger","authId":"","name":"Cagey Cameron Badger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cagey Cameron Badger","authId":"","name":"Cagey Cameron Badger","CNNId":"","myGameChains":null,"banStatus":null},"id":19198284,"name":"Star Rush Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cagey/Cameron/Badger/19198284.jpg","createDate":{"time":1356539930000,"minutes":38,"seconds":50,"hours":11,"month":11,"timezoneOffset":300,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cagey/Cameron/Badger/19198284.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1604,"difficulty":2.5442176870748296,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2867,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.40625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Pete Otter","authId":"","name":"Speedy Pete Otter","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Pete Otter","authId":"","name":"Speedy Pete Otter","CNNId":"","myGameChains":null,"banStatus":null},"id":18427503,"name":"Alien Whirlwind Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Pete/Otter/18427503.jpg","createDate":{"time":1352498342000,"minutes":59,"seconds":2,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Pete/Otter/18427503.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3173,"difficulty":1.8034959950917908,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13629,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.40132,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Burly Jacob Neptune","authId":"","name":"Burly Jacob Neptune","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Burly Jacob Neptune","authId":"","name":"Burly Jacob Neptune","CNNId":"","myGameChains":null,"banStatus":null},"id":19473211,"name":"Alien Hero Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Burly/Jacob/Neptune/19473211.jpg","createDate":{"time":1359659308000,"minutes":8,"seconds":28,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Burly/Jacob/Neptune/19473211.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1007,"difficulty":2.856142832000143,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51410,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.398927,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hideous Harry Sorcerer","authId":"","name":"Hideous Harry Sorcerer","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hideous Harry Sorcerer","authId":"","name":"Hideous Harry Sorcerer","CNNId":"","myGameChains":null,"banStatus":null},"id":19556733,"name":"Spidermonkey Blaster Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hideous/Harry/Sorcerer/19556733.jpg","createDate":{"time":1361100141000,"minutes":22,"seconds":21,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hideous/Harry/Sorcerer/19556733.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2996,"difficulty":2.0133855368825095,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40004,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.387489,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Zeus Bonanza","authId":"","name":"Icy Zeus Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Zeus Bonanza","authId":"","name":"Icy Zeus Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"id":18098380,"name":"Ultra Adventure Siege","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Zeus/Bonanza/18098380.jpg","createDate":{"time":1350038040000,"minutes":34,"seconds":0,"hours":6,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Zeus/Bonanza/18098380.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2086,"difficulty":2.8267789571969137,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5690,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.386672,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Healthy Makayla Tarmac","authId":"","name":"Healthy Makayla Tarmac","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Healthy Makayla Tarmac","authId":"","name":"Healthy Makayla Tarmac","CNNId":"","myGameChains":null,"banStatus":null},"id":17793468,"name":"Beast Metal Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Healthy/Makayla/Tarmac/17793468.jpg","createDate":{"time":1348721027000,"minutes":43,"seconds":47,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Healthy/Makayla/Tarmac/17793468.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2729,"difficulty":2.714062843625276,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39850,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.375853,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"61","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 = '4' 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":"70","currentPageToDisplay":7,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]