[{"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":"Barbaric Aaliyah Magician","authId":"","name":"Barbaric Aaliyah Magician","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Aaliyah Magician","authId":"","name":"Barbaric Aaliyah Magician","CNNId":"","myGameChains":null,"banStatus":null},"id":19413110,"name":"Rocket Assault Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Barbaric/Aaliyah/Magician/19413110.jpg","createDate":{"time":1358668068000,"minutes":47,"seconds":48,"hours":2,"month":0,"timezoneOffset":300,"year":113,"day":0,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Barbaric/Aaliyah/Magician/19413110.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2390,"difficulty":1.730009832548183,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72900,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.589851,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Rick Zing","authId":"","name":"Sparkly Rick Zing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sparkly Rick Zing","authId":"","name":"Sparkly Rick Zing","CNNId":"","myGameChains":null,"banStatus":null},"id":19311725,"name":"Lightning Adventure Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sparkly/Rick/Zing/19311725.jpg","createDate":{"time":1357303447000,"minutes":44,"seconds":7,"hours":7,"month":0,"timezoneOffset":300,"year":113,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sparkly/Rick/Zing/19311725.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":46763,"difficulty":1.3866879382940789,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56793,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.582635,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Jordan Gargoyle","authId":"","name":"Galactic Jordan Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Galactic Jordan Gargoyle","authId":"","name":"Galactic Jordan Gargoyle","CNNId":"","myGameChains":null,"banStatus":null},"id":18071225,"name":"Power Pulse Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Galactic/Jordan/Gargoyle/18071225.jpg","createDate":{"time":1349827114000,"minutes":58,"seconds":34,"hours":19,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Galactic/Jordan/Gargoyle/18071225.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33691,"difficulty":2.747086972358474,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":57623,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":2.565092,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Smart Rex Apple","authId":"","name":"Smart Rex Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Smart Rex Apple","authId":"","name":"Smart Rex Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":17785333,"name":"Battle Ben Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Smart/Rex/Apple/17785333.jpg","createDate":{"time":1348694962000,"minutes":29,"seconds":22,"hours":17,"month":8,"timezoneOffset":240,"year":112,"day":3,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Smart/Rex/Apple/17785333.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":186454,"difficulty":1.2797770604702645,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":349717,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.549536,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Hunter Zinger","authId":"","name":"Stout Hunter Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stout Hunter Zinger","authId":"","name":"Stout Hunter Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":18264843,"name":"Adventure Rampage Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stout/Hunter/Zinger/18264843.jpg","createDate":{"time":1351202244000,"minutes":57,"seconds":24,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stout/Hunter/Zinger/18264843.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14429,"difficulty":1.9471477506146715,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":97559,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":2.502292,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Ezekiel Figment","authId":"","name":"Leaping Ezekiel Figment","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Ezekiel Figment","authId":"","name":"Leaping Ezekiel Figment","CNNId":"","myGameChains":null,"banStatus":null},"id":19759479,"name":"Iron Adventure Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Leaping/Ezekiel/Figment/19759479.jpg","createDate":{"time":1363431868000,"minutes":4,"seconds":28,"hours":7,"month":2,"timezoneOffset":240,"year":113,"day":6,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Leaping/Ezekiel/Figment/19759479.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":30166,"difficulty":2.571367384530222,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":120646,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":2.501992,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Shane Vortex","authId":"","name":"Shaggy Shane Vortex","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shaggy Shane Vortex","authId":"","name":"Shaggy Shane Vortex","CNNId":"","myGameChains":null,"banStatus":null},"id":19435931,"name":"Attack Light Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shaggy/Shane/Vortex/19435931.jpg","createDate":{"time":1358994309000,"minutes":25,"seconds":9,"hours":21,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shaggy/Shane/Vortex/19435931.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":28099,"difficulty":2.4400442451092825,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50308,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.466929,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Vern Jungle","authId":"","name":"Hectic Vern Jungle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hectic Vern Jungle","authId":"","name":"Hectic Vern Jungle","CNNId":"","myGameChains":null,"banStatus":null},"id":19854337,"name":"Sonic Ambush Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hectic/Vern/Jungle/19854337.jpg","createDate":{"time":1363899667000,"minutes":1,"seconds":7,"hours":17,"month":2,"timezoneOffset":240,"year":113,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hectic/Vern/Jungle/19854337.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":58010,"difficulty":1.3316911112391734,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":76577,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.46594,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Laura Warrior","authId":"","name":"Grouchy Laura Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Laura Warrior","authId":"","name":"Grouchy Laura Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":18005081,"name":"Adventure Shock Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grouchy/Laura/Warrior/18005081.jpg","createDate":{"time":1349554612000,"minutes":16,"seconds":52,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grouchy/Laura/Warrior/18005081.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16359,"difficulty":1.7842763564643291,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":62577,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.462714,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Penny Behemoth","authId":"","name":"Gruesome Penny Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Penny Behemoth","authId":"","name":"Gruesome Penny Behemoth","CNNId":"","myGameChains":null,"banStatus":null},"id":18116532,"name":"Hero Steel Ultimate","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Penny/Behemoth/18116532.jpg","createDate":{"time":1350129725000,"minutes":2,"seconds":5,"hours":8,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Penny/Behemoth/18116532.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":33224,"difficulty":1.6752359003152921,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":43468,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.449049,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"171","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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]