[{"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":"Majestic Savannah Planet","authId":"","name":"Majestic Savannah Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Majestic Savannah Planet","authId":"","name":"Majestic Savannah Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":18995218,"name":"Ultimate Steel Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Majestic/Savannah/Planet/18995218.jpg","createDate":{"time":1355558786000,"minutes":6,"seconds":26,"hours":3,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Majestic/Savannah/Planet/18995218.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14410,"difficulty":2.456423238014918,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":113221,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.948307,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Elijah Bonanza","authId":"","name":"Ultimate Elijah Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Elijah Bonanza","authId":"","name":"Ultimate Elijah Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"id":19537857,"name":"Big Chill Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Elijah/Bonanza/19537857.jpg","createDate":{"time":1360799796000,"minutes":56,"seconds":36,"hours":18,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Elijah/Bonanza/19537857.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":162,"difficulty":2.5533202487875513,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":52025,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.935064,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Prince Alexa Jalapeno","authId":"","name":"Prince Alexa Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Prince Alexa Jalapeno","authId":"","name":"Prince Alexa Jalapeno","CNNId":"","myGameChains":null,"banStatus":null},"id":18490827,"name":"Ultimate Ultra Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Prince/Alexa/Jalapeno/18490827.jpg","createDate":{"time":1353066947000,"minutes":55,"seconds":47,"hours":6,"month":10,"timezoneOffset":300,"year":112,"day":5,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Prince/Alexa/Jalapeno/18490827.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33286,"difficulty":2.2781538723089456,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":205095,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.934033,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Kayak","authId":"","name":"Friendly Kayak","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Friendly Kayak","authId":"","name":"Friendly Kayak","CNNId":"","myGameChains":null,"banStatus":null},"id":19120516,"name":"Space Smash Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Friendly/Kayak/19120516.jpg","createDate":{"time":1356156119000,"minutes":1,"seconds":59,"hours":1,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Friendly/Kayak/19120516.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":22103,"difficulty":2.231612127389664,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":243643,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.903918,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Ivan Ghost","authId":"","name":"Enormous Ivan Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Enormous Ivan Ghost","authId":"","name":"Enormous Ivan Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":18346012,"name":"Mega Thunder Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Enormous/Ivan/Ghost/18346012.jpg","createDate":{"time":1351811783000,"minutes":16,"seconds":23,"hours":19,"month":10,"timezoneOffset":240,"year":112,"day":4,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Enormous/Ivan/Ghost/18346012.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18134,"difficulty":2.5219712319033976,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":95139,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.817745,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Gabe Robot","authId":"","name":"Electric Gabe Robot","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Gabe Robot","authId":"","name":"Electric Gabe Robot","CNNId":"","myGameChains":null,"banStatus":null},"id":19974032,"name":"Sonic Siege Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Gabe/Robot/19974032.jpg","createDate":{"time":1364673047000,"minutes":50,"seconds":47,"hours":15,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Gabe/Robot/19974032.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5798,"difficulty":1.834758227744958,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":66585,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.816327,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frosty Sandra Clone","authId":"","name":"Frosty Sandra Clone","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frosty Sandra Clone","authId":"","name":"Frosty Sandra Clone","CNNId":"","myGameChains":null,"banStatus":null},"id":19535503,"name":"Metal Ben Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frosty/Sandra/Clone/19535503.jpg","createDate":{"time":1360771265000,"minutes":1,"seconds":5,"hours":11,"month":1,"timezoneOffset":300,"year":113,"day":3,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frosty/Sandra/Clone/19535503.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21383,"difficulty":2.4127369070717064,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":38516,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.809855,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Vern Grackle","authId":"","name":"Luminous Vern Grackle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Luminous Vern Grackle","authId":"","name":"Luminous Vern Grackle","CNNId":"","myGameChains":null,"banStatus":null},"id":18702417,"name":"Cosmic Robot Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Luminous/Vern/Grackle/18702417.jpg","createDate":{"time":1354644094000,"minutes":1,"seconds":34,"hours":13,"month":11,"timezoneOffset":300,"year":112,"day":2,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Luminous/Vern/Grackle/18702417.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37126,"difficulty":2.409673955004779,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":105620,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.794487,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Bradley Minotaur","authId":"","name":"Regular Bradley Minotaur","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Bradley Minotaur","authId":"","name":"Regular Bradley Minotaur","CNNId":"","myGameChains":null,"banStatus":null},"id":19236412,"name":"Defense Ambush Bloxx","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Bradley/Minotaur/19236412.jpg","createDate":{"time":1356778305000,"minutes":51,"seconds":45,"hours":5,"month":11,"timezoneOffset":300,"year":112,"day":6,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Bradley/Minotaur/19236412.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38448,"difficulty":1.6192750522877952,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65788,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.782483,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Proud Zeke Tiger","authId":"","name":"Proud Zeke Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Proud Zeke Tiger","authId":"","name":"Proud Zeke Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":19946403,"name":"Lightning Storm Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Proud/Zeke/Tiger/19946403.jpg","createDate":{"time":1364508245000,"minutes":4,"seconds":5,"hours":18,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":28},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Proud/Zeke/Tiger/19946403.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3352,"difficulty":2.1716148380511626,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":125446,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.776428,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]