[{"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 = '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":"Shaggy Heather Pelican","authId":"","name":"Shaggy Heather Pelican","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Heather Pelican","authId":"","name":"Shaggy Heather Pelican","CNNId":"","myGameChains":null,"banStatus":null},"id":19364347,"name":"Solar Swampfire Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Heather/Pelican/19364347.jpg","createDate":{"time":1357961918000,"minutes":38,"seconds":38,"hours":22,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Heather/Pelican/19364347.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8519,"difficulty":2.42220241232893,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":106642,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.793927,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk Edd Atlas","authId":"","name":"Brisk Edd Atlas","CNNId":"","myGameChains":null,"banStatus":null},"id":19053317,"name":"Pursuit Adventure Target","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/Edd/Atlas/19053317.jpg","createDate":{"time":1355744736000,"minutes":45,"seconds":36,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/Edd/Atlas/19053317.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15877,"difficulty":2.474484085692277,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":105119,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.785544,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Burly Rapunzel Baboon","authId":"","name":"Burly Rapunzel Baboon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Burly Rapunzel Baboon","authId":"","name":"Burly Rapunzel Baboon","CNNId":"","myGameChains":null,"banStatus":null},"id":17540967,"name":"Energy Warp Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Burly/Rapunzel/Baboon/17540967.jpg","createDate":{"time":1348144397000,"minutes":33,"seconds":17,"hours":8,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Burly/Rapunzel/Baboon/17540967.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13262,"difficulty":2.8306320554261455,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":118330,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.785043,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Juan Crater","authId":"","name":"Vast Juan Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Juan Crater","authId":"","name":"Vast Juan Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":18089161,"name":"Fusion Light Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Juan/Crater/18089161.jpg","createDate":{"time":1349979145000,"minutes":12,"seconds":25,"hours":14,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Juan/Crater/18089161.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4778,"difficulty":2.8891419993809166,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":587832,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.779246,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Danny Buffalo","authId":"","name":"Colonel Danny Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Danny Buffalo","authId":"","name":"Colonel Danny Buffalo","CNNId":"","myGameChains":null,"banStatus":null},"id":18525939,"name":"BallWeevil Adventure Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Danny/Buffalo/18525939.jpg","createDate":{"time":1353415877000,"minutes":51,"seconds":17,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Danny/Buffalo/18525939.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1399,"difficulty":2.840918381455872,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":148594,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.758811,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Medusa Saber","authId":"","name":"Atomic Medusa Saber","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Atomic Medusa Saber","authId":"","name":"Atomic Medusa Saber","CNNId":"","myGameChains":null,"banStatus":null},"id":18911943,"name":"Defense Thunder Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Atomic/Medusa/Saber/18911943.jpg","createDate":{"time":1355129918000,"minutes":58,"seconds":38,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Atomic/Medusa/Saber/18911943.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34,"difficulty":2.8217618181751765,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37612,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.754601,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Felipe Mutant","authId":"","name":"Smooth Felipe Mutant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smooth Felipe Mutant","authId":"","name":"Smooth Felipe Mutant","CNNId":"","myGameChains":null,"banStatus":null},"id":17216501,"name":"Universe Ultimate Plasma","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smooth/Felipe/Mutant/17216501.jpg","createDate":{"time":1342182974000,"minutes":36,"seconds":14,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smooth/Felipe/Mutant/17216501.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":94988,"difficulty":2.300685352385239,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":242552,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.753699,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Leonard Doodad","authId":"","name":"Jolly Leonard Doodad","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Leonard Doodad","authId":"","name":"Jolly Leonard Doodad","CNNId":"","myGameChains":null,"banStatus":null},"id":17583464,"name":"Hyper Alien Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Leonard/Doodad/17583464.jpg","createDate":{"time":1348251105000,"minutes":11,"seconds":45,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Leonard/Doodad/17583464.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16789,"difficulty":1.4303989978371536,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47343,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.753634,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bogus Jay Fury","authId":"","name":"Bogus Jay Fury","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bogus Jay Fury","authId":"","name":"Bogus Jay Fury","CNNId":"","myGameChains":null,"banStatus":null},"id":18479989,"name":"Racer Alien Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bogus/Jay/Fury/18479989.jpg","createDate":{"time":1352911304000,"minutes":41,"seconds":44,"hours":11,"month":10,"timezoneOffset":300,"year":112,"day":3,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bogus/Jay/Fury/18479989.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6581,"difficulty":2.2945934789452216,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":112017,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.749287,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Ella Gumshoe","authId":"","name":"Towering Ella Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Ella Gumshoe","authId":"","name":"Towering Ella Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":19707310,"name":"Rock Attack Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Ella/Gumshoe/19707310.jpg","createDate":{"time":1363195972000,"minutes":32,"seconds":52,"hours":13,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Ella/Gumshoe/19707310.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13968,"difficulty":2.3364331770812963,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":44167,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.748688,"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.goalId = '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":"40","currentPageToDisplay":4,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]