[{"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":"Honest Lillian Foul","authId":"","name":"Honest Lillian Foul","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Honest Lillian Foul","authId":"","name":"Honest Lillian Foul","CNNId":"","myGameChains":null,"banStatus":null},"id":16338574,"name":"Cosmic Energy Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Honest/Lillian/Foul/16338574.jpg","createDate":{"time":1320795514000,"minutes":38,"seconds":34,"hours":18,"month":10,"timezoneOffset":300,"year":111,"day":2,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Honest/Lillian/Foul/16338574.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72,"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":"Curious Justin Alien","authId":"","name":"Curious Justin Alien","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Justin Alien","authId":"","name":"Curious Justin Alien","CNNId":"","myGameChains":null,"banStatus":null},"id":16401486,"name":"Cosmic Shadow Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Justin/Alien/16401486.jpg","createDate":{"time":1322141319000,"minutes":28,"seconds":39,"hours":8,"month":10,"timezoneOffset":300,"year":111,"day":4,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Justin/Alien/16401486.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2642,"difficulty":1.3151785714285713,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5194,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.598922,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Caden Doodle","authId":"","name":"Super Caden Doodle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Super Caden Doodle","authId":"","name":"Super Caden Doodle","CNNId":"","myGameChains":null,"banStatus":null},"id":16557404,"name":"Rocket Hyper Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Super/Caden/Doodle/16557404.jpg","createDate":{"time":1325197585000,"minutes":26,"seconds":25,"hours":17,"month":11,"timezoneOffset":300,"year":111,"day":4,"date":29},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Super/Caden/Doodle/16557404.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":105,"difficulty":2.91996151996152,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4902,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.379487,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Ryan Mummy","authId":"","name":"Radical Ryan Mummy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Radical Ryan Mummy","authId":"","name":"Radical Ryan Mummy","CNNId":"","myGameChains":null,"banStatus":null},"id":16595982,"name":"Dark Shadow Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Radical/Ryan/Mummy/16595982.jpg","createDate":{"time":1326045312000,"minutes":55,"seconds":12,"hours":12,"month":0,"timezoneOffset":300,"year":112,"day":0,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Radical/Ryan/Mummy/16595982.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1631,"difficulty":1.5442176870748299,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2005,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.98,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Joshua Buckaroo","authId":"","name":"Gorgeous Joshua Buckaroo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gorgeous Joshua Buckaroo","authId":"","name":"Gorgeous Joshua Buckaroo","CNNId":"","myGameChains":null,"banStatus":null},"id":16619735,"name":"Power Fusion Rush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gorgeous/Joshua/Buckaroo/16619735.jpg","createDate":{"time":1326736704000,"minutes":58,"seconds":24,"hours":12,"month":0,"timezoneOffset":300,"year":112,"day":1,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gorgeous/Joshua/Buckaroo/16619735.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1277,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Scurvy Dominic Cosmos","authId":"","name":"Scurvy Dominic Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scurvy Dominic Cosmos","authId":"","name":"Scurvy Dominic Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":16687942,"name":"Spark Pulse Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scurvy/Dominic/Cosmos/16687942.jpg","createDate":{"time":1328654787000,"minutes":46,"seconds":27,"hours":17,"month":1,"timezoneOffset":300,"year":112,"day":2,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scurvy/Dominic/Cosmos/16687942.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":58,"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":"Grubby Hercules Scout","authId":"","name":"Grubby Hercules Scout","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grubby Hercules Scout","authId":"","name":"Grubby Hercules Scout","CNNId":"","myGameChains":null,"banStatus":null},"id":16856402,"name":"Mega Storm Spike","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grubby/Hercules/Scout/16856402.jpg","createDate":{"time":1333090725000,"minutes":58,"seconds":45,"hours":2,"month":2,"timezoneOffset":240,"year":112,"day":5,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grubby/Hercules/Scout/16856402.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":52,"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":"Gruesome Rachel Quasar","authId":"","name":"Gruesome Rachel Quasar","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gruesome Rachel Quasar","authId":"","name":"Gruesome Rachel Quasar","CNNId":"","myGameChains":null,"banStatus":null},"id":16912509,"name":"Fire Fire Solar","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gruesome/Rachel/Quasar/16912509.jpg","createDate":{"time":1334110136000,"minutes":8,"seconds":56,"hours":22,"month":3,"timezoneOffset":240,"year":112,"day":2,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gruesome/Rachel/Quasar/16912509.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":106,"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":"Classic Cindy Ballyhoo","authId":"","name":"Classic Cindy Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Classic Cindy Ballyhoo","authId":"","name":"Classic Cindy Ballyhoo","CNNId":"","myGameChains":null,"banStatus":null},"id":16913060,"name":"Droid Nano Sonic","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Classic/Cindy/Ballyhoo/16913060.jpg","createDate":{"time":1334130153000,"minutes":42,"seconds":33,"hours":3,"month":3,"timezoneOffset":240,"year":112,"day":3,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Classic/Cindy/Ballyhoo/16913060.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":491,"difficulty":2.361111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1490,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.636111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Seth Mars","authId":"","name":"Awful Seth Mars","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Seth Mars","authId":"","name":"Awful Seth Mars","CNNId":"","myGameChains":null,"banStatus":null},"id":16965467,"name":"Titan Adventure Nitro","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awful/Seth/Mars/16965467.jpg","createDate":{"time":1335315492000,"minutes":58,"seconds":12,"hours":20,"month":3,"timezoneOffset":240,"year":112,"day":2,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awful/Seth/Mars/16965467.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":87,"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":"181","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":"190","currentPageToDisplay":19,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]