Longest time (in days) to accept answer, global with user links

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

select top 1000 p.id as [Post Link], p.owneruserid as [User Link], a.owneruserid as [User Link], datediff(day,  a.creationdate, v.creationdate ) as [Days Elapsed],
a.creationdate as Answered, v.creationdate as Accepted
from posts p, posts a, votes v
where a.parentid = p.id
and p.acceptedanswerid = v.postid
and v.postid = a.id
and v.votetypeid = 1
     order  by v.creationdate - a.creationdate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results