[{"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":"Neutral Dakota Denizen","authId":"","name":"Neutral Dakota Denizen","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Neutral Dakota Denizen","authId":"","name":"Neutral Dakota Denizen","CNNId":"","myGameChains":null,"banStatus":null},"id":19052181,"name":"Feedback Quake Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Neutral/Dakota/Denizen/19052181.jpg","createDate":{"time":1355725495000,"minutes":24,"seconds":55,"hours":1,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Neutral/Dakota/Denizen/19052181.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14365,"difficulty":2.3269037007481366,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63106,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.580218,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Zeus Nebula","authId":"","name":"Creepy Zeus Nebula","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Creepy Zeus Nebula","authId":"","name":"Creepy Zeus Nebula","CNNId":"","myGameChains":null,"banStatus":null},"id":18617920,"name":"Whirlwind Defense Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Creepy/Zeus/Nebula/18617920.jpg","createDate":{"time":1354015372000,"minutes":22,"seconds":52,"hours":6,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Creepy/Zeus/Nebula/18617920.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5105,"difficulty":2.809796831596394,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63459,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.571277,"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":19661157,"name":"Atomic Charge Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Joel/Fiddle/19661157.jpg","createDate":{"time":1363011495000,"minutes":18,"seconds":15,"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/19661157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11556,"difficulty":1.6751849095955316,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":69776,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.566796,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Billy Licorice","authId":"","name":"Sergeant Billy Licorice","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sergeant Billy Licorice","authId":"","name":"Sergeant Billy Licorice","CNNId":"","myGameChains":null,"banStatus":null},"id":19648347,"name":"Robot Robot Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sergeant/Billy/Licorice/19648347.jpg","createDate":{"time":1362833752000,"minutes":55,"seconds":52,"hours":7,"month":2,"timezoneOffset":300,"year":113,"day":6,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sergeant/Billy/Licorice/19648347.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2866,"difficulty":2.3931780500943165,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":13485,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.56452,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Ichabod Basilisk","authId":"","name":"Dramatic Ichabod Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Ichabod Basilisk","authId":"","name":"Dramatic Ichabod Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":19760014,"name":"Chill Galaxy Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dramatic/Ichabod/Basilisk/19760014.jpg","createDate":{"time":1363434587000,"minutes":49,"seconds":47,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dramatic/Ichabod/Basilisk/19760014.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5278,"difficulty":2.1648825943069783,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6017,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.563383,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Rolf Aardvark","authId":"","name":"Ironclad Rolf Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ironclad Rolf Aardvark","authId":"","name":"Ironclad Rolf Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":19169100,"name":"Danger Adventure Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ironclad/Rolf/Aardvark/19169100.jpg","createDate":{"time":1356349355000,"minutes":42,"seconds":35,"hours":6,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ironclad/Rolf/Aardvark/19169100.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12339,"difficulty":2.5964416866929296,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50865,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.562909,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Destiny Cutlass","authId":"","name":"Brawny Destiny Cutlass","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Destiny Cutlass","authId":"","name":"Brawny Destiny Cutlass","CNNId":"","myGameChains":null,"banStatus":null},"id":19871393,"name":"Rock Crusher Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brawny/Destiny/Cutlass/19871393.jpg","createDate":{"time":1364012249000,"minutes":17,"seconds":29,"hours":0,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brawny/Destiny/Cutlass/19871393.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8294,"difficulty":2.774479069265471,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":118971,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.562729,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Margaret Soldier","authId":"","name":"Vast Margaret Soldier","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vast Margaret Soldier","authId":"","name":"Vast Margaret Soldier","CNNId":"","myGameChains":null,"banStatus":null},"id":18984400,"name":"Blaster Shadow Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vast/Margaret/Soldier/18984400.jpg","createDate":{"time":1355522837000,"minutes":7,"seconds":17,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vast/Margaret/Soldier/18984400.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5342,"difficulty":2.356238644476274,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":17217,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.557301,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Spirited Chester Biscuit","authId":"","name":"Spirited Chester Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spirited Chester Biscuit","authId":"","name":"Spirited Chester Biscuit","CNNId":"","myGameChains":null,"banStatus":null},"id":18617903,"name":"Rustbucket Rush Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spirited/Chester/Biscuit/18617903.jpg","createDate":{"time":1354014951000,"minutes":15,"seconds":51,"hours":6,"month":10,"timezoneOffset":300,"year":112,"day":2,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spirited/Chester/Biscuit/18617903.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15293,"difficulty":2.6468778600481495,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":80654,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.551816,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Wayne Castle","authId":"","name":"Nifty Wayne Castle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Wayne Castle","authId":"","name":"Nifty Wayne Castle","CNNId":"","myGameChains":null,"banStatus":null},"id":17216524,"name":"Sonic Robot Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Wayne/Castle/17216524.jpg","createDate":{"time":1342183732000,"minutes":48,"seconds":52,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Wayne/Castle/17216524.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1883,"difficulty":2.3391301389728163,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":7521,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.536752,"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 = '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":"40","currentPageToDisplay":4,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]