[{"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":"Earnest Clyde Smidgen","authId":"","name":"Earnest Clyde Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Earnest Clyde Smidgen","authId":"","name":"Earnest Clyde Smidgen","CNNId":"","myGameChains":null,"banStatus":null},"id":19342072,"name":"Beast Robot Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Earnest/Clyde/Smidgen/19342072.jpg","createDate":{"time":1357586137000,"minutes":15,"seconds":37,"hours":14,"month":0,"timezoneOffset":300,"year":113,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Earnest/Clyde/Smidgen/19342072.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34582,"difficulty":1.7474010351035159,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":110220,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.713794,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Ralph Pulse","authId":"","name":"Infinite Ralph Pulse","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infinite Ralph Pulse","authId":"","name":"Infinite Ralph Pulse","CNNId":"","myGameChains":null,"banStatus":null},"id":17813357,"name":"Rumble Echo Omniverse","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infinite/Ralph/Pulse/17813357.jpg","createDate":{"time":1348832740000,"minutes":45,"seconds":40,"hours":7,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infinite/Ralph/Pulse/17813357.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1684,"difficulty":2.791551598145417,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":66497,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.586195,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Brayden Halo","authId":"","name":"Reckless Brayden Halo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Brayden Halo","authId":"","name":"Reckless Brayden Halo","CNNId":"","myGameChains":null,"banStatus":null},"id":19932402,"name":"Sonic Danger Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Brayden/Halo/19932402.jpg","createDate":{"time":1364411200000,"minutes":6,"seconds":40,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":3,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Brayden/Halo/19932402.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16269,"difficulty":1.8751124965710255,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":75044,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.524202,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stubborn Noel Giraffe","authId":"","name":"Stubborn Noel Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stubborn Noel Giraffe","authId":"","name":"Stubborn Noel Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"id":19278981,"name":"Rock Spidermonkey Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stubborn/Noel/Giraffe/19278981.jpg","createDate":{"time":1357033938000,"minutes":52,"seconds":18,"hours":4,"month":0,"timezoneOffset":300,"year":113,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stubborn/Noel/Giraffe/19278981.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33147,"difficulty":2.515071118879844,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":68415,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.517798,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shrewd Stanley Sunset","authId":"","name":"Shrewd Stanley Sunset","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shrewd Stanley Sunset","authId":"","name":"Shrewd Stanley Sunset","CNNId":"","myGameChains":null,"banStatus":null},"id":19197331,"name":"Universe Chill Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shrewd/Stanley/Sunset/19197331.jpg","createDate":{"time":1356534747000,"minutes":12,"seconds":27,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shrewd/Stanley/Sunset/19197331.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5106,"difficulty":1.8514506385219844,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":103142,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.462667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Bill Neptune","authId":"","name":"Organic Bill Neptune","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Organic Bill Neptune","authId":"","name":"Organic Bill Neptune","CNNId":"","myGameChains":null,"banStatus":null},"id":17535206,"name":"Beast Big Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Organic/Bill/Neptune/17535206.jpg","createDate":{"time":1348107923000,"minutes":25,"seconds":23,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Organic/Bill/Neptune/17535206.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":76263,"difficulty":2.0016655613000482,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":361041,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":2.441203,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Buford Blast","authId":"","name":"Quirky Buford Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Quirky Buford Blast","authId":"","name":"Quirky Buford Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":19250271,"name":"Plumber Sonic Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Quirky/Buford/Blast/19250271.jpg","createDate":{"time":1356855443000,"minutes":17,"seconds":23,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Quirky/Buford/Blast/19250271.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5293,"difficulty":1.6043887377265327,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":120482,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.430756,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Adam Aardvark","authId":"","name":"Prolific Adam Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prolific Adam Aardvark","authId":"","name":"Prolific Adam Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":17681366,"name":"Nitro Burst Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prolific/Adam/Aardvark/17681366.jpg","createDate":{"time":1348369120000,"minutes":58,"seconds":40,"hours":22,"month":8,"timezoneOffset":240,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prolific/Adam/Aardvark/17681366.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35356,"difficulty":2.274495013851522,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":82972,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.407227,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sinister Bethany Turtle","authId":"","name":"Sinister Bethany Turtle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sinister Bethany Turtle","authId":"","name":"Sinister Bethany Turtle","CNNId":"","myGameChains":null,"banStatus":null},"id":18241756,"name":"Robot Assault Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sinister/Bethany/Turtle/18241756.jpg","createDate":{"time":1350936919000,"minutes":15,"seconds":19,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":1,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sinister/Bethany/Turtle/18241756.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8887,"difficulty":1.8578646448419573,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":80120,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.348011,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Lawrence Jamboree","authId":"","name":"Infamous Lawrence Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Lawrence Jamboree","authId":"","name":"Infamous Lawrence Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":18675499,"name":"Power Shock Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infamous/Lawrence/Jamboree/18675499.jpg","createDate":{"time":1354543551000,"minutes":5,"seconds":51,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infamous/Lawrence/Jamboree/18675499.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":23199,"difficulty":1.320543294929432,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":148948,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.340625,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"181","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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]