[{"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":200,"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 Dustin Gorilla","authId":"","name":"Alien Dustin Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Dustin Gorilla","authId":"","name":"Alien Dustin Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":1388301,"name":"Earth Titan Alien","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Dustin/Gorilla/1388301.jpg","createDate":{"time":1211111721000,"minutes":55,"seconds":21,"hours":7,"month":4,"timezoneOffset":240,"year":108,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Dustin/Gorilla/1388301.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":84,"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":"Awesome Justin Wizard","authId":"","name":"Awesome Justin Wizard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awesome Justin Wizard","authId":"","name":"Awesome Justin Wizard","CNNId":"","myGameChains":null,"banStatus":null},"id":2989830,"name":"Solar Sonic Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awesome/Justin/Wizard/2989830.jpg","createDate":{"time":1212884311000,"minutes":18,"seconds":31,"hours":20,"month":5,"timezoneOffset":240,"year":108,"day":6,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awesome/Justin/Wizard/2989830.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50,"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":"Silly Shawn Tusk","authId":"","name":"Silly Shawn Tusk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Shawn Tusk","authId":"","name":"Silly Shawn Tusk","CNNId":"","myGameChains":null,"banStatus":null},"id":3058292,"name":"Blaster Pulse Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Shawn/Tusk/3058292.jpg","createDate":{"time":1213020032000,"minutes":0,"seconds":32,"hours":10,"month":5,"timezoneOffset":240,"year":108,"day":1,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Shawn/Tusk/3058292.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":121,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Vincent Squid","authId":"","name":"Zippy Vincent Squid","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Zippy Vincent Squid","authId":"","name":"Zippy Vincent Squid","CNNId":"","myGameChains":null,"banStatus":null},"id":3125549,"name":"Laser Rampage Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Zippy/Vincent/Squid/3125549.jpg","createDate":{"time":1213124852000,"minutes":7,"seconds":32,"hours":15,"month":5,"timezoneOffset":240,"year":108,"day":2,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Zippy/Vincent/Squid/3125549.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":8,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":75,"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":"Shiny Adam Dingbat","authId":"","name":"Shiny Adam Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Adam Dingbat","authId":"","name":"Shiny Adam Dingbat","CNNId":"","myGameChains":null,"banStatus":null},"id":3376084,"name":"Warrior Doom Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Adam/Dingbat/3376084.jpg","createDate":{"time":1213564600000,"minutes":16,"seconds":40,"hours":17,"month":5,"timezoneOffset":240,"year":108,"day":0,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Adam/Dingbat/3376084.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":66,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Robert Mantis","authId":"","name":"Fierce Robert Mantis","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fierce Robert Mantis","authId":"","name":"Fierce Robert Mantis","CNNId":"","myGameChains":null,"banStatus":null},"id":3411243,"name":"Razor Atomic Warp","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fierce/Robert/Mantis/3411243.jpg","createDate":{"time":1213636538000,"minutes":15,"seconds":38,"hours":13,"month":5,"timezoneOffset":240,"year":108,"day":1,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fierce/Robert/Mantis/3411243.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50,"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":"Magnetic Richard Frost","authId":"","name":"Magnetic Richard Frost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Richard Frost","authId":"","name":"Magnetic Richard Frost","CNNId":"","myGameChains":null,"banStatus":null},"id":3421068,"name":"Hero Adventure Universe","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Richard/Frost/3421068.jpg","createDate":{"time":1213644434000,"minutes":27,"seconds":14,"hours":15,"month":5,"timezoneOffset":240,"year":108,"day":1,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Richard/Frost/3421068.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":111,"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":"Bouncing Mitchell Gumshoe","authId":"","name":"Bouncing Mitchell Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bouncing Mitchell Gumshoe","authId":"","name":"Bouncing Mitchell Gumshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":3901816,"name":"Beast Rumble Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bouncing/Mitchell/Gumshoe/3901816.jpg","createDate":{"time":1214334579000,"minutes":9,"seconds":39,"hours":15,"month":5,"timezoneOffset":240,"year":108,"day":2,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bouncing/Mitchell/Gumshoe/3901816.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":120,"difficulty":2.7156001984126985,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3048,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":5.563048,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Timmy Mango","authId":"","name":"Bizarre Timmy Mango","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Timmy Mango","authId":"","name":"Bizarre Timmy Mango","CNNId":"","myGameChains":null,"banStatus":null},"id":4207795,"name":"Ultimate Spidermonkey Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bizarre/Timmy/Mango/4207795.jpg","createDate":{"time":1214922937000,"minutes":35,"seconds":37,"hours":10,"month":6,"timezoneOffset":240,"year":108,"day":2,"date":1},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bizarre/Timmy/Mango/4207795.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":273,"difficulty":1.9932894882726189,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3481,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":5.305689,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Horrid Gladys Goblin","authId":"","name":"Horrid Gladys Goblin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Horrid Gladys Goblin","authId":"","name":"Horrid Gladys Goblin","CNNId":"","myGameChains":null,"banStatus":null},"id":4349864,"name":"Ultra Energy Swampfire","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Horrid/Gladys/Goblin/4349864.jpg","createDate":{"time":1215145012000,"minutes":16,"seconds":52,"hours":0,"month":6,"timezoneOffset":240,"year":108,"day":5,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Horrid/Gladys/Goblin/4349864.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":50,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":235,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":5.166667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"1","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":"10","currentPageToDisplay":1,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]