[{"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":198,"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":"Alien Jason Zombie","authId":"","name":"Alien Jason Zombie","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Jason Zombie","authId":"","name":"Alien Jason Zombie","CNNId":"","myGameChains":null,"banStatus":null},"id":3636923,"name":"Rumble Spark Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Jason/Zombie/3636923.jpg","createDate":{"time":1213925392000,"minutes":29,"seconds":52,"hours":21,"month":5,"timezoneOffset":240,"year":108,"day":4,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Jason/Zombie/3636923.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":38,"difficulty":2.683842942771514,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":924,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.405957,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Dapper Ace Phantom","authId":"","name":"Dapper Ace Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dapper Ace Phantom","authId":"","name":"Dapper Ace Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":3710640,"name":"Cosmic Alien Escape","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dapper/Ace/Phantom/3710640.jpg","createDate":{"time":1214036440000,"minutes":20,"seconds":40,"hours":4,"month":5,"timezoneOffset":240,"year":108,"day":6,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dapper/Ace/Phantom/3710640.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34,"difficulty":2.4876543209876543,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":689,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.537262,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Gary Mummy","authId":"","name":"Scary Gary Mummy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Gary Mummy","authId":"","name":"Scary Gary Mummy","CNNId":"","myGameChains":null,"banStatus":null},"id":3710650,"name":"Robot Universe Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scary/Gary/Mummy/3710650.jpg","createDate":{"time":1214036695000,"minutes":24,"seconds":55,"hours":4,"month":5,"timezoneOffset":240,"year":108,"day":6,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scary/Gary/Mummy/3710650.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":385,"difficulty":1.0860767704517704,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":975,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.11605,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Jose Tuxedo","authId":"","name":"Curious Jose Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Jose Tuxedo","authId":"","name":"Curious Jose Tuxedo","CNNId":"","myGameChains":null,"banStatus":null},"id":3753500,"name":"Energy Rock Champion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Jose/Tuxedo/3753500.jpg","createDate":{"time":1214086700000,"minutes":18,"seconds":20,"hours":18,"month":5,"timezoneOffset":240,"year":108,"day":6,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Jose/Tuxedo/3753500.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1675,"difficulty":1.4937632378061196,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1839,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.573272,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cosmic Fred Universe","authId":"","name":"Cosmic Fred Universe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cosmic Fred Universe","authId":"","name":"Cosmic Fred Universe","CNNId":"","myGameChains":null,"banStatus":null},"id":3966902,"name":"Sonic Force Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cosmic/Fred/Universe/3966902.jpg","createDate":{"time":1214441109000,"minutes":45,"seconds":9,"hours":20,"month":5,"timezoneOffset":240,"year":108,"day":3,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cosmic/Fred/Universe/3966902.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":53,"difficulty":1.25,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":276,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":1,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Anthony Shark","authId":"","name":"Mighty Anthony Shark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Anthony Shark","authId":"","name":"Mighty Anthony Shark","CNNId":"","myGameChains":null,"banStatus":null},"id":4013027,"name":"Spidermonkey Spike Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mighty/Anthony/Shark/4013027.jpg","createDate":{"time":1214522653000,"minutes":24,"seconds":13,"hours":19,"month":5,"timezoneOffset":240,"year":108,"day":4,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mighty/Anthony/Shark/4013027.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":84,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Purple Scooter Rhino","authId":"","name":"Purple Scooter Rhino","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Purple Scooter Rhino","authId":"","name":"Purple Scooter Rhino","CNNId":"","myGameChains":null,"banStatus":null},"id":4201325,"name":"Steel Lightning Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Purple/Scooter/Rhino/4201325.jpg","createDate":{"time":1214884656000,"minutes":57,"seconds":36,"hours":23,"month":5,"timezoneOffset":240,"year":108,"day":1,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Purple/Scooter/Rhino/4201325.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":39,"difficulty":1.386111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":255,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.383333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Matthew Pinball","authId":"","name":"Mighty Matthew Pinball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Mighty Matthew Pinball","authId":"","name":"Mighty Matthew Pinball","CNNId":"","myGameChains":null,"banStatus":null},"id":4233643,"name":"Swampfire Hero Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Mighty/Matthew/Pinball/4233643.jpg","createDate":{"time":1214948465000,"minutes":41,"seconds":5,"hours":17,"month":6,"timezoneOffset":240,"year":108,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Mighty/Matthew/Pinball/4233643.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":9,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Green Gulliver Sizzle","authId":"","name":"Green Gulliver Sizzle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Green Gulliver Sizzle","authId":"","name":"Green Gulliver Sizzle","CNNId":"","myGameChains":null,"banStatus":null},"id":4412960,"name":"Jetray Hyper Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Green/Gulliver/Sizzle/4412960.jpg","createDate":{"time":1215291950000,"minutes":5,"seconds":50,"hours":17,"month":6,"timezoneOffset":240,"year":108,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Green/Gulliver/Sizzle/4412960.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":70,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Tabitha Bingo","authId":"","name":"Wondrous Tabitha Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Tabitha Bingo","authId":"","name":"Wondrous Tabitha Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":4712264,"name":"Nitro Swampfire Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wondrous/Tabitha/Bingo/4712264.jpg","createDate":{"time":1215835069000,"minutes":57,"seconds":49,"hours":23,"month":6,"timezoneOffset":240,"year":108,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wondrous/Tabitha/Bingo/4712264.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":111,"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":"11","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":"20","currentPageToDisplay":2,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]