[{"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 = '4' 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":"Ruthless Reuben Quack","authId":"","name":"Ruthless Reuben Quack","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ruthless Reuben Quack","authId":"","name":"Ruthless Reuben Quack","CNNId":"","myGameChains":null,"banStatus":null},"id":18333748,"name":"Attack Adventure Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ruthless/Reuben/Quack/18333748.jpg","createDate":{"time":1351673692000,"minutes":54,"seconds":52,"hours":4,"month":9,"timezoneOffset":240,"year":112,"day":3,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ruthless/Reuben/Quack/18333748.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7752,"difficulty":2.2110452943733145,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82329,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.593187,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dreadful Vladimir Oyster","authId":"","name":"Dreadful Vladimir Oyster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dreadful Vladimir Oyster","authId":"","name":"Dreadful Vladimir Oyster","CNNId":"","myGameChains":null,"banStatus":null},"id":19569686,"name":"Streak BallWeevil Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dreadful/Vladimir/Oyster/19569686.jpg","createDate":{"time":1361278032000,"minutes":47,"seconds":12,"hours":7,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dreadful/Vladimir/Oyster/19569686.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11697,"difficulty":2.6308668002735245,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":138841,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.589922,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Abigail Proton","authId":"","name":"Regal Abigail Proton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regal Abigail Proton","authId":"","name":"Regal Abigail Proton","CNNId":"","myGameChains":null,"banStatus":null},"id":17216489,"name":"Droid Nano Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regal/Abigail/Proton/17216489.jpg","createDate":{"time":1342182341000,"minutes":25,"seconds":41,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":5,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regal/Abigail/Proton/17216489.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8950,"difficulty":2.7030004948709054,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":146063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":42,"rating":4.585271,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Brandon Haystack","authId":"","name":"Solar Brandon Haystack","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Solar Brandon Haystack","authId":"","name":"Solar Brandon Haystack","CNNId":"","myGameChains":null,"banStatus":null},"id":19244177,"name":"Battle Target Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Solar/Brandon/Haystack/19244177.jpg","createDate":{"time":1356817507000,"minutes":45,"seconds":7,"hours":16,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Solar/Brandon/Haystack/19244177.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8405,"difficulty":2.8217092691068006,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82722,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.581697,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Carolyn Parsec","authId":"","name":"Cackling Carolyn Parsec","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Carolyn Parsec","authId":"","name":"Cackling Carolyn Parsec","CNNId":"","myGameChains":null,"banStatus":null},"id":19053112,"name":"Ultimate Adventure Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Carolyn/Parsec/19053112.jpg","createDate":{"time":1355741093000,"minutes":44,"seconds":53,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Carolyn/Parsec/19053112.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12077,"difficulty":2.499128563029519,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67424,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.579267,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Kathleen Typhoon","authId":"","name":"Leaping Kathleen Typhoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Kathleen Typhoon","authId":"","name":"Leaping Kathleen Typhoon","CNNId":"","myGameChains":null,"banStatus":null},"id":19362427,"name":"BallWeevil BallWeevil BallWeevil","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Leaping/Kathleen/Typhoon/19362427.jpg","createDate":{"time":1357944269000,"minutes":44,"seconds":29,"hours":17,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Leaping/Kathleen/Typhoon/19362427.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":239,"difficulty":2.879433748702959,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":73229,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.564123,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Violet Wyvern","authId":"","name":"Shaggy Violet Wyvern","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Violet Wyvern","authId":"","name":"Shaggy Violet Wyvern","CNNId":"","myGameChains":null,"banStatus":null},"id":18640501,"name":"Search Ambush Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Violet/Wyvern/18640501.jpg","createDate":{"time":1354304893000,"minutes":48,"seconds":13,"hours":14,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Violet/Wyvern/18640501.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4687,"difficulty":2.228385382566126,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":41968,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.556671,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Lively Trevor Gizzard","authId":"","name":"Lively Trevor Gizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lively Trevor Gizzard","authId":"","name":"Lively Trevor Gizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":19504343,"name":"Adventure Space Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lively/Trevor/Gizzard/19504343.jpg","createDate":{"time":1360249970000,"minutes":12,"seconds":50,"hours":10,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lively/Trevor/Gizzard/19504343.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8620,"difficulty":2.540347126747634,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54279,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.545481,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Marcia Tiptoe","authId":"","name":"Cackling Marcia Tiptoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cackling Marcia Tiptoe","authId":"","name":"Cackling Marcia Tiptoe","CNNId":"","myGameChains":null,"banStatus":null},"id":19465350,"name":"Thunder Clash Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cackling/Marcia/Tiptoe/19465350.jpg","createDate":{"time":1359468604000,"minutes":10,"seconds":4,"hours":9,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cackling/Marcia/Tiptoe/19465350.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3490,"difficulty":2.8295064634847824,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74873,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.535825,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Nick Sword","authId":"","name":"Cute Nick Sword","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cute Nick Sword","authId":"","name":"Cute Nick Sword","CNNId":"","myGameChains":null,"banStatus":null},"id":19534947,"name":"Sonic Ben Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cute/Nick/Sword/19534947.jpg","createDate":{"time":1360761402000,"minutes":16,"seconds":42,"hours":8,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cute/Nick/Sword/19534947.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1581,"difficulty":2.263531606241368,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51289,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.525244,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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 = '4' 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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]