[{"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":"Magical Franklin Maestro","authId":"","name":"Magical Franklin Maestro","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magical Franklin Maestro","authId":"","name":"Magical Franklin Maestro","CNNId":"","myGameChains":null,"banStatus":null},"id":15249438,"name":"Spark Titan Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magical/Franklin/Maestro/15249438.jpg","createDate":{"time":1298125934000,"minutes":32,"seconds":14,"hours":9,"month":1,"timezoneOffset":300,"year":111,"day":6,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magical/Franklin/Maestro/15249438.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4146,"difficulty":2.0147028740554376,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":38627,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":12,"rating":2.50822,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Joshua Amoeba","authId":"","name":"Reckless Joshua Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Reckless Joshua Amoeba","authId":"","name":"Reckless Joshua Amoeba","CNNId":"","myGameChains":null,"banStatus":null},"id":15282043,"name":"Spidermonkey Razor Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Reckless/Joshua/Amoeba/15282043.jpg","createDate":{"time":1298516677000,"minutes":4,"seconds":37,"hours":22,"month":1,"timezoneOffset":300,"year":111,"day":3,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Reckless/Joshua/Amoeba/15282043.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":20,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":117,"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":"Ultimate Simon Tiger","authId":"","name":"Ultimate Simon Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Ultimate Simon Tiger","authId":"","name":"Ultimate Simon Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":15369829,"name":"Quake Burst Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Ultimate/Simon/Tiger/15369829.jpg","createDate":{"time":1299477394000,"minutes":56,"seconds":34,"hours":0,"month":2,"timezoneOffset":300,"year":111,"day":1,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Ultimate/Simon/Tiger/15369829.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":43,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":406,"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":"Gross John Buckaroo","authId":"","name":"Gross John Buckaroo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Gross John Buckaroo","authId":"","name":"Gross John Buckaroo","CNNId":"","myGameChains":null,"banStatus":null},"id":15388055,"name":"Plasma Adventure Fury","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Gross/John/Buckaroo/15388055.jpg","createDate":{"time":1299769482000,"minutes":4,"seconds":42,"hours":10,"month":2,"timezoneOffset":300,"year":111,"day":4,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Gross/John/Buckaroo/15388055.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":47,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":91,"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":"Admiral Oscar Tiger","authId":"","name":"Admiral Oscar Tiger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Oscar Tiger","authId":"","name":"Admiral Oscar Tiger","CNNId":"","myGameChains":null,"banStatus":null},"id":15494561,"name":"Star Solar Ambush","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Oscar/Tiger/15494561.jpg","createDate":{"time":1301278070000,"minutes":7,"seconds":50,"hours":22,"month":2,"timezoneOffset":240,"year":111,"day":0,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Oscar/Tiger/15494561.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":698,"difficulty":2.311111111111111,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":944,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.254464,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Foul Lily Apple","authId":"","name":"Foul Lily Apple","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Foul Lily Apple","authId":"","name":"Foul Lily Apple","CNNId":"","myGameChains":null,"banStatus":null},"id":15522109,"name":"Cosmic Droid Chase","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Foul/Lily/Apple/15522109.jpg","createDate":{"time":1301873838000,"minutes":37,"seconds":18,"hours":19,"month":3,"timezoneOffset":240,"year":111,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Foul/Lily/Apple/15522109.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":526,"difficulty":2.368707482993197,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2013,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.14,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Calvin Whale","authId":"","name":"Stinky Calvin Whale","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Stinky Calvin Whale","authId":"","name":"Stinky Calvin Whale","CNNId":"","myGameChains":null,"banStatus":null},"id":15527189,"name":"Ultimate Rampage Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Stinky/Calvin/Whale/15527189.jpg","createDate":{"time":1302024769000,"minutes":32,"seconds":49,"hours":13,"month":3,"timezoneOffset":240,"year":111,"day":2,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Stinky/Calvin/Whale/15527189.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":36,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65,"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":"Admiral Ashton Blast","authId":"","name":"Admiral Ashton Blast","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Admiral Ashton Blast","authId":"","name":"Admiral Ashton Blast","CNNId":"","myGameChains":null,"banStatus":null},"id":15594936,"name":"Jetray Danger Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Admiral/Ashton/Blast/15594936.jpg","createDate":{"time":1303416985000,"minutes":16,"seconds":25,"hours":16,"month":3,"timezoneOffset":240,"year":111,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Admiral/Ashton/Blast/15594936.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":251,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":392,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.555556,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Cunning Ethan Bingo","authId":"","name":"Cunning Ethan Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Cunning Ethan Bingo","authId":"","name":"Cunning Ethan Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":15610216,"name":"Whirlwind Nova Cannonbolt","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Cunning/Ethan/Bingo/15610216.jpg","createDate":{"time":1303748972000,"minutes":29,"seconds":32,"hours":12,"month":3,"timezoneOffset":240,"year":111,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Cunning/Ethan/Bingo/15610216.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":83,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Geoff Concrete","authId":"","name":"Hyper Geoff Concrete","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Hyper Geoff Concrete","authId":"","name":"Hyper Geoff Concrete","CNNId":"","myGameChains":null,"banStatus":null},"id":15611157,"name":"Slam Storm Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Hyper/Geoff/Concrete/15611157.jpg","createDate":{"time":1303769474000,"minutes":11,"seconds":14,"hours":18,"month":3,"timezoneOffset":240,"year":111,"day":1,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Hyper/Geoff/Concrete/15611157.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":31,"difficulty":2.3333333333333335,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":252,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.666667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"151","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":"160","currentPageToDisplay":16,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]