[{"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":"Alien Tim Universe","authId":"","name":"Alien Tim Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Tim Universe","authId":"","name":"Alien Tim Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":18102533,"name":"Cosmic Alien Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Tim/Universe/18102533.jpg","createDate":{"time":1350063594000,"minutes":39,"seconds":54,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":5,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Tim/Universe/18102533.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25716,"difficulty":1.9523897887512096,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":161588,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.616976,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Dixie Thunder","authId":"","name":"Blustery Dixie Thunder","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Blustery Dixie Thunder","authId":"","name":"Blustery Dixie Thunder","CNNId":"","myGameChains":null,"banStatus":null},"id":19789315,"name":"Spark Lightning Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Blustery/Dixie/Thunder/19789315.jpg","createDate":{"time":1363519555000,"minutes":25,"seconds":55,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Blustery/Dixie/Thunder/19789315.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7041,"difficulty":2.1898910436574917,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":84399,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.593953,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Countess Lois Tiger","authId":"","name":"Countess Lois Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Countess Lois Tiger","authId":"","name":"Countess Lois Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19611862,"name":"Blaster Breaker Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Countess/Lois/Tiger/19611862.jpg","createDate":{"time":1362049650000,"minutes":7,"seconds":30,"hours":6,"month":1,"timezoneOffset":300,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Countess/Lois/Tiger/19611862.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4845,"difficulty":2.6686270550193503,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45161,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.589963,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Eugene Anvil","authId":"","name":"Crispy Eugene Anvil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crispy Eugene Anvil","authId":"","name":"Crispy Eugene Anvil","CNNId":"","myGameChains":null,"banStatus":null},"id":18224034,"name":"Space Alien Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crispy/Eugene/Anvil/18224034.jpg","createDate":{"time":1350804233000,"minutes":23,"seconds":53,"hours":3,"month":9,"timezoneOffset":240,"year":112,"day":0,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crispy/Eugene/Anvil/18224034.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6145,"difficulty":1.4805570548133364,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":86726,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.540324,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gullible William Kazoo","authId":"","name":"Gullible William Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gullible William Kazoo","authId":"","name":"Gullible William Kazoo","CNNId":"","myGameChains":null,"banStatus":null},"id":19053552,"name":"Rush Stone Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gullible/William/Kazoo/19053552.jpg","createDate":{"time":1355747025000,"minutes":23,"seconds":45,"hours":7,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gullible/William/Kazoo/19053552.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2681,"difficulty":1.3965804350426845,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":39179,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.43767,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Jenna Zeppelin","authId":"","name":"Smelly Jenna Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smelly Jenna Zeppelin","authId":"","name":"Smelly Jenna Zeppelin","CNNId":"","myGameChains":null,"banStatus":null},"id":19102167,"name":"Nano Hyper Turbo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smelly/Jenna/Zeppelin/19102167.jpg","createDate":{"time":1356066453000,"minutes":7,"seconds":33,"hours":0,"month":11,"timezoneOffset":300,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smelly/Jenna/Zeppelin/19102167.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41700,"difficulty":1.9276531922830848,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":138882,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.390411,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Eloquent Collin Apple","authId":"","name":"Eloquent Collin Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eloquent Collin Apple","authId":"","name":"Eloquent Collin Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":17587753,"name":"Droid Gear Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eloquent/Collin/Apple/17587753.jpg","createDate":{"time":1348259395000,"minutes":29,"seconds":55,"hours":16,"month":8,"timezoneOffset":240,"year":112,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eloquent/Collin/Apple/17587753.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4191,"difficulty":2.7391599833736855,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":46143,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.385366,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Shnitzel Tornado","authId":"","name":"Athletic Shnitzel Tornado","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Athletic Shnitzel Tornado","authId":"","name":"Athletic Shnitzel Tornado","CNNId":"","myGameChains":null,"banStatus":null},"id":19145501,"name":"Spark Lightning Atomic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Athletic/Shnitzel/Tornado/19145501.jpg","createDate":{"time":1356256086000,"minutes":48,"seconds":6,"hours":4,"month":11,"timezoneOffset":300,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Athletic/Shnitzel/Tornado/19145501.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16408,"difficulty":1.9644892815507362,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":62275,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.380085,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Bert Splat","authId":"","name":"Grubby Bert Splat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Bert Splat","authId":"","name":"Grubby Bert Splat","CNNId":"","myGameChains":null,"banStatus":null},"id":18707737,"name":"Power Echo Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grubby/Bert/Splat/18707737.jpg","createDate":{"time":1354658615000,"minutes":3,"seconds":35,"hours":17,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grubby/Bert/Splat/18707737.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8863,"difficulty":2.420031178235068,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45561,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.31461,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colorful Gavin Alien","authId":"","name":"Colorful Gavin Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colorful Gavin Alien","authId":"","name":"Colorful Gavin Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":17712787,"name":"Ben Robot Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colorful/Gavin/Alien/17712787.jpg","createDate":{"time":1348426216000,"minutes":50,"seconds":16,"hours":14,"month":8,"timezoneOffset":240,"year":112,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colorful/Gavin/Alien/17712787.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":11639,"difficulty":2.431705568445753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":147687,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.311451,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]