Q&A about the site for those using, extending or developing Emacs
select pid , elapsed_time, accepted, answered from (select p.id as pid, datediff(SECOND, a.creationdate, v.creationdate) as elapsed_time, a.creationdate as answered, v.creationdate as accepted, v.votetypeid as vote_type from posts p, posts a, votes v where a.parentid = p.id and p.acceptedanswerid = v.postid and v.postid = a.id and a.owneruserid = 25554 ) s where vote_type = 1 order by elapsed_time desc