[{"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":"Groovy Joshua Whale","authId":"","name":"Groovy Joshua Whale","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Groovy Joshua Whale","authId":"","name":"Groovy Joshua Whale","CNNId":"","myGameChains":null,"banStatus":null},"id":18633719,"name":"Siege Shock Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Groovy/Joshua/Whale/18633719.jpg","createDate":{"time":1354223918000,"minutes":18,"seconds":38,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Groovy/Joshua/Whale/18633719.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38556,"difficulty":2.1253916421642782,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":64497,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.494962,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Jared Alien","authId":"","name":"Musical Jared Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Musical Jared Alien","authId":"","name":"Musical Jared Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":17216548,"name":"Rock Star Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Musical/Jared/Alien/17216548.jpg","createDate":{"time":1342184481000,"minutes":1,"seconds":21,"hours":9,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Musical/Jared/Alien/17216548.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19623,"difficulty":2.2966082283715776,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67219,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":9,"rating":4.493924,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Profound Juno Droid","authId":"","name":"Profound Juno Droid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Profound Juno Droid","authId":"","name":"Profound Juno Droid","CNNId":"","myGameChains":null,"banStatus":null},"id":18280632,"name":"Universe Universe Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Profound/Juno/Droid/18280632.jpg","createDate":{"time":1351316860000,"minutes":47,"seconds":40,"hours":1,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Profound/Juno/Droid/18280632.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11877,"difficulty":2.694185678294271,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":64490,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.482504,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Queen Dillon Talon","authId":"","name":"Queen Dillon Talon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Queen Dillon Talon","authId":"","name":"Queen Dillon Talon","CNNId":"","myGameChains":null,"banStatus":null},"id":18521578,"name":"Atomic Adventure Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Queen/Dillon/Talon/18521578.jpg","createDate":{"time":1353358524000,"minutes":55,"seconds":24,"hours":15,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Queen/Dillon/Talon/18521578.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3299,"difficulty":2.7321384123347543,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40904,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.473843,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Rocky Tiger","authId":"","name":"Splendid Rocky Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Splendid Rocky Tiger","authId":"","name":"Splendid Rocky Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19545470,"name":"Adventure Stone Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Splendid/Rocky/Tiger/19545470.jpg","createDate":{"time":1360962020000,"minutes":0,"seconds":20,"hours":16,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Splendid/Rocky/Tiger/19545470.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3030,"difficulty":2.7433116546899377,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":58538,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.470943,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Steel","authId":"","name":"Admiral Spike Steel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Steel","authId":"","name":"Admiral Spike Steel","CNNId":"","myGameChains":null,"banStatus":null},"id":18638032,"name":"Steel Echo Big","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Spike/Steel/18638032.jpg","createDate":{"time":1354277358000,"minutes":9,"seconds":18,"hours":7,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Spike/Steel/18638032.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45384,"difficulty":1.7756996601589354,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":53024,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.470913,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Gloria Nebula","authId":"","name":"Nifty Gloria Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Gloria Nebula","authId":"","name":"Nifty Gloria Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":17756183,"name":"Space Adventure Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Gloria/Nebula/17756183.jpg","createDate":{"time":1348548229000,"minutes":43,"seconds":49,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Gloria/Nebula/17756183.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29324,"difficulty":2.037991171385918,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":94121,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.469707,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Jared","authId":"","name":"Fabulous Jared","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fabulous Jared","authId":"","name":"Fabulous Jared","CNNId":"","myGameChains":null,"banStatus":null},"id":19661200,"name":"Quake Metal Nano","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fabulous/Jared/19661200.jpg","createDate":{"time":1363011826000,"minutes":23,"seconds":46,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fabulous/Jared/19661200.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13631,"difficulty":2.2469063749600813,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56322,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.454075,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Joel Fiddle","authId":"","name":"Sturdy Joel Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Joel Fiddle","authId":"","name":"Sturdy Joel Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"id":19661521,"name":"Atomic Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Joel/Fiddle/19661521.jpg","createDate":{"time":1363013551000,"minutes":52,"seconds":31,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Joel/Fiddle/19661521.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6264,"difficulty":2.105565980963057,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":53401,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.422049,"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}],"descending":false,"beginRecordId":"41","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":"50","currentPageToDisplay":5,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]