[{"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 = '3' 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":"Imperial Chad Dragoon","authId":"","name":"Imperial Chad Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Imperial Chad Dragoon","authId":"","name":"Imperial Chad Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":17793473,"name":"Omniverse Titan Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Imperial/Chad/Dragoon/17793473.jpg","createDate":{"time":1348721301000,"minutes":48,"seconds":21,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Imperial/Chad/Dragoon/17793473.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12184,"difficulty":2.716346530325485,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":102967,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.85113,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome CJ Galaxy","authId":"","name":"Awesome CJ Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome CJ Galaxy","authId":"","name":"Awesome CJ Galaxy","CNNId":"","myGameChains":null,"banStatus":null},"id":19498322,"name":"Rescue Echo Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/CJ/Galaxy/19498322.jpg","createDate":{"time":1360103907000,"minutes":38,"seconds":27,"hours":17,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/CJ/Galaxy/19498322.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12441,"difficulty":1.889048661020803,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65601,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.844754,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Rick Snake","authId":"","name":"Doctor Rick Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Doctor Rick Snake","authId":"","name":"Doctor Rick Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":17420977,"name":"Warrior Hex Star","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Doctor/Rick/Snake/17420977.jpg","createDate":{"time":1347840376000,"minutes":6,"seconds":16,"hours":20,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Doctor/Rick/Snake/17420977.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12827,"difficulty":2.705464512441176,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":286261,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.831075,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing DJ Wolf","authId":"","name":"Dashing DJ Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing DJ Wolf","authId":"","name":"Dashing DJ Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":18994807,"name":"Adventure Drone Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/DJ/Wolf/18994807.jpg","createDate":{"time":1355554325000,"minutes":52,"seconds":5,"hours":1,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/DJ/Wolf/18994807.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38760,"difficulty":2.130604303290513,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":97742,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.830526,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Benton Concrete","authId":"","name":"Gigantic Benton Concrete","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gigantic Benton Concrete","authId":"","name":"Gigantic Benton Concrete","CNNId":"","myGameChains":null,"banStatus":null},"id":19573513,"name":"Drone Iron Blaster","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gigantic/Benton/Concrete/19573513.jpg","createDate":{"time":1361326718000,"minutes":18,"seconds":38,"hours":21,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gigantic/Benton/Concrete/19573513.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19096,"difficulty":2.376729318066217,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59361,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.830276,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Eric Knight","authId":"","name":"Glorious Eric Knight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Glorious Eric Knight","authId":"","name":"Glorious Eric Knight","CNNId":"","myGameChains":null,"banStatus":null},"id":19850970,"name":"Universe Ultimate Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Glorious/Eric/Knight/19850970.jpg","createDate":{"time":1363877325000,"minutes":48,"seconds":45,"hours":10,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Glorious/Eric/Knight/19850970.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19729,"difficulty":2.379711378101278,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":104406,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.798738,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Matthew Fang","authId":"","name":"Ultimate Matthew Fang","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Matthew Fang","authId":"","name":"Ultimate Matthew Fang","CNNId":"","myGameChains":null,"banStatus":null},"id":17784493,"name":"Power Alien Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Matthew/Fang/17784493.jpg","createDate":{"time":1348693033000,"minutes":57,"seconds":13,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Matthew/Fang/17784493.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6755,"difficulty":1.6537599459876933,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":626547,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.751296,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Pulse","authId":"","name":"Admiral Spike Pulse","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Spike Pulse","authId":"","name":"Admiral Spike Pulse","CNNId":"","myGameChains":null,"banStatus":null},"id":19477936,"name":"Alien Patrol Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Spike/Pulse/19477936.jpg","createDate":{"time":1359761534000,"minutes":32,"seconds":14,"hours":18,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Spike/Pulse/19477936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":454,"difficulty":2.7674658605041427,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":90452,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.740439,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Kenneth Omelet","authId":"","name":"Gracious Kenneth Omelet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gracious Kenneth Omelet","authId":"","name":"Gracious Kenneth Omelet","CNNId":"","myGameChains":null,"banStatus":null},"id":17957150,"name":"Shadow Hyper Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gracious/Kenneth/Omelet/17957150.jpg","createDate":{"time":1349373125000,"minutes":52,"seconds":5,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gracious/Kenneth/Omelet/17957150.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8267,"difficulty":1.6748166399979447,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":61920,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.737492,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Ludwig Dingbat","authId":"","name":"Tough Ludwig Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tough Ludwig Dingbat","authId":"","name":"Tough Ludwig Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"id":19803210,"name":"Mission Ultimate Vilgax","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tough/Ludwig/Dingbat/19803210.jpg","createDate":{"time":1363549047000,"minutes":37,"seconds":27,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tough/Ludwig/Dingbat/19803210.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13844,"difficulty":1.5762362062535495,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57546,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.731102,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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 = '3' 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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]