SELECT * FROM Users WHERE DeleteAt != 0;
I see nothing in the results of this query that would indicate last activity for a user. The schema isn’t very specific about the uses of each table column, but it seems to me tracking last activity of a user would at least require a join with the Posts
table, and probably with a few others as well if you wanted to catch meta-activity like channel joins.