[{"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":197,"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":"Fearless Napoleon Cosmos","authId":"","name":"Fearless Napoleon Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Napoleon Cosmos","authId":"","name":"Fearless Napoleon Cosmos","CNNId":"","myGameChains":null,"banStatus":null},"id":10687552,"name":"Dark Hero Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Napoleon/Cosmos/10687552.jpg","createDate":{"time":1250881355000,"minutes":2,"seconds":35,"hours":15,"month":7,"timezoneOffset":240,"year":109,"day":5,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Napoleon/Cosmos/10687552.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":431,"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":"Joyous Leah Ninja","authId":"","name":"Joyous Leah Ninja","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Joyous Leah Ninja","authId":"","name":"Joyous Leah Ninja","CNNId":"","myGameChains":null,"banStatus":null},"id":10695901,"name":"Steel Burst Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Joyous/Leah/Ninja/10695901.jpg","createDate":{"time":1250955027000,"minutes":30,"seconds":27,"hours":11,"month":7,"timezoneOffset":240,"year":109,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Joyous/Leah/Ninja/10695901.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5,"difficulty":2,"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":"Dashing Trinity Marigold","authId":"","name":"Dashing Trinity Marigold","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Dashing Trinity Marigold","authId":"","name":"Dashing Trinity Marigold","CNNId":"","myGameChains":null,"banStatus":null},"id":10736914,"name":"Mission Drone Shock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Dashing/Trinity/Marigold/10736914.jpg","createDate":{"time":1251379850000,"minutes":30,"seconds":50,"hours":9,"month":7,"timezoneOffset":240,"year":109,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Dashing/Trinity/Marigold/10736914.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":2.5555555555555554,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":136,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.111111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Isaiah Gizzard","authId":"","name":"Magnetic Isaiah Gizzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Isaiah Gizzard","authId":"","name":"Magnetic Isaiah Gizzard","CNNId":"","myGameChains":null,"banStatus":null},"id":10851491,"name":"Rescue Beast Ultra","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Isaiah/Gizzard/10851491.jpg","createDate":{"time":1252536639000,"minutes":50,"seconds":39,"hours":18,"month":8,"timezoneOffset":240,"year":109,"day":3,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Isaiah/Gizzard/10851491.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":142,"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":"Towering Dylan Monster","authId":"","name":"Towering Dylan Monster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Towering Dylan Monster","authId":"","name":"Towering Dylan Monster","CNNId":"","myGameChains":null,"banStatus":null},"id":10929159,"name":"Hyper Plumber Pursuit","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Towering/Dylan/Monster/10929159.jpg","createDate":{"time":1253387286000,"minutes":8,"seconds":6,"hours":15,"month":8,"timezoneOffset":240,"year":109,"day":6,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Towering/Dylan/Monster/10929159.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":7,"difficulty":2.25,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":81,"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":"Frantic Julius Frost","authId":"","name":"Frantic Julius Frost","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frantic Julius Frost","authId":"","name":"Frantic Julius Frost","CNNId":"","myGameChains":null,"banStatus":null},"id":11019185,"name":"Rush Blaster Nitro","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frantic/Julius/Frost/11019185.jpg","createDate":{"time":1254289302000,"minutes":41,"seconds":42,"hours":1,"month":8,"timezoneOffset":240,"year":109,"day":3,"date":30},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frantic/Julius/Frost/11019185.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":169,"difficulty":2.8258503401360544,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":387,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.611111,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sublime Cameron Gorgon","authId":"","name":"Sublime Cameron Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sublime Cameron Gorgon","authId":"","name":"Sublime Cameron Gorgon","CNNId":"","myGameChains":null,"banStatus":null},"id":11033195,"name":"Warp Champion Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sublime/Cameron/Gorgon/11033195.jpg","createDate":{"time":1254571355000,"minutes":2,"seconds":35,"hours":8,"month":9,"timezoneOffset":240,"year":109,"day":6,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sublime/Cameron/Gorgon/11033195.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":35,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":94,"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":"Eager Nicole Lobster","authId":"","name":"Eager Nicole Lobster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Eager Nicole Lobster","authId":"","name":"Eager Nicole Lobster","CNNId":"","myGameChains":null,"banStatus":null},"id":11056415,"name":"Vilgax Spike Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Eager/Nicole/Lobster/11056415.jpg","createDate":{"time":1254830311000,"minutes":58,"seconds":31,"hours":7,"month":9,"timezoneOffset":240,"year":109,"day":2,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Eager/Nicole/Lobster/11056415.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":527,"difficulty":2.7422447263778533,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4328,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7,"rating":4.039643,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Jimmy Mummy","authId":"","name":"Twisty Jimmy Mummy","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Jimmy Mummy","authId":"","name":"Twisty Jimmy Mummy","CNNId":"","myGameChains":null,"banStatus":null},"id":11061638,"name":"Rumble Cosmic Attack","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Twisty/Jimmy/Mummy/11061638.jpg","createDate":{"time":1254920566000,"minutes":2,"seconds":46,"hours":9,"month":9,"timezoneOffset":240,"year":109,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Twisty/Jimmy/Mummy/11061638.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2159,"difficulty":1.1418803418803418,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2455,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.214806,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Tommy Ukulele","authId":"","name":"Grouchy Tommy Ukulele","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Tommy Ukulele","authId":"","name":"Grouchy Tommy Ukulele","CNNId":"","myGameChains":null,"banStatus":null},"id":11248249,"name":"Battle Solar Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grouchy/Tommy/Ukulele/11248249.jpg","createDate":{"time":1256989720000,"minutes":48,"seconds":40,"hours":7,"month":9,"timezoneOffset":240,"year":109,"day":6,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grouchy/Tommy/Ukulele/11248249.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":156,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":163,"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":"81","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":"90","currentPageToDisplay":9,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]