[{"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":"Negative Aaron Dynamite","authId":"","name":"Negative Aaron Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Negative Aaron Dynamite","authId":"","name":"Negative Aaron Dynamite","CNNId":"","myGameChains":null,"banStatus":null},"id":18079075,"name":"Rampage Beast Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Negative/Aaron/Dynamite/18079075.jpg","createDate":{"time":1349899804000,"minutes":10,"seconds":4,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Negative/Aaron/Dynamite/18079075.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2459,"difficulty":2.6014976424917946,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8449,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.904384,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Velma Basilisk","authId":"","name":"Ancient Velma Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ancient Velma Basilisk","authId":"","name":"Ancient Velma Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":19648443,"name":"Racer Champion Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ancient/Velma/Basilisk/19648443.jpg","createDate":{"time":1362835028000,"minutes":17,"seconds":8,"hours":8,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ancient/Velma/Basilisk/19648443.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7387,"difficulty":1.3997805389960178,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":9158,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.900552,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cunning Sphinx","authId":"","name":"Cunning Sphinx","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cunning Sphinx","authId":"","name":"Cunning Sphinx","CNNId":"","myGameChains":null,"banStatus":null},"id":19606140,"name":"Atomic Universe Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cunning/Sphinx/19606140.jpg","createDate":{"time":1361896344000,"minutes":32,"seconds":24,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cunning/Sphinx/19606140.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":365,"difficulty":2.709163429163429,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7571,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.896689,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Jay Vitamin","authId":"","name":"Savage Jay Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Savage Jay Vitamin","authId":"","name":"Savage Jay Vitamin","CNNId":"","myGameChains":null,"banStatus":null},"id":17736748,"name":"Mission Universe Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Savage/Jay/Vitamin/17736748.jpg","createDate":{"time":1348462373000,"minutes":52,"seconds":53,"hours":0,"month":8,"timezoneOffset":240,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Savage/Jay/Vitamin/17736748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":243,"difficulty":1.7361616161616162,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7992,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.859877,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling Adrian Twilight","authId":"","name":"Howling Adrian Twilight","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Howling Adrian Twilight","authId":"","name":"Howling Adrian Twilight","CNNId":"","myGameChains":null,"banStatus":null},"id":18469470,"name":"Ultimate Patrol Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Howling/Adrian/Twilight/18469470.jpg","createDate":{"time":1352757667000,"minutes":1,"seconds":7,"hours":17,"month":10,"timezoneOffset":300,"year":112,"day":1,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Howling/Adrian/Twilight/18469470.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13234,"difficulty":1.6691452859174156,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":20448,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.818674,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Simon Glacier","authId":"","name":"Wacky Simon Glacier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wacky Simon Glacier","authId":"","name":"Wacky Simon Glacier","CNNId":"","myGameChains":null,"banStatus":null},"id":19090047,"name":"Echo Techno Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wacky/Simon/Glacier/19090047.jpg","createDate":{"time":1356003763000,"minutes":42,"seconds":43,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wacky/Simon/Glacier/19090047.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":718,"difficulty":2.1402976487797916,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15028,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.796143,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Tasteful Shelby Rocket","authId":"","name":"Tasteful Shelby Rocket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Tasteful Shelby Rocket","authId":"","name":"Tasteful Shelby Rocket","CNNId":"","myGameChains":null,"banStatus":null},"id":19639850,"name":"Humungousaur Challenge Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Tasteful/Shelby/Rocket/19639850.jpg","createDate":{"time":1362642981000,"minutes":56,"seconds":21,"hours":2,"month":2,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Tasteful/Shelby/Rocket/19639850.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17429,"difficulty":2.2511676132345357,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":60795,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.794101,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Ben Crater","authId":"","name":"Brave Ben Crater","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Ben Crater","authId":"","name":"Brave Ben Crater","CNNId":"","myGameChains":null,"banStatus":null},"id":19721182,"name":"Rook Clash Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brave/Ben/Crater/19721182.jpg","createDate":{"time":1363260076000,"minutes":21,"seconds":16,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brave/Ben/Crater/19721182.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3644,"difficulty":2.5274434211970656,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17859,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.788947,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Wayne Bullfrog","authId":"","name":"Academic Wayne Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Wayne Bullfrog","authId":"","name":"Academic Wayne Bullfrog","CNNId":"","myGameChains":null,"banStatus":null},"id":18553166,"name":"Gear Chase Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Wayne/Bullfrog/18553166.jpg","createDate":{"time":1353606902000,"minutes":55,"seconds":2,"hours":12,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Wayne/Bullfrog/18553166.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10754,"difficulty":1.8776643090759282,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37192,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.779843,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Polly Proton","authId":"","name":"Friendly Polly Proton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Polly Proton","authId":"","name":"Friendly Polly Proton","CNNId":"","myGameChains":null,"banStatus":null},"id":17216555,"name":"Invasion Laser Plumber","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Polly/Proton/17216555.jpg","createDate":{"time":1342184541000,"minutes":2,"seconds":21,"hours":9,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Polly/Proton/17216555.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":57383,"difficulty":2.4989904747053022,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":81099,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":38,"rating":3.767202,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"121","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":"130","currentPageToDisplay":13,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]