[{"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":"Funny Dustin Fuzz","authId":"","name":"Funny Dustin Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Funny Dustin Fuzz","authId":"","name":"Funny Dustin Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"id":7510821,"name":"Crusher Pursuit Dark","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Funny/Dustin/Fuzz/7510821.jpg","createDate":{"time":1228574761000,"minutes":46,"seconds":1,"hours":9,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Funny/Dustin/Fuzz/7510821.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":189,"difficulty":1.4277777777777778,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":209,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.741071,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Emily Kiwi","authId":"","name":"Alien Emily Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Alien Emily Kiwi","authId":"","name":"Alien Emily Kiwi","CNNId":"","myGameChains":null,"banStatus":null},"id":7543644,"name":"Vilgax Shock Drone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Alien/Emily/Kiwi/7543644.jpg","createDate":{"time":1228701457000,"minutes":57,"seconds":37,"hours":20,"month":11,"timezoneOffset":300,"year":108,"day":0,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Alien/Emily/Kiwi/7543644.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":24,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":111,"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":"Ghostly Harry Planet","authId":"","name":"Ghostly Harry Planet","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ghostly Harry Planet","authId":"","name":"Ghostly Harry Planet","CNNId":"","myGameChains":null,"banStatus":null},"id":7575193,"name":"Ultra Spidermonkey Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ghostly/Harry/Planet/7575193.jpg","createDate":{"time":1228956418000,"minutes":46,"seconds":58,"hours":19,"month":11,"timezoneOffset":300,"year":108,"day":3,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ghostly/Harry/Planet/7575193.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51,"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":"Beastly Matt Mammoth","authId":"","name":"Beastly Matt Mammoth","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Matt Mammoth","authId":"","name":"Beastly Matt Mammoth","CNNId":"","myGameChains":null,"banStatus":null},"id":7607752,"name":"Nano Gear Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Beastly/Matt/Mammoth/7607752.jpg","createDate":{"time":1229178787000,"minutes":33,"seconds":7,"hours":9,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Beastly/Matt/Mammoth/7607752.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67,"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":"Cosmic Mario Fuzz","authId":"","name":"Cosmic Mario Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cosmic Mario Fuzz","authId":"","name":"Cosmic Mario Fuzz","CNNId":"","myGameChains":null,"banStatus":null},"id":7633806,"name":"Nova Nova Nova","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cosmic/Mario/Fuzz/7633806.jpg","createDate":{"time":1229216661000,"minutes":4,"seconds":21,"hours":20,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cosmic/Mario/Fuzz/7633806.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":17,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":97,"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":"Beastly Rocky Warthog","authId":"","name":"Beastly Rocky Warthog","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Beastly Rocky Warthog","authId":"","name":"Beastly Rocky Warthog","CNNId":"","myGameChains":null,"banStatus":null},"id":7647332,"name":"Ultimate Charge Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Beastly/Rocky/Warthog/7647332.jpg","createDate":{"time":1229270670000,"minutes":4,"seconds":30,"hours":11,"month":11,"timezoneOffset":300,"year":108,"day":0,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Beastly/Rocky/Warthog/7647332.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":67,"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":"Dramatic Oscar Blade","authId":"","name":"Dramatic Oscar Blade","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dramatic Oscar Blade","authId":"","name":"Dramatic Oscar Blade","CNNId":"","myGameChains":null,"banStatus":null},"id":7647412,"name":"Titan Clash Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dramatic/Oscar/Blade/7647412.jpg","createDate":{"time":1229270779000,"minutes":6,"seconds":19,"hours":11,"month":11,"timezoneOffset":300,"year":108,"day":0,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dramatic/Oscar/Blade/7647412.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":59,"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":"Silly Jake Plankton","authId":"","name":"Silly Jake Plankton","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Silly Jake Plankton","authId":"","name":"Silly Jake Plankton","CNNId":"","myGameChains":null,"banStatus":null},"id":7742562,"name":"Iron Challenge Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Silly/Jake/Plankton/7742562.jpg","createDate":{"time":1229648090000,"minutes":54,"seconds":50,"hours":19,"month":11,"timezoneOffset":300,"year":108,"day":4,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Silly/Jake/Plankton/7742562.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":70,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":74,"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":"Sleek Bianca Eggplant","authId":"","name":"Sleek Bianca Eggplant","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleek Bianca Eggplant","authId":"","name":"Sleek Bianca Eggplant","CNNId":"","myGameChains":null,"banStatus":null},"id":7753636,"name":"Assault Danger Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleek/Bianca/Eggplant/7753636.jpg","createDate":{"time":1229708551000,"minutes":42,"seconds":31,"hours":12,"month":11,"timezoneOffset":300,"year":108,"day":5,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleek/Bianca/Eggplant/7753636.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":10,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":60,"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":"Aquatic Ludwig Aurora","authId":"","name":"Aquatic Ludwig Aurora","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aquatic Ludwig Aurora","authId":"","name":"Aquatic Ludwig Aurora","CNNId":"","myGameChains":null,"banStatus":null},"id":7772663,"name":"Champion Danger Rocket","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aquatic/Ludwig/Aurora/7772663.jpg","createDate":{"time":1229745690000,"minutes":1,"seconds":30,"hours":23,"month":11,"timezoneOffset":300,"year":108,"day":5,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aquatic/Ludwig/Aurora/7772663.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14,"difficulty":2.3125,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":212,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"51","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":"60","currentPageToDisplay":6,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]