[{"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":"Daring Daniel Prism","authId":"","name":"Daring Daniel Prism","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Daring Daniel Prism","authId":"","name":"Daring Daniel Prism","CNNId":"","myGameChains":null,"banStatus":null},"id":13768397,"name":"Water Target Rampage","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Daring/Daniel/Prism/13768397.jpg","createDate":{"time":1281832012000,"minutes":26,"seconds":52,"hours":20,"month":7,"timezoneOffset":240,"year":110,"day":6,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Daring/Daniel/Prism/13768397.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":39,"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":"Shady Isaiah Cipher","authId":"","name":"Shady Isaiah Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shady Isaiah Cipher","authId":"","name":"Shady Isaiah Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":13768744,"name":"Burst Adventure Streak","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shady/Isaiah/Cipher/13768744.jpg","createDate":{"time":1281834029000,"minutes":0,"seconds":29,"hours":21,"month":7,"timezoneOffset":240,"year":110,"day":6,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shady/Isaiah/Cipher/13768744.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27,"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":"Crafty Trinity Chutney","authId":"","name":"Crafty Trinity Chutney","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Crafty Trinity Chutney","authId":"","name":"Crafty Trinity Chutney","CNNId":"","myGameChains":null,"banStatus":null},"id":13814768,"name":"Razor Beast Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Crafty/Trinity/Chutney/13814768.jpg","createDate":{"time":1282328851000,"minutes":27,"seconds":31,"hours":14,"month":7,"timezoneOffset":240,"year":110,"day":5,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Crafty/Trinity/Chutney/13814768.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":231,"difficulty":2.5944444444444446,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2116,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.4375,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Adam Zinger","authId":"","name":"Speedy Adam Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Speedy Adam Zinger","authId":"","name":"Speedy Adam Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":13918869,"name":"Metal Nova Slam","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Speedy/Adam/Zinger/13918869.jpg","createDate":{"time":1283793157000,"minutes":12,"seconds":37,"hours":13,"month":8,"timezoneOffset":240,"year":110,"day":1,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Speedy/Adam/Zinger/13918869.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6648,"difficulty":1.8194554997682661,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":18305,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7,"rating":3.669856,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Ed Phantom","authId":"","name":"Elegant Ed Phantom","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Elegant Ed Phantom","authId":"","name":"Elegant Ed Phantom","CNNId":"","myGameChains":null,"banStatus":null},"id":13990727,"name":"Ultimate Waterhazard Mission","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Elegant/Ed/Phantom/13990727.jpg","createDate":{"time":1285580405000,"minutes":40,"seconds":5,"hours":5,"month":8,"timezoneOffset":240,"year":110,"day":1,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Elegant/Ed/Phantom/13990727.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":108,"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":"Abstract Jackson Acorn","authId":"","name":"Abstract Jackson Acorn","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Abstract Jackson Acorn","authId":"","name":"Abstract Jackson Acorn","CNNId":"","myGameChains":null,"banStatus":null},"id":14058197,"name":"Mission Assault Force","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Abstract/Jackson/Acorn/14058197.jpg","createDate":{"time":1286843374000,"minutes":29,"seconds":34,"hours":20,"month":9,"timezoneOffset":240,"year":110,"day":1,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Abstract/Jackson/Acorn/14058197.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":56,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1231,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Lloyd Basilisk","authId":"","name":"Nifty Lloyd Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Nifty Lloyd Basilisk","authId":"","name":"Nifty Lloyd Basilisk","CNNId":"","myGameChains":null,"banStatus":null},"id":14068437,"name":"Ultimate Siege Titan","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Nifty/Lloyd/Basilisk/14068437.jpg","createDate":{"time":1287097841000,"minutes":10,"seconds":41,"hours":19,"month":9,"timezoneOffset":240,"year":110,"day":4,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Nifty/Lloyd/Basilisk/14068437.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":51,"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":"Wondrous Oscar Wiffle","authId":"","name":"Wondrous Oscar Wiffle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Oscar Wiffle","authId":"","name":"Wondrous Oscar Wiffle","CNNId":"","myGameChains":null,"banStatus":null},"id":14214816,"name":"Ultimate Alien Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wondrous/Oscar/Wiffle/14214816.jpg","createDate":{"time":1290453356000,"minutes":15,"seconds":56,"hours":14,"month":10,"timezoneOffset":300,"year":110,"day":1,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wondrous/Oscar/Wiffle/14214816.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":216,"difficulty":1.2222222222222223,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":378,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Hunter Mastodon","authId":"","name":"Infamous Hunter Mastodon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Infamous Hunter Mastodon","authId":"","name":"Infamous Hunter Mastodon","CNNId":"","myGameChains":null,"banStatus":null},"id":14268012,"name":"Giga Shock Galaxy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Infamous/Hunter/Mastodon/14268012.jpg","createDate":{"time":1290566248000,"minutes":37,"seconds":28,"hours":21,"month":10,"timezoneOffset":300,"year":110,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Infamous/Hunter/Mastodon/14268012.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":65,"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":"Clever Shawn Bongo","authId":"","name":"Clever Shawn Bongo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Clever Shawn Bongo","authId":"","name":"Clever Shawn Bongo","CNNId":"","myGameChains":null,"banStatus":null},"id":14330794,"name":"Patrol Universe Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Clever/Shawn/Bongo/14330794.jpg","createDate":{"time":1290714420000,"minutes":47,"seconds":0,"hours":14,"month":10,"timezoneOffset":300,"year":110,"day":4,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Clever/Shawn/Bongo/14330794.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":5,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":116,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"131","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":"140","currentPageToDisplay":14,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]