[{"getMostPopularThisWeek":{"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":199,"SQLFilter":null,"limitStatement":" AND ROWNUM <= 200","totalRecordsSQL":"Select count(*) as \"FromTheVault.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.status = 1 AND GameStat.timesPlayed >= '50' AND createdate <= SYSDATE-'280' AND Game.id = GameStat.gameid order by dbms_random.value) where rownum <= 200) ORDER BY GAME.createdate ASC ) ","list":[{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Hunter Llama","authId":"","name":"Mumbling Hunter Llama","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mumbling Hunter Llama","authId":"","name":"Mumbling Hunter Llama","CNNId":"","myGameChains":null,"banStatus":null},"id":16902028,"name":"Adventure Shock Techno","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mumbling/Hunter/Llama/16902028.jpg","createDate":{"time":1333906361000,"minutes":32,"seconds":41,"hours":13,"month":3,"timezoneOffset":240,"year":112,"day":0,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mumbling/Hunter/Llama/16902028.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":113,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Subtle Danny Skylark","authId":"","name":"Subtle Danny Skylark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Subtle Danny Skylark","authId":"","name":"Subtle Danny Skylark","CNNId":"","myGameChains":null,"banStatus":null},"id":16966622,"name":"Sonic Warp Gear","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Subtle/Danny/Skylark/16966622.jpg","createDate":{"time":1335371722000,"minutes":35,"seconds":22,"hours":12,"month":3,"timezoneOffset":240,"year":112,"day":3,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Subtle/Danny/Skylark/16966622.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4811,"difficulty":2.414402741902742,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":15768,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":11,"rating":4.130182,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Hazel Crash","authId":"","name":"Electric Hazel Crash","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Hazel Crash","authId":"","name":"Electric Hazel Crash","CNNId":"","myGameChains":null,"banStatus":null},"id":17072606,"name":"Power Mission Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Hazel/Crash/17072606.jpg","createDate":{"time":1338381462000,"minutes":37,"seconds":42,"hours":8,"month":4,"timezoneOffset":240,"year":112,"day":3,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Hazel/Crash/17072606.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":556,"difficulty":2.4004464285714286,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2319,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.424162,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Dylan","authId":"","name":"Fiery Dylan","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fiery Dylan","authId":"","name":"Fiery Dylan","CNNId":"","myGameChains":null,"banStatus":null},"id":17072615,"name":"Ben Target Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fiery/Dylan/17072615.jpg","createDate":{"time":1338381658000,"minutes":40,"seconds":58,"hours":8,"month":4,"timezoneOffset":240,"year":112,"day":3,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fiery/Dylan/17072615.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":298,"difficulty":1.4947658402203856,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3117,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.085556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Romeo Yoyo","authId":"","name":"Famous Romeo Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Famous Romeo Yoyo","authId":"","name":"Famous Romeo Yoyo","CNNId":"","myGameChains":null,"banStatus":null},"id":17095517,"name":"Spidermonkey Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Famous/Romeo/Yoyo/17095517.jpg","createDate":{"time":1338993302000,"minutes":35,"seconds":2,"hours":10,"month":5,"timezoneOffset":240,"year":112,"day":3,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Famous/Romeo/Yoyo/17095517.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2219,"difficulty":1.461168948289162,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":37693,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":18,"rating":2.658888,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Countess Harold Fiddle","authId":"","name":"Countess Harold Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Countess Harold Fiddle","authId":"","name":"Countess Harold Fiddle","CNNId":"","myGameChains":null,"banStatus":null},"id":17140885,"name":"Lightning Beast Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Countess/Harold/Fiddle/17140885.jpg","createDate":{"time":1340169853000,"minutes":24,"seconds":13,"hours":1,"month":5,"timezoneOffset":240,"year":112,"day":3,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Countess/Harold/Fiddle/17140885.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":624,"difficulty":1.9943308201086838,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8014,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.65391,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dazzling Pete Zigzag","authId":"","name":"Dazzling Pete Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dazzling Pete Zigzag","authId":"","name":"Dazzling Pete Zigzag","CNNId":"","myGameChains":null,"banStatus":null},"id":17155014,"name":"Galaxy Earth Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dazzling/Pete/Zigzag/17155014.jpg","createDate":{"time":1340553850000,"minutes":4,"seconds":10,"hours":12,"month":5,"timezoneOffset":240,"year":112,"day":0,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dazzling/Pete/Zigzag/17155014.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":89,"difficulty":1.88,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":960,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"General Robin Warrior","authId":"","name":"General Robin Warrior","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"General Robin Warrior","authId":"","name":"General Robin Warrior","CNNId":"","myGameChains":null,"banStatus":null},"id":17183617,"name":"Laser Fusion Fire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/General/Robin/Warrior/17183617.jpg","createDate":{"time":1341327851000,"minutes":4,"seconds":11,"hours":11,"month":6,"timezoneOffset":240,"year":112,"day":2,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"General/Robin/Warrior/17183617.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":407,"difficulty":2.2278231663035584,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8854,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.568189,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Talented Whit Cosmos","authId":"","name":"Talented Whit Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Talented Whit Cosmos","authId":"","name":"Talented Whit Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":17186972,"name":"Earth Adventure Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Talented/Whit/Cosmos/17186972.jpg","createDate":{"time":1341414915000,"minutes":15,"seconds":15,"hours":11,"month":6,"timezoneOffset":240,"year":112,"day":3,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Talented/Whit/Cosmos/17186972.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":25,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":56,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"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.status = 1 AND GameStat.timesPlayed >= '50' AND createdate <= SYSDATE-'280' AND Game.id = GameStat.gameid order by dbms_random.value) where rownum <= 200) ORDER BY GAME.createdate ASC ","endRecordId":"199","currentPageToDisplay":20,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]