0

Please login or register to vote for this query.

(click on this box to dismiss)

how long before I get tag badges?

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

select  p1.Id, p1.PostTypeId, p1.AcceptedAnswerId, p1.ParentId, p1.CreationDate,p2.Id, p2.PostTypeId, p2.AcceptedAnswerId, p2.ParentId, p2.CreationDate,p2.body from posts p2 
join posts p1  on p1.posttypeid=1 and p1.CreationDate between '2022/2/2 23:59:46' and '2022/2/3 0:09:56'and p2.posttypeid=2 and p2.ParentId=p1.id

fork query

edited mar 4 litingting

created may 24 10 sam.saffron