[{"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":"Electric Jeffrey Ghost","authId":"","name":"Electric Jeffrey Ghost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Jeffrey Ghost","authId":"","name":"Electric Jeffrey Ghost","CNNId":"","myGameChains":null,"banStatus":null},"id":16129293,"name":"Hex Charge Rustbucket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Jeffrey/Ghost/16129293.jpg","createDate":{"time":1315317459000,"minutes":57,"seconds":39,"hours":9,"month":8,"timezoneOffset":240,"year":111,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Jeffrey/Ghost/16129293.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":261,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":295,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.25,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Perseus Python","authId":"","name":"Regular Perseus Python","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Perseus Python","authId":"","name":"Regular Perseus Python","CNNId":"","myGameChains":null,"banStatus":null},"id":16238225,"name":"Power Giga Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Perseus/Python/16238225.jpg","createDate":{"time":1318601441000,"minutes":10,"seconds":41,"hours":10,"month":9,"timezoneOffset":240,"year":111,"day":5,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Perseus/Python/16238225.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":181,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Madelyn Wolf","authId":"","name":"Acoustic Madelyn Wolf","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Acoustic Madelyn Wolf","authId":"","name":"Acoustic Madelyn Wolf","CNNId":"","myGameChains":null,"banStatus":null},"id":16276570,"name":"Attack Streak Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Acoustic/Madelyn/Wolf/16276570.jpg","createDate":{"time":1319422735000,"minutes":18,"seconds":55,"hours":22,"month":9,"timezoneOffset":240,"year":111,"day":0,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Acoustic/Madelyn/Wolf/16276570.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":3526,"difficulty":2.457501891313612,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6575,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":5,"rating":4.685344,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Angelina Dragoon","authId":"","name":"Jolly Angelina Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Angelina Dragoon","authId":"","name":"Jolly Angelina Dragoon","CNNId":"","myGameChains":null,"banStatus":null},"id":16296443,"name":"Waterhazard Ambush Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Angelina/Dragoon/16296443.jpg","createDate":{"time":1319921256000,"minutes":47,"seconds":36,"hours":16,"month":9,"timezoneOffset":240,"year":111,"day":6,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Angelina/Dragoon/16296443.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":131,"difficulty":1.9131349206349204,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1814,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.288435,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Charles Brick","authId":"","name":"Curious Charles Brick","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Charles Brick","authId":"","name":"Curious Charles Brick","CNNId":"","myGameChains":null,"banStatus":null},"id":16334894,"name":"Dark Pursuit Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Charles/Brick/16334894.jpg","createDate":{"time":1320702602000,"minutes":50,"seconds":2,"hours":16,"month":10,"timezoneOffset":300,"year":111,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Charles/Brick/16334894.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78,"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":"Zany Baxter Amoeba","authId":"","name":"Zany Baxter Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zany Baxter Amoeba","authId":"","name":"Zany Baxter Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"id":16343426,"name":"Plasma Mega Patrol","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zany/Baxter/Amoeba/16343426.jpg","createDate":{"time":1320949738000,"minutes":28,"seconds":58,"hours":13,"month":10,"timezoneOffset":300,"year":111,"day":4,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zany/Baxter/Amoeba/16343426.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1071,"difficulty":1.14421768707483,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2695,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.434259,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Noisy Brittney Aardvark","authId":"","name":"Noisy Brittney Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Noisy Brittney Aardvark","authId":"","name":"Noisy Brittney Aardvark","CNNId":"","myGameChains":null,"banStatus":null},"id":16399948,"name":"Battle Plasma Metal","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Noisy/Brittney/Aardvark/16399948.jpg","createDate":{"time":1322095282000,"minutes":41,"seconds":22,"hours":19,"month":10,"timezoneOffset":300,"year":111,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Noisy/Brittney/Aardvark/16399948.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":107,"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":"Genuine Marcia Ballyhoo","authId":"","name":"Genuine Marcia Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Genuine Marcia Ballyhoo","authId":"","name":"Genuine Marcia Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"id":16520125,"name":"Giga Power Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Genuine/Marcia/Ballyhoo/16520125.jpg","createDate":{"time":1324496192000,"minutes":36,"seconds":32,"hours":14,"month":11,"timezoneOffset":300,"year":111,"day":3,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Genuine/Marcia/Ballyhoo/16520125.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":18,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":169,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":0,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Skylar Giraffe","authId":"","name":"Admiral Skylar Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Skylar Giraffe","authId":"","name":"Admiral Skylar Giraffe","CNNId":"","myGameChains":null,"banStatus":null},"id":16549432,"name":"Slam Earth Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Skylar/Giraffe/16549432.jpg","createDate":{"time":1325043858000,"minutes":44,"seconds":18,"hours":22,"month":11,"timezoneOffset":300,"year":111,"day":2,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Skylar/Giraffe/16549432.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":980,"difficulty":2.1413989125061788,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3054,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.024734,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Jingling Aaron Aviator","authId":"","name":"Jingling Aaron Aviator","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jingling Aaron Aviator","authId":"","name":"Jingling Aaron Aviator","CNNId":"","myGameChains":null,"banStatus":null},"id":16577983,"name":"Charge Storm Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jingling/Aaron/Aviator/16577983.jpg","createDate":{"time":1325573457000,"minutes":50,"seconds":57,"hours":1,"month":0,"timezoneOffset":300,"year":112,"day":2,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jingling/Aaron/Aviator/16577983.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1562,"difficulty":2.3219418989315184,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4205,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.600318,"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.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":"180","currentPageToDisplay":18,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]