[{"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":"Shiny Grant Flywheel","authId":"","name":"Shiny Grant Flywheel","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shiny Grant Flywheel","authId":"","name":"Shiny Grant Flywheel","CNNId":"","myGameChains":null,"banStatus":null},"id":14948055,"name":"Big Cannonbolt Clash","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shiny/Grant/Flywheel/14948055.jpg","createDate":{"time":1294592796000,"minutes":6,"seconds":36,"hours":12,"month":0,"timezoneOffset":300,"year":111,"day":0,"date":9},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shiny/Grant/Flywheel/14948055.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":78,"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":"Academic Bradley Ape","authId":"","name":"Academic Bradley Ape","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Bradley Ape","authId":"","name":"Academic Bradley Ape","CNNId":"","myGameChains":null,"banStatus":null},"id":14960902,"name":"Rumble Defense Power","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Bradley/Ape/14960902.jpg","createDate":{"time":1294760321000,"minutes":38,"seconds":41,"hours":10,"month":0,"timezoneOffset":300,"year":111,"day":2,"date":11},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Bradley/Ape/14960902.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":34,"difficulty":1,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":106,"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":"Artful Amy Cupcake","authId":"","name":"Artful Amy Cupcake","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Artful Amy Cupcake","authId":"","name":"Artful Amy Cupcake","CNNId":"","myGameChains":null,"banStatus":null},"id":14966008,"name":"Shadow Fire Rumble","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Artful/Amy/Cupcake/14966008.jpg","createDate":{"time":1294809056000,"minutes":10,"seconds":56,"hours":0,"month":0,"timezoneOffset":300,"year":111,"day":3,"date":12},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Artful/Amy/Cupcake/14966008.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2359,"difficulty":1.5453331056940682,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":3631,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":7,"rating":2.078234,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Spike Cobra","authId":"","name":"Heroic Spike Cobra","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Heroic Spike Cobra","authId":"","name":"Heroic Spike Cobra","CNNId":"","myGameChains":null,"banStatus":null},"id":14991597,"name":"Big Force Droid","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Heroic/Spike/Cobra/14991597.jpg","createDate":{"time":1295110049000,"minutes":47,"seconds":29,"hours":11,"month":0,"timezoneOffset":300,"year":111,"day":6,"date":15},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Heroic/Spike/Cobra/14991597.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":39,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":58,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":1,"rating":4,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Wolfgang Photon","authId":"","name":"Electric Wolfgang Photon","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Electric Wolfgang Photon","authId":"","name":"Electric Wolfgang Photon","CNNId":"","myGameChains":null,"banStatus":null},"id":15048581,"name":"Cosmic Solar Invasion","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Electric/Wolfgang/Photon/15048581.jpg","createDate":{"time":1295713248000,"minutes":20,"seconds":48,"hours":11,"month":0,"timezoneOffset":300,"year":111,"day":6,"date":22},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Electric/Wolfgang/Photon/15048581.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":2681,"difficulty":2.4116898148148147,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":6879,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":3,"rating":4.261837,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Bernard Zinger","authId":"","name":"Academic Bernard Zinger","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Academic Bernard Zinger","authId":"","name":"Academic Bernard Zinger","CNNId":"","myGameChains":null,"banStatus":null},"id":15073475,"name":"Ultimate Search Hyper","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Academic/Bernard/Zinger/15073475.jpg","createDate":{"time":1295964496000,"minutes":8,"seconds":16,"hours":9,"month":0,"timezoneOffset":300,"year":111,"day":2,"date":25},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Academic/Bernard/Zinger/15073475.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":6,"difficulty":2.25,"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":"Spectral Calvin Android","authId":"","name":"Spectral Calvin Android","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Spectral Calvin Android","authId":"","name":"Spectral Calvin Android","CNNId":"","myGameChains":null,"banStatus":null},"id":15083922,"name":"Mission Adventure Challenge","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Spectral/Calvin/Android/15083922.jpg","createDate":{"time":1296139948000,"minutes":52,"seconds":28,"hours":9,"month":0,"timezoneOffset":300,"year":111,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Spectral/Calvin/Android/15083922.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":21,"difficulty":2,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":77,"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":"Shy Bill Snowshoe","authId":"","name":"Shy Bill Snowshoe","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Shy Bill Snowshoe","authId":"","name":"Shy Bill Snowshoe","CNNId":"","myGameChains":null,"banStatus":null},"id":15084229,"name":"Crusher Water Adventure","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Shy/Bill/Snowshoe/15084229.jpg","createDate":{"time":1296143175000,"minutes":46,"seconds":15,"hours":10,"month":0,"timezoneOffset":300,"year":111,"day":4,"date":27},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Shy/Bill/Snowshoe/15084229.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":66,"difficulty":3,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":1354,"dbTimesPlayed":0,"dbTimesWon":0,"id":0,"lastPlayDate":null,"timesShared":2,"rating":3,"percentWon":0,"diffSamples":0,"dbTimesShared":0},"rejectBy":"","sequence":0,"configuration":"","chainStatus":0},{"relatedGames":null,"player":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Madelyn Pulse","authId":"","name":"Regular Madelyn Pulse","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Regular Madelyn Pulse","authId":"","name":"Regular Madelyn Pulse","CNNId":"","myGameChains":null,"banStatus":null},"id":15150987,"name":"Rescue Plumber Steel","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Regular/Madelyn/Pulse/15150987.jpg","createDate":{"time":1296915238000,"minutes":13,"seconds":58,"hours":9,"month":1,"timezoneOffset":300,"year":111,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Regular/Madelyn/Pulse/15150987.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":46,"difficulty":0,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":50,"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":"Awful Trevor Anvil","authId":"","name":"Awful Trevor Anvil","CNNId":"","myGameChains":null,"banStatus":null},"featuredDate":null,"timesReported":0,"featured":false,"rejectDate":null,"creator":{"id":0,"playerStat":null,"myGames":null,"alias":"Awful Trevor Anvil","authId":"","name":"Awful Trevor Anvil","CNNId":"","myGameChains":null,"banStatus":null},"id":15151133,"name":"Whirlwind Rush Doom","approveDate":null,"timeToBeat":0,"approveBy":"","fullUrlImg":"http://i.cdn.turner.com/v5cache/CARTOON/gamecreator/images2/Awful/Trevor/Anvil/15151133.jpg","createDate":{"time":1296915921000,"minutes":25,"seconds":21,"hours":9,"month":1,"timezoneOffset":300,"year":111,"day":6,"date":5},"hero":null,"rejectReason":"","status":0,"goal":null,"numberOfLevels":0,"base64img":"Awful/Trevor/Anvil/15151133.jpg","statistic":{"computedDifficultySamplesThisRun":0,"timesWon":119,"difficulty":2.5,"ratingSamples":0,"computedRatingSamplesThisRun":0,"timesPlayed":136,"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":"141","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":"150","currentPageToDisplay":15,"totalNumberOfPages":20},"status":"SUCCESS","msg":"Message was not set. Please refer to documentation for HandleResponse"}}]