[{"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":"Fuzzy Joshua Acrobat","authId":"","name":"Fuzzy Joshua Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fuzzy Joshua Acrobat","authId":"","name":"Fuzzy Joshua Acrobat","CNNId":"","myGameChains":null,"banStatus":null},"id":18676262,"name":"Search Alien Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fuzzy/Joshua/Acrobat/18676262.jpg","createDate":{"time":1354549845000,"minutes":50,"seconds":45,"hours":10,"month":11,"timezoneOffset":300,"year":112,"day":1,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fuzzy/Joshua/Acrobat/18676262.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10968,"difficulty":2.2234345356462906,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43375,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.680643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Spencer Seagull","authId":"","name":"Hyper Spencer Seagull","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Spencer Seagull","authId":"","name":"Hyper Spencer Seagull","CNNId":"","myGameChains":null,"banStatus":null},"id":19809941,"name":"Racer Chase Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hyper/Spencer/Seagull/19809941.jpg","createDate":{"time":1363561535000,"minutes":5,"seconds":35,"hours":19,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hyper/Spencer/Seagull/19809941.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":41034,"difficulty":1.775090067888934,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45483,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.667373,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Aaron Ricochet","authId":"","name":"Active Aaron Ricochet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Active Aaron Ricochet","authId":"","name":"Active Aaron Ricochet","CNNId":"","myGameChains":null,"banStatus":null},"id":17532655,"name":"Alien Alien Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Active/Aaron/Ricochet/17532655.jpg","createDate":{"time":1348103378000,"minutes":9,"seconds":38,"hours":21,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Active/Aaron/Ricochet/17532655.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20556,"difficulty":2.4492473601975115,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":138796,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.617726,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"King Brittney Cipher","authId":"","name":"King Brittney Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"King Brittney Cipher","authId":"","name":"King Brittney Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":18280936,"name":"Champion Space Breaker","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/King/Brittney/Cipher/18280936.jpg","createDate":{"time":1351320914000,"minutes":55,"seconds":14,"hours":2,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"King/Brittney/Cipher/18280936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36402,"difficulty":2.4983622327320805,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72218,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.597259,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Susannah Snake","authId":"","name":"Sturdy Susannah Snake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sturdy Susannah Snake","authId":"","name":"Sturdy Susannah Snake","CNNId":"","myGameChains":null,"banStatus":null},"id":19445792,"name":"Ambush Rumble Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sturdy/Susannah/Snake/19445792.jpg","createDate":{"time":1359177487000,"minutes":18,"seconds":7,"hours":0,"month":0,"timezoneOffset":300,"year":113,"day":6,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sturdy/Susannah/Snake/19445792.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8933,"difficulty":2.5835849124270953,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":45987,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.590284,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Alvin Ape","authId":"","name":"Visible Alvin Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Visible Alvin Ape","authId":"","name":"Visible Alvin Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":19124380,"name":"Beast Plasma Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Visible/Alvin/Ape/19124380.jpg","createDate":{"time":1356187865000,"minutes":51,"seconds":5,"hours":9,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Visible/Alvin/Ape/19124380.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6527,"difficulty":2.3123550953949494,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":109323,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.581693,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Waldo Dragon","authId":"","name":"Fierce Waldo Dragon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Waldo Dragon","authId":"","name":"Fierce Waldo Dragon","CNNId":"","myGameChains":null,"banStatus":null},"id":19854497,"name":"Solar Animo Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fierce/Waldo/Dragon/19854497.jpg","createDate":{"time":1363900222000,"minutes":10,"seconds":22,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fierce/Waldo/Dragon/19854497.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37961,"difficulty":1.9628053541147874,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":121623,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.581486,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Rex Fox","authId":"","name":"Vigilant Rex Fox","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Rex Fox","authId":"","name":"Vigilant Rex Fox","CNNId":"","myGameChains":null,"banStatus":null},"id":17212383,"name":"Spidermonkey Energy Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Rex/Fox/17212383.jpg","createDate":{"time":1342095704000,"minutes":21,"seconds":44,"hours":8,"month":6,"timezoneOffset":240,"year":112,"day":4,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Rex/Fox/17212383.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":153620,"difficulty":2.463828743028753,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1208962,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":203,"rating":4.564564,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elastic Marco Hacksaw","authId":"","name":"Elastic Marco Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elastic Marco Hacksaw","authId":"","name":"Elastic Marco Hacksaw","CNNId":"","myGameChains":null,"banStatus":null},"id":18556543,"name":"Space Water Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elastic/Marco/Hacksaw/18556543.jpg","createDate":{"time":1353619375000,"minutes":22,"seconds":55,"hours":16,"month":10,"timezoneOffset":300,"year":112,"day":4,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elastic/Marco/Hacksaw/18556543.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38134,"difficulty":1.4370198300243748,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72090,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.5627,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Ben Brick","authId":"","name":"Electric Ben Brick","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Ben Brick","authId":"","name":"Electric Ben Brick","CNNId":"","myGameChains":null,"banStatus":null},"id":18960723,"name":"Fire Fusion Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Ben/Brick/18960723.jpg","createDate":{"time":1355378645000,"minutes":4,"seconds":5,"hours":1,"month":11,"timezoneOffset":300,"year":112,"day":4,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Ben/Brick/18960723.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28796,"difficulty":2.276686166877657,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74659,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.560183,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"21","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":"30","currentPageToDisplay":3,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]