[{"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 = '2' 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":"Ancient Marco Bingo","authId":"","name":"Ancient Marco Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Marco Bingo","authId":"","name":"Ancient Marco Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":17956033,"name":"Power Ambush Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Marco/Bingo/17956033.jpg","createDate":{"time":1349365312000,"minutes":41,"seconds":52,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Marco/Bingo/17956033.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":692,"difficulty":2.7407320209139163,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":25646,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.436345,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Matthew Oyster","authId":"","name":"Admiral Matthew Oyster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Matthew Oyster","authId":"","name":"Admiral Matthew Oyster","CNNId":"","myGameChains":null,"banStatus":null},"id":19313221,"name":"Adventure Fury Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Matthew/Oyster/19313221.jpg","createDate":{"time":1357321581000,"minutes":46,"seconds":21,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Matthew/Oyster/19313221.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4266,"difficulty":2.6176320076455997,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7614,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.435252,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Husky Felipe Bonkers","authId":"","name":"Husky Felipe Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Husky Felipe Bonkers","authId":"","name":"Husky Felipe Bonkers","CNNId":"","myGameChains":null,"banStatus":null},"id":19588744,"name":"Burst Assault Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Husky/Felipe/Bonkers/19588744.jpg","createDate":{"time":1361614194000,"minutes":9,"seconds":54,"hours":5,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Husky/Felipe/Bonkers/19588744.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18903,"difficulty":2.216140170017439,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":21897,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.433137,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Arthur Fox","authId":"","name":"Shiny Arthur Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Arthur Fox","authId":"","name":"Shiny Arthur Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":17216075,"name":"Animo Storm Hero","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Arthur/Fox/17216075.jpg","createDate":{"time":1342162126000,"minutes":48,"seconds":46,"hours":2,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Arthur/Fox/17216075.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2414,"difficulty":2.1836177017842187,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6721,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.42071,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Jake Hawk","authId":"","name":"Brisk Jake Hawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Jake Hawk","authId":"","name":"Brisk Jake Hawk","CNNId":"","myGameChains":null,"banStatus":null},"id":19489429,"name":"Storm Nano Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Jake/Hawk/19489429.jpg","createDate":{"time":1359918774000,"minutes":12,"seconds":54,"hours":14,"month":1,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Jake/Hawk/19489429.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":243,"difficulty":2.6434525753181872,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13091,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.414649,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Polly Mercury","authId":"","name":"Wacky Polly Mercury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Polly Mercury","authId":"","name":"Wacky Polly Mercury","CNNId":"","myGameChains":null,"banStatus":null},"id":18345298,"name":"Ambush Storm Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Polly/Mercury/18345298.jpg","createDate":{"time":1351807561000,"minutes":6,"seconds":1,"hours":18,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Polly/Mercury/18345298.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":985,"difficulty":2.246482453323886,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":10821,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.414133,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Kaden Dragoon","authId":"","name":"Zany Kaden Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Kaden Dragoon","authId":"","name":"Zany Kaden Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19312120,"name":"Razor Assault Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Kaden/Dragoon/19312120.jpg","createDate":{"time":1357309263000,"minutes":21,"seconds":3,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Kaden/Dragoon/19312120.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11653,"difficulty":2.3556376985875658,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36264,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.412947,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Adrian Warrior","authId":"","name":"Suave Adrian Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Suave Adrian Warrior","authId":"","name":"Suave Adrian Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":17736840,"name":"Nitro Charge Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Suave/Adrian/Warrior/17736840.jpg","createDate":{"time":1348463940000,"minutes":19,"seconds":0,"hours":1,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Suave/Adrian/Warrior/17736840.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":647,"difficulty":2.519120760192189,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8840,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.403317,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Colin Wraith","authId":"","name":"Jumping Colin Wraith","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jumping Colin Wraith","authId":"","name":"Jumping Colin Wraith","CNNId":"","myGameChains":null,"banStatus":null},"id":19347493,"name":"Crusher Mission Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jumping/Colin/Wraith/19347493.jpg","createDate":{"time":1357681105000,"minutes":38,"seconds":25,"hours":16,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jumping/Colin/Wraith/19347493.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17931,"difficulty":2.349517789678612,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24639,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.40265,"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}],"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 = '2' 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"}}]