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 developers and researchers interested in open data

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/1/20 23:59:33' and '2022/1/26 00:00:00'and p2.posttypeid=2 and p2.ParentId=p1.id;

fork query

edited feb 26 litingting

created may 24 10 sam.saffron