[{"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":"Spotted Sofia Warrior","authId":"","name":"Spotted Sofia Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spotted Sofia Warrior","authId":"","name":"Spotted Sofia Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":18340747,"name":"Fury Steel Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spotted/Sofia/Warrior/18340747.jpg","createDate":{"time":1351760848000,"minutes":7,"seconds":28,"hours":5,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spotted/Sofia/Warrior/18340747.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41054,"difficulty":1.208635328028046,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67327,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.132821,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Volcanic Heather Shuriken","authId":"","name":"Volcanic Heather Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Volcanic Heather Shuriken","authId":"","name":"Volcanic Heather Shuriken","CNNId":"","myGameChains":null,"banStatus":null},"id":19401342,"name":"Nano Turbo Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Volcanic/Heather/Shuriken/19401342.jpg","createDate":{"time":1358531609000,"minutes":53,"seconds":29,"hours":12,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Volcanic/Heather/Shuriken/19401342.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9731,"difficulty":1.6969259016389369,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":48609,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.121056,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Ray Quark","authId":"","name":"Hearty Ray Quark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hearty Ray Quark","authId":"","name":"Hearty Ray Quark","CNNId":"","myGameChains":null,"banStatus":null},"id":18640571,"name":"Solar Pulse Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hearty/Ray/Quark/18640571.jpg","createDate":{"time":1354305462000,"minutes":57,"seconds":42,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hearty/Ray/Quark/18640571.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7953,"difficulty":2.387315189109239,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40631,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.117793,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fanciful Fiona Dinosaur","authId":"","name":"Fanciful Fiona Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fanciful Fiona Dinosaur","authId":"","name":"Fanciful Fiona Dinosaur","CNNId":"","myGameChains":null,"banStatus":null},"id":17813337,"name":"Iron Chase Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fanciful/Fiona/Dinosaur/17813337.jpg","createDate":{"time":1348832570000,"minutes":42,"seconds":50,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fanciful/Fiona/Dinosaur/17813337.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":40136,"difficulty":1.5302354243342762,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":87356,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.103019,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Emmett Blammo","authId":"","name":"Epic Emmett Blammo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Epic Emmett Blammo","authId":"","name":"Epic Emmett Blammo","CNNId":"","myGameChains":null,"banStatus":null},"id":19547042,"name":"Mission Adventure Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Epic/Emmett/Blammo/19547042.jpg","createDate":{"time":1360976189000,"minutes":56,"seconds":29,"hours":19,"month":1,"timezoneOffset":300,"year":113,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Epic/Emmett/Blammo/19547042.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8770,"difficulty":2.3066806699629154,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":40502,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.100909,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Rachel Aviator","authId":"","name":"Robust Rachel Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Robust Rachel Aviator","authId":"","name":"Robust Rachel Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":18983056,"name":"Fury Sonic Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Robust/Rachel/Aviator/18983056.jpg","createDate":{"time":1355519192000,"minutes":6,"seconds":32,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Robust/Rachel/Aviator/18983056.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":45466,"difficulty":2.5400726215824805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":155913,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.07398,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Alicia Moppet","authId":"","name":"Bold Alicia Moppet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bold Alicia Moppet","authId":"","name":"Bold Alicia Moppet","CNNId":"","myGameChains":null,"banStatus":null},"id":17813262,"name":"Razor Doom Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bold/Alicia/Moppet/17813262.jpg","createDate":{"time":1348832145000,"minutes":35,"seconds":45,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bold/Alicia/Moppet/17813262.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56770,"difficulty":2.530684436513643,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63906,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.050985,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Joshua Aviator","authId":"","name":"Feisty Joshua Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Feisty Joshua Aviator","authId":"","name":"Feisty Joshua Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":18285543,"name":"Beast Adventure Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Feisty/Joshua/Aviator/18285543.jpg","createDate":{"time":1351351431000,"minutes":23,"seconds":51,"hours":11,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Feisty/Joshua/Aviator/18285543.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":29383,"difficulty":2.3434973757984796,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":42255,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.041498,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jingling Samuel Creature","authId":"","name":"Jingling Samuel Creature","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jingling Samuel Creature","authId":"","name":"Jingling Samuel Creature","CNNId":"","myGameChains":null,"banStatus":null},"id":18104013,"name":"Hyper Rush Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jingling/Samuel/Creature/18104013.jpg","createDate":{"time":1350070308000,"minutes":31,"seconds":48,"hours":15,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jingling/Samuel/Creature/18104013.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14228,"difficulty":1.9489054430730706,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":173521,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.036825,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Kennedy Polliwog","authId":"","name":"Singular Kennedy Polliwog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Singular Kennedy Polliwog","authId":"","name":"Singular Kennedy Polliwog","CNNId":"","myGameChains":null,"banStatus":null},"id":18206277,"name":"Solar Quake Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Singular/Kennedy/Polliwog/18206277.jpg","createDate":{"time":1350714489000,"minutes":28,"seconds":9,"hours":2,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Singular/Kennedy/Polliwog/18206277.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":19519,"difficulty":1.2571079075172422,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":47112,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.016171,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"81","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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]