« first day (529 days earlier)      last day (1592 days later) » 

2:02 PM
@Martin if you're around can you tell me if for this question the active 3 days ago is caused by any deleted answer(s) and/or actions on those deleted answers?
 
2:18 PM
@rene Yes there was a deleted answer.
 
ah, okay. That explains it.
 
Are some of the reviews shown for users below 10k? Perhaps suggested edits?
I have a vague recollection that I talked about something like that somewhere in chat.
 
@Martin No, I get the review, but not the answer
 
It was in this room:
Aug 15 '18 at 8:22, by Martin
I have noticed that even users below 10k can see (some part of) deleted post if they find reopen or suggested edit review - here are examples I happen to have at hand: https://mathoverflow.net/review/reopen/96268 and https://mathoverflow.net/review/suggested-edits/95740
 
@Martin I can see that one, yes.
 
2:22 PM
So it does not help in this case - but for suggested edit and reopen reviews something is still visible even after deletion.
 
I checked if you had >10K on Math so I knew you could tell me if deletion was the case ;)
 
So that query returns posts where some recent activity was on a deleted answer?
 
No, It should have returned all posts that didn't see any activity for the last 6 months
But it doesn't
 
So posts with no activity and created only recently?
 
due to deleted posts
@Martin yeah, that was kind of the idea
 
2:31 PM
I was wondering how active.postid = p.id and active.postid is null is possible at the same time.
Has it something to do with the fact that outer join is used there?
 
@Martin yes. I'm basically looking for posts that don't have a record in the other set.
could have done a where not exists as well
 
So LastActivityDate for a question means the last activity either on the question or on any of the answers (including the deleted ones)?
 
yes.
 
I did not know that.
Or at least I wasn't sure whether it means last edit/retag/whatever of the question or whether the answers are included too.
 

« first day (529 days earlier)      last day (1592 days later) »