[{"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":"Super Kenneth Bramble","authId":"","name":"Super Kenneth Bramble","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Kenneth Bramble","authId":"","name":"Super Kenneth Bramble","CNNId":"","myGameChains":null,"banStatus":null},"id":19549100,"name":"Battle Brainstorm Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Kenneth/Bramble/19549100.jpg","createDate":{"time":1361013774000,"minutes":22,"seconds":54,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Kenneth/Bramble/19549100.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11910,"difficulty":1.3546454427935883,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18488,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.746739,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Ava Magician","authId":"","name":"Elite Ava Magician","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elite Ava Magician","authId":"","name":"Elite Ava Magician","CNNId":"","myGameChains":null,"banStatus":null},"id":18247545,"name":"Pulse Force Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elite/Ava/Magician/18247545.jpg","createDate":{"time":1351007453000,"minutes":50,"seconds":53,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elite/Ava/Magician/18247545.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3743,"difficulty":2.0136271125381233,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19658,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.730204,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Zachary Omelet","authId":"","name":"Virtual Zachary Omelet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Virtual Zachary Omelet","authId":"","name":"Virtual Zachary Omelet","CNNId":"","myGameChains":null,"banStatus":null},"id":18285577,"name":"Hyper Battle Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Virtual/Zachary/Omelet/18285577.jpg","createDate":{"time":1351351524000,"minutes":25,"seconds":24,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Virtual/Zachary/Omelet/18285577.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7067,"difficulty":1.2672352952026114,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":85123,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.71766,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Gabe Dingbat","authId":"","name":"Roaring Gabe Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Gabe Dingbat","authId":"","name":"Roaring Gabe Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"id":19413731,"name":"Star Fury Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Roaring/Gabe/Dingbat/19413731.jpg","createDate":{"time":1358684119000,"minutes":15,"seconds":19,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Roaring/Gabe/Dingbat/19413731.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2122,"difficulty":2.8066950690021213,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8989,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.636058,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Peculiar Bugsy Sprocket","authId":"","name":"Peculiar Bugsy Sprocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Peculiar Bugsy Sprocket","authId":"","name":"Peculiar Bugsy Sprocket","CNNId":"","myGameChains":null,"banStatus":null},"id":17805628,"name":"Big Big Mega","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Peculiar/Bugsy/Sprocket/17805628.jpg","createDate":{"time":1348788135000,"minutes":22,"seconds":15,"hours":19,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Peculiar/Bugsy/Sprocket/17805628.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":68829,"difficulty":2.187961036733008,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":95652,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.626315,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Chester Daffodil","authId":"","name":"Loyal Chester Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loyal Chester Daffodil","authId":"","name":"Loyal Chester Daffodil","CNNId":"","myGameChains":null,"banStatus":null},"id":18392918,"name":"Hero Target Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loyal/Chester/Daffodil/18392918.jpg","createDate":{"time":1352128417000,"minutes":13,"seconds":37,"hours":10,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loyal/Chester/Daffodil/18392918.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4867,"difficulty":2.5744162103779953,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63098,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.617439,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Eli Charger","authId":"","name":"Icy Eli Charger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Icy Eli Charger","authId":"","name":"Icy Eli Charger","CNNId":"","myGameChains":null,"banStatus":null},"id":19760180,"name":"Swampfire Adventure Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Icy/Eli/Charger/19760180.jpg","createDate":{"time":1363435248000,"minutes":0,"seconds":48,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Icy/Eli/Charger/19760180.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2942,"difficulty":2.5315223029496443,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":24544,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.608401,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Timothy Grackle","authId":"","name":"Nomadic Timothy Grackle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nomadic Timothy Grackle","authId":"","name":"Nomadic Timothy Grackle","CNNId":"","myGameChains":null,"banStatus":null},"id":19736885,"name":"Adventure Adventure Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nomadic/Timothy/Grackle/19736885.jpg","createDate":{"time":1363323456000,"minutes":57,"seconds":36,"hours":0,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nomadic/Timothy/Grackle/19736885.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36567,"difficulty":1.3852488058841959,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":76414,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.552392,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Iris Tornado","authId":"","name":"Evil Iris Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evil Iris Tornado","authId":"","name":"Evil Iris Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19279629,"name":"Omniverse Ultimate Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evil/Iris/Tornado/19279629.jpg","createDate":{"time":1357043017000,"minutes":23,"seconds":37,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evil/Iris/Tornado/19279629.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7040,"difficulty":1.3944902681245888,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7845,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.495226,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Yorick Avator","authId":"","name":"Creative Yorick Avator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creative Yorick Avator","authId":"","name":"Creative Yorick Avator","CNNId":"","myGameChains":null,"banStatus":null},"id":18165090,"name":"Adventure Droid Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creative/Yorick/Avator/18165090.jpg","createDate":{"time":1350332376000,"minutes":19,"seconds":36,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":1,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creative/Yorick/Avator/18165090.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38884,"difficulty":1.3455445420404217,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":157784,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.491313,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]