[{"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":"Wise Orlando Nova","authId":"","name":"Wise Orlando Nova","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wise Orlando Nova","authId":"","name":"Wise Orlando Nova","CNNId":"","myGameChains":null,"banStatus":null},"id":7510534,"name":"Cosmic Fire Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wise/Orlando/Nova/7510534.jpg","createDate":{"time":1228573965000,"minutes":32,"seconds":45,"hours":9,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wise/Orlando/Nova/7510534.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":152,"difficulty":2.7291666666666665,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1507,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.666667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Joseph Fireball","authId":"","name":"Sleepy Joseph Fireball","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Sleepy Joseph Fireball","authId":"","name":"Sleepy Joseph Fireball","CNNId":"","myGameChains":null,"banStatus":null},"id":7510740,"name":"Charge Dark Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Sleepy/Joseph/Fireball/7510740.jpg","createDate":{"time":1228574530000,"minutes":42,"seconds":10,"hours":9,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Sleepy/Joseph/Fireball/7510740.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":13,"difficulty":2.458333333333333,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":115,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.541667,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Dakota Fishbowl","authId":"","name":"Magnetic Dakota Fishbowl","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Magnetic Dakota Fishbowl","authId":"","name":"Magnetic Dakota Fishbowl","CNNId":"","myGameChains":null,"banStatus":null},"id":7626689,"name":"Alien Shadow Lightning","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Magnetic/Dakota/Fishbowl/7626689.jpg","createDate":{"time":1229206693000,"minutes":18,"seconds":13,"hours":17,"month":11,"timezoneOffset":300,"year":108,"day":6,"date":13},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Magnetic/Dakota/Fishbowl/7626689.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":112,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":152,"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":"Massive Tex Wizard","authId":"","name":"Massive Tex Wizard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Massive Tex Wizard","authId":"","name":"Massive Tex Wizard","CNNId":"","myGameChains":null,"banStatus":null},"id":7718397,"name":"Humongousaur Hero Crusher","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Massive/Tex/Wizard/7718397.jpg","createDate":{"time":1229549824000,"minutes":37,"seconds":4,"hours":16,"month":11,"timezoneOffset":300,"year":108,"day":3,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Massive/Tex/Wizard/7718397.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":44,"difficulty":1.4444444444444444,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":313,"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":"Curious Bill Monkey","authId":"","name":"Curious Bill Monkey","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Curious Bill Monkey","authId":"","name":"Curious Bill Monkey","CNNId":"","myGameChains":null,"banStatus":null},"id":7718531,"name":"Steel Brainstorm Stone","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Curious/Bill/Monkey/7718531.jpg","createDate":{"time":1229550097000,"minutes":41,"seconds":37,"hours":16,"month":11,"timezoneOffset":300,"year":108,"day":3,"date":17},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Curious/Bill/Monkey/7718531.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":4,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72,"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":"Leaping Ariana Cipher","authId":"","name":"Leaping Ariana Cipher","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Leaping Ariana Cipher","authId":"","name":"Leaping Ariana Cipher","CNNId":"","myGameChains":null,"banStatus":null},"id":7935259,"name":"Hex Crusher Search","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Leaping/Ariana/Cipher/7935259.jpg","createDate":{"time":1230073750000,"minutes":9,"seconds":10,"hours":18,"month":11,"timezoneOffset":300,"year":108,"day":2,"date":23},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Leaping/Ariana/Cipher/7935259.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27,"difficulty":1.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":63,"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":"Scary Kevin Gizmo","authId":"","name":"Scary Kevin Gizmo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Scary Kevin Gizmo","authId":"","name":"Scary Kevin Gizmo","CNNId":"","myGameChains":null,"banStatus":null},"id":7998244,"name":"Search Challenge Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Scary/Kevin/Gizmo/7998244.jpg","createDate":{"time":1230175314000,"minutes":21,"seconds":54,"hours":22,"month":11,"timezoneOffset":300,"year":108,"day":3,"date":24},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Scary/Kevin/Gizmo/7998244.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":154,"difficulty":2.5442170378166082,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3642,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":4.454281,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Frosty Patrick Icicle","authId":"","name":"Frosty Patrick Icicle","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Frosty Patrick Icicle","authId":"","name":"Frosty Patrick Icicle","CNNId":"","myGameChains":null,"banStatus":null},"id":8190859,"name":"Razor Spike Spidermonkey","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Frosty/Patrick/Icicle/8190859.jpg","createDate":{"time":1231047066000,"minutes":31,"seconds":6,"hours":0,"month":0,"timezoneOffset":300,"year":109,"day":0,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Frosty/Patrick/Icicle/8190859.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":14,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":72,"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":"Fearless Jacob Fishbowl","authId":"","name":"Fearless Jacob Fishbowl","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fearless Jacob Fishbowl","authId":"","name":"Fearless Jacob Fishbowl","CNNId":"","myGameChains":null,"banStatus":null},"id":8233396,"name":"Defense Energy Racer","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fearless/Jacob/Fishbowl/8233396.jpg","createDate":{"time":1231378093000,"minutes":28,"seconds":13,"hours":20,"month":0,"timezoneOffset":300,"year":109,"day":3,"date":7},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fearless/Jacob/Fishbowl/8233396.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":450,"difficulty":2.218768881875606,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":2892,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":3.8175,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Julius Gorilla","authId":"","name":"Brave Julius Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brave Julius Gorilla","authId":"","name":"Brave Julius Gorilla","CNNId":"","myGameChains":null,"banStatus":null},"id":8239889,"name":"Energy Force Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brave/Julius/Gorilla/8239889.jpg","createDate":{"time":1231460323000,"minutes":18,"seconds":43,"hours":19,"month":0,"timezoneOffset":300,"year":109,"day":4,"date":8},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brave/Julius/Gorilla/8239889.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":0,"difficulty":1.8571428571428572,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":216,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.714286,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"71","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":"80","currentPageToDisplay":8,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]