[{"getBestRatedByGoal":{"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 \"Goal.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.goalId = '1' 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":"Acoustic Alfonso Windmill","authId":"","name":"Acoustic Alfonso Windmill","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Alfonso Windmill","authId":"","name":"Acoustic Alfonso Windmill","CNNId":"","myGameChains":null,"banStatus":null},"id":18631654,"name":"Shock Rumble Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Acoustic/Alfonso/Windmill/18631654.jpg","createDate":{"time":1354196596000,"minutes":43,"seconds":16,"hours":8,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Acoustic/Alfonso/Windmill/18631654.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36147,"difficulty":2.1152863954791528,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":111411,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.348278,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Jay Samurai","authId":"","name":"Kinetic Jay Samurai","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Kinetic Jay Samurai","authId":"","name":"Kinetic Jay Samurai","CNNId":"","myGameChains":null,"banStatus":null},"id":18005083,"name":"Solar Hex Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Kinetic/Jay/Samurai/18005083.jpg","createDate":{"time":1349554613000,"minutes":16,"seconds":53,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Kinetic/Jay/Samurai/18005083.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48714,"difficulty":1.4747993240394315,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83625,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.347901,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Angel Badger","authId":"","name":"Agile Angel Badger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Agile Angel Badger","authId":"","name":"Agile Angel Badger","CNNId":"","myGameChains":null,"banStatus":null},"id":19089408,"name":"Adventure Steel Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Agile/Angel/Badger/19089408.jpg","createDate":{"time":1355988843000,"minutes":34,"seconds":3,"hours":2,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Agile/Angel/Badger/19089408.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24055,"difficulty":2.4429112446784527,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40007,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.341223,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Beth Elephant","authId":"","name":"Vast Beth Elephant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Beth Elephant","authId":"","name":"Vast Beth Elephant","CNNId":"","myGameChains":null,"banStatus":null},"id":18004848,"name":"Magno Quake Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Beth/Elephant/18004848.jpg","createDate":{"time":1349554251000,"minutes":10,"seconds":51,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Beth/Elephant/18004848.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2140,"difficulty":2.7765630171662026,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":46277,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.340595,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold David Goblin","authId":"","name":"Bold David Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold David Goblin","authId":"","name":"Bold David Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":17587734,"name":"Spark Omniverse Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/David/Goblin/17587734.jpg","createDate":{"time":1348259364000,"minutes":29,"seconds":24,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/David/Goblin/17587734.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11129,"difficulty":1.6884962375997186,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43915,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.33616,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Katie Unicorn","authId":"","name":"Complex Katie Unicorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Complex Katie Unicorn","authId":"","name":"Complex Katie Unicorn","CNNId":"","myGameChains":null,"banStatus":null},"id":18535105,"name":"Adventure Solar Magno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Complex/Katie/Unicorn/18535105.jpg","createDate":{"time":1353490316000,"minutes":31,"seconds":56,"hours":4,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Complex/Katie/Unicorn/18535105.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38319,"difficulty":2.5584177802226464,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47236,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.317293,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Bessie Shamrock","authId":"","name":"Sly Bessie Shamrock","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sly Bessie Shamrock","authId":"","name":"Sly Bessie Shamrock","CNNId":"","myGameChains":null,"banStatus":null},"id":19831974,"name":"Adventure Metal Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sly/Bessie/Shamrock/19831974.jpg","createDate":{"time":1363718153000,"minutes":35,"seconds":53,"hours":14,"month":2,"timezoneOffset":240,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sly/Bessie/Shamrock/19831974.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27923,"difficulty":2.856667977961818,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65636,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.314299,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Parker Kumquat","authId":"","name":"Grimy Parker Kumquat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grimy Parker Kumquat","authId":"","name":"Grimy Parker Kumquat","CNNId":"","myGameChains":null,"banStatus":null},"id":19395947,"name":"Alien Energy Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grimy/Parker/Kumquat/19395947.jpg","createDate":{"time":1358421437000,"minutes":17,"seconds":17,"hours":6,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grimy/Parker/Kumquat/19395947.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4426,"difficulty":2.829157290662229,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":75329,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.304358,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Chuck Funk","authId":"","name":"Digital Chuck Funk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Chuck Funk","authId":"","name":"Digital Chuck Funk","CNNId":"","myGameChains":null,"banStatus":null},"id":18484237,"name":"Plumber Charge Quake","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Chuck/Funk/18484237.jpg","createDate":{"time":1352955832000,"minutes":3,"seconds":52,"hours":0,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Chuck/Funk/18484237.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29462,"difficulty":1.5880977904193854,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47542,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.29939,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Johnny Bonkers","authId":"","name":"Count Johnny Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Count Johnny Bonkers","authId":"","name":"Count Johnny Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"id":19323593,"name":"Battle Turbo Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Count/Johnny/Bonkers/19323593.jpg","createDate":{"time":1357409795000,"minutes":16,"seconds":35,"hours":13,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Count/Johnny/Bonkers/19323593.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25368,"difficulty":2.4012035318993634,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":42532,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.289745,"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.goalId = '1' 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"}}]