[{"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":198,"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":"Lucky Jose Fossil","authId":"","name":"Lucky Jose Fossil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Lucky Jose Fossil","authId":"","name":"Lucky Jose Fossil","CNNId":"","myGameChains":null,"banStatus":null},"id":11170384,"name":"Rampage Invasion Assault","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Lucky/Jose/Fossil/11170384.jpg","createDate":{"time":1255895516000,"minutes":51,"seconds":56,"hours":15,"month":9,"timezoneOffset":240,"year":109,"day":0,"date":18},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Lucky/Jose/Fossil/11170384.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":50,"difficulty":2.25,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":172,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.5,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Max Blob","authId":"","name":"Roaring Max Blob","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Roaring Max Blob","authId":"","name":"Roaring Max Blob","CNNId":"","myGameChains":null,"banStatus":null},"id":11247985,"name":"Spidermonkey Alien Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Roaring/Max/Blob/11247985.jpg","createDate":{"time":1256985462000,"minutes":37,"seconds":42,"hours":6,"month":9,"timezoneOffset":240,"year":109,"day":6,"date":31},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Roaring/Max/Blob/11247985.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":48,"difficulty":3,"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":"Plucky Diego Lavender","authId":"","name":"Plucky Diego Lavender","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Plucky Diego Lavender","authId":"","name":"Plucky Diego Lavender","CNNId":"","myGameChains":null,"banStatus":null},"id":11498097,"name":"Star Dark Earth","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Plucky/Diego/Lavender/11498097.jpg","createDate":{"time":1260120613000,"minutes":30,"seconds":13,"hours":12,"month":11,"timezoneOffset":300,"year":109,"day":0,"date":6},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Plucky/Diego/Lavender/11498097.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":1162,"difficulty":2.6734122993926914,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":4087,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":4.067071,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Goliath Nonsense","authId":"","name":"Grouchy Goliath Nonsense","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Grouchy Goliath Nonsense","authId":"","name":"Grouchy Goliath Nonsense","CNNId":"","myGameChains":null,"banStatus":null},"id":11525828,"name":"Ultra Slam Shadow","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Grouchy/Goliath/Nonsense/11525828.jpg","createDate":{"time":1260588135000,"minutes":22,"seconds":15,"hours":22,"month":11,"timezoneOffset":300,"year":109,"day":5,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Grouchy/Goliath/Nonsense/11525828.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":37,"difficulty":2.375,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":608,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":3.75,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Angel Orbit","authId":"","name":"Aromatic Angel Orbit","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Aromatic Angel Orbit","authId":"","name":"Aromatic Angel Orbit","CNNId":"","myGameChains":null,"banStatus":null},"id":11679676,"name":"Jetray Hero Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Aromatic/Angel/Orbit/11679676.jpg","createDate":{"time":1262528983000,"minutes":29,"seconds":43,"hours":9,"month":0,"timezoneOffset":300,"year":110,"day":0,"date":3},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Aromatic/Angel/Orbit/11679676.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":368,"difficulty":2.365307055472815,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":5561,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"rating":4.823073,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Antonio Virtuoso","authId":"","name":"Shiny Antonio Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Antonio Virtuoso","authId":"","name":"Shiny Antonio Virtuoso","CNNId":"","myGameChains":null,"banStatus":null},"id":11739189,"name":"Force Charge Rescue","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Antonio/Virtuoso/11739189.jpg","createDate":{"time":1263557298000,"minutes":8,"seconds":18,"hours":7,"month":0,"timezoneOffset":300,"year":110,"day":5,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Antonio/Virtuoso/11739189.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":15,"difficulty":2.6,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":964,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3.628571,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Fanciful Wilford Zing","authId":"","name":"Fanciful Wilford Zing","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Fanciful Wilford Zing","authId":"","name":"Fanciful Wilford Zing","CNNId":"","myGameChains":null,"banStatus":null},"id":11926087,"name":"Sonic Slam Thunder","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Fanciful/Wilford/Zing/11926087.jpg","createDate":{"time":1266359351000,"minutes":29,"seconds":11,"hours":17,"month":1,"timezoneOffset":300,"year":110,"day":2,"date":16},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Fanciful/Wilford/Zing/11926087.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":154,"difficulty":2.6,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1387,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4.553741,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Zeus Amethyst","authId":"","name":"Barbaric Zeus Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Barbaric Zeus Amethyst","authId":"","name":"Barbaric Zeus Amethyst","CNNId":"","myGameChains":null,"banStatus":null},"id":11944164,"name":"Streak Sonic Battle","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Barbaric/Zeus/Amethyst/11944164.jpg","createDate":{"time":1266684205000,"minutes":43,"seconds":25,"hours":11,"month":1,"timezoneOffset":300,"year":110,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Barbaric/Zeus/Amethyst/11944164.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":343,"difficulty":2.320634920634921,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":8160,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7,"rating":3.812286,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Bridgette Tsunami","authId":"","name":"Witty Bridgette Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Witty Bridgette Tsunami","authId":"","name":"Witty Bridgette Tsunami","CNNId":"","myGameChains":null,"banStatus":null},"id":11948099,"name":"Escape Attack Space","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Witty/Bridgette/Tsunami/11948099.jpg","createDate":{"time":1266713997000,"minutes":59,"seconds":57,"hours":19,"month":1,"timezoneOffset":300,"year":110,"day":6,"date":20},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Witty/Bridgette/Tsunami/11948099.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":12,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":554,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":0,"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":"Jolly Hugo Rooster","authId":"","name":"Jolly Hugo Rooster","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Jolly Hugo Rooster","authId":"","name":"Jolly Hugo Rooster","CNNId":"","myGameChains":null,"banStatus":null},"id":12129488,"name":"Brainstorm Iron Warrior","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Jolly/Hugo/Rooster/12129488.jpg","createDate":{"time":1269652458000,"minutes":14,"seconds":18,"hours":21,"month":2,"timezoneOffset":240,"year":110,"day":5,"date":26},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Jolly/Hugo/Rooster/12129488.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":27,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":88,"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":"101","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":"110","currentPageToDisplay":11,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]