[{"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":"Twisty Jacob Sprout","authId":"","name":"Twisty Jacob Sprout","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Twisty Jacob Sprout","authId":"","name":"Twisty Jacob Sprout","CNNId":"","myGameChains":null,"banStatus":null},"id":15655239,"name":"Giga Shock Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Twisty/Jacob/Sprout/15655239.jpg","createDate":{"time":1305064811000,"minutes":0,"seconds":11,"hours":18,"month":4,"timezoneOffset":240,"year":111,"day":2,"date":10},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Twisty/Jacob/Sprout/15655239.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2510,"difficulty":2.3821447651842718,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":30748,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":11,"rating":4.312134,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Chase Bingo","authId":"","name":"Digital Chase Bingo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Digital Chase Bingo","authId":"","name":"Digital Chase Bingo","CNNId":"","myGameChains":null,"banStatus":null},"id":15663741,"name":"Nitro Fury Fusion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Digital/Chase/Bingo/15663741.jpg","createDate":{"time":1305397101000,"minutes":18,"seconds":21,"hours":14,"month":4,"timezoneOffset":240,"year":111,"day":6,"date":14},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Digital/Chase/Bingo/15663741.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":79,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":88,"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":"Popular Dora Nonsense","authId":"","name":"Popular Dora Nonsense","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Popular Dora Nonsense","authId":"","name":"Popular Dora Nonsense","CNNId":"","myGameChains":null,"banStatus":null},"id":15677864,"name":"Ben Pulse Rock","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Popular/Dora/Nonsense/15677864.jpg","createDate":{"time":1305936906000,"minutes":15,"seconds":6,"hours":20,"month":4,"timezoneOffset":240,"year":111,"day":5,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Popular/Dora/Nonsense/15677864.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":599,"difficulty":2.2006349206349207,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5105,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":4,"rating":3.495671,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Leonardo Gizmo","authId":"","name":"Wondrous Leonardo Gizmo","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Wondrous Leonardo Gizmo","authId":"","name":"Wondrous Leonardo Gizmo","CNNId":"","myGameChains":null,"banStatus":null},"id":15812322,"name":"Dark Techno Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Wondrous/Leonardo/Gizmo/15812322.jpg","createDate":{"time":1308770669000,"minutes":24,"seconds":29,"hours":15,"month":5,"timezoneOffset":240,"year":111,"day":3,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Wondrous/Leonardo/Gizmo/15812322.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":62,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":110,"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":"Strong Oscar Buzzard","authId":"","name":"Strong Oscar Buzzard","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Strong Oscar Buzzard","authId":"","name":"Strong Oscar Buzzard","CNNId":"","myGameChains":null,"banStatus":null},"id":15863974,"name":"Rampage Siege Defense","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Strong/Oscar/Buzzard/15863974.jpg","createDate":{"time":1309644895000,"minutes":14,"seconds":55,"hours":18,"month":6,"timezoneOffset":240,"year":111,"day":6,"date":2},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Strong/Oscar/Buzzard/15863974.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":897,"difficulty":2.4387834387834384,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5108,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.277485,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk CJ Genius","authId":"","name":"Brisk CJ Genius","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brisk CJ Genius","authId":"","name":"Brisk CJ Genius","CNNId":"","myGameChains":null,"banStatus":null},"id":15874254,"name":"Rampage Adventure Laser","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brisk/CJ/Genius/15874254.jpg","createDate":{"time":1309821920000,"minutes":25,"seconds":20,"hours":19,"month":6,"timezoneOffset":240,"year":111,"day":1,"date":4},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brisk/CJ/Genius/15874254.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":16,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":55,"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":"Bizarre Ken Jamboree","authId":"","name":"Bizarre Ken Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Bizarre Ken Jamboree","authId":"","name":"Bizarre Ken Jamboree","CNNId":"","myGameChains":null,"banStatus":null},"id":15935126,"name":"Pursuit Galaxy Energy","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Bizarre/Ken/Jamboree/15935126.jpg","createDate":{"time":1310993425000,"minutes":50,"seconds":25,"hours":8,"month":6,"timezoneOffset":240,"year":111,"day":1,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Bizarre/Ken/Jamboree/15935126.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":39,"difficulty":1.1111111111111112,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":507,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.333333,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Lorenzo Bonanza","authId":"","name":"Rowdy Lorenzo Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Rowdy Lorenzo Bonanza","authId":"","name":"Rowdy Lorenzo Bonanza","CNNId":"","myGameChains":null,"banStatus":null},"id":15941555,"name":"Battle Hero Light","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Rowdy/Lorenzo/Bonanza/15941555.jpg","createDate":{"time":1311116717000,"minutes":5,"seconds":17,"hours":19,"month":6,"timezoneOffset":240,"year":111,"day":2,"date":19},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Rowdy/Lorenzo/Bonanza/15941555.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":54,"difficulty":2.75,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":329,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":2.75,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Ivan Pumpkin","authId":"","name":"Graceful Ivan Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Graceful Ivan Pumpkin","authId":"","name":"Graceful Ivan Pumpkin","CNNId":"","myGameChains":null,"banStatus":null},"id":15948872,"name":"Adventure Dark Beast","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Graceful/Ivan/Pumpkin/15948872.jpg","createDate":{"time":1311286887000,"minutes":21,"seconds":27,"hours":18,"month":6,"timezoneOffset":240,"year":111,"day":4,"date":21},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Graceful/Ivan/Pumpkin/15948872.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":42,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":81,"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":"Brawny Alan Bayou","authId":"","name":"Brawny Alan Bayou","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Brawny Alan Bayou","authId":"","name":"Brawny Alan Bayou","CNNId":"","myGameChains":null,"banStatus":null},"id":16030295,"name":"Warrior Turbo Storm","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Brawny/Alan/Bayou/16030295.jpg","createDate":{"time":1312923800000,"minutes":3,"seconds":20,"hours":17,"month":7,"timezoneOffset":240,"year":111,"day":2,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Brawny/Alan/Bayou/16030295.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":47,"difficulty":2.3660714285714284,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3542,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.976871,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0}],"descending":false,"beginRecordId":"161","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":"170","currentPageToDisplay":17,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]