[{"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 = '2' 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 Josiah Potato","authId":"","name":"Alien Josiah Potato","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Josiah Potato","authId":"","name":"Alien Josiah Potato","CNNId":"","myGameChains":null,"banStatus":null},"id":19988125,"name":"Racer Assault Spark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Josiah/Potato/19988125.jpg","createDate":{"time":1364773825000,"minutes":50,"seconds":25,"hours":19,"month":2,"timezoneOffset":240,"year":113,"day":0,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Josiah/Potato/19988125.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9996,"difficulty":1.3758671531644429,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":16063,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.1403,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Caleb Cosmos","authId":"","name":"Vigilant Caleb Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Vigilant Caleb Cosmos","authId":"","name":"Vigilant Caleb Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":19605759,"name":"Hyper Galaxy Razor","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Vigilant/Caleb/Cosmos/19605759.jpg","createDate":{"time":1361884246000,"minutes":10,"seconds":46,"hours":8,"month":1,"timezoneOffset":300,"year":113,"day":2,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Vigilant/Caleb/Cosmos/19605759.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12364,"difficulty":1.5336161571413787,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":19113,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.116372,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Jonathan Squawk","authId":"","name":"Ghastly Jonathan Squawk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghastly Jonathan Squawk","authId":"","name":"Ghastly Jonathan Squawk","CNNId":"","myGameChains":null,"banStatus":null},"id":18223219,"name":"Battle Shock Cosmic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghastly/Jonathan/Squawk/18223219.jpg","createDate":{"time":1350795196000,"minutes":53,"seconds":16,"hours":0,"month":9,"timezoneOffset":240,"year":112,"day":0,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghastly/Jonathan/Squawk/18223219.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24898,"difficulty":1.201831971267634,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":32724,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.094361,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Igor Calliope","authId":"","name":"Dandy Igor Calliope","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dandy Igor Calliope","authId":"","name":"Dandy Igor Calliope","CNNId":"","myGameChains":null,"banStatus":null},"id":18287737,"name":"Escape Smash Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dandy/Igor/Calliope/18287737.jpg","createDate":{"time":1351358801000,"minutes":26,"seconds":41,"hours":13,"month":9,"timezoneOffset":240,"year":112,"day":6,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dandy/Igor/Calliope/18287737.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3852,"difficulty":2.4001120775841382,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83971,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":2.068525,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Joe Venom","authId":"","name":"Famous Joe Venom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Joe Venom","authId":"","name":"Famous Joe Venom","CNNId":"","myGameChains":null,"banStatus":null},"id":19951950,"name":"Ultimate Spidermonkey Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Joe/Venom/19951950.jpg","createDate":{"time":1364559371000,"minutes":16,"seconds":11,"hours":8,"month":2,"timezoneOffset":240,"year":113,"day":5,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Joe/Venom/19951950.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2995,"difficulty":1.2678124529128774,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5912,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.060956,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Evasive Diego Frog","authId":"","name":"Evasive Diego Frog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Evasive Diego Frog","authId":"","name":"Evasive Diego Frog","CNNId":"","myGameChains":null,"banStatus":null},"id":19472604,"name":"Alien Burst Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Evasive/Diego/Frog/19472604.jpg","createDate":{"time":1359646517000,"minutes":35,"seconds":17,"hours":10,"month":0,"timezoneOffset":300,"year":113,"day":4,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Evasive/Diego/Frog/19472604.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":105,"difficulty":1.9547507978269845,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":41226,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.970596,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Caden Sparkle","authId":"","name":"Loony Caden Sparkle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Loony Caden Sparkle","authId":"","name":"Loony Caden Sparkle","CNNId":"","myGameChains":null,"banStatus":null},"id":19298653,"name":"Adventure Nitro Charge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Loony/Caden/Sparkle/19298653.jpg","createDate":{"time":1357170770000,"minutes":52,"seconds":50,"hours":18,"month":0,"timezoneOffset":300,"year":113,"day":3,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Loony/Caden/Sparkle/19298653.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15272,"difficulty":2.3560903570895366,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":54787,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.93534,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Xerxes Bucket","authId":"","name":"Extreme Xerxes Bucket","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Extreme Xerxes Bucket","authId":"","name":"Extreme Xerxes Bucket","CNNId":"","myGameChains":null,"banStatus":null},"id":18242376,"name":"Rush Power Animo","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Extreme/Xerxes/Bucket/18242376.jpg","createDate":{"time":1350941532000,"minutes":32,"seconds":12,"hours":17,"month":9,"timezoneOffset":240,"year":112,"day":1,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Extreme/Xerxes/Bucket/18242376.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17706,"difficulty":1.16536349047917,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":52056,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":1.680986,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Unusual Madelyn Polka","authId":"","name":"Unusual Madelyn Polka","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Unusual Madelyn Polka","authId":"","name":"Unusual Madelyn Polka","CNNId":"","myGameChains":null,"banStatus":null},"id":19626927,"name":"Metal Adventure Iron","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Unusual/Madelyn/Polka/19626927.jpg","createDate":{"time":1362323224000,"minutes":7,"seconds":4,"hours":10,"month":2,"timezoneOffset":300,"year":113,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Unusual/Madelyn/Polka/19626927.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14172,"difficulty":1.2107587047474542,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":36272,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1.668718,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Scooby Blizzard","authId":"","name":"Colonel Scooby Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Colonel Scooby Blizzard","authId":"","name":"Colonel Scooby Blizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":18249248,"name":"Whirlwind Cosmic Chill","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Colonel/Scooby/Blizzard/18249248.jpg","createDate":{"time":1351025386000,"minutes":49,"seconds":46,"hours":16,"month":9,"timezoneOffset":240,"year":112,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Colonel/Scooby/Blizzard/18249248.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":95736,"difficulty":1.1775667805485577,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":104608,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":1.527679,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"191","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 = '2' 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":"200","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]